Comparison of object-relational database management systems

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 External links

## Basic data

Name  | Vendor  | License | OS | Notes

|
|
|
|

Adaptive Server Enterprise | SAP  | Proprietary | Cross-platform  |
CUBRID | NHN Corporation  | GPL/BSD | Linux, Windows  |
DB2 | IBM | Proprietary  | Cross-platform  |
Greenplum Database | Greenplum division of EMC Corporation  | Proprietary  | ?  | Uses PostgreSQL codebase
Informix | IBM | Proprietary  | Cross-platform  |
Caché | InterSystems | Proprietary  | Cross-platform  |
Microsoft SQL Server | Microsoft Corporation  | Proprietary  | Windows, Linux  | Supports data objects in .NET languages
Oracle Database | Oracle Corporation | Proprietary  | Linux, Windows, Unix  |
PostgreSQL | PostgreSQL Global Development Group  | PostgreSQL License | Cross-platform  |
OpenEdge Advanced Business Language (formerly Progress 4GL)  | Progress Software Corporation  | Proprietary  | 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  |
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[Note 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 tools
* Comparison of object database management systems
* Comparison of relational database management systems
* List of relational database management systems

## Notes

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

## 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)

|

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