Object-relational mapping

ORMobject-relational mapperobject relational mappingmappedmappingO/R mappingORM frameworksmapsObject Relational Mapperobject relational mapping (ORM)
Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages.wikipedia
185 Related Articles

Document-oriented database

document databasedocumentdocument-oriented
Another approach is to use an object-oriented database management system (OODBMS) or document-oriented databases such as native XML databases that provide more flexibility in data modeling.
This eliminates the need for object-relational mapping while loading data into the database.

Object-relational impedance mismatch

object/relational impedance mismatch
These difficulties are referred to as the 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 served by an application program (or multiple application programs) written in an object-oriented programming language or style, particularly because objects or class definitions must be mapped to database tables defined by a relational schema.

List of object-relational mapping software

List of object relational mapping softwareOther object-relational mappers for Perlother PHP ORM
List of object-relational mapping software
This is a list of well-known object-relational mapping software.

Object-oriented programming

object-orientedobject orientedobject-oriented programming language
Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages. In object-oriented programming, data-management tasks act on objects that are almost always non-scalar values.
One of the most common approaches is object-relational mapping, as found in IDE languages such as Visual FoxPro and libraries such as Java Data Objects and Ruby on Rails' ActiveRecord.

AutoFetch

AutoFetch – automatic query tuning
AutoFetch is a mechanism for automatically tuning object-relational mapping queries.

Entity Framework

ADO.NETEDMentities
Entity Framework
Entity Framework (EF) is an open source object-relational mapping (ORM) framework for ADO.NET.

Data access object

DAODAO PatternsDAOs
The Data Access Object (DAO) design pattern is used to abstract these statements and offer a lightweight object-oriented interface to the rest of the application.
Commercial products like TopLink are available based on object-relational mapping (ORM).

Object-relational database

object-relational database management systemobject-relationalORDBMS
Object-relational database
However, a more popular alternative for achieving such a bridge is to use a standard relational database systems with some form of object-relational mapping (ORM) software.

Active record pattern

Active RecordActiveRecordActive Record design pattern
Active record pattern
This pattern is commonly used by object persistence tools and in object-relational mapping (ORM).

Java Data Objects

JDOJDO datastores
Java Data Objects
JPA, however, is an object-relational mapping (ORM) standard, while JDO is both an object-relational mapping standard and a transparent object persistence standard.

Data mapper pattern

data mapperdata mappers
Data mapper pattern
Object-relational mapping

Computer science

computer scientistcomputer sciencescomputer scientists
Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages.

Computer programming

programmingcodingcomputer programmer
Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages.

Type system

dynamicstaticdynamically typed
Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages.

Data management

managementConsolidationdata-management
In object-oriented programming, data-management tasks act on objects that are almost always non-scalar values.

Object (computer science)

objectobjectsdata object
In object-oriented programming, data-management tasks act on objects that are almost always non-scalar values. This could be modeled in an object-oriented implementation by a "Person object" with attributes/fields to hold each data item that the entry comprises: the person's name, a list of phone numbers, and a list of addresses.

Attribute (computing)

attributesattribute attributes
This could be modeled in an object-oriented implementation by a "Person object" with attributes/fields to hold each data item that the entry comprises: the person's name, a list of phone numbers, and a list of addresses.

SQL

Structured Query LanguageSQL DatabasesWikibook SQL
However, many popular database products such as SQL database management systems (DBMS) can only store and manipulate scalar values such as integers and strings organized within tables. The following is a simple example, written in C# code, to execute a query written in SQL using a database engine.

Table (database)

tabletablesdatabase table
However, many popular database products such as SQL database management systems (DBMS) can only store and manipulate scalar values such as integers and strings organized within tables.

Persistence (computer science)

persistencepersistentpersistent storage
If this storage and retrieval functionality is implemented, the objects are said to be persistent.

C Sharp (programming language)

C#Visual C#C# programming language
The following is a simple example, written in C# code, to execute a query written in SQL using a database engine.

XML database

nativenative XML databaseXML data sources
Another approach is to use an object-oriented database management system (OODBMS) or document-oriented databases such as native XML databases that provide more flexibility in data modeling.

Associative entity

junction tableassociation data mappingassociative
Using an OODBMS eliminates the need for converting data to and from its SQL form, as the data is stored in its original object representation and relationships are directly represented, rather than requiring join tables/operations.

XQuery

queried
Many of these systems also support the XQuery query language to retrieve datasets.