Comparison of object–relational database management systems: Difference between revisions

Revision as of 18:29, 20 November 2006

Latest revision as of 16:45, 24 August 2025

(83 intermediate revisions by 61 users not shown)

Line 1:

{{short description|None}}

{{tone}}

{{incomplete}}

{{Multiple issues|

The following Database Management Systems (DBMSs) have at least some [[object-relational database management system|object-relational features.]] They vary widely in their completeness and the approaches taken.

{{Original research|date=August 2025}}

{{Unreferenced|date=August 2025}}

}}

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. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

*[[IBM DB2|DB2]]

*[[GigaBASE]] [http://www.ispras.ru/~knizhnik/gigabase.html]

*[[Informix]]

*[[Caché (software)|Intersystems Cache]] [http://intersystems.com]

*[[Oracle database|Oracle]]

*[[Virtuoso Universal Server|OpenLink Virtuoso]]

*[[UniSQL]] [http://www.unisql.com]

*[[Valentina database|Valentina]] [http://valentina-db.com]

*[[VMDS]]

*[[PostgreSQL]]

== Basic data ==

The following tables compare general and technical information for a number of [[object-relational database management system]]s. 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.

{| class="wikitable sortable"

! Name

! Vendor

! [[Software license|License]]

! [[Operating system|OS]]

! Notes

|-

| [[Adaptive Server Enterprise]]

| [[SAP AG|SAP]]

| [[Proprietary software|Proprietary]]

| Cross-platform

|

|-

| [[InterSystems Caché|Caché]]

| [[InterSystems]]

| Proprietary

| Cross-platform

|

|-

| [[CUBRID]]

| [[NHN Corporation]]

| [[GNU GPL|GPL]]/[[BSD license|BSD]]

| Linux, Windows

|

|-

| [[IBM Db2]]

| [[IBM]]

| Proprietary

| Cross-platform

|

|-

|GigaSpaces

|[[GigaSpaces]]

|Apache-2.0 or Proprietary

|Cross-platform

|

|-

| [[Greenplum|Greenplum Database]]

| [[Greenplum]] division of [[EMC Corporation]]

| Proprietary

| ?

| Uses PostgreSQL codebase

|-

| [[Informix]]

| [[IBM]]

| Proprietary

| Cross-platform

|

|-

| [[Microsoft SQL Server]]

| [[Microsoft Corporation]]

| Proprietary

| Windows, Linux

| Supports data objects in .NET languages

|-

| [[OpenEdge Advanced Business Language]] (formerly Progress 4GL)

| [[Progress Software Corporation]]

| Proprietary

| Cross-platform

|

|-

| [[Oracle Database]]

| [[Oracle Corporation]]

| Proprietary

| Linux, Windows, Unix

|

|-

| [[PostgreSQL]]

| PostgreSQL Global Development Group

| [[PostgreSQL|PostgreSQL License]]

| Cross-platform

|

|-

| [[Virtuoso Universal Server]]

| OpenLink Software

| [[GNU GPL|GPL]]v2 or proprietary

| Cross-platform

|

|-

| [[VMDS]] (Version Managed Data Store)

| [[GE Energy]], a division of [[General Electric]]

| Proprietary

| ?

| GIS for public utilities; can be stored inside Oracle Database

|-

| WakandaDB

| [[4th Dimension (software)|4th Dimension]]

| [[GNU Affero General Public License|AGPL]]v3 or proprietary

| Windows, Linux, macOS

| Based on REST and server-side JavaScript

|-

| [[XDB Enterprise Server]]

| [[Micro Focus]]

| Proprietary

| DOS, Windows NT, OS/2

|

|-

| [[YugabyteDB]]

| [[Yugabyte]]

| Apache 2.0

| Linux

|

|-

| [[Zope Object Database]]

| Zope Corporation

| [[Zope Public License]]

| Cross-platform

| For Python, also included in [[Zope]] web application server

|}

==Fundamental Object features ==

Information about what fundamental ORDBMSes features are implemented natively.

{| border="1" cellpadding="1" cellspacing="0" style="font-size: 85%; border: gray solid 1px; border-collapse: collapse; text-align: center; width: 100%; table-layout: fixed;"

{| class="wikitable" style="width: 95%; text-align: center;"

|- style="background: #ececec"

! style="width:12em 10%" |

! [[Datatype|Type]]

! [[Method (computer science)|Method]]

Line 27 ⟶ 130:

! Table inheritance

|-

! style="text-align:left;" bgcolor="#ececec" | [[Oracle database|OracleCUBRID]]

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ddffdd" | Yes<ref>No private methods, no way to call super method from a child.</ref>

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ffdddd" | No

|-

|! style="text-align:left;" bgcolor="#ececec" | [[VirtuosoOracle Universal Serverdatabase|OpenLink VirtuosoOracle]]

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}{{efn|No private methods, no way to call super method from a child.}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ddffdd" | Yes

|-

! style="text-align:left;" bgcolor="#ececec" | [[PostgreSQLVirtuoso Universal Server|OpenLink Virtuoso]]

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ddffdd" | Yes

|- style="background: #ececec"

!

! [[Datatype|Type]]

! [[Method (computer science)|Method]]

! [[Inheritance (object-oriented programming)|Type inheritance]]

! Table inheritance

|-

! style="text-align:left;" | [[PostgreSQL]]

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|-

! style="text-align:left;" | [[Informix]]

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|-

! style="text-align:left;" | WakandaDB

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|}

Notes:

<references/>

==Data types==

Information about what data types are implemented natively.

{| borderclass="1" cellpadding="1" cellspacing="0wikitable" style="font-sizewidth: 8595%; border: gray solid 1px; border-collapse: collapse; text-align: center; width: 100%; table-layout: fixed;"

|-! style="backgroundwidth: #ececec10%" |

! [[Array data type|Array]]

! style="width:12em" |

! [[Array]]

! [[List (computing)|List]]

! [[Set (computer science)|Set]]

! [[Multiset]]

! [[Reference (computer science)|Object reference]]

|-

! style="text-align:left;" bgcolor="#ececec" | [[Oracle database|OracleCUBRID]]

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ddffdd" | Yes

|-

! style="text-align:left;" bgcolor="#ececec" | [[VirtuosoOracle Universal Serverdatabase|OpenLink VirtuosoOracle]]

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ddffdd" | Yes

|-

! style="text-align:left;" bgcolor="#ececec" | [[PostgreSQLVirtuoso Universal Server|OpenLink Virtuoso]]

| {{yes}}

| bgcolor="#ddffdd" | Yes

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ffdddd" | No

| {{yes}}

| bgcolor="#ffdddd" | No

|- style="background: #ececec"

!

! [[Array]]

! [[List (computing)|List]]

! [[Set]]

! [[Multiset]]

! [[Reference (computer science)|Object reference]]

|-

! style="text-align:left;" | [[PostgreSQL]]

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|-

! style="text-align:left;" | [[Informix]]

| {{no}}

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|}

== ExternalSee linksalso ==

* [http://troels.arvin.dk/db/rdbms/ [Comparison of differentdatabase SQLadministration implementationstools]]

* [[Comparison of object database management systems]]

* [[Comparison of relational database management systems]]

* [[List of relational database management systems]]

== Notes ==

[[Category:Database management systems|*]]

{{notelist}}

[[Category:Lists of software|Database management systems]]

[[Category:Software comparisons|Database management systems]]

== References ==

{{Reflist}}

== External links ==

* [http://troels.arvin.dk/db/rdbms/ Arvin.dk], comparison of different SQL implementations

{{Databases}}

{{DEFAULTSORT:Comparison Of Object-Relational Database Management Systems}}

[[Category:Database management systems|*]]

[[Category:Database software comparisons|object-relational databases]]