O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The MDX Language

As mentioned earlier, Analysis Services employs a very different data storage and retrieval mechanism from that of a relational database technology. This mechanism is based on the concept of an n-dimensional space. In a relational database, such as SQL Server Database Engine Services, data storage and retrieval is based on set theory.

This fundamental difference between the two technologies requires you to handle interaction with the data in very different ways. With relational databases, the SQL language is used to assemble sets of data. With Analysis Services, the MDX language is used to assemble tuples identifying points of data within an n-dimensional space.

Note

You will explore the concept of tuples and n-dimensional space ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required