Object-relational database

object-relationalobject-relational database management systemobject extensionsobject relationalobject-relational dataObject-Relational Data Management Systems (ORDBMS)Object-relational modelobject-SQL DBMSORDBMS
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language.wikipedia
72 Related Articles

Database

database management systemdatabasesDBMS
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language.
Object databases were developed in the 1980s to overcome the inconvenience of object-relational impedance mismatch, which led to the coining of the term "post-relational" and also the development of hybrid object-relational databases.

Data model

structured datastructuredData models
In addition, just as with pure relational systems, it supports extension of the data model with custom data types and methods.

Object database

object-oriented databaseobject-oriented databasesobject persistence
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language.
Object-relational databases are a hybrid of both approaches.

Object-relational mapping

ORMobject-relational mapperObject Relational Mapping
However, a more popular alternative for achieving such a bridge is to use a standard relational database systems with some form of object-relational mapping (ORM) software.

IBM Db2 Family

DB2IBM DB2pureQuery
For example, IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success.
They initially supported the relational model, but were extended to support object-relational features and non-relational structures like JSON and XML.

Structured type

structured user-defined type
Many of the ideas of early object-relational database efforts have largely become incorporated into SQL:1999 via structured types.
The SQL:1999 standard introduced a number of object-relational database features into SQL, chiefly among them structured user-defined types, usually called just structured types.

Comparison of object-relational database management systems

List of object-relational database management systems
Each system has at least some features of an object-relational database; they vary widely in their completeness and the approaches taken.

Database schema

schemarelational schemaschemas
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language.

Query language

querydatabase query languageData query language
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language.

Data type

typedatatypetypes
In addition, just as with pure relational systems, it supports extension of the data model with custom data types and methods.

Method (computer programming)

methodsmethodabstract method
In addition, just as with pure relational systems, it supports extension of the data model with custom data types and methods.

Application programming interface

APIAPIsapplication programming interfaces
In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying.

Java (programming language)

JavaJava programming languageJava language
The basic goal for the Object-relational database is to bridge the gap between relational databases and the object-oriented modeling techniques used in programming languages such as Java, C++, Visual Basic .NET or C#.

C++

C++ programming languageC++98C with Classes
The basic goal for the Object-relational database is to bridge the gap between relational databases and the object-oriented modeling techniques used in programming languages such as Java, C++, Visual Basic .NET or C#.

Visual Basic .NET

VB.NETVisual Basic.NETVisual Basic
The basic goal for the Object-relational database is to bridge the gap between relational databases and the object-oriented modeling techniques used in programming languages such as Java, C++, Visual Basic .NET or C#.

C Sharp (programming language)

C#Visual C#C# programming language
The basic goal for the Object-relational database is to bridge the gap between relational databases and the object-oriented modeling techniques used in programming languages such as Java, C++, Visual Basic .NET or C#.

Relational database

relational database management systemRDBMSrelational databases
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language.

Object composition

compositionaggregationUser-defined type
Complex data creation in most SQL ORDBMSs is based on preliminary schema definition via the user-defined type (UDT).

Object identifier

OIDOIDsobject identifier (OID)
Inside a database, all the relations with a persistent program object are relations with its object identifier (OID).

Object-oriented programming

object-orientedobject orientedobject-oriented programming language
In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying.

Type signature

method signaturesignaturetype annotation
The methods denoted by one name are distinguished by the type of their parameters and type of objects for which they attached (method signature).

Polymorphism (computer science)

polymorphismpolymorphictype polymorphism
The OOP languages call this the polymorphism principle, which briefly is defined as "one interface, many implementations".

Inheritance (object-oriented programming)

inheritancesuperclasssubclass
Other OOP principles, inheritance and encapsulation, are related both to methods and attributes.

Encapsulation (computer programming)

encapsulationencapsulateencapsulated
Other OOP principles, inheritance and encapsulation, are related both to methods and attributes.