CSC/ECE 517 Fall 2010/ch2 2a aa

Language extensions for ORM

---

1. Introduction to ORM.
2. Why ORM, why not another solution?
3. Flavors of ORM.
4. ORM implementation in specific languages
   1. Groovy, Grails and GROM
      1. Creating classes and tables
      2. Basic CRUD
         1. Creating objects
         2. Reading objects
         3. Updating objects
         4. Deleting objects
   2. PHP
      1. Creating classes and tables
      2. Basic CRUD
         1. Creating objects
         2. Reading objects
         3. Updating objects
         4. Deleting objects

---

Introduction to ORM.

Object Relational Mapping is a technique of mapping the solution entities of an object oriented system, Objects to relational database tables. (link to RDBMS+wiki). This technique came into existence as an answer to the problem of lack of persistence of objects across session in Object Oriented Systems (link to Object Oriented systems+wiki). For instance in a software solution to manage the order and inventory systems of a company, the objects that are part of the systems (orders, customers . . .) must be accessible even if the system was temporarily shut down for a while. ORM helps in achieving this very essential requirement by bringing the database into the picture, more specifically bringing the RDBMS(link to RDBMS) into the picture.