Assignment 4: Technologies and Patterns for Data Access

This is one of the choices for Assignment 4.

Object-Relational Mapping

Objectives: This assignment focuses on Object-Relational Mapping pattern and the typical architecrture of ORM frameworks. As a conceptual background, all concepts related to data access technologies of different levels of abstraction and data access patterns must be known (Lectures weeks 9,10,11).

Assignment 4 variant: Implement a simplified ORM framework

Stanndard Requirements

Implement a generator which takes as input a set of classes (they can have inheritance and association relationships) and determines and generates the structure of the corresponding database tables and their relationships. The generator applies the known patterns for mapping different types of class relationships to tables relationships.

Bonus Requirements

In order to create a more complete ORM, add following features:implement also an EntityManager that can save different objects (instances of the entity classes) into the generated database tables. Write at least 2 different applications using 2 different models to demonstrate the usability of your ORM.

Deadlines and Grading

The deadline for this assignment is in Week 13. See the Grading Policy on CV for PASSC and DACSS.

Frameworks/technologies to use

JDBC
Database: can use any relational database; recommended for easy usage without installation: H2 database

Resources

Slides - Lecture notes weeks 9, 10, 11 link
Source code of an example using JDBC with in-memory H2 database JDBCPersonsCars.zip
Your competitor (not to be used here, just for inspiration): Object-Relational Mapping in JPA (Jakarta Persistence, formerly known as Java Persistence API)
Source code of example using JPA with Hibernate and H2: JPAHibernatePersonsCars.zip