Transformation of relational schemas to object-oriented schemas

Weiyi Meng; Aqueo Kamada; Yu Hsi Chang

Transformation of relational schemas to object-oriented schemas

Weiyi Meng
, Aqueo Kamada
, Yu Hsi Chang

School of Computing

Binghamton University

State University of New York Binghamton University

Research output: Contribution to journal › Conference article › peer-review

Abstract

In this paper, 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.

Original language	English
Pages (from-to)	356-361
Number of pages	6
Journal	Proceedings - IEEE Computer Society's International Computer Software & Applications Conference
State	Published - 1995
Event	Proceedings of the 19th Annual International Computer Software and Applications Conference COMPSAC '95 - Dallas, TX, USA Duration: Aug 9 1995 → Aug 11 1995

Cite this

@article{4ea2dd5abe554e6a8e349a3b40564dc8,

title = "Transformation of relational schemas to object-oriented schemas",

abstract = "In this paper, 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 O2 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.",

author = "Weiyi Meng and Aqueo Kamada and Chang, \{Yu Hsi\}",

year = "1995",

language = "English",

pages = "356--361",

journal = "Proceedings - IEEE Computer Society's International Computer Software \& Applications Conference",

issn = "0730-6512",

note = "Proceedings of the 19th Annual International Computer Software and Applications Conference COMPSAC '95 ; Conference date: 09-08-1995 Through 11-08-1995",

}

TY - JOUR

T1 - Transformation of relational schemas to object-oriented schemas

AU - Meng, Weiyi

AU - Kamada, Aqueo

AU - Chang, Yu Hsi

PY - 1995

Y1 - 1995

N2 - In this paper, 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 O2 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.

AB - In this paper, 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 O2 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.

UR - https://www.scopus.com/pages/publications/0029192210

M3 - Conference article

SN - 0730-6512

SP - 356

EP - 361

JO - Proceedings - IEEE Computer Society's International Computer Software & Applications Conference

JF - Proceedings - IEEE Computer Society's International Computer Software & Applications Conference

T2 - Proceedings of the 19th Annual International Computer Software and Applications Conference COMPSAC '95

Y2 - 9 August 1995 through 11 August 1995

ER -

Transformation of relational schemas to object-oriented schemas

Abstract

Other files and links

Fingerprint

Cite this