article thumbnail

How gaming companies can use Amazon Redshift Serverless to build scalable analytical applications faster and easier

AWS Big Data

Refer to the respective service documentation for further details. Data repository services Amazon Redshift is the recommended data storage service for OLAP (Online Analytical Processing) workloads such as cloud data warehouses, data marts, and other analytical data stores.

article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing). Think of it like something that houses the metrics used to power daily, weekly, or monthly business KPIs. OLTP vs OLAP. roll-ups of many rows of data). Sort & Dist Keys.