Chapter 25. Code Engineering

  1. Home
  2. Docs
  3. Chapter 25. Code Engineering
  4. 5. Object Relational Mapping

5. Object Relational Mapping

Download PDF

What is Object Relational Mapping?

Object-relational mapping (ORM) is a programming technique in which a metadata descriptor is used to connect object code to a relational database. Object code is written in object-oriented programming (OOP) languages such as Java or C#. ORM converts data between type systems that are unable to coexist within relational databases and OOP languages.

Benefits of Object Relational Mapping

Object-relational mapping is a powerful technique that supports the conversion of incompatible types in object-oriented programming languages, specifically between a data store in RDBM and programming objects. ORM performs the rather amazing task of managing the application’s interactions with the database. Visual Paradigm automatically create mappings and objects for use in an application, those objects completely manage the application’s data access needs. Thus eliminate the need to write any other low-level data access code.

Visual Paradigm ORM tool streamlines the data creation, data manipulation and data access. It is a programming technique that maps the object to the data stored in the database.  In addition to the data access technique, ORM’s benefits also include:

  • Simplified development using visual modeling process from object-to-table and table-to-object conversion, significantly lower development and maintenance costs
  • Transparent object caching in the application tier, improving system performance
  • Less code compared to embedded SQL and handwritten stored procedures
  • Create a class library to generate a separate DLL for the ORM and generated data access code once, you can then easily reuse the data objects in a variety of applications for different purposes.