摘要: 根据空气质量监测数据的空间特征,对数据仓库的星型模型进行扩展,利用Oracle10g 和ArcGIS9.0设计并建立中国城市空气质量数据仓库的原型系统,实现面向高级分析、挖掘和决策的数据组织和管理。为方便查询和分析数据,设计一个基于Web的空间OLAP系统,弥补了传统OLAP在空间分析和可视化表达方面的不足。
关键词:
空气质量,
数据仓库,
空间OLAP
Abstract: This paper extends the star model according to the spatial characteristic of air quality monitor data, and utilizes Oracle10g and ArcGIS 9.0 to design and implement an air quality data warehouse prototype system in China. The system can organize and manage the data effectively to support the requirement of complicated analysis, mining and decision-making. To query and analyze the data in the data warehouse conveniently, this paper designs a Web spatial OLAP system to improve the ability of spatial analysis and visual presentation of the traditional OLAP system.
Key words:
air quality,
data warehouse,
spatial OLAP
中图分类号:
纪翠玲;肖永康. 中国城市空气质量数据仓库的研究与实现[J]. 计算机工程, 2009, 35(17): 235-237,.
JI Cui-ling; XIAO Yong-kang. Research and Implementation of Chinese City Air Quality Data Warehouse[J]. Computer Engineering, 2009, 35(17): 235-237,.