3 ms·
A data warehouse is basically a read oriented database. In my mind, any database that offers column based indexes can serve as a data warehouse. My default is
by rawgabbit 4y ago
A data warehouse is basically a read oriented database. In my mind, any database that offers column based indexes can serve as a data warehouse.
My default is Azure SQL database (SQL as a service) using its column store indexes. [1] https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/relational-databases/i... [2] https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-warehouse?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/relational-databases/i...
If I outgrow it, I would look into more enterprise-y solutions.