MD-SQL：一种基于MDX的多维数据查询语言

多维数据分析技术在建立企业级数据仓库的过程中起着关键的作用,同时也是面向联机分析处理(OLAP)的核心.本文在分析了传统多维数据查询语言MDX(Multi-Dimensional eXpression)不足的基础上,提出了一种改进的多维数据查询的语言模型MD-SQL,并给予实现,最后对模型提出了优化方法,通过相关实验证明MD-SQL语言性能优于MDX语言.

MD-SQL:A Query Language for Multi-dimensional Data Analysis Based on MDX

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.