Data Warehouse design

I understand the concept of a Data Warehouse for online analytical processing.

My question relates specifically to querying a Data Warehouse. What is the difference between SQL that is used for Data Warehouses and SQL that is used for Data Warehouses? I am trying to understand if there is a variation of SQL that is used specifically for Data Warehouse type systems or whether “multi dimensional Data Mining” tools are simply SQL tools at their implementation level.

For example, Object Oriented SQL and Object Relational SQL are documented as supersets of the SQL language. Are one of these used more in a hypercube (multi dimensional) data model?

Answer

you should use T-SQL to query OLTP databases and MDX to query cubes (OLAP)

Leave a Reply

Your email address will not be published. Required fields are marked *