loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Max Chevalier 1 ; Mohammed El Malki 2 ; Arlind Kopliku 1 ; Olivier Teste 1 and Ronan Tournier 1

Affiliations: 1 University of Toulouse, France ; 2 University of Toulouse and Capgemini, France

Keyword(s): NoSQL, OLAP, Aggregate Lattice, Column-oriented, Document-oriented.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

Abstract: Not only SQL (NoSQL) databases are becoming increasingly popular and have some interesting strengths such as scalability and flexibility. In this paper, we investigate on the use of NoSQL systems for implementing OLAP (On-Line Analytical Processing) systems. More precisely, we are interested in instantiating OLAP systems (from the conceptual level to the logical level) and instantiating an aggregation lattice (optimization). We define a set of rules to map star schemas into two NoSQL models: column-oriented and document-oriented. The experimental part is carried out using the reference benchmark TPC. Our experiments show that our rules can effectively instantiate such systems (star schema and lattice). We also analyze differences between the two NoSQL systems considered. In our experiments, HBase (column-oriented) happens to be faster than MongoDB (document-oriented) in terms of loading time.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 13.59.218.147

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Chevalier, M.; El Malki, M.; Kopliku, A.; Teste, O. and Tournier, R. (2015). Implementing Multidimensional Data Warehouses into NoSQL. In Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 2: ICEIS; ISBN 978-989-758-096-3; ISSN 2184-4992, SciTePress, pages 172-183. DOI: 10.5220/0005379801720183

@conference{iceis15,
author={Max Chevalier. and Mohammed {El Malki}. and Arlind Kopliku. and Olivier Teste. and Ronan Tournier.},
title={Implementing Multidimensional Data Warehouses into NoSQL},
booktitle={Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 2: ICEIS},
year={2015},
pages={172-183},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005379801720183},
isbn={978-989-758-096-3},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 2: ICEIS
TI - Implementing Multidimensional Data Warehouses into NoSQL
SN - 978-989-758-096-3
IS - 2184-4992
AU - Chevalier, M.
AU - El Malki, M.
AU - Kopliku, A.
AU - Teste, O.
AU - Tournier, R.
PY - 2015
SP - 172
EP - 183
DO - 10.5220/0005379801720183
PB - SciTePress

- Science and Technology Publications, Lda.
RESOURCES

Proceedings

Papers

Authors

Ontology

CONTACTS

Science and Technology Publications, Lda
Avenida de S. Francisco Xavier, Lote 7 Cv. C,
2900-616 Setúbal, Portugal.

Phone: +351 265 520 185 (National fixed network call)
Fax: +351 265 520 186
Email: info@scitepress.org

EXTERNAL LINKS

PRIMORIS

INSTICC

SCITEVENTS

CROSSREF

PROCEEDINGS SUBMITTED FOR INDEXATION BY:

dblp

Ei Compendex

SCOPUS

Semantic Scholar

Google Scholar

Microsoft Academic