Design and Implementation of Air Quality Data Mart for Ontario Canada

Samira Muhammad


OLAP, Data Mart, Open Source, Air Quality


Every year, there are approximately 6000 additional deaths in Canada, because of short term exposure to air pollution. Research suggests that 69% of these deaths come in the form of cardio and cerebrovascular disease [1]. The Ontario ministry of environment has historical air pollutant data available for the general public. It is available for monitoring stations across Ontario. The data presented on this website is on an hourly basis for the selected pollutant and time frame. However this data is hard to interpret. It could cause confusion if an individual is unaware of the acceptable Ambient Air Quality Criteria (AAQC). This paper will highlight how the issue is resolved, by building a data mart using open source On-Line Analytical Processing (OLAP) tools. It will also discuss the challenges, limitations and steps taken during the design and development phase.

Important Links:

Go Back