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 条
  • [41] Web 2.0 OLAP: From Data Cubes to Tag Clouds
    Aouiche, Kamel
    Lemire, Daniel
    Godin, Robert
    [J]. WEB INFORMATION SYSTEMS AND TECHNOLOGIES, 2009, 18 : 51 - 64
  • [42] Benchmarking Big Data OLAP NoSQL Databases
    El Malki, Mohammed
    Kopliku, Arlind
    Sabir, Essaid
    Teste, Olivier
    [J]. UBIQUITOUS NETWORKING, UNET 2018, 2018, 11277 : 82 - 94
  • [43] An Optimized Distributed OLAP System for Big Data
    Chen, Wenhao
    Wang, Haoxiang
    Zhang, Xingming
    Lin, Qidi
    [J]. 2017 2ND IEEE INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND APPLICATIONS (ICCIA), 2017, : 36 - 40
  • [44] OLAP over uncertain and imprecise data
    Burdick, Doug
    Deshpande, Prasad M.
    Jayram, T. S.
    Ramakrishnan, Raghu
    Vaithyanathan, Shivakumar
    [J]. VLDB JOURNAL, 2007, 16 (01): : 123 - 144
  • [45] OLAP over uncertain and imprecise data
    Doug Burdick
    Prasad M. Deshpande
    T. S. Jayram
    Raghu Ramakrishnan
    Shivakumar Vaithyanathan
    [J]. The VLDB Journal, 2007, 16 : 123 - 144
  • [46] Range top/bottom k queries in OLAP sparse data cubes
    Luo, ZW
    Ling, TW
    Ang, CH
    Lee, SY
    Cui, B
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS, 2001, 2113 : 678 - 687
  • [47] Cloud-based OLAP over Big Data: Application Scenarios and Performance Analysis
    Cuzzocrea, Alfredo
    Moussa, Rim
    Xu, Guandong
    Grasso, Giorgio Mario
    [J]. 2015 15TH IEEE/ACM INTERNATIONAL SYMPOSIUM ON CLUSTER, CLOUD AND GRID COMPUTING, 2015, : 921 - 927
  • [48] Multiple-objective compression of data cubes in cooperative OLAP environments
    Cuzzocrea, Alfredo
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2008, 5207 : 62 - 80
  • [49] Semantics-aware advanced OLAP visualization of multidimensional data cubes
    Department of Electronics Computer Science and Systems, University of Calabria, Calabria, Italy
    不详
    不详
    [J]. Int. J. Data Warehouse. Min., 2007, 4 (1-30):
  • [50] i3:: Intelligent, interactive investigaton of OLAP data cubes
    Sarawagi, S
    Sathe, G
    [J]. SIGMOD RECORD, 2000, 29 (02) : 589 - 589