Data Mining Extensions: Difference between revisions

Content deleted Content added
No edit summary
No edit summary
 
Line 3:
'''Data Mining Extensions''' ('''DMX''') is a [[query language]] for [[data mining]] models supported by [[Microsoft]]'s [[SQL Server Analysis Services]] product.<ref>{{Cite web |title=Sql server - Explain how to use DMX-the data mining query language |url=https://www.careerride.com/data-mining-query-language.aspx |access-date=2022-08-23 |website=www.careerride.com}}</ref>
 
Like [[SQL]], it supports a [[data definition language]] (DDL), [[data manipulation language]] (DML) and a [[data query language]] (QLDQL), all three with SQL-like syntax. Whereas SQL statements operate on relational tables, DMX statements operate on data mining models. Similarly, [[Microsoft SQL Server]] supports the [[Multidimensional Expressions|MDX]] language for [[OLAP]] databases. DMX is used to create and train data mining models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.
Whereas SQL statements operate on relational tables, DMX statements operate on data mining models.
Similarly, SQL Server supports the [[Multidimensional Expressions|MDX]] language for [[OLAP]] databases.
DMX is used to create and train data mining models, and to browse, manage, and predict against them.
DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.
 
== Queries ==