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
Comment2
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…

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2022 Justin
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing