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

Revision as of 19:30, 4 April 2013

Latest revision as of 16:45, 24 August 2025

(38 intermediate revisions by 31 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"

! Name

! Vendor

! [[Software license|License]]

! [[Operating system|OS]]

! OS

! Notes

|-

| [[Adaptive Server Enterprise]]

| [[SybaseSAP AG|SAP]]

| [[Proprietary commercialsoftware|Proprietary]]

| Cross-platform

|

|-

| [[InterSystems Caché|Caché]]

| [[InterSystems]]

| Proprietary

| Cross-platform

|

Line 22 ⟶ 31:

| [[CUBRID]]

| [[NHN Corporation]]

| Free/open[[GNU source (GPL|GPL]]/[[BSD license|BSD)]]

| Linux, Windows

|

|-

| [[IBM DB2|DB2Db2]]

| [[IBM]]

| Proprietary commercial

| Cross-platform

|

|-

|GigaSpaces

| [[GigaBASE]]

|[[GigaSpaces]]

| knizhnik

|Apache-2.0 or Proprietary

| Free/open source (MIT License)

|Cross-platform

| Various

|

| [http://sourceforge.net/projects/gigabase/ SourceForge download page]

|-

| [[Greenplum|Greenplum Database]]

Line 46 ⟶ 55:

| [[Informix]]

| [[IBM]]

| Proprietary commercial

| Cross-platform

|

|-

| [[InterSystems Caché|Caché]]

| [[InterSystems]]

| Proprietary commercial

|

|

|-

| [[LogicSQL]]

| Shanghai Shifang Software, Inc.

| Free download, unknown license

| [http://webdocs.cs.ualberta.ca/~yuan/databases/index.html Download page]

|

|-

| [[Microsoft SQL Server]]

| [[Microsoft Corporation]]

| Proprietary commercial

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

| Linux, Windows, Unix

|

Line 76 ⟶ 79:

| [[PostgreSQL]]

| PostgreSQL Global Development Group

| Free/open source Postgres[[PostgreSQL|PostgreSQL License]]

| Cross-platform

|

|-

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

| [[Progress Software Corporation]]

| Proprietary

| Cross-platform

|

|-

| [[Valentina (database)|Valentina ]]

| [[Paradigma Software]]

| Proprietary/free download with commercial add-ons

| Windows, Linux , Mac OS X

| [http://www.valentina-db.com/ Web site]

|-

| [[Virtuoso Universal Server]]

| [[OpenLink Software]]

| Free/open[[GNU source (GPLv2)GPL|GPL]]v2 or proprietary

| Cross-platform

|

Line 103 ⟶ 94:

| ?

| 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

| Free/open source ([[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 125 ⟶ 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 151 ⟶ 155:

|-

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

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

Line 173 ⟶ 183:

| {{yes}}

| {{yes}}

|-

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

| {{?}}

| {{?}}

| {{?}}

| {{?}}

| {{?}}

|-

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

Line 210 ⟶ 213:

|}

==References See also ==

* [[Comparison of database administration tools]]

<references/>

==See also==

* [[Comparison of database tools]]

* [[Comparison of object database management systems]]

* [[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}}