MemSQL Demonstrates Untapped Power of the Industrial Internet of Things With Real-Time Analytics
Streamliner Application, PowerStream, Debuts at Spark Summit East
San Francisco, CA - February 16, 2016 - (SPARK SUMMIT EAST, Booth #101) - MemSQL, the leader in real-time databases for transactions and analytics, will unveil PowerStream, a brand new application using the Industrial Internet of Things to fuel real-time analytics, at Spark Summit East. PowerStream uses a real-life dataset of approximately 20,000 wind farms and 200,000 individual wind turbines equipped with sensors generating over a million transactions per second. PowerStream ingests that data and provides actionable insights in real time, giving users a glimpse of how the future of sustainability can be fully realized by adapting data to drive innovation.
MemSQL Demonstrates Untapped Power of the Industrial Internet of Things With Real-Time Analytics - Click to Tweet
PowerStream is built with MemSQL Streamliner, an integrated Apache Spark solution that supports thousands of concurrent users running real-time analytical queries and reduces data latency from days or hours down to zero. Temperature and vibration input from millions of sensors on turbines located around the world flows through a real-time Streamliner pipeline. With this data and a machine learning algorithm, PowerStream predicts and visualizes the health of turbines. A healthy turbine appears green. A turbine likely facing severe weather, software malfunctions or in need of maintenance appears red. When the needs of individual turbines can be assessed in real time, performance can be monitored, remote software repairs can occur, and the delivery of a spare part by drone to the repairman to minimize downtime become possible. PowerStream runs on seven c4.2xlarge instances from Amazon Web Services. At $0.311 per instance/hour, total annual hardware costs are approximately $19,070.
“The world is amassing more data than many businesses are equipped to handle and companies need to prepare for real-time opportunities today," said Eric Frenkiel, CEO and co-founder, MemSQL. “With MemSQL Streamliner, we're bringing information into the light of day to help companies boost their bottom line regardless of industry, market or segment.”
Any business can be agile, but companies that more effectively derive insights from data can readily adapt to changing conditions. PowerStream exemplifies the power of Industrial IoT applications with real-time analytics. Industries unchanged for decades can now undergo drastic transformations. With machines more frequently full of sensors, the Industrial Internet of Things will improve manufacturing processes, manage logistics across supply chains, and increase our ability to discover value from data.
For more information about PowerStream, read the blog post: blog.memsql.com/powerstream-demo
Partner Application with Zoomdata TaxiStats
At Spark Summit East, MemSQL will jointly showcase a new real-time dashboard application with Zoomdata. Simulated pickup and drop-off data from taxis is streamed into MemSQL as rides complete. The Zoomdata business intelligence dashboard displays that data as it is collected while exploratory analytics run simultaneously on the dataset. The dashboard includes:
- Real-time data for pickups by ZIP code on the map, total volume of rides, and rides by time of day
- A map and graph that can be filtered to explore and drill down
- A live stream that can be paused or rewound to examine a specific time period
Spark Summit Details
The Spark Summit brings the Apache Spark community together. Attendees will hear from leading users of Spark, Spark SQL, Spark Streaming, and related projects; find out where the project development is going; learn how to use the Spark stack in a variety of applications and hear from businesses that are utilizing Spark to meet their needs.
For more information about MemSQL at Spark Summit, visit memsql.com/sparkeast
MemSQL is the leader in real-time databases for transactions and analytics. As a purpose built database for instant access to real-time and historical data, MemSQL uses a familiar SQL interface and a horizontally scalable distributed architecture that runs on commodity hardware or in the cloud. Innovative enterprises use MemSQL to better predict and react to opportunities by extracting previously untapped value in their data to drive new revenue. MemSQL is deployed across hundreds of nodes in high velocity big data environments. Based in San Francisco, MemSQL is a Y Combinator company funded by prominent investors including Accel Partners, Khosla Ventures, First Round Capital and Data Collective. Follow us @MemSQL or visit at www.memsql.com.