Relational Databases Ingestion into a NoSQL Data Warehouse - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2021

Relational Databases Ingestion into a NoSQL Data Warehouse

Résumé

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.
Fichier principal
Vignette du fichier
Relational Databases Ingestion into a NoSQL Data Warehouse 2021.pdf (675.22 Ko) Télécharger le fichier
Origine Fichiers produits par l'(les) auteur(s)

Dates et versions

hal-03758339 , version 1 (23-08-2022)

Identifiants

Citer

Fatma Abdelhedi, Rym Jemmali, Gilles Zurfluh. Relational Databases Ingestion into a NoSQL Data Warehouse. Sixteenth International Conference on Software Engineering Advances (ICSEA 2021), Oct 2021, Barcelone, Spain. ⟨hal-03758339⟩
44 Consultations
60 Téléchargements

Altmetric

Partager

Gmail Mastodon Facebook X LinkedIn More