Presented By O'Reilly and Cloudera
Make Data Work
December 1–3, 2015 • Singapore

Modeling the smart and connected city of the future with Kafka and Spark

Eric Frenkiel (MemSQL)
2:20pm–3:00pm Thursday, 12/03/2015
IoT and Real-time
Location: 324 Level: Intermediate
Average rating: ***..
(3.33, 9 ratings)
Slides:   external link

Prerequisite Knowledge

Attendees should have background knowledge on real-time and historical processing, as well as Apache Spark and Apache Kafka.


Smart cities are no longer nice-to-have, they are becoming a necessity. By capturing energy readings by device in real time over geographical distances and over periods of time, we can enable urban planners, energy companies, and other like organizations to identify trends in consumption and figure out the right solutions for smarter energy systems and savings. Putting in place a true intelligent data platform fueled by the analysis of real-time data enables a smart, connected city to become possible..

In this session, Eric Frenkiel, CEO and cofounder, MemSQL, will demonstrate the powerful possibilities real-time data analysis can bring to our lives through a prototype of a futuristic ‘smart’ city where all household energy devices are tracked simultaneously. Eric will present the challenges, design choices and architecture required to enable smarter energy systems and efficient energy consumption through a real-time data pipeline combining Apache Kafka, Apache Spark, and an in-memory database. Learn how we can gather deep and meaningful insights from sensors, and realize the possibility of doing so with low-cost, commodity hardware.

Eric Frenkiel


Eric Frenkiel co-founded our company and has served as CEO since inception. Before MemSQL, Eric worked at Facebook on partnership development. He has worked in various engineering and sales engineering capacities at both consumer and enterprise startups. Eric is a graduate of Stanford University’s School of Engineering. In 2011 and 2012, Eric was named to Forbes’ 30 under 30 list of technology innovators.