NoSQL@Extreme Performance,take your NoSQL to the Next Level | Big Data Demystified

Bio:
Zohar is a technology evangelist and an expert in data technologies with over 20 years of experience.
At his current position, Zohar is a Solutions Architect for Aerospike – a low latency-high throughput big scale database.
Before that, Zohar was an Oracle ACE, CTO and consultant technical lead at Brillix, and the director for databases, big data and BI at Glasshouse Technologies.

Abstract/description:

Building a low latency (sub millisecond), high throughput database that can handle big data AND linearly scale is not easy – but we did it anyway…
In this session we will get to know Aerospike, an enterprise distributed primary key database solution.

– We will do an introduction to Aerospike – basic terms, how it works and why is it widely used in mission critical systems deployments.
– We will understand the ‘magic’ behind Aerospike ability to handle small, medium and even Petabyte scale data, and still guarantee predictable performance of sub-millisecond latency
– We will learn how Aerospike devops is different than other solutions in the market, and see how easy it is to run it on cloud environments as well as on premise.

We will also run a demo – showing a live example of the performance and self-healing technologies the database have to offer.

Want more information from an official AeroSpike representative?

Just fill the following form and someone will get back to you:

https://forms.gle/3DmGjtt3LrRR4Pnz9

NoSQL@Extreme Performance,take your NoSQL to the Next Level|Big Data Demystified

Monday, Jul 1, 2019, 6:00 PM

Investing.com
Ha-Shlosha St 2 Tel Aviv-Yafo, IL

58 Members Went

18:00 networking 18:30 “AI & BIG DATA IN HEALTH SECTOR-OPPORTUNITIES & SECURITY / PRIVACY CHALLENGES”, Alexander Raif, Chief security and Privacy architect at Maccabi Health care HMO. [Spoken language – English ] 19:15 break 19:20 “NoSQL at Extreme Performance – taking your NoSQL to the Next Level” Zohar Elkayam, Solutions Architect at Aerospike ET…

Check out this Meetup →

AI and Big Data in Health Sector Opportunities and challenges | Big Data Demystified

“AI & BIG DATA IN HEALTH SECTOR-OPPORTUNITIES & SECURITY / PRIVACY CHALLENGES”

Lecturer has Deep experience defining Cloud computing, security models for IaaS, PaaS, and SaaS architectures specifically as the architecture relates to IAM. Deep Experience Defining Privacy protection Policy, a big fan of GDPR interpretation.

DeelExperience in Information security, Defining Healthcare security best practices including AI and Big Data, IT Security and ICS security and privacy controls in the industrial environments.
Deep knowledge of security frameworks such as Cloud Security Alliance (CSA), International Organization for Standardization (ISO), National Institute of Standards and Technology (NIST), IBM ITCS104 etc.

What Will You learn:
Every day, the website collects a huge amount of data. The data allows to analyze the behavior of Internet users, their interests, their purchasing behavior and the conversion rates. In order to increase business, big data offers the tools to analyze and process data in order to reveal competitive advantages from the data.
What Healthcare has to do with Big Data
How AI can assist in patient care?
Why some are afraid? Are there any dangers?

AI & Big Data in Health Sector-Opportunities & challenges | Big Data Demystified

Monday, Jul 1, 2019, 6:00 PM

investing
hashelosha st 2, Tel Aviv, Tel Aviv-Yafo Tel Aviv-Yafo, al

211 Members Went

18:00 networking 18:30 “AI & BIG DATA IN HEALTH SECTOR-OPPORTUNITIES & SECURITY / PRIVACY CHALLENGES”, Alexander Raif, Chief security and Privacy architect at Maccabi Health care HMO. [Spoken language – English ] 19:15 break 19:20 “NoSQL at Extreme Performance – taking your NoSQL to the Next Level” Zohar Elkayam, Solutions Architect at Aerospike ET…

Check out this Meetup →

How to ignore quoted fields inside a CSV via AWS Athena?

The idea is to tell athena via the create table , to ignore quoted fields

CREATE external TABLE

create table myTable(
id bigint,
guid string)

ROW FORMAT SERDE ‘org.apache.hadoop.hive.serde2.OpenCSVSerde’
WITH SERDEPROPERTIES (
“separatorChar” = “,”,
“quoteChar” = “\””
)
STORED AS TEXTFILE
LOCATION ‘s3://my-bucket/’;

AWS Aurora | MySQL Cheat Sheet

show databases;
show tables;

Check Tables size

SELECT       table_schema as `Database`,       table_name AS `Table`,       round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`  FROM information_schema.TABLES  ORDER BY (data_length + index_length) DESC;
SHOW FULL PROCESSLIST;

SHOW VARIABLES LIKE "general_log%";

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME >= 5;

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND INFO LIKE '%UPDATE %';

Query log mysql

https://tableplus.io/blog/2018/10/how-to-show-queries-log-in-mysql.html

Audit aurora logs in athena

https://aws.amazon.com/blogs/database/audit-amazon-aurora-database-logs-for-connections-query-patterns-and-more-using-amazon-athena-and-amazon-quicksight/

https://console.aws.amazon.com/rds/home?region=us-east-1#performance-insights:

ALIGNING YOUR BI OPERATIONS WITH YOUR CUSTOMERS’ UNSPOKEN NEEDS, by Eyal Steiner, Senior BI Engineer, Alexa Shopping at Amazon

What You Will Learn:

Data is a strategic business function, but due to its heavy technical components, the strategic element is often overlooked by the very people who work with it. However, to achieve success in a data career, it is crucial to zero in on the business value of the data provided and to align all data projects and output with the organization’s business goals.

This event aims to provide you, as a professional working in data, with a broader understanding of how to relate the day-to-day technical aspects of data operations to the business goals, and how you can leverage this business understanding (along with your technical skillset) to drive your career forward.

ALIGNING YOUR BI OPERATIONS WITH YOUR CUSTOMERS’ UNSPOKEN NEEDS

-Learn how to connect BI and product management to solve business problems
-Discover how to lead clients to ask the right questions to get the data and insight they really want
-Get pointers on saving your time and your company’s resources by understanding what your customers need, not what they ask for

Bio:

Eyal Steiner – Eyal is a senior BI engineer at Alexa Shopping at Amazon. Alexa Shopping integrates voice recognition with Amazon e-commerce, allowing users to make purchases with the sound of their voice. With this venture, Amazon is hoping to dominate the emerging field of voice-activated shopping.

Eyal has a broad perspective in both data and business, having worked previously at SimilarWeb as a data scientist and as the CEO and co-founder of DNA-7, a SaaS that uses the power of organizational network analysis for workforce optimization.

BI And Analytics: The Business Connection

Sunday, Jun 2, 2019, 6:00 PM

Google Campus
Ha-Umanim St 12 Tel Aviv-Yafo, IL

114 Members Went

Agenda: 18:00 PM – Networking 18:30 PM – BUSINESS ANALYTICS AT SELINA, by Assaf Levinson, Head of Analytics at Selina 19:15 – Break 19:30 PM – ALIGNING YOUR BI OPERATIONS WITH YOUR CUSTOMERS’ UNSPOKEN NEEDS, by Eyal Steiner, Senior BI Engineer, Alexa Shopping at Amazon 20:15 pm – Wrap-up *Lectures will be in English *(Kosher) snacks will be served …

Check out this Meetup →