Comparison of object-relational database management systems Computer Informatics 485 reader-information-science.pts-ptn.net

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.

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

Basic data

Name	Vendor	License	OS	Notes
Adaptive Server Enterprise	Sybase	Proprietary commercial	Cross-platform
CUBRID	NHN Corporation	Free/open source (GPL/BSD)	Linux, Windows
DB2	IBM	Proprietary commercial	Cross-platform
GigaBASE	knizhnik	Free/open source (MIT License)	Various	SourceForge download page
Greenplum Database	Greenplum division of EMC Corporation	Proprietary	?	Uses PostgreSQL codebase
Informix	IBM	Proprietary commercial	Cross-platform
Caché	InterSystems	Proprietary commercial
LogicSQL	Shanghai Shifang Software, Inc.	Free download, unknown license	Download page
Microsoft SQL Server	Microsoft Corporation	Proprietary commercial	Windows	Supports data objects in .NET languages
Oracle Database	Oracle Corporation	Proprietary commercial	Linux, Windows, Unix
PostgreSQL	PostgreSQL Global Development Group	Free/open source Postgres License	Cross-platform
OpenEdge Advanced Business Language (formerly Progress 4GL)	Progress Software Corporation	Proprietary	Cross-platform
Valentina	Paradigma Software	Proprietary/free download with commercial add-ons	Windows, Linux , Mac OS X	Web site
Virtuoso Universal Server	OpenLink Software	Free/open source (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
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.

	Type	Method	Type inheritance	Table inheritance
CUBRID	Yes	Yes	Yes	Yes
LogicSQL^[1]	?	?	?	?
Oracle	Yes	Yes^[2]	Yes	Yes
OpenLink Virtuoso	Yes	Yes	Yes	Yes
PostgreSQL	Yes	Yes	Yes	Yes
Informix	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
LogicSQL	?	?	?	?	?
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

^ http://webdocs.cs.ualberta.ca/~yuan/databases/index.html
^ No private methods, no way to call super method from a child.

External links

Arvin.dk, Comparison of different SQL implementations

Database management systems

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

Concepts	Database ACID CRUD Null Candidate key Foreign key Primary key Superkey Surrogate key Armstrong's axioms

Objects	Relation table column row View 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

Database products Object-oriented comparison Relational comparison Document-oriented NoSQL NewSQL

Comparison of object-relational database management systems

Contents

Basic data

Object features

Data types

References

See also

External links