By Topic

An approach for reverse engineering of relational databases

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$33 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
Premerlani, W.J. ; GE Corp. Res. & Dev., Schenectady, NY, USA ; Blaha, M.R.

A process for reverse engineering of relational databases is proposed. Object-oriented models provide a natural language for facilitating the re-engineering process. An object-oriented model can describe the existing software, the reverse-engineered semantic intent, and the forward-engineered new system. The Object Modeling Technique (OMT) notation for modeling data is adopted. Graphical OMT models are intuitive and provide a rigorous basis for specifying software. A more robust process than advanced in the literature is proposed. Guidelines for coping with design optimizations and unfortunate implementation decisions are provided. The process emphasizes analysis of candidate keys rather than primary keys. Three sources for information are incorporated: schema, observed patterns of data, and the semantic understanding of application intent

Published in:

Reverse Engineering, 1993., Proceedings of Working Conference on

Date of Conference:

21-23 May 1993