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 条
  • [21] Using superimposed multidimensional schemas and OLAP patterns for RDF data analysis
    Hilal, Median
    Schuetz, Christoph G.
    Schrefl, Michael
    OPEN COMPUTER SCIENCE, 2018, 8 (01): : 18 - 37
  • [22] AIR POLUTION AS CRITERION IN MULTI CRITERIA ANALYSIS PERFORMED IN HDM-4
    Decky, Martin
    Mikolaj, Jan
    Remek, Lubos
    Pepucha, Lubomir
    GEOCONFERENCE ON ECOLOGY, ECONOMICS, EDUCATION AND LEGISLATION, SGEM 2013, VOL II, 2013, : 27 - 34
  • [23] Using OLAP and multidimensional data for decision making
    Hasan, H.
    Hyland, P.
    IT Professional, 2001, 3 (05) : 44 - 50
  • [24] Association analysis of air polution on acute coronary syndrome and myocardial infarction in a large cohort
    Taucher, V.
    Rainer, P.
    Ablasser, K.
    Berghaus, T. M.
    Zechner, P.
    Weihs, W.
    Muster, A.
    Von Lewinski, D.
    EUROPEAN HEART JOURNAL, 2018, 39 : 499 - 499
  • [25] The Swiss data cube, analysis ready data archive using earth observations of Switzerland
    Chatenoux, Bruno
    Richard, Jean-Philippe
    Small, David
    Roeoesli, Claudia
    Wingate, Vladimir
    Poussin, Charlotte
    Rodila, Denisa
    Peduzzi, Pascal
    Steinmeier, Charlotte
    Ginzler, Christian
    Psomas, Achileas
    Schaepman, Michael E.
    Giuliani, Gregory
    SCIENTIFIC DATA, 2021, 8 (01)
  • [26] Interactive analysis of event data using space-time cube
    Gatalsky, P
    Andrienko, N
    Andrienko, G
    EIGHTH INTERNATIONAL CONFERENCE ON INFORMATION VISUALISATION, PROCEEDINGS, 2004, : 145 - 152
  • [27] The Swiss data cube, analysis ready data archive using earth observations of Switzerland
    Bruno Chatenoux
    Jean-Philippe Richard
    David Small
    Claudia Roeoesli
    Vladimir Wingate
    Charlotte Poussin
    Denisa Rodila
    Pascal Peduzzi
    Charlotte Steinmeier
    Christian Ginzler
    Achileas Psomas
    Michael E. Schaepman
    Gregory Giuliani
    Scientific Data, 8
  • [28] Spatio-Temporal Analysis of Large Air Pollution Data
    Bin Tarek, Mirza Farhan
    Asaduzzaman, Md
    Patwary, Mohammad
    2018 10TH INTERNATIONAL CONFERENCE ON ELECTRICAL AND COMPUTER ENGINEERING (ICECE), 2018, : 221 - 224
  • [29] Clinical Decision Support Using OLAP With Data Mining
    Palaniappan, Sellappan
    Ling, Chua Sook
    INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND NETWORK SECURITY, 2008, 8 (09): : 290 - 296
  • [30] Movie Recommendation Using OLAP and Multidimensional Data Model
    Jakkhupan, Worapot
    Kajkamhaeng, Supasit
    COMPUTER INFORMATION SYSTEMS AND INDUSTRIAL MANAGEMENT, CISIM 2014, 2014, 8838 : 209 - 218
12345