Temporal analysis of air polution data by using OLAP cube

Abstract

This paper presents integration of data warehouse system, database system and reporting tools in aim to show results of data aquisition carried out with automatic measuring station in urban traffic zone, in Zrenjanin, Vojvodina region, Serbia. The process of integration of these tools allows design and computation of aggregated data regarding air pollutants concentrations. Relational data model of created database is presented, as well as aggregated data created with data warehouse. Multidimensional Online Analytical Processing cube, based on snowflake schema, is implemented. Additional features are used such as exporting analytical data to spreadsheet application, for the purposes of generating reports in the form of pivot tables and charts to illustrate air pollutants concentration analysis.