Automatic reverse engineering extraction of ERC + from relational databases. (c1998)
Includes bibliographical references (leaves 78-79).
محفوظ في:
| المؤلف الرئيسي: | |
|---|---|
| التنسيق: | masterThesis |
| منشور في: |
1998
|
| الموضوعات: | |
| الوصول للمادة أونلاين: | http://hdl.handle.net/10725/420 https://doi.org/10.26756/th.1998.7 |
| الوسوم: |
إضافة وسم
لا توجد وسوم, كن أول من يضع وسما على هذه التسجيلة!
|
| _version_ | 1864513453816807424 |
|---|---|
| author | Abou Rakabeh, Raji F. |
| author_facet | Abou Rakabeh, Raji F. |
| author_role | author |
| dc.creator.none.fl_str_mv | Abou Rakabeh, Raji F. |
| dc.date.none.fl_str_mv | 1998 1998-06 2011-04-26T08:32:38Z 2011-04-26T08:32:38Z 2011-04-26 |
| dc.identifier.none.fl_str_mv | http://hdl.handle.net/10725/420 https://doi.org/10.26756/th.1998.7 |
| dc.language.none.fl_str_mv | en |
| dc.publisher.none.fl_str_mv | Lebanese American University |
| dc.rights.*.fl_str_mv | info:eu-repo/semantics/openAccess |
| dc.subject.none.fl_str_mv | Reverse engineering Relational databases |
| dc.title.none.fl_str_mv | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| dc.type.none.fl_str_mv | Thesis info:eu-repo/semantics/publishedVersion info:eu-repo/semantics/masterThesis |
| description | Includes bibliographical references (leaves 78-79). |
| eu_rights_str_mv | openAccess |
| format | masterThesis |
| id | LAURepo_6263ce2c84c6c35253a2d4d5d5ca2a97 |
| language_invalid_str_mv | en |
| network_acronym_str | LAURepo |
| network_name_str | Lebanese American University repository |
| oai_identifier_str | oai:laur.lau.edu.lb:10725/420 |
| publishDate | 1998 |
| publisher.none.fl_str_mv | Lebanese American University |
| repository.mail.fl_str_mv | |
| repository.name.fl_str_mv | |
| repository_id_str | |
| spelling | Automatic reverse engineering extraction of ERC + from relational databases. (c1998)Abou Rakabeh, Raji F.Reverse engineeringRelational databasesIncludes bibliographical references (leaves 78-79).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.1 bound copy: ix, 81 leaves; ill.; 30 cm. available at RNL.Lebanese American University2011-04-26T08:32:38Z2011-04-26T08:32:38Z19982011-04-261998-06Thesisinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesishttp://hdl.handle.net/10725/420https://doi.org/10.26756/th.1998.7eninfo:eu-repo/semantics/openAccessoai:laur.lau.edu.lb:10725/4202020-05-18T14:53:45Z |
| spellingShingle | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) Abou Rakabeh, Raji F. Reverse engineering Relational databases |
| status_str | publishedVersion |
| title | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| title_full | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| title_fullStr | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| title_full_unstemmed | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| title_short | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| title_sort | Automatic reverse engineering extraction of ERC + from relational databases. (c1998) |
| topic | Reverse engineering Relational databases |
| url | http://hdl.handle.net/10725/420 https://doi.org/10.26756/th.1998.7 |