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.