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 条
  • [41] A multi-source spatio-temporal data cube for large-scale geospatial analysis
    Gao, Fan
    Yue, Peng
    Cao, Zhipeng
    Zhao, Shuaifeng
    Shangguan, Boyi
    Jiang, Liangcun
    Hu, Lei
    Fang, Zhe
    Liang, Zheheng
    INTERNATIONAL JOURNAL OF GEOGRAPHICAL INFORMATION SCIENCE, 2022, 36 (09) : 1853 - 1884
  • [42] GeoCube： A spatio-temporal cube toward massive and multi-source EO data analysis
    Gao F.
    Yue P.
    Jiang L.
    Cao Z.
    Liang Z.
    Shangguan B.
    Hu L.
    Zhao S.
    National Remote Sensing Bulletin, 2022, 26 (06) : 1051 - 1066
  • [43] Crop growth monitoring study by using multi-temporal index image cube analysis
    Tong, QX
    Zhang, X
    Zhang, B
    Wang, J
    2002 INTERNATIONAL CONFERENCE ON COMMUNICATIONS, CIRCUITS AND SYSTEMS AND WEST SINO EXPOSITION PROCEEDINGS, VOLS 1-4, 2002, : 1596 - 1601
  • [44] Spatial and Temporal Data Analysis with Deep Learning for Air Quality Prediction
    Alsaedi, Alaa Saleh
    Liyakathunisa
    12TH INTERNATIONAL CONFERENCE ON THE DEVELOPMENTS IN ESYSTEMS ENGINEERING (DESE 2019), 2019, : 581 - 587
  • [45] Construction of decision trees using data cube
    Fu, Lixin
    ENTERPRISE INFORMATION SYSTEMS VII, 2006, : 87 - 94
  • [46] MRDataCube: Data Cube Computation Using MapReduce
    Lee, Suan
    Jo, Sunhwa
    Kim, Jinho
    2015 INTERNATIONAL CONFERENCE ON BIG DATA AND SMART COMPUTING (BIGCOMP), 2015, : 95 - 102
  • [47] Designing Data Warehouses for Geographic OLAP Querying by Using MDA
    Glorio, Octavio
    Trujillo, Juan
    COMPUTATIONAL SCIENCE AND ITS APPLICATIONS - ICCSA 2009, PT I, 2009, 5592 : 505 - 519
  • [48] RADAR DATA CUBE ANALYSIS FOR FALL DETECTION
    Erol, Baris
    Amin, Moeness G.
    2018 IEEE INTERNATIONAL CONFERENCE ON ACOUSTICS, SPEECH AND SIGNAL PROCESSING (ICASSP), 2018, : 2446 - 2450
  • [49] OLAP Analysis Operators for Multi-State Data Warehouses
    Ravat, Franck
    Song, Jiefu
    Teste, Olivier
    INTERNATIONAL JOURNAL OF DATA WAREHOUSING AND MINING, 2016, 12 (04) : 20 - 53
  • [50] OLAP on Complex Data: Visualization Operator Based on Correspondence Analysis
    Loudcher, Sabine
    Boussaid, Omar
    IS OLYMPICS: INFORMATION SYSTEMS IN A DIVERSE WORLD, 2012, 107 : 172 - 185
12345