CSC/ECE 517 Fall 2014/ch1b 28 cg

From Expertiza_Wiki
Revision as of 16:25, 28 September 2014 by Jgu7 (talk | contribs)
Jump to navigation Jump to search

Object-relational Mapping

Object-relational Mapping (ORM, O/RM, and O/R mapping) is a programming framework that allows you to define a mapping between application object model and the relational database. In an Object model, the application objects are not aware of the database structure. Objects have properties and references to other objects. Databases consist of tables with columns that maybe related to other tables.

ORM provides a bridge between the Relational database and the object model and lead to a huge reduction in lines of code as ORM tools translate the query language into the appropriate syntax for the database for developers. By using ORM, you can access and update data entirely using the object model of an application. There are lots of free and commercial packages available that perform object-relational mapping. Object code can be written using object-oriented programming (OOP) languages such as Java, Ruby, C++ or C#.

Background