OATAO - Open Archive Toulouse Archive Ouverte Open Access Week

Document-oriented data warehouses: models and extended cuboids

Chevalier, Max and El Malki, Mohammed and Kopliku, Arlind and Teste, Olivier and Tournier, Ronan Document-oriented data warehouses: models and extended cuboids. (2016) In: 10th International IEEE Conference on Research Challenges in Information Science (RCIS 2016) co-located witht the 34th French Conference INFORSID, 1 June 2016 - 3 June 2016 (Grenoble, France).

[img]
Preview
(Document in English)

PDF (Author's version) - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
621kB

Official URL: http://dx.doi.org/10.1109/RCIS.2016.7549351

Abstract

Within the Big Data trend, there is an increasing interest in Not-only-SQL systems (NoSQL). These systems are promising candidates for implementing data warehouses particularly due to the data structuration/storage possibilities they offer. In this paper, we investigate data warehouse instantiation using a document-oriented system (a special class of NoSQL systems). On the one hand, we analyze several issues including modeling, querying, loading data and OLAP cuboids. We compare document-oriented models (with and without normalization) to analogous relational database models. On the other hand, we suggest improvements in order to benefit from document-oriented features. We focus particularly on extended versions of OLAP cuboids that exploit nesting and arrays. They are shown to work better on workloads with drill-down queries. Research in this direction is new. As existing work focuses on feasibility issues, document-specific implementation features, modeling and cross-model comparison.

Item Type:Conference or Workshop Item (Paper)
Additional Information:Thanks to IEEE editor. The definitive version is available at http://ieeexplore.ieee.org This papers appears in Proceedings of IEEE RCIS 2016. Electronic ISBN: 978-1-4799-8710-8 Electronic ISBN: 978-1-4799-8710-8 The original PDF of the article can be found at: http://ieeexplore.ieee.org/document/7549351/ Personal use of this material is permitted. Permission from IEEE must be obtained for all other uses, in any current or future media, including reprinting/republishing this material for advertising or promotional purposes, creating new collective works, for resale or redistribution to servers or lists, or reuse of any copyrighted component of this work in other works.
HAL Id:hal-01474901
Audience (conference):International conference proceedings
Uncontrolled Keywords:
Institution:French research institutions > Centre National de la Recherche Scientifique - CNRS (FRANCE)
Université de Toulouse > Institut National Polytechnique de Toulouse - INPT (FRANCE)
Université de Toulouse > Université Toulouse III - Paul Sabatier - UPS (FRANCE)
Université de Toulouse > Université Toulouse - Jean Jaurès - UT2J (FRANCE)
Université de Toulouse > Université Toulouse 1 Capitole - UT1 (FRANCE)
Other partners > Capgemini (FRANCE)
Laboratory name:
Statistics:download
Deposited By: IRIT IRIT
Deposited On:01 Feb 2017 10:01

Repository Staff Only: item control page