Object database

From Academic Kids

Template:Merging

An object database (more correctly referred to as ODBMS or OODBMS for Object Database Management System) is a DBMS that stores objects as opposed to rows or tuples in respectively a SQL or a RDBMS (Relational Database Management System).

It is most often used in the case of C++ and Java programmers that do not wish to deal with the impedance mismatch of going from an object oriented (OO) programming language to a database query language like SQL programming language that is the current standard. Developers prefer to be able to persist an object without having to go through a paradigm shift. Also missing from SQL is the concept of polymorphism, which is central to OO design, thus causing headaches when mapping from OO code to SQL.

Of course this has advantages and disadvantages. The ability to stay closer to the OO paradigm is a plus for organizations who believe in OOP. However, the SQL DBMSs is a mature and proven one that has had decades of development and testing.

Certain benchmarks between ODBMS and SQL DBMSs have shown that ODBMS can be clearly superior for certain kinds of tasks. One of the main reasons is that ODBMS do not use joins to associate objects but references which are usually implemented as pointers. In SQL-based RDBMS, a join would often require a search through a B-tree index (although some vendors offer short-cut technology). In general, navigation in an ODBMS is via traversing references, whereas in SQL data is joined in an ad-hoc fashion (which is better for arbitrary queries).

The successful market segments for ODBMS seem to be in telecommunications, high energy physics and subsets of financial services. The things that work against ODBMS seem to be the lack of interoperability with a great number of tools/features that are taken for granted in the SQL world including but not limited to industry standard connectivity, reporting tools, OLAP tools and backup and recovery standards. Additionally, ODBMS lacks a formal mathematical foundation, unlike the relational model, which rests upon the firm and well-understood mathematical basis of the relational calculus.

It must be noted that all SQL limitations come from it violating the principles of the relational model. A proper implementation, such as Alphora Dataphor, provides all the benefits of OO DBMSs without their drawbacks.

The Object Database Management Group did come up with an industry standard called ODMG 2.0 but it failed to gain acceptance with the ODBMS vendors mostly opting for proprietary features and extensions instead of attempting to grow the ODBMS pie by standards compliance and competing on implementations.

As an industry, ODBMS were long considered to be a lost opportunity to revolutionize software development. Instead, there are more solutions out there providing so-called object-relational mapping abilities -- actually object-SQL mappings -- than there are ODBMS. There are many design patterns for designing object-SQL mappings (it is a non-trivial task; see notes to this effect in database). A directory service DBMS is considered an alternate, less ambitious approach that shares many goals with ODBMS.

Since 2004, object databases have seen a renaissance when open source object databases appeared and managed to build large user communities of Java and .NET developers who are seeking an embeddable, zero-administration persistence solution.

See also

Commercial Insight

External links

fr:Base de données orientée objet pl:Obiektowa baza danych

Navigation

Academic Kids Menu

  • Art and Cultures
    • Art (http://www.academickids.com/encyclopedia/index.php/Art)
    • Architecture (http://www.academickids.com/encyclopedia/index.php/Architecture)
    • Cultures (http://www.academickids.com/encyclopedia/index.php/Cultures)
    • Music (http://www.academickids.com/encyclopedia/index.php/Music)
    • Musical Instruments (http://academickids.com/encyclopedia/index.php/List_of_musical_instruments)
  • Biographies (http://www.academickids.com/encyclopedia/index.php/Biographies)
  • Clipart (http://www.academickids.com/encyclopedia/index.php/Clipart)
  • Geography (http://www.academickids.com/encyclopedia/index.php/Geography)
    • Countries of the World (http://www.academickids.com/encyclopedia/index.php/Countries)
    • Maps (http://www.academickids.com/encyclopedia/index.php/Maps)
    • Flags (http://www.academickids.com/encyclopedia/index.php/Flags)
    • Continents (http://www.academickids.com/encyclopedia/index.php/Continents)
  • History (http://www.academickids.com/encyclopedia/index.php/History)
    • Ancient Civilizations (http://www.academickids.com/encyclopedia/index.php/Ancient_Civilizations)
    • Industrial Revolution (http://www.academickids.com/encyclopedia/index.php/Industrial_Revolution)
    • Middle Ages (http://www.academickids.com/encyclopedia/index.php/Middle_Ages)
    • Prehistory (http://www.academickids.com/encyclopedia/index.php/Prehistory)
    • Renaissance (http://www.academickids.com/encyclopedia/index.php/Renaissance)
    • Timelines (http://www.academickids.com/encyclopedia/index.php/Timelines)
    • United States (http://www.academickids.com/encyclopedia/index.php/United_States)
    • Wars (http://www.academickids.com/encyclopedia/index.php/Wars)
    • World History (http://www.academickids.com/encyclopedia/index.php/History_of_the_world)
  • Human Body (http://www.academickids.com/encyclopedia/index.php/Human_Body)
  • Mathematics (http://www.academickids.com/encyclopedia/index.php/Mathematics)
  • Reference (http://www.academickids.com/encyclopedia/index.php/Reference)
  • Science (http://www.academickids.com/encyclopedia/index.php/Science)
    • Animals (http://www.academickids.com/encyclopedia/index.php/Animals)
    • Aviation (http://www.academickids.com/encyclopedia/index.php/Aviation)
    • Dinosaurs (http://www.academickids.com/encyclopedia/index.php/Dinosaurs)
    • Earth (http://www.academickids.com/encyclopedia/index.php/Earth)
    • Inventions (http://www.academickids.com/encyclopedia/index.php/Inventions)
    • Physical Science (http://www.academickids.com/encyclopedia/index.php/Physical_Science)
    • Plants (http://www.academickids.com/encyclopedia/index.php/Plants)
    • Scientists (http://www.academickids.com/encyclopedia/index.php/Scientists)
  • Social Studies (http://www.academickids.com/encyclopedia/index.php/Social_Studies)
    • Anthropology (http://www.academickids.com/encyclopedia/index.php/Anthropology)
    • Economics (http://www.academickids.com/encyclopedia/index.php/Economics)
    • Government (http://www.academickids.com/encyclopedia/index.php/Government)
    • Religion (http://www.academickids.com/encyclopedia/index.php/Religion)
    • Holidays (http://www.academickids.com/encyclopedia/index.php/Holidays)
  • Space and Astronomy
    • Solar System (http://www.academickids.com/encyclopedia/index.php/Solar_System)
    • Planets (http://www.academickids.com/encyclopedia/index.php/Planets)
  • Sports (http://www.academickids.com/encyclopedia/index.php/Sports)
  • Timelines (http://www.academickids.com/encyclopedia/index.php/Timelines)
  • Weather (http://www.academickids.com/encyclopedia/index.php/Weather)
  • US States (http://www.academickids.com/encyclopedia/index.php/US_States)

Information

  • Home Page (http://academickids.com/encyclopedia/index.php)
  • Contact Us (http://www.academickids.com/encyclopedia/index.php/Contactus)

  • Clip Art (http://classroomclipart.com)
Toolbox
Personal tools