摘要
针对一系列大气监测指标的分析要求,建立了大气分析系统的立方体模型.探讨了GMDJ(General Multi-Dimensional Join,通用的多维联接)技术在哈尔滨市环保局大气分析系统中的具体应用问题.并在此基础上,将GMDJ技术引入MIS(Management Information System,管理信息系统)领域,解决了实际应用中遇到的OLAP(Online Analytical Processing,联机分析处理)查询问题.举例说明了用GMDJ表示OLAP查询任务的方法,以高度简洁的代数形式表达了十分复杂的OLAP查询任务,从而提高了系统的查询响应速度,优化了系统性能.
The application of GMDJ (General Multi-Dimensional Join) technology in the Atmosphere Analysis System of Harbin Environment Protection Bureau is discussed in the paper. Aiming at the requirement of analyzing testing index of atmosphere, this article constructs a data cube model of the Atmosphere Analysis System, uses GM- DJ into MIS ( Management Information System) in order to solve the practical problems of OLAP ( Online Analytical Processing) queries. The paper illustrates how to express the OLAP queries using GMDJ, succinctly expresses complex OLAP queries using algebraically expressions, thereby improves the respondent speed of queries, and optimizes the performance of the system.
出处
《哈尔滨理工大学学报》
CAS
2008年第1期32-35,共4页
Journal of Harbin University of Science and Technology
关键词
数据仓库
联机分析处理
多维联接
data warehouse
online analytical processing
muhi-dimensional join