Joint Systems Design and Implementation / Intel Science & Technology Center / Database Seminar

Thursday, October 4, 2018 - 12:00pm to 1:00pm

Location:

Panther Hollow Conference Room 4101 Robert Mehrabian Collaborative Innovation Center

Speaker:

JAKE WHEAT, Lead Architect https://www.linkedin.com/in/jake-wheat-7b089023/

SQream DB - Bigger Data On GPUs: Approaches, Challenges, Successes


Speaker: Jake Wheat

Location: CIC Room 4101


SQream DB - Bigger Data On GPUs: Approaches, Challenges, Successes

This talk will present SQream’s journey to building an analytics data warehouse powered by GPUs. SQream DB is an SQL data warehouse designed for larger than main-memory datasets (up to petabytes). It’s an on-disk database that combines novel ideas and algorithms to rapidly analyze trillions of rows with the help of high-throughput GPUs. We will explore some of SQream’s ideas and approaches to developing its analytics database – from simple prototype and tech demos, to a fully functional data warehouse product containing the most important features for enterprise deployment. We will also describe the challenges of working with exotic hardware like GPUs, and what choices had to be made in order to combine the CPU and GPU capabilities to achieve industry-leading performance – complete with real world use case comparisons.

As part of this discussion, we will also share some of the real issues that were discovered, and the engineering decisions that led to the creation of SQream DB’s high-speed columnar storage engine, designed specifically to take advantage of streaming architectures like GPUs.

Jake Wheat is the lead architect of SQream DB. Jake is one of the founding members of SQream, having developed core parts of SQream DB from 2010 onwards. Jake's main experience is in various areas of programming and infrastructure, with particular focus on user interface design, database design, programming language theory, and implementing analytic database management systems. Prior to joining SQream, Jake was a big appreciator of relational theory (and occasionally SQL), wrote his own open-source SQL parser for fun, and holds a Pure Maths degree from Warwick University.

Faculty Host: Andy Pavlo

Partially funded by Yahoo! Labs

Event Website:

http://www.pdl.cmu.edu/SDI/2018/100418.html

For More Information, Contact:

Keywords:

Seminar Series