Taming Size and Cardinality of OLAP Data Cubes over Big Data

被引:0
|
作者
Cuzzocrea, Alfredo [1 ,2 ]
Moussa, Rim [3 ]
Laabidi, Achref [4 ]
机构
[1] Univ Trieste, DIA Dept, Trieste, Italy
[2] ICAR CNR, Trieste, Italy
[3] Univ Carthage, LaTICE, ENI Carthage, Carthage, Tunisia
[4] Univ Carthage, ENI Carthage, Carthage, Tunisia
来源
DATA ANALYTICS | 2017年 / 10365卷
关键词
Multidimensional databases; Data warehousing; Schema evolution; Logical OLAP Design;
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
In this paper, we provide three authoritative application scenarios of TPC-H*d. The latter is a suitable transformation of TPC-H benchmark. The three application scenarios are (i) OLAP cube calculus on top of columnar relational DBMS, (ii) parallel OLAP data cube processing and (iii) virtual OLAP data cube design. We assess the effectiveness and the efficiency of our proposal, using open source systems, namely, Mondrian ROLAP server and its OLAP4j driver, MySQL-row oriented relational database management system and MonetDB - a column-oriented relational database management system.
引用
收藏
页码:113 / 125
页数:13
相关论文
共 50 条
  • [21] Self-Service, On-Demand Creation of OLAP Cubes over Big Data: a Metadata-Driven Approach
    Latreche, Othmane
    Boukraa, Doulkifli
    [J]. 2020 IEEE INTERNATIONAL CONFERENCE ON BIG DATA (BIG DATA), 2020, : 2907 - 2914
  • [22] BAYESIAN OPTIMIZATION ALGORITHM FOR OLAP DATA CUBES
    Jia, Chen
    Chen, HongWei
    [J]. 2011 INTERNATIONAL CONFERENCE ON INSTRUMENTATION, MEASUREMENT, CIRCUITS AND SYSTEMS (ICIMCS 2011), VOL 2: FUTURE COMMUNICATION AND NETWORKING, 2011, : 391 - 394
  • [23] Missing Data in OLAP Cubes: Challenges and Strategies
    Tremblay, Monica Chiarini
    Hevner, Alan R.
    [J]. JOURNAL OF DATABASE MANAGEMENT, 2021, 32 (03) : 1 - 28
  • [24] OLAP Operators for Complex Object Data Cubes
    Boukraa, Doulkifli
    Boussaid, Omar
    Bentayeb, Fadila
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, 2010, 6295 : 103 - +
  • [25] A Genetic Selection Algorithm for OLAP Data Cubes
    Wen-Yang Lin
    I-Chung Kuo
    [J]. Knowledge and Information Systems, 2004, 6 : 83 - 102
  • [26] OLAP over Probabilistic Data Cubes II: Parallel Materialization and Extended Aggregates
    Xie, Xike
    Zou, Kai
    Hao, Xingjun
    Pedersen, Torben Bach
    Jin, Peiquan
    Yang, Wei
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2020, 32 (10) : 1966 - 1981
  • [27] OLAP analysis based on clustering over big data streams
    Woo, Ho Jin
    Joo, Kil Hong
    Park, Nam Hun
    [J]. ASIA LIFE SCIENCES, 2015, : 223 - 232
  • [28] Data Cubes Integration in Spatial OLAP for Agricultural Commodities
    Putri, A. I.
    Sitanggang, I. S.
    [J]. 3RD INTERNATIONAL SEMINAR ON SCIENCES SCIENCES ON PRECISION AND SUSTAINABLE AGRICULTURE (ISS-2016), 2017, 58
  • [29] Range sum queries in dynamic OLAP data cubes
    Li, HG
    Ling, TW
    Lee, SY
    Loh, ZX
    [J]. PROCEEDINGS OF THE THIRD INTERNATIONAL SYMPOSIUM ON COOPERATIVE DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, 2000, : 74 - 81
  • [30] Discretization of Continuous Valued Dimensions in OLAP Data Cubes
    Palaniappan, Sellappan
    Hong, Tan Kim
    [J]. INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND NETWORK SECURITY, 2008, 8 (11): : 116 - 126