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 条
  • [1] Bandlimited OLAP Cubes for Interactive Big Data Visualization
    Reach, Caleb
    North, Chris
    [J]. 2015 IEEE 5TH SYMPOSIUM ON LARGE DATA ANALYSIS AND VISUALIZATION (LDAV), 2015, : 107 - 114
  • [2] Big Data Warehouse: Building Columnar NoSQL OLAP Cubes
    Dehdouh, Khaled
    Boussaid, Omar
    Bentayeb, Fadila
    [J]. INTERNATIONAL JOURNAL OF DECISION SUPPORT SYSTEM TECHNOLOGY, 2020, 12 (01) : 1 - 24
  • [3] Nested data cubes for OLAP
    Dekeyser, S
    Kuijpers, B
    Paredaens, J
    Wijsen, J
    [J]. ADVANCES IN DATABASE TECHNOLOGIES, 1999, 1552 : 129 - 140
  • [4] Prediction in OLAP Data Cubes
    Salmam, Fatima Zahra
    Fakir, Mohamed
    Errattahi, Rahhal
    [J]. JOURNAL OF INFORMATION & KNOWLEDGE MANAGEMENT, 2016, 15 (02)
  • [5] Explanation in OLAP Data Cubes
    Errattahi, Rahhal
    Fakir, Mohammed
    Salmam, Fatima Zahra
    [J]. JOURNAL OF INFORMATION TECHNOLOGY RESEARCH, 2014, 7 (04) : 63 - 78
  • [6] OLAP*: Effectively and Efficiently Supporting Parallel OLAP over Big Data
    Cuzzocrea, Alfredo
    Moussa, Rim
    Xu, Guandong
    [J]. MODEL AND DATA ENGINEERING, MEDI 2013, 2013, 8216 : 38 - 49
  • [7] Special issue on DOLAP 2015: Evolving data warehousing and OLAP cubes to big data analytics
    Ordonez, Carlos
    Garcia-Alvarado, Carlos
    Song, Il-Yeol
    [J]. INFORMATION SYSTEMS, 2017, 68 : 1 - 2
  • [8] Efficiently Computing and Querying Multidimensional OLAP Data Cubes over Probabilistic Relational Data
    Cuzzocrea, Alfredo
    Gunopulos, Dimitrios
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, 2010, 6295 : 132 - +
  • [9] Specifying OLAP Cubes on XML Data
    Mikael R. Jensen
    Thomas H. Møller
    Torben Bach Pedersen
    [J]. Journal of Intelligent Information Systems, 2001, 17 : 255 - 280
  • [10] Specifying OLAP cubes on XML data
    Jensen, MR
    Moller, TH
    Pedersen, TB
    [J]. JOURNAL OF INTELLIGENT INFORMATION SYSTEMS, 2001, 17 (2-3) : 255 - 280