April 25, 2017 – Data Warehousing in the Cloud, David DeWitt

Data Warehousing in the Cloud

Dr David DeWitt

Dr David DeWitt joins us to help BostonSQL kick off our first group meeting.

For more than 30 years, parallel database systems such as those from Teradata, Microsoft, Netezza, and Vertica have been employed a “shared-nothing” design in which storage and compute are co-located. Recently serveral cloud-based data warehousing SAAS solutions have appeared including Amazon Redshift™, Microsoft’s SQL Data Warehouse, the Snowflake Elastic Data Warehouse™ service, and Google’s BigQuery. Except for Redshift, every cloud DW SAAS offering that we are aware of is based on a shared-storage, and not a shared-nothing, paradigm.

In this talk we explain why the marketplace for Cloud DW offerings has exploded and is expected to continue to expand in the years to come. We will briefly describe each of the four services, highlighting their key architectural features and motivate why we expect that the designs based on a shared-storage paradigm to dominate going forward.

Presentation Slides: