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.

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	Supports data objects in .NET languages
Oracle Database	Oracle Corporation	Proprietary	Linux, Windows, Unix
PostgreSQL	PostgreSQL Global Development Group	Postgres	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, Mac OS X	Based on REST and Server-Side JavaScript
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^[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

References

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

External links

Arvin.dk, Comparison of different SQL implementations

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 plan

Functions	Administration and automation Query optimization Replication

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

This article is issued from Wikipedia - version of the 7/11/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.