Implementing a Data Warehouse on AWS in a Hybrid Environment

Опубликовано 20 июня 2019, 17:24

Data warehouses (DWs) are central repositories of integrated data from one or more disparate sources, used for reporting, data analysis, and business intelligence. In this session, we dive deep into concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift - the petabyte-scale data warehouse in AWS. Additionally, we review patterns in hybrid environments for collecting, storing, and preparing data for DWs using Amazon DynamoDB, AWS Database Migration Service, Amazon Kinesis Data Firehose, and Amazon Simple Storage Service (Amazon S3). Learn how Fannie Mae successfully migrated from its on-premises DW to Amazon Redshift and achieved its goals by implementing parallel query execution, key performance adjustments, and more.