← recall

data warehouse term

analytical DB optimized for large aggregate queries

Columnar storage, compressed, denormalized. Snowflake, BigQuery, Redshift, ClickHouse. Distinct from OLTP (Postgres, MySQL) which optimizes for row-level transactions.

topics: data-pipelines, databases

references:

• Wikipedia — Data warehouse