Home | Issues | Profile | History | Submission | Review
Vol: 49(63) No: 3 / September 2004

About Object-Relational Database Implementations Using Oracle
Liliana Jian
Department of Computer Science and Engineering, Politehnica University of Timisoara, 2 V. Parvan Bv, 300223 Timisoara, Romania, e-mail: ljian@cs.utt.ro, web: www.cs.utt.ro/~ljian
Lucian Jian
Department of Computer Science and Engineering, Politehnica University of Timisoara, 2 V. Parvan Bv, 300223 Timisoara, Romania, e-mail: luci@cs.utt.ro


Keywords: object-relational databases, Oracle, PL/SQL, object oriented programming

Abstract
The object-relational databases extend the performance and security offered by relational databases, adding object oriented programming capabilities. The choice of developing object-relational databases first appeared in the Oracle 8 release , by using PL/SQL language, which permits the definition of objects. The present paper proposes an implementation pattern of object-relational database, emphasizing that persisting objects are relationally stored on disc, and the object processing is performed in the main memory, where we can refer to the structural and behavioural properties of objects.

References
[1] Oracle Corporation - PL/SQL User\'s Guide and Ref.
[2] Oracle Corporation - Oracle8i Appl. Developer Guide
[3] Oracle Corporation - Oracle8i PL/SQL Packages Ref.
[4] Oracle Unleashed Second ed. – SAMS Publ. 1997.