A prototype using a hybrid approach to recover dynamic semantics from relational schema

Author

Cheng, Y.W.

Author_Institution

Dept. of Comput. & Math., Hong Kong Inst. of Vocational Educ., Hong Kong

Volume

5

fYear

1999

fDate

1999

Firstpage

750

Abstract

Organizations with legacy database systems are seeking solutions to re-engineer their existing relational databases to object-oriented databases for better maintainability and evolutionary ability. Kwan (1997) has proposed a complete methodology to transform relational schema to object-oriented schema, using data reverse engineering to extract the structural semantics and a hybrid approach to recover dynamic semantics from data flow diagrams and data dictionary. This paper presents the result of applying Kwan´s methodology to a college system, of which the relational database schema is successfully transformed to object-oriented database schema with both structural and dynamic semantics. This paper proves that the hybrid approach in recovering dynamic semantics from data flow diagrams is feasible, simple and cost-effective

Keywords

data flow analysis; diagrams; educational administrative data processing; object-oriented databases; relational databases; reverse engineering; systems re-engineering; college system; data dictionary; data flow diagrams; data reverse engineering; dynamic semantics; hybrid approach; legacy database systems; object-oriented databases; relational databases; relational schema; structural semantics; system re-engineering; Data mining; Design for disassembly; Dictionaries; Educational institutions; Inference algorithms; Mathematics; Object oriented databases; Object oriented modeling; Prototypes; Relational databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Systems, Man, and Cybernetics, 1999. IEEE SMC '99 Conference Proceedings. 1999 IEEE International Conference on

Conference_Location

Tokyo

ISSN

1062-922X

Print_ISBN

0-7803-5731-0

Type

conf

DOI

10.1109/ICSMC.1999.815645

Filename

815645