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.