Title :
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
fDate :
March 31 2009-April 2 2009
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;
Conference_Titel :
Computer Science and Information Engineering, 2009 WRI World Congress on
Conference_Location :
Los Angeles, CA
Print_ISBN :
978-0-7695-3507-4
DOI :
10.1109/CSIE.2009.280
