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 条
  • [1] ANALYSIS OF MULTIDIMENSIONAL OLAP DATA CUBE
    Codreanu, Diana-Elena
    Radut, Carmen
    Popa, Ionela
    Parpandel, Denisa
    [J]. 17TH INTERNATIONAL CONFERENCE - THE KNOWLEDGE-BASED ORGANIZATION: APPLIED TECHNICAL SCIENCES AND ADVANCED MILITARY TECHNOLOGIES, CONFERENCE PROCEEDING 3, 2011, : 251 - 255
  • [2] A new data cube for integrating data mining and OLAP
    Ohmori, Tadashi
    Naruse, Masahide
    Hoshi, Mamoru
    [J]. 2007 IEEE 23RD INTERNATIONAL CONFERENCE ON DATA ENGINEERING WORKSHOP, VOLS 1-2, 2007, : 896 - 903
  • [3] Fuzzy OLAP cube for qualitative analysis
    Kumar, KVNNP
    Krishna, PR
    De, SK
    [J]. 2005 International Conference on Intelligent Sensing and Information Processing, Proceedings, 2005, : 290 - 295
  • [4] Compressed data cube for approximate OLAP query processing
    Feng, Y
    Wang, S
    [J]. JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY, 2002, 17 (05) : 625 - 635
  • [5] A wavelet framework for adapting data cube views for OLAP
    Smith, JR
    Li, CS
    Jhingran, A
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2004, 16 (05) : 552 - 565
  • [6] Compressed data cube for approximate OLAP query processing
    Yu Feng
    Shan Wang
    [J]. Journal of Computer Science and Technology, 2002, 17 : 625 - 635
  • [7] NetCube: a comprehensive network traffic analysis model based on multidimensional OLAP data cube
    Park, Daihee
    Yu, Jaehak
    Park, Jun-Sang
    Kim, Myung-Sup
    [J]. INTERNATIONAL JOURNAL OF NETWORK MANAGEMENT, 2013, 23 (02) : 101 - 118
  • [8] A New Big Data Benchmark for OLAP Cube Design Using Data Pre-Aggregation Techniques
    Tardio, Roberto
    Mate, Alejandro
    Trujillo, Juan
    [J]. APPLIED SCIENCES-BASEL, 2020, 10 (23): : 1 - 18
  • [9] A Data Cube Design and Construction Methodology Based on OLAP Queries
    Djiroun, Rahma
    Boukhalfa, Kamel
    Alimazighi, Zaia
    Atigui, Faten
    Bimonte, Sandro
    [J]. 2016 IEEE/ACS 13TH INTERNATIONAL CONFERENCE OF COMPUTER SYSTEMS AND APPLICATIONS (AICCSA), 2016,
  • [10] Programming of automatic and incremental update of data cube in MS OLAP
    Xiang, Yang
    Wang, Qingda
    Zhang, Yingchun
    [J]. Jisuanji Gongcheng/Computer Engineering, 2005, 31 (20): : 70 - 71
12345