作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (17): 235-237,. doi: 10.3969/j.issn.1000-3428.2009.17.081

• 开发研究与设计技术 • 上一篇    下一篇

中国城市空气质量数据仓库的研究与实现

纪翠玲1,肖永康2   

  1. (1. 中国气象局培训中心,北京 100081;2. 北京师范大学信息科学与技术学院,北京 100875)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-09-05 发布日期:2009-09-05

Research and Implementation of Chinese City Air Quality Data Warehouse

JI Cui-ling1, XIAO Yong-kang2   

  1. (1. Training Center, China Meteorological Administration, Beijing 100081; 2. College of Information Science and Technology, Beijing Normal University, Beijing 100875)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-09-05 Published:2009-09-05

摘要: 根据空气质量监测数据的空间特征,对数据仓库的星型模型进行扩展,利用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

中图分类号: