From Document Warehouse to Column-Oriented NoSQL Document Warehouse

Ines Ben Messaoud, Refka Ben Ali, Jamel Feki

2017

Abstract

NoSQL (Not only SQL) gathers recent solutions that differ from the SQL model by a different logic of data representation. It is characterized by its performance and its ability to handle a large amount of data. Due to the absence of a clear approach to implement a Document Warehouse (DocW) under NoSQL model, we propose, in this paper, a set of rules to transform the multidimensional galaxy model of the DocW into the column-oriented NoSQL model. We suggest two types of transformations namely Simple and Hierarchical. In order to validate our proposed transformation rules, we have used Cassandra as a Column-oriented NoSQL system to implement a DocW for each type of transformation. We used Talend Data Integration tool to load data in the implemented DocWs. We evaluate these two DocWs with two metrics WRL (Write Request Latency) and RRL (Read Request Latency) using a medical collection.

Paper Citation

in Harvard Style

Ben Messaoud I., Ben Ali R. and Feki J. (2017). From Document Warehouse to Column-Oriented NoSQL Document Warehouse . In Proceedings of the 12th International Conference on Software Technologies - Volume 1: ICSOFT, ISBN 978-989-758-262-2, pages 85-94. DOI: 10.5220/0006423500850094

in Bibtex Style

@conference{icsoft17,
author={Ines Ben Messaoud and Refka Ben Ali and Jamel Feki},
title={From Document Warehouse to Column-Oriented NoSQL Document Warehouse},
booktitle={Proceedings of the 12th International Conference on Software Technologies - Volume 1: ICSOFT,},
year={2017},
pages={85-94},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006423500850094},
isbn={978-989-758-262-2},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 12th International Conference on Software Technologies - Volume 1: ICSOFT,
TI - From Document Warehouse to Column-Oriented NoSQL Document Warehouse
SN - 978-989-758-262-2
AU - Ben Messaoud I.
AU - Ben Ali R.
AU - Feki J.
PY - 2017
SP - 85
EP - 94
DO - 10.5220/0006423500850094