Extraction process of conceptual model from a document-oriented NoSQL database

Amal Aït Brahim (1) , Rabah Tighilt Ferhat (1) , Gilles Zurfluh (1, 2)

1 IRIT-SIG - Systèmes d’Informations Généralisées
2 UT Capitole - Université Toulouse Capitole

NoSQL systems are used to manage massive databases that verify 3V: Volume, Variety and Velocity. Generally, these systems are known by the characteristic "schema less" which means that we can create a database without defining the data schema beforehand. This property offers more flexibility and speed by allowing the evolution of the data model during the exploitation of the base. However, to formulate queries on the database, the user needs a precise knowledge of data model. In this article, we propose a process for the automatic extraction of the conceptual model of a document-oriented NoSQL database. To do this, we use the Model Driven Architecture (MDA) architecture that provides a formal framework for automatic model transformation. From a NoSQL database, we propose a set of transformation rules with QVT to generate the conceptual model in the form of a UML class diagram. An experimentation of the extraction process was carried out on an application in the medical field.

Mots clés: Big Data; NoSQL; Model extraction; Schema less; MDA; QVT

Domaines: Recherche d'information [cs.IR]

Amal Aït Brahim, Rabah Tighilt Ferhat, Gilles Zurfluh. Extraction process of conceptual model from a document-oriented NoSQL database. 11th International Conference on Knowledge and Systems Engineering (KSE 2019), Oct 2019, Da Nang, Vietnam. pp.1--5, ⟨10.1109/KSE.2019.8919400⟩. ⟨hal-02950717⟩