Remove Data Lake Remove OLAP Remove Optimization Remove Seminar
article thumbnail

Data Modeling 201 for the cloud: designing databases for data warehouses

erwin

The first and most important thing to recognize and understand is the new and radically different target environment that you are now designing a data model for. Star schema: a data modeling and database design paradigm for data warehouses and data lakes. Don’t obstruct the optimizer from seeing it’s a star schema.

article thumbnail

How Aura from Unity revolutionized their big data pipeline with Amazon Redshift Serverless

AWS Big Data

Amazon Redshift is a recommended service for online analytical processing (OLAP) workloads such as cloud data warehouses, data marts, and other analytical data stores. Aura’s initial data pipeline Aura is a pioneer in using Redshift RA3 clusters with data sharing for extract, transform, and load (ETL) and BI workloads.