|
计算机科学 2008
MD-SQL:A Query Language for Multi-dimensional Data Analysis Based on MDX
|
Abstract:
As the core of OLAP,multi-dimensional data analysis plays an important role in the establishment of enterprise data warehouse. Based on the shortcomings of the traditional MDX,we propose a new SQL language model,MD-SQL,to support the OLAP computing and compare the traditional MDX with it. One kind of optimization is presented in the latter part. The experiment shows that MD-SQL is better than traditional MDX in terms of efficiency.