Object Relational Mapping Tools Sivakumar Natarajan 122022 Introduction

Object Relational Mapping Tools [Sivakumar Natarajan] 1/2/2022

Introduction l OO is the predominant approach used to build mainstream B systems l RDBMS are the most prevalent implementation of data stores l OO design models problem domain as real-world objects, RD development is to normalize data l O-R modelling is a necessary but not sufficient to build strong and flexible systems 1/2/2022

Relational Terminology l l l l l Relation Attribute Domain Tuple<Person SSN# = "123 -45 -6789" Name = "Art Larsson" City = "San Francisco"> Attribute Value Relation Variable Database Base Relation Values Derived Relation Values 1/2/2022

Relational Database Design The relational model is composed of entities and relations. Figure 1 illustrates LINEITEM and PRODUCT tables and various relationship between them Figure 1 1/2/2022

Object Modeling Terminology l l l l Identity State Behavior Encapsulation Type Associations Class Inheritance 1/2/2022

Object Model Design An object model contains classes Figure 2 illustrates a simple object model. Figure 2 1/2/2022

Objects integrated into the Relational Model l Why do we want to do it? l What are the advantages in doing it? l What are the disadvantages in doing it? l Is there any help available? 1/2/2022

Java Blend v 2. 0 Components are: l Mapping tool: A GUI for mapping between database schema and Java programming language classes l The Preprocess program: The preprocess program - Preprocesses. xjava Java programming language source files and. oql OQL source files l Runtime libraries - Accessed by means of the Java Blend API, a set of Java language routines for access to Java Blend objects, and the underlying database. Application programmers use these methods. 1/2/2022

Java Blend Example application that queries and updates data about customers and their sales orders. CREATE TABLE customer { custid INTEGER NOT NULL, address VARCHAR (50), rep INTEGER, PK_custid PRIMARY KEY (custid), FK_salesrep FOREIGN KEY (rep) REFERENCES salesrep (repid) ) } Equivalent class is class Customer implements Persistence. Capable { int cust. ID; String address; Sales. Rep rep; }; 1/2/2022

Java Blend Resources l http: //www. sun. com/software/javablend 1/2/2022

Top Link for Java Features: l Transparent Persistence l Object-data mapping solution l EJB persistence solution l Enterprise data integration l Mapping workbench l optimistic and pessimistic locking l object level transactions l application server integration and portability l real-time performance 1/2/2022

Visual Mapping workbench 1/2/2022

Foundation Library for Java Top. Link for Java Foundation Library is an object-relational framework, which facilitates the construction of an object-oriented system that can store its objects/data in a relational database. 1/2/2022

Top Link Resources Http: //www. objectpeople. com 1/2/2022

Other Tools l JRB (Java Relational Binding) -- Ardent l Data Director for Java (DDJ) -- Informix/IBM l UDE (Universal Development Env)--Formida Free Software l Power Tier-- Persistence l Oracle Designer 2000 --Oracle l Jasmine -- Computer Associates l SQL Object Factory -- POET Software l VBS Framework -- Object. Matter Inc. 1/2/2022

Persistence Power. Tier Example to be included: 1/2/2022