Comparison of object-relational database management systems

Comparison of object-relational database management systems

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

Fundamental 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

Notes

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

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

External links

  • Arvin.dk, Comparison of different SQL implementations

Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • Comparison of relational database management systems — Programming language comparisons General comparison Basic syntax Basic instructions Arrays Associative arrays String operations …   Wikipedia

  • List of object-oriented database management systems — The following is a list of object oriented database management systems.*Caché * [http://www.codeplex.com/Cerebrum Cerebrum : Object oriented network knowledge base] *ConceptBase *Datawasp *Db4o *eXtremeDB *Facets (previously known as GemStone J)… …   Wikipedia

  • List of relational database management systems — See DBMS for a shorter list of “typical”, representative database management systems.Current software*4th Dimension *Adabas D *Alpha Five *Apache Derby *CA Datacom *CSQL *Daffodil database *Dataphor *DB2 *Derby aka Java DB *EnterpriseDB… …   Wikipedia

  • Relational database management system — A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the… …   Wikipedia

  • Object-relational database — An object relational database (ORD), or object relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object oriented database model: objects, classes and inheritance… …   Wikipedia

  • Comparison of object database management systems — Features Information about what fundamental ODBMS features are implemented natively. Name Current Stable Version Language(s) SQL support Datatypes License Description Caché 2010.1.4 ObjectScript (dynamic language), Basic. Java/.NET object mapping …   Wikipedia

  • Relational database — A visual diagram showing the relationship between the two tables, as indicated by the arrow A relational database matches data by using common characteristics found within the data set. The resulting groups of data uses the relational model (a… …   Wikipedia

  • Object-relational impedance mismatch — The object relational impedance mismatch is a set of conceptual and technical difficulties that are often encountered when a relational database management system (RDBMS) is being used by a program written in an object oriented programming… …   Wikipedia

  • Object-relational mapping — For another use of ORM , see Object role modeling. Object relational mapping (ORM, O/RM, and O/R mapping) in computer software is a programming technique for converting data between incompatible type systems in object oriented programming… …   Wikipedia

  • Comparison of database tools — The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information. This article is neither all inclusive nor necessarily up to… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”