160 likes | 269 Views
This presentation will probably involve audience discussion, which will create action items. Use PowerPoint to keep track of these action items during your presentation In Slide Show, click on the right mouse button Select “Meeting Minder” Select the “Action Items” tab
E N D
This presentation will probably involve audience discussion, which will create action items. Use PowerPoint to keep track of these action items during your presentation • In Slide Show, click on the right mouse button • Select “Meeting Minder” • Select the “Action Items” tab • Type in action items as they come up • Click OK to dismiss this box • This will automatically create an Action Item slide at the end of your presentation with your points entered. Object Relational MappingTools [Sivakumar Natarajan]
Introduction • OO is the predominant approach used to build mainstream B systems • RDBMS are the most prevalent implementation of data stores • OO design models problem domain as real-world objects, RD development is to normalize data • O-R modelling is a necessary but not sufficient to build strong and flexible systems
Relational Terminology • Relation • Attribute • Domain • Tuple<Person SSN# = "123-45-6789" Name = "Art Larsson" City = "San Francisco"> • Attribute Value • Relation Value • Relation Variable • Database • Base Relation Values • Derived Relation Values
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
Object Modeling Terminology • Identity • State • Behavior • Encapsulation • Type • Associations • Class • Inheritance
Object Model Design An object model contains classes Figure 2 illustrates a simple object model. Figure 2
Objects integrated into the Relational Model • Why do we want to do it? • What are the advantages in doing it? • What are the disadvantages in doing it? • Is there any help available?
Java Blend v2.0 Components are: • Mapping tool: A GUI for mapping between database schema and Java programming language classes • The Preprocess program: The preprocess program - Preprocesses .xjava Java programming language source files and .oql OQL source files • 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.
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 PersistenceCapable { int custID; String address; SalesRep rep; };
Java Blend Resources • http://www.sun.com/software/javablend
Top Link for Java Features: • Transparent Persistence • Object-data mapping solution • EJB persistence solution • Enterprise data integration • Mapping workbench • optimistic and pessimistic locking • object level transactions • application server integration and portability • real-time performance
Foundation Library for Java TopLink 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.
Top Link Resources Http://www.objectpeople.com
Other Tools • JRB (Java Relational Binding) -- Ardent • Data Director for Java (DDJ) -- Informix/IBM • UDE (Universal Development Env)--Formida Free Software • Power Tier-- Persistence • Oracle Designer 2000--Oracle • Jasmine -- Computer Associates • SQL Object Factory -- POET Software • VBS Framework -- ObjectMatter Inc.
Persistence PowerTier Example to be included: