Remove 2000 Remove Big Data Remove OLAP Remove Online Analytical Processing
article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

Redshift, like BigQuery and Snowflake, is a cloud-based distributed multi-parallel processing (MPP) database, built for big data sets and complex analytical workflows. OLTP vs OLAP. First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing).