Performance Interoperability between RDBs and OODBs

Object-oriented databases and relational database are becoming more and more popular for applications to support the complexity and the irregularity of the real-world entities. Object-Oriented Databases (OODBs) have been designed to support large and complex programming projects. The data accuracy, consistency, and integrity in OODBs are extremely important for developers and users. In Object Oriented Data Model each record is represented by object. The basic element of an object-oriented database is the object. A relational database allows the definition of data structures, storage and retrieval operations and integrity constraints. In such a model the data and relations between them are organized in tables. A table is a collection of records and each record in a table contains the same fields. Object-oriented database systems began developing in the mid-80’s out of a necessity to meet the requirements of applications beyond the data processing applications which were served by relational database systems. In this paper, the Achievements and weaknesses of both database models and the Special problems found in the both model are discussed. This paper deals with different constraints in object-oriented databases and relational database. Keyword: Distributed database system, relational model, objects oriented model, database, security, homogeneous, heterogeneous, constraint etc.