Comparison of object-relational database management systems

From Wikipedia, the free encyclopedia

This article or section is not written in the formal tone expected of an encyclopedia article.
Please improve it or discuss changes on the talk page. See Wikipedia's guide to writing better articles for suggestions.

This article or section is incomplete and may require expansion and/or cleanup.
Please improve the article, or discuss the issue on the talk page.

The following Database Management Systems (DBMSs) have at least some object-relational features. They vary widely in their completeness and the approaches taken.

The following tables compare general and technical information for a number of object-relational database management systems. 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.

[edit] Fundamental features

Information about what fundamental ORDBMSes features are implemented natively.

	Type	Method	Type inheritance	Table inheritance
Oracle	Yes	Yes^[1]	Yes	No
OpenLink Virtuoso	Yes	No	Yes	Yes
PostgreSQL	Yes	No	No	Yes
	Type	Method	Type inheritance	Table inheritance

Notes:

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

[edit] Data types

Information about what data types are implemented natively.

	Array	List	Set	Multiset	Object reference
Oracle	Yes	No	Yes	Yes	Yes
OpenLink Virtuoso	Yes	No	No	No	Yes
PostgreSQL	Yes	No	No	No	No
	Array	List	Set	Multiset	Object reference

[edit] External links

Comparison of different SQL implementations

Topics in database management systems (DBMS) ( view • talk • edit )
Concepts Database • Database model • Relational database • Relational model • Relational algebra • Primary key, Foreign key, Surrogate key, Superkey, Candidate key • Database normalization • Referential integrity • Relational DBMS • Distributed DBMS • ACID
Objects Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition	Topics in SQL Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Implementations of database management systems
Types of implementations Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores	Components Query language • Query optimizer • Query plan • ODBC • JDBC
Database products
Alpha Five • Apache Derby • Berkeley DB • Caché • DB2 • db4o • DBase • eXtremeDB • Filemaker Pro • Firebird • Greenplum • H2 • Hsqldb • Helix • Informix • Ingres • InterBase • Linter • Microsoft Access • Microsoft SQL Server • Mimer SQL • MonetDB • MySQL • NonStop SQL • Objectivity/DB • OpenLink Virtuoso • OpenOffice.org Base • Oracle • Oracle Rdb • Paradox • Perst • PostgreSQL • SQLite • Sybase IQ • Sybase • Teradata • UniVerse • Visual FoxPro Other: Object-oriented (comparison) • relational (comparison)