Technically

Technically

Share this post

Technically
Technically
What's a data warehouse?
Copy link
Facebook
Email
Notes
More

What's a data warehouse?

Where warehouse workers means something else

Justin's avatar
Justin
Aug 04, 2020
∙ Paid
58

Share this post

Technically
Technically
What's a data warehouse?
Copy link
Facebook
Email
Notes
More
3
Share

The TL;DR

A data warehouse is a special type of database designed for analytics instead of transactions. 

  • There are two types of database use cases: transactional and analytical

  • Transactional databases like PostgreSQL are built for adding, updating, and removing data, but analytical DBs are for complex queries and joins

  • Data gets moved from transactional to…

Keep reading with a 7-day free trial

Subscribe to Technically to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Justin
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share

Copy link
Facebook
Email
Notes
More