Object-relational mapping

ORMobject-relational mapperObject Relational MappingmappedmappingORM frameworksmapsO/R mappingObject 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
169 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

Other object-relational mappers for PerlPHP Object Generator
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 is a mechanism for automatically tuning object-relational mapping queries.

Entity Framework

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

Data access object

DAODAO PatternsDatabase Access Objects
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-relationalobject-relational database management systemobject extensions
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

ActiveRecordActive RecordCastle ActiveRecord
This pattern is commonly used by object persistence tools and in object-relational mapping (ORM).

Java Data Objects

JDOJDO datastoresJSR 12
JPA, however, is an object-relational mapping (ORM) standard, while JDO is both an object-relational mapping standard and a transparent object persistence standard.

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

programmingcodingprogrammable
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

dynamicstatictype checking
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

managementData maintenancedata-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 databaseSQL Databases
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.

Abstraction (computer science)

abstractiondata abstractionabstract
Disadvantages of ORM tools generally stem from the high level of abstraction obscuring what is actually happening in the implementation code.

XML database

Native XML databaseXML databasesnative
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.