Data Mining Extensions: Difference between revisions

Revision as of 17:41, 10 July 2020

Latest revision as of 18:59, 26 April 2024

(7 intermediate revisions by 6 users not shown)

Line 1:

{{short description|Query language}}

{{More citations needed|date=September 2022}}

'''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]] (DQL), 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 ==

Line 47 ⟶ 44:

== See also ==

*[[XML for Analysis]]

==References==

{{Reflist}}

== External links ==