Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
An approach for reverse engineering of relational databases
Communications of the ACM
Reverse engineering of relational databases: extraction of an EER model from a relational database
Data & Knowledge Engineering
Converting relational to object-oriented databases
ACM SIGMOD Record
Management Information Systems: A Contemporary Perspective
Management Information Systems: A Contemporary Perspective
Converting A Relational Database Model into an Entity-Relationship Model
Proceedings of the Sixth International Conference on Entity-Relationship Approach
Schema Transformation Techniques for Database Reverse Engineering
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Reconstruction of ER Schema from Database Applications: a Cognitive Approach
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
An Executable Meta Model for Re-Engineering of Database Schemas
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Using Queries to Improve Database Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Mapping an Extended Entity-Relationship Schema into a Schema of Complex Objects
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
Reverse Engineering of Relational Database Physical Schema
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
Towards an Assisted Reorganization of Is_A Hierarchies
OOIS '02 Proceedings of the 8th International Conference on Object-Oriented. Information Systems
Conceptual Data Modeling: An Algebraic Viewpoint
PSI '02 Revised Papers from the 4th International Andrei Ershov Memorial Conference on Perspectives of System Informatics: Akademgorodok, Novosibirsk, Russia
Re-engineering relational databases: the way forward
Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications
Performing and analyzing non-formal inspections of entity relationship diagram (ERD)
Journal of Systems and Software
| Hi-index | 0.00 |
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.