Relational database reverse engineering : elicitation of generalization hierarchies
International audience This paper describes a method aiming at the extraction of generalization/specialization hierarchies contained in a relational database. This reverse engineering approach takes advantage of two major characteristics: first, we use DDL and DML specifications as well as data in a...
Main Authors: | , , |
---|---|
Other Authors: | , , , , , , , , |
Format: | Conference Object |
Language: | English |
Published: |
HAL CCSD
1999
|
Subjects: | |
Online Access: | https://hal.archives-ouvertes.fr/hal-01124843 https://doi.org/10.1007/3-540-48054-4_15 |
id |
ftccsdartic:oai:HAL:hal-01124843v1 |
---|---|
record_format |
openpolar |
spelling |
ftccsdartic:oai:HAL:hal-01124843v1 2023-05-15T16:01:53+02:00 Relational database reverse engineering : elicitation of generalization hierarchies Akoka, Jacky Comyn-Wattiau, Isabelle Lammari, Nadira Centre d'études et de recherche en informatique et communications (CEDRIC) Ecole Nationale Supérieure d'Informatique pour l'Industrie et l'Entreprise (ENSIIE)-Conservatoire National des Arts et Métiers CNAM (CNAM) Département Systèmes d'Information (DSI) Télécom Ecole de Management (TEM)-Institut Mines-Télécom Paris (IMT)-Institut Mines-Télécom Business School (IMT-BS) Institut Mines-Télécom Paris (IMT) Parallélisme, Réseaux, Systèmes, Modélisation (PRISM) Université de Versailles Saint-Quentin-en-Yvelines (UVSQ)-Centre National de la Recherche Scientifique (CNRS) ESSEC Business School Essec Business School Paris, France 1999-11-15 https://hal.archives-ouvertes.fr/hal-01124843 https://doi.org/10.1007/3-540-48054-4_15 en eng HAL CCSD Springer info:eu-repo/semantics/altIdentifier/doi/10.1007/3-540-48054-4_15 hal-01124843 https://hal.archives-ouvertes.fr/hal-01124843 doi:10.1007/3-540-48054-4_15 Advances in Conceptual Modeling : ER’ 99 Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling Paris, France, November 15–18, 1999 Proceedings ER’ 99 Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling https://hal.archives-ouvertes.fr/hal-01124843 ER’ 99 Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling, Nov 1999, Paris, France. pp.173-185, ⟨10.1007/3-540-48054-4_15⟩ [INFO]Computer Science [cs] [INFO.INFO-DB]Computer Science [cs]/Databases [cs.DB] info:eu-repo/semantics/conferenceObject Conference papers 1999 ftccsdartic https://doi.org/10.1007/3-540-48054-4_15 2021-10-24T12:19:30Z International audience This paper describes a method aiming at the extraction of generalization/specialization hierarchies contained in a relational database. This reverse engineering approach takes advantage of two major characteristics: first, we use DDL and DML specifications as well as data in a combined way, secondly, we provide not only generalization/specialization hierarchies but also integrity constraints allowing us to elicit the generalization/specialization links hidden in the structures and instances of the database. The result of the process consists of an enriched conceptual representation of the relational database. This approach is mainly based on heuristics. The heuristic rules map a relational meta-model onto a conceptual one. They are divided into three categories: semantics suspicion rules, reinforcement rules and confirmation rules. We illustrate our approach using a fairly complex example. Some extensions are discussed. Conference Object DML Archive ouverte HAL (Hyper Article en Ligne, CCSD - Centre pour la Communication Scientifique Directe) 173 185 |
institution |
Open Polar |
collection |
Archive ouverte HAL (Hyper Article en Ligne, CCSD - Centre pour la Communication Scientifique Directe) |
op_collection_id |
ftccsdartic |
language |
English |
topic |
[INFO]Computer Science [cs] [INFO.INFO-DB]Computer Science [cs]/Databases [cs.DB] |
spellingShingle |
[INFO]Computer Science [cs] [INFO.INFO-DB]Computer Science [cs]/Databases [cs.DB] Akoka, Jacky Comyn-Wattiau, Isabelle Lammari, Nadira Relational database reverse engineering : elicitation of generalization hierarchies |
topic_facet |
[INFO]Computer Science [cs] [INFO.INFO-DB]Computer Science [cs]/Databases [cs.DB] |
description |
International audience This paper describes a method aiming at the extraction of generalization/specialization hierarchies contained in a relational database. This reverse engineering approach takes advantage of two major characteristics: first, we use DDL and DML specifications as well as data in a combined way, secondly, we provide not only generalization/specialization hierarchies but also integrity constraints allowing us to elicit the generalization/specialization links hidden in the structures and instances of the database. The result of the process consists of an enriched conceptual representation of the relational database. This approach is mainly based on heuristics. The heuristic rules map a relational meta-model onto a conceptual one. They are divided into three categories: semantics suspicion rules, reinforcement rules and confirmation rules. We illustrate our approach using a fairly complex example. Some extensions are discussed. |
author2 |
Centre d'études et de recherche en informatique et communications (CEDRIC) Ecole Nationale Supérieure d'Informatique pour l'Industrie et l'Entreprise (ENSIIE)-Conservatoire National des Arts et Métiers CNAM (CNAM) Département Systèmes d'Information (DSI) Télécom Ecole de Management (TEM)-Institut Mines-Télécom Paris (IMT)-Institut Mines-Télécom Business School (IMT-BS) Institut Mines-Télécom Paris (IMT) Parallélisme, Réseaux, Systèmes, Modélisation (PRISM) Université de Versailles Saint-Quentin-en-Yvelines (UVSQ)-Centre National de la Recherche Scientifique (CNRS) ESSEC Business School Essec Business School |
format |
Conference Object |
author |
Akoka, Jacky Comyn-Wattiau, Isabelle Lammari, Nadira |
author_facet |
Akoka, Jacky Comyn-Wattiau, Isabelle Lammari, Nadira |
author_sort |
Akoka, Jacky |
title |
Relational database reverse engineering : elicitation of generalization hierarchies |
title_short |
Relational database reverse engineering : elicitation of generalization hierarchies |
title_full |
Relational database reverse engineering : elicitation of generalization hierarchies |
title_fullStr |
Relational database reverse engineering : elicitation of generalization hierarchies |
title_full_unstemmed |
Relational database reverse engineering : elicitation of generalization hierarchies |
title_sort |
relational database reverse engineering : elicitation of generalization hierarchies |
publisher |
HAL CCSD |
publishDate |
1999 |
url |
https://hal.archives-ouvertes.fr/hal-01124843 https://doi.org/10.1007/3-540-48054-4_15 |
op_coverage |
Paris, France |
genre |
DML |
genre_facet |
DML |
op_source |
Advances in Conceptual Modeling : ER’ 99 Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling Paris, France, November 15–18, 1999 Proceedings ER’ 99 Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling https://hal.archives-ouvertes.fr/hal-01124843 ER’ 99 Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling, Nov 1999, Paris, France. pp.173-185, ⟨10.1007/3-540-48054-4_15⟩ |
op_relation |
info:eu-repo/semantics/altIdentifier/doi/10.1007/3-540-48054-4_15 hal-01124843 https://hal.archives-ouvertes.fr/hal-01124843 doi:10.1007/3-540-48054-4_15 |
op_doi |
https://doi.org/10.1007/3-540-48054-4_15 |
container_start_page |
173 |
op_container_end_page |
185 |
_version_ |
1766397570413756416 |