Transformation of relational schemas to object-oriented schemas

Author

Meng, Weiyi ; Kamada, Aqueo ; Chang, Yu-Hsi

Author_Institution

Dept. of Comput. Sci., State Univ. of New York, Binghamton, NY, USA

fYear

1995

fDate

9-11 Aug 1995

Firstpage

356

Lastpage

361

Abstract

We present an algorithm that transforms schemas of relational databases to schemas of object-oriented databases (OODB). This algorithm has the following special features: (1) it transforms schemas between two commercial database systems, i.e., from Sybase relational schemas to O₂ OODB schemas; (2) it initiates limited interactive sessions between the schema transformer and its user when additional input to the schema transformer is necessary although most of the transformation is automated; and (3) the transformed schemas are typical OODB schemas that may contain class hierarchies, composition hierarchies, set attributes and subtuple constructs

Keywords

database theory; entity-relationship modelling; object-oriented databases; relational databases; O₂ OODB schemas; Sybase relational schemas; algorithm; class hierarchies; commercial database systems; composition hierarchies; limited interactive sessions; object-oriented databases; object-oriented schemas; relational databases; relational schema transformation; schema transformer; set attributes; subtuple constructs; Computer science; Data models; Database languages; Database systems; Object oriented databases; Object oriented modeling; Relational databases; Spatial databases; Standards development;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Software and Applications Conference, 1995. COMPSAC 95. Proceedings., Nineteenth Annual International

Conference_Location

Dallas, TX

ISSN

0730-3157

Print_ISBN

0-8186-7119-X

Type

conf

DOI

10.1109/CMPSAC.1995.524801

Filename

524801