Sunday January 21st 2018




Difference between DMX and MDX

dmx vrs mdxDMX stands for Data Mining Extensions. The DMX is similar to SQL language and contains statements for data defination and data manipulation. the data defination language includes statements for model creation and data manipulation language contains statements for training the model which includes inserting data into the model and retrieving prediction results from it. Just as SQL language has a select statement to retrieve data from relational database, DMX has select statement to retrieve data from mining model. DMX syntax is more similar to – SQL than – MDX. In other words SQL language expertise can be further enhanced in DMX or vice versa.

We reconciled our experience with following sources;

1- Professional Microsoft SQL Server Analysis Services 2008