Remove Data Lake Remove Online Analytical Processing Remove Snapshot
article thumbnail

Unleashing the power of Presto: The Uber case study

IBM Big Data Hub

Uber understood that digital superiority required the capture of all their transactional data, not just a sampling. They stood up a file-based data lake alongside their analytical database. For traditional analytics, they are bringing data discipline to their use of Presto. It lands as raw data in HDFS.

OLAP 86
article thumbnail

Build an Amazon Redshift data warehouse using an Amazon DynamoDB single-table design

AWS Big Data

A key pillar of AWS’s modern data strategy is the use of purpose-built data stores for specific use cases to achieve performance, cost, and scale. Deriving business insights by identifying year-on-year sales growth is an example of an online analytical processing (OLAP) query.

article thumbnail

Unlock scalability, cost-efficiency, and faster insights with large-scale data migration to Amazon Redshift

AWS Big Data

The data warehouse is highly business critical with minimal allowable downtime. We can determine the following are needed: An open data format ingestion architecture processing the source dataset and refining the data in the S3 data lake. The following figure shows a daily usage KPI. Vijay Bagur is a Sr.