TEMPORAL ANALYSIS OF AIR POLUTION DATA BY USING OLAP CUBE

被引：0
|
作者：
Kazi, Zoltan [1 ]
Kazi, Ljubica [1 ]
Filip, Snezana [1 ]
Radulovic, Biljana [1 ]
机构：
[1] Univ Novi Sad, Mihajlo Pupin Tech Fac, Zrenjanin, Serbia
来源：
METALURGIA INTERNATIONAL | 2012年 / 17卷 / 03期
关键词：
temporal analysis; air pollution data; data warehouse; OLAP cube;
D O I：
暂无
中图分类号：
TF [冶金工业];
学科分类号：
0806 ;
摘要：
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.
引用
收藏
页码：110 / 115
页数：6
相关论文
共 50 条
  • [31] Criminal incident data association using the OLAP technology
    Lin, S
    Brown, DE
    INTELLIGENCE AND SECURITY INFORMATICS, PROCEEDINGS, 2003, 2665 : 13 - 26
  • [32] CT-OLAP: Temporal multidimensional data model and algebra for moving objects
    Free University of Bozen-Bolzano, Italy
    DOLAP Proc. ACM Int. Workshop Data Warehousing OLAP, (81-88):
  • [33] Active data warehouses: complementing OLAP with analysis rules
    Thalhammer, T
    Schrefl, M
    Mohania, M
    DATA & KNOWLEDGE ENGINEERING, 2001, 39 (03) : 241 - 269
  • [34] Revisiting the OLAP interaction to cope with spatial data and spatial data analysis
    Matias, Rosa
    Moura-Pires, Joao
    ICEIS 2007: PROCEEDINGS OF THE NINTH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS: DATABASES AND INFORMATION SYSTEMS INTEGRATION, 2007, : 157 - +
  • [35] A Multidimensional Data Model and OLAP Analysis for Agricultural Production
    Radulescu, Constanta Zoie
    Radulescu, Marius
    Rahoveanu, Adrian Turek
    MICBE '09: PROCEEDINGS OF THE 10TH WSEAS INTERNATIONAL CONFERENCE ON MATHEMATICS AND COMPUTERS IN BUSINESS AND ECONOMICS, 2009, : 243 - +
  • [36] Outlier Detection in Data Streams Using OLAP Cubes
    Heine, Felix
    NEW TRENDS IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2017, 2017, 767 : 29 - 36
  • [37] Using data warehousing and OLAP in public health care
    Hristovski, D
    Rogac, M
    Markota, M
    JOURNAL OF THE AMERICAN MEDICAL INFORMATICS ASSOCIATION, 2000, : 369 - 373
  • [38] Managing quality by using OLAP techniques and data warehouses
    Faïz, S
    Zghal, HB
    ACCURACY 2000, PROCEEDINGS, 2000, : 203 - 206
  • [39] A Call Detail Records Data Mart: Data Modelling and OLAP Analysis
    Camilovic, Dragana
    Becejski-Vujaklija, Dragana
    Gospic, Natasa
    COMPUTER SCIENCE AND INFORMATION SYSTEMS, 2009, 6 (02) : 87 - 110
  • [40] The hierarchical agglomerative clustering with Gower index: A methodology for automatic design of OLAP cube in ecological data processing context
    Sautot, Lucile
    Faivre, Bruno
    Journaux, Ludovic
    Molin, Paul
    ECOLOGICAL INFORMATICS, 2015, 26 : 217 - 230
12345