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
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