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

Author

Mfourga, N.

Author_Institution

Inst. d´´Adm. et de Gestion, Univ. Catholique de Louvain, Belgium

fYear

1997

fDate

6-8 Oct 1997

Firstpage

184

Lastpage

193

Abstract

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

Keywords

business data processing; entity-relationship modelling; information systems; relational databases; reverse engineering; software maintenance; systems re-engineering; conceptual schema reconstruction; data constraints; database semantics; entity-relationship schema extraction; form instances; form model schemas; form structures; form-driven approach; human activity; inference process; operational relational database; structural information; supplemented low-level schemas; Data engineering; Data mining; Displays; Documentation; Hardware; Humans; Information retrieval; Relational databases; Reverse engineering; Software maintenance;

fLanguage

English

Publisher

ieee

Conference_Titel

Reverse Engineering, 1997. Proceedings of the Fourth Working Conference on

Conference_Location

Amsterdam

Print_ISBN

0-8186-8162-4

Type

conf

DOI

10.1109/WCRE.1997.624589

Filename

624589