Management of Air Quality Monitor Data with Data Warehouse and GIS

Author

Xiao, Yongkang ; Ji, Cuiling

Author_Institution

Coll. of Inf. Sci. & Technol., Beijing Normal Univ., Beijing, China

Volume

4

fYear

2009

fDate

March 31 2009-April 2 2009

Firstpage

148

Lastpage

152

Abstract

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.

Keywords

air pollution; computerised monitoring; data warehouses; environmental management; environmental science computing; geographic information systems; AD 2000 to 2007; ArcGIS 9.0; China; GIS; Oracle; Web spatial OLAP system; air quality monitor data management; data warehouse; decision-making support; spatial data; spatio-temporal characteristic; Air pollution; Cities and towns; Data visualization; Data warehouses; Decision making; Geographic Information Systems; Monitoring; Protection; Prototypes; Quality management; GIS; air quality; data warehouse; web spatial OLAP system;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Science and Information Engineering, 2009 WRI World Congress on

Conference_Location

Los Angeles, CA

Print_ISBN

978-0-7695-3507-4

Type

conf

DOI

10.1109/CSIE.2009.280

Filename

5170977