摘要
多维数据分析技术在建立企业级数据仓库的过程中起着关键的作用,同时也是面向联机分析处理(OLAP)的核心。本文在分析了传统多维数据查询语言MDX(Multi-Dimensional eXpression)不足的基础上,提出了一种改进的多维数据查询的语言模型MD-SQL,并给予实现,最后对模型提出了优化方法,通过相关实验证明MD-SQL语言性能优于MDX语言。
As the core of OLAP, multi-dimensional data analysis plays an important role in the establishment of enter-prise 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.
出处
《计算机科学》
CSCD
北大核心
2008年第3期68-70,共3页
Computer Science
基金
上海市科委的资助
资助课题编号为05DZ11C06
