Technically

Share this post

What's a data warehouse?

technically.substack.com

What's a data warehouse?

Where warehouse workers means something else

Justin
Aug 4, 2020
47
3
Share this post

What's a data warehouse?

technically.substack.com

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
Previous
Next
© 2023 Justin
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing