Object Relational Database Management System(ORDBMS) is a database management system acts as a bridge between objects & relational databases.
The main objective of ORDBMS is to achieve the benefits of both the relational and the object models such as scalability, support for oo features & custom types.
It directly supports object oriented paradigms objects, classes, inheritances , polymorphism in the database schemas & query language. Also has the ability to extensible with user-defined types & methods.
Advantages
- Supports rich data types such as audio, video and image files.
- Access and manipulate the complex data types in the database without breaking the rule of relational model.
Disadvantages
- Complexity
ORDBMS vendors in the market : Oracle, SQL Server, PostgreSQL, Informix. Among these, PostgreSQL is an Open Source ORDBMS.
Tags: Object Relational, object relational database, Object Relational Database Management System, object relational mapping, ORDBMS, ORDBMS vendors, Relational Model with Object Oriented features, Relational model with OO features, user defined types database
