Home // ICSEA 2021, The Sixteenth International Conference on Software Engineering Advances // View article

Relational Databases Ingestion into a NoSQL Data Warehouse

Authors:
Rym Jemmali
Fatma Abdelhedi
Gilles Zurfluh

Keywords: Data Lake; Data Warehouse; NoSQL; Big Data; Relational Database; MDA; QVT

Abstract:
The digital transformation of companies has led to the evolution of databases towards Big Data. Our work is part of this context and concerns more particularly the mechanisms to extract datasets stored in a Data Lake and to store the data in a Data Warehouse. The latter will allow, in a second time, decisional analysis. In this paper, we present the extraction mechanism limited to relational databases. To automate this process, we used the Model Driven Architecture (MDA), which offers a formalized environment for schema transformation. From the physical schemas describing a Data Lake, we propose transformation rules that allow the creation of a Data Warehouse stored on a document-oriented NoSQL system. An experimentation of the transformation process has been performed on a medical application.

Pages: 128 to 133

Copyright: Copyright (c) IARIA, 2021

Publication date: October 3, 2021

Published in: conference

ISSN: 2308-4235

ISBN: 978-1-61208-894-5

Location: Barcelona, Spain

Dates: from October 3, 2021 to October 7, 2021