What is ORDBMS?


Important ORDBMS Features

User Defined Types (UDTs): UDTs allow developer to define their own data type. UDTs include structure, array, text, multimedia, time-series, etc.

User Defined Functions (UDFs): UDFs allow developer to define their own functions. UDFs can be invoked independently or inside a SQL statement i.e. WHERE clause. UDFs usually operate on complex data.

Extended Search/Index Capabilities: ORDBMS allow for searching complex data type. The new ORDBMS provide to specify the “cost” for searching UDTs & executing UDFs to better optimize queries in complex data.

Predefined Extensions: The ORDBMS vendors offer a number of predefined extensions (called – Data Cartridges by Oracle, Snapins by Sybase, DataBlades by Informix) which handle complex information in particular application domain such text search, images, video, messaging etc.

Extended Support for Programming Languages: In RDBMS functions had to be written in database vendor’s native language i.e. PL/SQL in Oracle, T-SQL in SOL Server, SPL in Informix. ORDBMS are now providing support for C, C++ and Java when writing UDFs in their database.
         
Example: Most of the ORDBMS features are being included in the new SQL3 standard.  

Difference between ODBMS & RDMBS

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


DEGREE
ODBMS
RDBMS
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.