Title :
A prototype using a hybrid approach to recover dynamic semantics from relational schema
Author_Institution :
Dept. of Comput. & Math., Hong Kong Inst. of Vocational Educ., Hong Kong
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;
Conference_Titel :
Systems, Man, and Cybernetics, 1999. IEEE SMC '99 Conference Proceedings. 1999 IEEE International Conference on
Conference_Location :
Tokyo
Print_ISBN :
0-7803-5731-0
DOI :
10.1109/ICSMC.1999.815645
