1 / 16

Object Relational Mapping Tools

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

mickey
Download Presentation

Object Relational Mapping Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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]

  2. 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

  3. 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

  4. 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

  5. Object Modeling Terminology • Identity • State • Behavior • Encapsulation • Type • Associations • Class • Inheritance

  6. Object Model Design An object model contains classes Figure 2 illustrates a simple object model. Figure 2

  7. 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?

  8. 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.

  9. 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; };

  10. Java Blend Resources • http://www.sun.com/software/javablend

  11. 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

  12. Visual Mapping workbench

  13. 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.

  14. Top Link Resources Http://www.objectpeople.com

  15. 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.

  16. Persistence PowerTier Example to be included:

More Related