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. These campaigns are optimized by using an AI-based bid process that requires running hundreds of analytical queries per campaign.

article thumbnail

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

erwin

I first met Ralph in the early 1990’s while attending one of his seminars. Don’t obstruct the optimizer from seeing it’s a star schema. Many database optimizers recognize the star schema and have code to optimize their execution by orders of magnitude. Business Focus. Operational. Operational Tactical. Tactical Strategic.