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

Revision as of 12:30, 22 November 2012

Latest revision as of 16:45, 24 August 2025

(48 intermediate revisions by 34 users not shown)

Line 1:

{{short description|None}}

{{Incomplete|date=February 2009}}

{{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}}

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.

{{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.

==Fundamental features==

== Basic data ==

{| 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

|}

== Object features ==

Information about what fundamental ORDBMSes features are implemented natively.

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

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

! style="width: 10%" |

! [[Datatype|Type]]

Line 18 ⟶ 135:

| {{yes}}

| {{yes}}

|-

! style="text-align:left;" | [[LogicSQL]]<ref name="Logicsql: An Object-Relational Database System">http://webdocs.cs.ualberta.ca/~yuan/databases/index.html</ref>

| {{?}}

| {{?}}

| {{?}}

| {{?}}

|-

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

| {{yes}}

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

| {{yes}}

| {{yes}}

Line 44 ⟶ 155:

|-

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

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

Line 66 ⟶ 183:

| {{yes}}

| {{yes}}

|-

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

| {{?}}

| {{?}}

| {{?}}

| {{?}}

| {{?}}

|-

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

Line 103 ⟶ 213:

|}

==References See also ==

* [[Comparison of database administration tools]]

<references/>

* [[Comparison of object database management systems]]

==See also==

* [[Comparison of database tools]]

* [[Comparison of relational database management systems]]

* [[List of relational database management systems]]

== Notes ==

{{notelist}}

== References ==

{{Reflist}}

== External links ==

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

{{Databases}}

Line 118 ⟶ 232:

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

[[Category:Database management systems|*]]

[[Category:SoftwareDatabase software comparisons|Database managementobject-relational systemsdatabases]]