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

Revision as of 07:33, 28 August 2007

Revision as of 11:10, 26 September 2007

Line 3:

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.

*[[IBM DB2|DB2]]

*[[GigaBASE]]

*[[Greenplum]]

*[[Informix]]

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

*[[Virtuoso Universal Server|OpenLink Virtuoso]]

*[[Oracle database|Oracle]]

*[[PostgreSQL]]

*[[Progress 4GL]]

*[[UniSQL]]

*[[Valentina (Database)|Valentina ]]

*[[VMDS]]

*[[Zope|Zope / ZODB]]

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.

==Fundamental features==

Information about what fundamental ORDBMSes features 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%" |

! style="width:12em" |

! [[Datatype|Type]]

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

Line 30 ⟶ 14:

! Table inheritance

|-

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

| {{yes}}

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

Line 36 ⟶ 20:

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

Line 42 ⟶ 26:

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

| {{yes}}

| {{yes}}

|- style="background: #ececec"

!

! [[Datatype|Type]]

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

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

! Table inheritance

|-

|}

===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%" |

! style="width:12em" |

! [[Array]]

! [[List (computing)|List]]

Line 69 ⟶ 46:

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

|-

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

| {{yes}}

| {{yes}}

Line 76 ⟶ 53:

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

Line 83 ⟶ 60:

| {{yes}}

|-

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

| {{yes}}

| {{yes}}

Line 89 ⟶ 66:

| {{yes}}

| {{yes}}

|- style="background: #ececec"

!

! [[Array]]

! [[List (computing)|List]]

! [[Set]]

! [[Multiset]]

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

|-

|}