REVERSE ENGINEERING OF RELATIONAL DATABASES - EXTRACTION OF AN EER MODEL FROM A RELATIONAL DATABASE

被引：108

作者：

CHIANG, RHL ^{[1
]}

BARRON, TM ^{[1
]}

STOREY, VC ^{[1
]}

机构：

[1] UNIV ROCHESTER,WILLIAM E SIMON GRAD SCH BUSINESS ADM,ROCHESTER,NY 14627

来源：

DATA & KNOWLEDGE ENGINEERING | 1994年 / 12卷 / 02期

关键词：

DATABASE REVERSE ENGINEERING; RELATIONAL DATABASES; EXTENDED ENTITY-RELATIONSHIP MODEL; DATABASE DESIGN;

D O I：

10.1016/0169-023X(94)90011-6

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

A methodology for extracting an extended Entity-Relationship (EER) model from a relational database is presented. Through a combination of data schema and data instance analysis, an EER model is derived which is semantically richer and more comprehensible for maintenance and design purposes than the original database. Classification schemes for relations and attributes necessary for the EER model extraction are derived and justified. These have been demonstrated to be implementable in a knowledge-based system; a working prototype system which does so is briefly discussed. In addition, cases in which human input is required are also clearly identified. This research also illustrates that the database reverse engineering process can be implemented at a high level of automation.

引用

页码：107 / 142

页数：36

共 32 条

[1]

Bachman C. W., 1989, IEEE Transactions on Knowledge and Data Engineering, V1, P17, DOI 10.1109/69.43401

[2]

BATINI C, 1986, COMPUT SURV, V18, P323, DOI 10.1145/27633.27634

[3]

Batini C., 1992, CONCEPTUAL DATABASE

[4]

BERNSTEIN P, 1976, ACM T DATABASE SYST, V1, P272

[5]

BITTON D, 1989, 5TH P INT C DAT ENG, P635

[6]

BRACHMAN RJ, 1983, IEEE COMPUT, V16, P30

[7] INCLUSION DEPENDENCIES AND THEIR INTERACTION WITH FUNCTIONAL-DEPENDENCIES [J].

CASANOVA, MA ;

FAGIN, R ;

PAPADIMITRIOU, CH .

JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 1984, 28 (01) :29-59

[8]

CHIANG RHL, IN PRESS DECISION SU

[9] REVERSE ENGINEERING AND DESIGN RECOVERY - A TAXONOMY [J].

CHIKOFSKY, EJ ;

CROSS, JH .

IEEE SOFTWARE, 1990, 7 (01) :13-17

[10]

Date C. J., 1986, INTRO DATABASE SYSTE, V1

← 1 2 3 4 →