Computer Science and Information Engineering, World Congress on (2009)
Los Angeles, California USA
Mar. 31, 2009 to Apr. 2, 2009
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/CSIE.2009.280
Air quality status is an important problem focused by all people. This paper utilizes Oracle 10g 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 characterist-ic, forecast and provide decision-making support for improvement of air quality.
air quality, data warehouse, web spatial OLAP system, GIS
Yongkang Xiao, Cuiling Ji, "Management of Air Quality Monitor Data with Data Warehouse and GIS", Computer Science and Information Engineering, World Congress on, vol. 04, no. , pp. 148-152, 2009, doi:10.1109/CSIE.2009.280