A Trillion Rows Per Second as a Foundation for Interactive Analytics

Eric Hanson | MemSQL

ABOUT THE TALK

To push the frontier of real-time insight, MemSQL and Intel worked together to run a single analytical SQL query at over a trillion rows per second scan rate. The ability to do a query at this speed was based on the MemSQL compiled, vectorized and SIMD-based query execution technology, and a cluster with 18 Intel Xeon Platinum 8180 Processors with 28 cores each.
 
We’ll discuss the level of concurrency and response time that’s now possible, and how data architects can use it to create business value through fast and accurate decision-making at any scale.

Download Slides

eric hanson

Principal Product Manager | MemSQL

Eric Hanson is a principal product manager at MemSQL, responsible for query processing, extensibility, and geo-spatial feature areas. He’s a PhD graduate of UC Berkeley, was an Air Force officer, a professor of computer science at the University of Florida during the 1990s, and a principal program manager and developer in the SQL Server team at Microsoft from 2002-2016. He was named a Hive committer for contributions to Stinger. He’s a technology expert on data warehousing, column stores, and vectorized query execution.

Eric Hanson MemSQL