Data Truth or Dare: “MDX” – A query language for relational databases OR multidimensional OR navigational?
Welcome to another exciting game of Data Truth or Dare. You can catch up on past entries here. This week’s question is about the term MDX. What does it stand for: Relational databases, multidimensional databases, or navigational databases?
Data Truth: MDX facilitates business intelligence across multiple dimensions.
MDX is the query language for multidimensional databases used in BI. It is equivalent to SQL (for relational databases), and can be used to add business logic to the data to maximize the ease of use for the end-user.
Also known as Multidimensional Expressions, it is also a calculation language, with syntax similar to spreadsheet formulas. MDX has been embraced by a wide majority of OLAP vendors and has become the standard for OLAP systems.
Stay tuned for more chances to flex your BI vocabulary muscles in the next posting of Data Truth or Dare!
Interested in learning more? Have a look at the free TARGIT ebook, the BI Dictionary, to hone your skills for the next Data Truth or Dare.
Content Marketing Manager
A professional writer, communicator, and marketer by trade, I'm fascinated by the way data - and in particular big data - is changing the way companies do business. As Content Marketing Manager for TARGIT I tackle this topic and many others in my mission to expand TARGIT's footprint and show the world exactly what it means when you have TARGIT in your tool box. I..