Automatic reverse engineering extraction of ERC + from relational databases. (c1998)

LAUR Repository

Show simple item record

dc.contributor.author Abou Rakabeh, Raji F.
dc.date.accessioned 2011-04-26T08:32:38Z
dc.date.available 2011-04-26T08:32:38Z
dc.date.copyright 1998 en_US
dc.date.issued 2011-04-26
dc.date.submitted 1998-06
dc.identifier.uri http://hdl.handle.net/10725/420
dc.description Includes bibliographical references (leaves 78-79). en_US
dc.description.abstract A reverse engineering method is presented and implemented in this work to extract a conceptual schema from a relational database. In this work we extend the extraction method presented in Andersson's paper entitled "Extracting an entity relationship schema from a relational database through reverse engineering". Such a method depends on the analysis of the database extension as well as the analysis of data manipulating statements, SQL 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. Candidate keys are determined with the help of the referencing attributes in their corresponding relations. The analysis of the database extension will determine whether the proposed keys are actually primary keys or not. Also, database extension helps in determining the inclusion dependencies between tables. When ambiguity occurs concerning candidate keys, users can interact with the system to clarity such ambiguity. This approach makes it possible to efficiently construct a conceptual schema, ERC+, from only elementary information. en_US
dc.language.iso en en_US
dc.subject Reverse engineering en_US
dc.subject Relational databases en_US
dc.title Automatic reverse engineering extraction of ERC + from relational databases. (c1998) en_US
dc.type Thesis en_US
dc.term.submitted Summer I en_US
dc.author.degree MS in Computer Science en_US
dc.author.school Arts and Sciences en_US
dc.author.idnumber 199108790 en_US
dc.author.commembers Dr. Nashat Mansour
dc.author.woa RA en_US
dc.description.physdesc 1 bound copy: ix, 81 leaves; ill.; 30 cm. available at RNL. en_US
dc.author.division Computer Science en_US
dc.author.advisor Dr. Issam Moghrabi
dc.identifier.doi https://doi.org/10.26756/th.1998.7 en_US
dc.publisher.institution Lebanese American University en_US

Files in this item

This item appears in the following Collection(s)

Show simple item record

Search LAUR

Advanced Search


My Account