Hey folks, forgive the potentially dumb question.
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!
I think the buzzword is really centered around intent, not actual technical ability. You _could_ use Postgres as a data warehouse, given it supports JSON types, but you wouldn't be taking advantage of all the innovation that's gone into the warehousing space.