CODEWITHSUNDEEP
sqldatabase
w0051977
w0051977

Reputation: 15787

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?

Upvotes: 0

Views: 572

Answers (2)

DBDWDeveloper
DBDWDeveloper

Reputation: 1

Also, you mention data mining. Querying languages, such as T-SQL and MDX in SQL Server, are used when you know what patterns exist in the data, and you want to find the statistical results. Data mining is used as artificial intelligence, when there are patterns within the data that you do not know about, and the software searches the database and discovers those patterns for you. When utilizing the SQL Server stack, SSAS offers this feature.

Upvotes: 0

Diego
Diego

Reputation: 36126

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

Upvotes: 1

Related Questions