Authors:
Ines Ben Messaoud
1
;
Refka Ben Ali
2
and
Jamel Feki
3
Affiliations:
1
Laboratory Mir@cl and University of Sfax, Tunisia
;
2
Institute of Management of Gabès and University of Gabès, Tunisia
;
3
University of Jeddah, Saudi Arabia
Keyword(s):
NoSQL Document Warehouse, Galaxy Model, Column-Oriented Model, Hierarchical Transformation.
Related
Ontology
Subjects/Areas/Topics:
Artificial Intelligence
;
Business Analytics
;
Cardiovascular Technologies
;
Computing and Telecommunications in Cardiology
;
Data Engineering
;
Decision Support Systems
;
Decision Support Systems, Remote Data Analysis
;
Health Engineering and Technology Applications
;
Knowledge-Based Systems
;
Symbolic Systems
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.