Jump to content

Comparison of object–relational database management systems

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Cigano (talk | contribs) at 12:29, 22 November 2012 (Added LogicSQL; Added References section). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The following Database Management Systems (DBMSs) have at least some object-relational features. They vary widely in their completeness and the approaches taken. The following tables compare general and technical information for a number of object-relational database management systems. Please see the individual products' articles for further information. This article is not all-inclusive or necessarily up to date. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

Fundamental features

Information about what fundamental ORDBMSes features are implemented natively.

Type Method Type inheritance Table inheritance
CUBRID Yes Yes Yes Yes
LogicSQL[1] ? ? ? ?
Oracle Yes Yes[2] Yes Yes
OpenLink Virtuoso Yes Yes Yes Yes
PostgreSQL Yes Yes Yes Yes
Informix Yes Yes Yes Yes

Notes

  1. ^ http://webdocs.cs.ualberta.ca/~yuan/databases/index.html
  2. ^ No private methods, no way to call super method from a child.

Data types

Information about what data types are implemented natively.

Array List Set Multiset Object reference
CUBRID Yes Yes Yes Yes Yes
LogicSQL ? ? ? ? ?
Oracle Yes Yes Yes Yes Yes
OpenLink Virtuoso Yes Yes Yes Yes Yes
PostgreSQL Yes Yes Yes Yes Yes
Informix No Yes Yes Yes Yes

References


See also

  • Arvin.dk, Comparison of different SQL implementations