A generic metadata management model for heterogeneous sources in a data warehouse

¹ LIMA laboratory,Ibn Zohr University, Agadir, Avenue Tamsoult, Morocco
² AS laboratory, Abdelmalek Essaadi University, Al hoceima, Morocco

^* Corresponding author: o.oukhouya@uiz.ac.ma

Abstract

For more than 30 decades, data warehouses have been considered the only business intelligence storage system for enterprises. However, with the advent of big data, they have been modernized to support the variety and dynamics of data by adopting the data lake as a centralized data source for heterogeneous sources. Indeed, the data lake is characterized by its flexibility and performance when storing and analyzing data. However, the absence of schema on the data during ingestion increases the risk of the transformation of the data lake into a data swamp, so the use of metadata management is essential to exploit the data lake. In this paper, we will present a conceptual metadata management model for the data lake. Our solution will be based on a functional architecture of the data lake as well as on a set of features allowing the genericity of the metadata model. Furthermore, we will present a set of transformation rules, allowing us to translate our conceptual model into an owl ontology.