Topic List

Click a topic to learn more.


Term of the Moment

Data General-One


Look Up Another Term


Redirected from: object-relational mapping

Definition: O-R mapping


(Object-Relational Mapping) Converting data from tables in a relational database to objects and vice versa. Many applications employ object-oriented programming, but keep the data in traditional relational tables. The O-R mapping function can be accomplished with statements in the object-oriented programming language or via a third-party O-R mapping program.

For Complex Relationships
When an object model is very complex with a large number of many-to-many relationships, it takes time to store the data in relational tables. This "impedance mismatch" is resolved with the use of an object database, which is designed for complex object data. See object database and object-oriented programming.




Object Relational Mapping
There are three common types of O-R mapping from tables to objects and back again. A third-party O-R mapping program eliminates much of the tedium of writing this conversion code. (Illustration courtesy of Progress Software.)