Building a Document-Oriented Warehouse Using NoSQL

Building a Document-Oriented Warehouse Using NoSQL

Ines Ben Messaoud (University of Gabes, Tunisia), Abdulrahman A. Alshdadi (University of Jeddah, Saudi Arabia) and Jamel Feki (University of Jeddah, Saudi Arabia)
DOI: 10.4018/IJORIS.20210401.oa3
Article PDF Download
Open access articles are freely available for download

Abstract

The traditional data warehousing approaches should adapt to take into consideration novel needs and data structures. In this context, NoSQL technology is progressively gaining a place in the research and industry domains. This paper proposes an approach for building a NoSQL document-oriented warehouse (DocW). This approach has two methods, namely 1) document warehouse builder and 2) NoSQL-Converter. The first method generates the DocW schema as a galaxy model whereas the second one translates the generated galaxy into a document-oriented NoSQL model. This relies on two types of rules: structure and hierarchical rules. Furthermore, in order to help understanding the textual results of analytical queries on the NoSQL-DocW, the authors define two semantic operators S-Drill-Up and S-Drill-Down to aggregate/expand the terms of query. The implementation of our proposals uses MangoDB and Talend. The experiment uses the medical collection Clef-2007 and two metrics called write request latency and read request latency to evaluate respectively the loading time and the response time to queries.
Article Preview
Top

Warehousing allows big data management and analysis; NoSQL offers interesting features to implement Data/Document warehouses (Chevalier et al., 2015a). Next, we review relevant works related to NoSQL warehouses.

In (Li, 2010) the author proposed a two-phase approach to transforming a relational database (RDB) into the column-oriented NoSQL HBase. First, they transform the relational schema into HBase schema; secondly, they express the relationships between the source and target schemas by mappings. Nevertheless, this approach applies on the conceptual schema only.

Similarly, the authors of (Freitas et al., 2016) suggested the R2NoSQL approach, which defines conceptual mappings to convert the concepts of a RDB into NoSQL.

Complete Article List

Search this Journal:
Reset
Volume 14: 1 Issue (2023): Forthcoming, Available for Pre-Order
Volume 13: 2 Issues (2022)
Volume 12: 4 Issues (2021)
Volume 11: 4 Issues (2020)
Volume 10: 4 Issues (2019)
Volume 9: 4 Issues (2018)
Volume 8: 4 Issues (2017)
Volume 7: 4 Issues (2016)
Volume 6: 4 Issues (2015)
Volume 5: 4 Issues (2014)
Volume 4: 4 Issues (2013)
Volume 3: 4 Issues (2012)
Volume 2: 4 Issues (2011)
Volume 1: 4 Issues (2010)
View Complete Journal Contents Listing