loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Ninth European Conference on Software Maintenance and Reengineering (CSMR'05)
Extracting Entity Relationship Diagram from a Table-Based Legacy Database
Manchester, UK
March 21-March 23
ISBN: 0-7695-2304-8
Dowming Yeh, National Kaohsiung Normal University
Yuwen Li, National Kaohsiung Normal University
Current database reverse engineering researches presume that the information regarding semantics of attributes, primary keys, and foreign keys in database tables is complete. However, this may not be the case. In this paper, we present a process that extracts an extended entity relationship diagram from a table-based database with little descriptions for the fields in its tables and no description for keys. The primary inputs of our approach are system display forms and table schema. An extended ER diagram is successfully extracted in a case study.
Index Terms:
database, reverse engineering, entity relationship diagram, data model, case study
Citation:
Dowming Yeh, Yuwen Li, "Extracting Entity Relationship Diagram from a Table-Based Legacy Database," csmr, pp.72-79, Ninth European Conference on Software Maintenance and Reengineering (CSMR'05), 2005
Usage of this product signifies your acceptance of the Terms of Use.