Object-relational database

related topics
{math, number, function}
{system, computer, user}
{company, market, business}
{work, book, publish}
{theory, work, human}
{country, population, people}
{line, north, south}

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. In addition, it supports extension of the data model with custom data-types and methods.

An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases (OODBMS). 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.

Contents

Overview

One aim for the Object-relational database is to bridge the gap between conceptual data modeling techniques such as Entity-relationship diagram (ERD) and object-relational mapping (ORM), which often use classes and inheritance, and relational databases, which do not directly support them.

Another, related, aim 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#. However, a more popular alternative for achieving such a bridge is to use a standard relational database systems with some form of ORM software.

Whereas traditional RDBMS or SQL-DBMS products focused on the efficient management of data drawn from a limited set of data-types (defined by the relevant language standards), an object-relational DBMS allows software-developers to integrate their own types and the methods that apply to them into the DBMS. ORDBMS technology aims to allow developers to raise the level of abstraction at which they view the problem domain.[clarification needed] This goal is not universally shared; proponents of relational databases often argue that object-oriented specification lowers the abstraction level.

Full article ▸

related documents
Spaghetti code
SECD machine
Grep
Transfer function
XOR swap algorithm
Block cipher
Arithmetic shift
Shannon–Fano coding
Linear cryptanalysis
P-complete
Zorn's lemma
Arithmetic function
Intermediate value theorem
Distributivity
Local field
Group isomorphism
Five lemma
Codomain
Mathematical singularity
Pointless topology
Hahn–Banach theorem
Epimorphism
Chomsky hierarchy
Pike (programming language)
Dedekind cut
Real analysis
Symmetric-key algorithm
Lambert W function
ZPP
Dual number