Extracting Entity Relationship Diagram from a Table-Based Legacy Database

Authors:
Dowming Yeh;Yuwen Li
Affiliations:
National Kaohsiung Normal University;National Kaohsiung Normal University
Venue:
CSMR '05 Proceedings of the Ninth European Conference on Software Maintenance and Reengineering
Year:
2005

Citing 0
Cited 2

An MDA-based approach for database re-engineering

Journal of Software Maintenance and Evolution: Research and Practice
R2O transformation system: relation to ontology transformation for scalable data integration

IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.