Title :
Air Quality Assessment of Ontario Using an Open Source Decision Support System
Author :
Muhammad, Samira
Author_Institution :
Lund Univ., Lund, Sweden
Abstract :
Data marts and Online Analytical Processing (OLAP) tools support specialized form of analysis. They are widely used when analytical navigation of the data is required. In this study a data mart has been created, "Air Quality Data Mart for Ontario Canada" using OLAP tool. The study conducts a case study which presents comparisons of air quality between the urban and rural areas, peak and non-peak hours, working days and weekends and pattern analysis of ground level ozone (O3) and particulate matter (PM 2.5) for various cities in Ontario. The purpose of this study is to evaluate the functionality of the data mart by extracting the data across several dimensions. Analysis of the results indicates that the data mart has the ability to roll up, drill down, dice and slice the data across several dimensions. The results are compared against the Canadian Environmental Sustainability Indicator (CESI) to further corroborate the results achieved by the air quality data mart.
Keywords :
air; air pollution measurement; data mining; data warehouses; decision support systems; environmental science computing; ozone; CESI; Canadian Environmental Sustainability Indicator; O3; OLAP tools; Ontario; air quality assessment; analytical data navigation; data marts; online analytical processing; open source decision support system; ozone; pattern analysis; Air pollution; Atmospheric measurements; Cities and towns; Instruments; Monitoring; Pollution measurement; Urban areas; Air quality; Ambient Air Quality Criteria; Canadian Environment Sustainability Indicator; Data mart; Multidimensional modeling; OLAP;
Conference_Titel :
Biomedical Engineering and Biotechnology (iCBEB), 2012 International Conference on
Conference_Location :
Macau, Macao
Print_ISBN :
978-1-4577-1987-5
DOI :
10.1109/iCBEB.2012.52
