Jump to content

Comparison of object–relational database management systems

Edit links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Beland (talk | contribs) at 02:09, 4 March 2013 (→Basic data: make sortable, add more data, remove Unisys - does not appear to be an actual DB product). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

This is a comparison of object-relational database management systems (ORDBMSs). Each system has at least some features of an object-relational database; they vary widely in their completeness and the approaches taken.

The following tables compare general and technical information; please see the individual products' articles for further information. This article is not all-inclusive nor necessarily up to date. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

Basic data

Name Vendor License Notes
DB2 IBM Proprietary commercial
GigaBASE knizhnik Free/open source (MIT License) SourceForge download page
Greenplum Database Greenplum division of EMC Corporation Proprietary Uses PostgreSQL codebase
Informix IBM Proprietary commercial
Caché InterSystems Proprietary commercial
Virtuoso Universal Server OpenLink Software Free/open source (GPLv2) or proprietary
Oracle Database Oracle Corporation Proprietary commercial
PostgreSQL PostgreSQL Global Development Group Free/open source Postgres License
OpenEdge Advanced Business Language (formerly Progress 4GL) Progress Software Corporation Proprietary
? Sybase ?
Valentina Paradigma Software Proprietary/free download with commercial add-ons Web site
VMDS (Version Managed Data Store) GE Energy, a division of General Electric Proprietary GIS for public utilities; can be stored inside Oracle Database
Zope Object Database Zope Corporation Free/open source (Zope Public License) For Python, also included in Zope web application server

Object 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

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

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

See also

  • Arvin.dk, Comparison of different SQL implementations
Retrieved from "https://en.wikipedia.org/w/index.php?title=Comparison_of_object–relational_database_management_systems&oldid=541982382"