Automatic reverse engineering approach for the extraction of ERC+ from databases

Authors:
Issam A. R. Moghrabi;Raji F. Abou Rakabeh
Affiliations:
Natural Science Division, Lebanese American University, P.O. Box 13-5053, Beirut, LEBANON;Natural Science Division, Lebanese American University, P.O. Box 13-5053, Beirut, LEBANON
Venue:
Progress in computer research
Year:
2001

Citing 11
Cited 0

Software engineering: a practitioner's approach (2nd ed.)

Software engineering: a practitioner's approach (2nd ed.)
Object-oriented analysis (2nd ed.)

Object-oriented analysis (2nd ed.)
Fundamentals of database systems (2nd ed.)

Fundamentals of database systems (2nd ed.)
Fundamentals of algorithmics

Fundamentals of algorithmics
Case: Using Software Development Tools

Case: Using Software Development Tools
Database System Concepts

Database System Concepts
A Proposal for Formalizing and Extending the Generalization and Subset Abstractions in the Enity-Relationship Model

Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
An ER Calculus for the Entity-Relationship Complex Model

Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Name Assignment Techniques for Relational Schemas Representing Extended Entity-Relationship Schemas

Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Some Findings on the Intuitivness of Entity-Relationship Constructs

Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering

ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach

Quantified Score

Hi-index	0.00

Visualization

Abstract

A fully automatic Reverse Engineering method is presented in this work to extract a conceptual schema from a relational database. Such a practical method depends on the analysis of the database extension as well as the analysis of data manipulation statements in the source code of a database application that uses a Relational Database Management System. Attributes representing references between tables in the relational schema are determined by an analysis of join conditions in all queries of the database. Also, database extension helps in determining the inclusion dependencies between tables.