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

Revision as of 00:15, 4 March 2013

Latest revision as of 16:45, 24 August 2025

(46 intermediate revisions by 34 users not shown)

Line 1:

{{short description|None}}

{{Incomplete|date=February 2009}}

{{Multiple issues|

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.

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

{| class="wikitable sortable"

{| class="wikitable"

! Name

! Vendor

! [[Software license|License]]

! [[Operating system|OS]]

! Notes

|-

| [[Adaptive Server Enterprise]]

|[[IBM DB2|DB2]]

| [[SAP AG|SAP]]

| ?

| [[Proprietary software|Proprietary]]

| ?

| Cross-platform

|

|-

| [[InterSystems Caché|Caché]]

|[[GigaBASE]]

| [[InterSystems]]

| ?

| Proprietary

| ?

| Cross-platform

|

|-

| [[GreenplumCUBRID]]

| [[NHN Corporation]]

| ?

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

| ?

| Linux, Windows

|

|-

| [[InformixIBM Db2]]

| ?[[IBM]]

| Proprietary

| ?

| Cross-platform

|

|-

|GigaSpaces

|[[Caché (software)|Intersystems Cache]]

|[[GigaSpaces]]

| ?

|Apache-2.0 or Proprietary

| ?

|Cross-platform

|

|-

| [[Greenplum|Greenplum Database]]

|[[Virtuoso Universal Server|OpenLink Virtuoso]]

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

| ?

| Proprietary

| ?

| Uses PostgreSQL codebase

|-

| [[Oracle databaseInformix]]

| ?[[IBM]]

| Proprietary

| ?

| Cross-platform

|

|-

| [[Microsoft SQL Server]]

|[[PostgreSQL]]

| [[Microsoft Corporation]]

| ?

| Proprietary

| ?

| Windows, Linux

| Supports data objects in .NET languages

|-

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

|[[Progress 4GL]]

| [[Progress Software Corporation]]

| ?

| Proprietary

| ?

| Cross-platform

|

|-

| [[Oracle Database]]

| ?

| [[SybaseOracle Corporation]]

| Proprietary

| ?

| Linux, Windows, Unix

|

|-

| [[UniSQLPostgreSQL]]

| PostgreSQL Global Development Group

| ?

| [[PostgreSQL|PostgreSQL License]]

| ?

| Cross-platform

|

|-

| [[Virtuoso Universal Server]]

|[[Valentina (Database)|Valentina ]]

| 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

|[[Zope|Zope / ZODB]]

| [[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 83 ⟶ 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 109 ⟶ 155:

|-

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

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

Line 131 ⟶ 183:

| {{yes}}

| {{yes}}

|-

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

| {{?}}

| {{?}}

| {{?}}

| {{?}}

| {{?}}

|-

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

Line 168 ⟶ 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 183 ⟶ 232:

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

[[Category:Database management systems|*]]

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