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.