Difference between ODBMS & RDMBS

The difference between ODBMS & RDMBS may figure out using the following table:

Data type parsing
-Support complex data type using user defined data type.
-Supports Binary large Objects (BLOBs) which are essentially very large database column.
-Database columns must generally be simple data elements instead of structures & array.
 Locating data
-Slower than RDBMS when locating simple data type.
-Refined algorithms used to search data within complex data type.  
-Fast to find simple data type.
-No support for searching or indexing BLOBs.
Language standards
-Most of ODBMS support OQL (Object Query Language) & ODL (Object Definition Language) which are part of ODMG (Object Data Management Group).
-The programming language is used for data manipulation by invoking methods of the object instead of SQL-insert, update, and delete command.
-Major RDBMS use a standard language (SQL2/SQL92) with vendor specific extensions. SQL is both DDL (Data Definition Language) & DML (Data Manipulation Language).
DBMS functions/methods
-Object methods are usually in a selected OOP language (like C++, Java).
-Object/method inheritance is supported.
-Provide triggers/stored procedures which are written in the native DBMS language.

No comments:

Post a Comment