Data Mining Extensions: Difference between revisions

Revision as of 18:18, 23 August 2022

Latest revision as of 18:59, 26 April 2024

(4 intermediate revisions by 3 users not shown)

Line 1:

{{short description|Query language}}

{{UnreferencedMore citations needed|date=MaySeptember 20212022}}

'''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 48 ⟶ 44:

== See also ==

*[[XML for Analysis]]

==References==

{{Reflist}}

== External links ==