Implementation of an object-oriented front-end to a relational database system

Author

Kisworo, Marsudi W. ; Rajagopalan, P.

Author_Institution

Sch. of Comput. Sci., Curtin Univ. of Technol., Bentley, WA, Australia

fYear

1990

fDate

24-27 Sep 1990

Firstpage

811

Abstract

The authors describe the implementation of an object-oriented SQL (structured query language) front-end, called OOSQL, for the IBM DB2 relational database system. The restricted semantic entity-relationship model is used as the data model. The syntax of OOSQL is based on the syntax of SQL, which is the database language for DB2. SQL was chosen as the basis because it is expressive, powerful, and provides an easy evolution for DB2 SQL users. The authors modify and extend SQL by providing object management functions. OOSQL relies on the features of DB2 for dealing with concurrency, transaction management, integrity, and security. OOSQL provides constructors for object definition of any type, including recursive objects and complex objects. A prototype of the front-end described here has been successfully implemented

Keywords

object-oriented databases; query languages; relational databases; IBM DB2 relational database system; OOSQL; complex objects; concurrency; data model; database language; implementation; integrity; object definition; object-oriented SQL front-end; recursive objects; restricted semantic entity-relationship model; security; structured query language; syntax; transaction management; Australia; Computer languages; Data models; Impedance; Object oriented databases; Object oriented modeling; Organizing; Prototypes; Relational databases; Very large scale integration;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer and Communication Systems, 1990. IEEE TENCON'90., 1990 IEEE Region 10 Conference on

Print_ISBN

0-87942-556-3

Type

conf

DOI

10.1109/TENCON.1990.152725

Filename

152725