Comparison of object–relational database management systems

Short description: None

This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages)

This article possibly contains original research. Please improve it by verifying the claims made and adding inline citations. Statements consisting only of original research should be removed. (August 2025) (Learn how and when to remove this template message)

|

(Learn how and when to remove this template message)

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.

## Contents

* 1 Basic data
* 2 Object features
* 3 Data types
* 4 See also
* 5 Notes
* 6 References
* 7 External links

## Basic data

Name  | Vendor  | License | OS | Notes

|
|
|
|

Adaptive Server Enterprise | SAP  | Proprietary | Cross-platform  |
Caché | InterSystems | Proprietary  | Cross-platform  |
CUBRID | NHN Corporation  | GPL/BSD | Linux, Windows  |
IBM Db2 | IBM | Proprietary  | Cross-platform  |
GigaSpaces  | GigaSpaces | Apache-2.0 or Proprietary  | Cross-platform  |
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 License | Cross-platform  |
Virtuoso Universal Server | OpenLink Software  | GPLv2 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 | AGPLv3 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.

| Type  | Method  | Type inheritance | Table inheritance

|
|
|
|

CUBRID | Yes  | Yes  | Yes  | Yes
Oracle | Yes  | Yes[lower-alpha 1] | Yes  | Yes
OpenLink Virtuoso | Yes  | Yes  | Yes  | Yes
PostgreSQL | Yes  | Yes  | Yes  | Yes
Informix | Yes  | Yes  | Yes  | Yes
WakandaDB  | Yes  | Yes  | Yes  | Yes

## Data types

Information about what data types are implemented natively.

| Array | List  | Set  | Multiset | Object reference

|
|
|
|
|

CUBRID | Yes  | Yes  | Yes  | Yes  | Yes
Oracle | Yes  | Yes  | Yes  | Yes  | Yes
OpenLink Virtuoso | Yes  | Yes  | Yes  | Yes  | Yes
PostgreSQL | Yes  | Yes  | Yes  | Yes  | Yes
Informix | No  | Yes  | Yes  | Yes  | Yes

## See also

* Comparison of database administration tools
* Comparison of object database management systems
* Comparison of relational database management systems
* DB-Engine Ranking list
* List of relational database management systems

## Notes

1. ↑ No private methods, no way to call super method from a child.

## References

## External links

* Arvin.dk, comparison of different SQL implementations

* v
* t
* e

Database management systems

Types|

* Object-oriented
* comparison
* Relational
* comparison
* Document-oriented
* Graph
* NoSQL
* NewSQL

Concepts|

* Database
* ACID
* Armstrong's axioms
* CAP theorem
* CRUD
* Null
* Candidate key
* Foreign key
* Superkey
* Surrogate key
* Unique key

Objects|

* Relation
* table
* column
* row
* View
* Transaction
* Transaction log
* Trigger
* Index
* Stored procedure
* Cursor
* Partition

Components|

* Concurrency control
* Data dictionary
* JDBC
* XQJ
* ODBC
* Query language
* Query optimizer
* Query rewriting system
* Query plan

Functions|

* Administration
* Query optimization
* Replication

Related topics|

* Database models
* Database normalization
* Database storage
* Distributed database
* Federated database system
* Referential integrity
* Relational algebra
* Relational calculus
* Relational database
* Relational model
* Object-relational database
* Transaction processing

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Comparison of object–relational database management systems. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Comparison_of_object–relational_database_management_systems&oldid=4344513"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template