Ask HN: How is a data warehouse different to an SQL RDMBS?
I've been using standard RDBMSs (mostly MySQL and PostgreSQL) for a little over 20 years, but I've never dabbled in Data Warehouses. I'm trying to understand the technical differences between the two.
The top answer on (my) google search for "differences between a database and a data warehouse" is that "a database is any collection of data organized for storage, accessibility, and retrieval. A data warehouse is a type of database the integrates copies of transaction data from disparate source systems and provisions them for analytical use."
That speaks more to the purpose of the Data Warehouse, and less to its underlying structure.
I've also come across articles that espouse the benefits of a Data Warehouse in terms of OLAP (versus OLTP). I understand the basic premise of this, but yeah I'm just trying to picture what it is about a Data Warehouse under the hood that makes it superior.
Can you kind folks please point me in the right direction? Technical depth welcome.
Thanks!