Compare oodbms with rdbms

Answer 1

The differences between the three approaches Table 1: A Comparison of Database Management Systems Criteria RDBMS ODBMS ORDBMS Defining standard SQL2 ODMG-2.0 SQL3 (in process) Support for object-oriented features Does not support; It is difficult to map program object to the database Supports extensively Limited support; mostly to new data types Usage Easy to use OK for programmers; some SQL access for end users Easy to use except for some extensions Support for complex relationships Does not support abstract datatypes Supports a wide variety of datatypes and data with complex inter-relationships Supports Abstract datatypes and complex relationships Performance Very good performance Relatively less performance Expected to perform very well Product maturity Relatively old and so very mature This concept is few years old and so relatively mature Still in development stage so immature. The use of SQL Extensive supports SQL OQL is similar to SQL, but with additional features like Complex objects and object-oriented features. SQL3 is being developed with OO features incorporated in it Advantages Its dependence on SQL, relatively simple query optimization hence good performance It can handle all types of complex applications, reusability of code, less coding Ability to query complex applications and ability to handle large and complex applications Disadvantages Inability to handle complex applications Low performance due to complex query optimization, inability to support large-scale systems Low performance in web applications Support from vendors It is considered to be highly successful so the market size is very large but many vendors are moving towards ORDBMS Presently lacking vendor support due to vast size of RDBMS market All major RDBMS vendors are after this so has very good future

Answer 2

RDBMS have been around for more than 20 years, OODBMS

are relatively new.

1. RDBMS can handle >1010 records, OODBMS up to 107.

2. OODBM good for storing complex descriptions (e.g., a plant

schematic), RDMSs appropriate for simple, "flat" data.

3. RDBMS control the DB market (>90%), OODBMS own <5% of

the market.

4. Most commercial RDBMS come with an "Object-Relational"

extension which implements an object database on top of a

RDBMS.

Answer 3

The acronym ODBMS stands for Object DataBase Management System. The acronym RDBMS stands for Object Relational DataBase Management System. RDBMS supports more complex types of data in tabular form.