Laboratory LITEN, University Hassan 1, 26000 Settat, Morocco.

---

Abstract—In this paper, we present a method that retro-designs a relational database to generate a conceptual model by extracting data structures and constraints: Our method extracts a conceptual model directly from an existing relational database without using the ER model (Entity / Relationship). The method is proposed as a two-step process, the first is to extract the data structure of the relational database and the conceptualization of this data structure by generating a conceptual model. The second stage involves the extraction of relational constraints and the semantic enrichment of the conceptual model by improving the understanding of relationships between data structures.

Index Terms—RDB, model, meta-model, constraint, transformation, semantic.

[PDF]

Cite: Widad Jakjoud*, Mohamed Bahaj, "RDB2 Model: A Relational Databases Retro-Design Tool Enriched by the Extraction of Constraints," Journal of Software vol. 12, no. 6, pp. 426-438, 2017.