Combining multidimensional expressions and data mining extensions to mine OLAP cubes
AssigneeMicrosoft Corporation
InventorsC. James MacLennan, Pyungchul Kim, ZhaoHui Tang
Life of this patent
Estimating the term…
Abstract
A language schema that integrates multidimensional extensions (e.g., MDX) and data mining extensions (e.g., DMX) for performing data mining operations on data residing in OLAP cubes. The schema provides that the <source-data-query> can not only be a relational query, rather a multidimensional query formed using MDX, for example. The operations of model creation, training and prediction are described.
Claims22
A computer program product of use at a computer system the computer program product for implementing a method for data mining on a multidimensional data cube, the computer program product comprising one or more computer storage media having stored thereon computer-executable instructions that, when executed at a processor, cause the computer system to perform the method, including performing the following:
- access multidimensional data;
- access multidimensional expressions defining how to view the multidimensional data as a multidimensional data cube;
- access data mining extensions for performing data mining on data residing in the multidimensional data cube;
- integrate the multidimensional expressions and the data mining extensions into input for data mining model creation;
- create a data mining model trained on the multidimensional data from the input;
- store the data mining model;
- perform data predictions against data contained in the multidimensional data cube by data mining the multidimensional data cube in accordance with the data mining model, data mining including performing data mining operations on portions of data contained in the multidimensional data cube in accordance with a multidimensional query element.
At a computer system, the computer system including a processor and system memory, a computer implemented method for data mining on a multidimensional data cube, comprising:
- accessing multidimensional data;
- accessing multidimensional expressions defining how to view the multidimensional data as a multidimensional data cube;
- accessing data mining extensions for performing data mining on data residing in the multidimensional cube;
- integrating the multidimensional expressions and the data mining extensions into input for data mining model creation;
- the processor creating a data mining model trained on the multidimensional data from the input;
- storing the data mining model;
- performing data predictions against data contained in the multidimensional data cube by data mining the multidimensional data cube in accordance with the data mining model, data mining including performing data mining operations on portions of data contained in the multidimensional data cube in accordance with a multidimensional query element.
Dependencies are inferred from the claim text.