Comparison of object-relational database management systems

From Wikipedia, the free encyclopedia

The tone or style of this article or section may not be appropriate for Wikipedia. Specific concerns may be found on the talk page. See Wikipedia's guide to writing better articles for suggestions.(December 2007)

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.

Contents 1 Fundamental features 1.1 Notes 2 Data types 3 See also 4 External links

[edit] Fundamental features

Information about what fundamental ORDBMSes features are implemented natively.

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

[edit] Notes

1. ^ 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	Yes	Yes	Yes	Yes
OpenLink Virtuoso	Yes	Yes	Yes	Yes	Yes
PostgreSQL	Yes	Yes	Yes	Yes	Yes

[edit] See also

• List of relational database management systems
• Comparison of relational database management systems
• Comparison of database tools

[edit] External links

• Comparison of different SQL implementations

v • d • e Database management systems Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing Concepts Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key Objects Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition SQL Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter Implementations Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores · Triple stores Components Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented