Extracting entity-relationship schemas from relational databases: a form-driven approach

The paper presents a framework for extracting an entity-relationship schema from a set of form model schemas of an operational relational database. Form model schemas gather information, i.e., structural information and constraints among data, extracted from both form structures and instances and then generalized into database semantics using an inference process guided by human activity. The approach uses these schemas to supplement low-level schemas to help reconstruct a conceptual schema, in this case an entity-relationship schema.

[1]  William J. Premerlani,et al.  An approach for reverse engineering of relational databases , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[2]  Henry C. Lefkovits,et al.  A Status Report on the Activities of the CODASYL End User Facilities Commitee (EUFC) , 1978, SIGMOD Rec..

[3]  Shamkant B. Navathe,et al.  Abstracting Relational and Hierarchical Data with a Semantic Data Model , 1987, International Conference on Conceptual Modeling.

[4]  Franklin Gracer,et al.  Saving a Legacy With Objects , 1989, OOPSLA.

[5]  Ryszard S. Michalski,et al.  A Theory and Methodology of Inductive Learning , 1983, Artificial Intelligence.

[6]  Gregory Piatetsky-Shapiro,et al.  The KDD process for extracting useful knowledge from volumes of data , 1996, CACM.

[7]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.

[8]  Jean-Luc Hainaut,et al.  Contribution to a theory of database reverse engineering , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[9]  Jan Paredis.  Learning the Behavior of Dynamical Systems form Examples , 1989, ML.

[10]  Jean-Luc Hainaut,et al.  Database Reverse Engineering: Models, Techniques, and Strategies , 1991, ER.

[11]  Paul Johannesson,et al.  A method for transforming relational schemas into conceptual schemas , 1989, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[12]  Raymond Reiter,et al.  Towards a Logical Reconstruction of Relational Database Theory , 1982, On Conceptual Modelling.

[13]  Kathi Hogshead Davis,et al.  Converting A Relational Database Model into an Entity-Relationship Model , 1987, ER.

[14]  Dennis Tsichritzis,et al.  Form management , 1982, CACM.