DoD legacy systems: reverse engineering data requirements
Communications of the ACM
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
Closure maintenance in an object-oriented query model
CIKM '94 Proceedings of the third international conference on Information and knowledge management
A survey of database design transformations based on the Entity-Relationship model
Data & Knowledge Engineering
A framework for the design and evaluation of reverse engineering methods for relational databases
Data & Knowledge Engineering
Proper handling of query results towards maximizing reusability in object-oriented databases
Information Sciences: an International Journal
Incremental materialization of object-oriented views
Data & Knowledge Engineering
Designing the Reengineering Services for the DOK Federated Database System
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
A Query Model for Object-Oriented Databases
Proceedings of the Ninth International Conference on Data Engineering
A Method for Transforming Relational Schemas Into Conceptual Schemas
Proceedings of the Tenth International Conference on Data Engineering
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering
ER '94 Proceedings of the13th International Conference on the 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
Using Queries to Improve Database Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Requirements for information system reverse engineering support
WCRE '95 Proceedings of the Second Working Conference on Reverse Engineering
Dimensions of Data ase Reverse Engineering
WCRE '97 Proceedings of the Fourth Working Conference on Reverse Engineering (WCRE '97)
Deciding on the Equivalence of a Relational Schema and and Object-Oriented Schema
DEXA '00 Proceedings of the 11th International Conference on Database and Expert Systems Applications
| Hi-index | 0.00 |
This paper addresses the issue of documenting an existing legacy database by mining out its characteristics and derive the corresponding entity-relationship model. We developed algorithms to identify candidate keys of all relations in the relational schema, to locate the occurrence of a given candidate key as foreign key in any existing relation, and to decide on the appropriate links (relationships) between the given relations. Based on the mentioned analysis, we draw a graph that corresponds to the entity-relationship diagram, and predicts all possible relationships between relations in the existing relational schema. Finally, we derive the cardinality of each link in the graph.