The object-relational database(ORDB) is now viewed as target of migration for relational databases(RDB). ORDBs offer several features that RDBs do not have. These include a general type system, user defined functions/methods, and inheritance. Further,...
The object-relational database(ORDB) is now viewed as target of migration for relational databases(RDB). ORDBs offer several features that RDBs do not have. These include a general type system, user defined functions/methods, and inheritance. Further, ORDBs provide support for set-valued attributes and composition(nested data). Although users can use RDBs to model set-valued attributes and composition, ORDBs make it much more natural and simple to model them. The objective of this paper is to establish performance differences between ORDBs and RDBs in supporting these two important data modeling facilities.