Management of Air Quality Monitor Data with Data Warehouse and GIS

Air quality status is an important problem focused by all people. This paper utilizes Oracle 10 g to design and implement a prototype system of air quality data warehouse with the monitor data of 86 main cities from the year of 2000 to 2007 in China. To query and analyze the data in the data warehouse conveniently and effectively, it extends the star model to manage the spatial data with ArcGIS 9.0, and implements a Web spatial OLAP system to improve the ability of spatial analysis and visualization of traditional OLAP systems synchronously. Our work will help to evaluate air quality status, analyze its spatio-temporal characteristic, forecast and provide decision-making support for improvement of air quality.