Object Relational Mapping Frameworks

1
Object Relational Mapping Frameworks

• Wiene Höweler

2
Why ORM frameworks

• Maps Object-Oriented programming objects to
  relational databases
• Advantages
• reduce programming code
• improve performance (caching)

3
ORM frameworks

• Open source
• Object Relational Bridge
• Castor
• Hibernate
• Simple ORM
• Ammentos
• Vendors
• Visual Paradigm for UML
• ADF BC (BC4J)
• Toplink

4
Object Relational Bridge

• Support of standard and non-standard API's (PB,
  OTM, ODMG, JDO)
• Transparent persistence
• Object caching
• Optimistic and pessimistic Locking
• Allows to build massively distributed and
  clustered systems
• Configurable persistence by reachability
• Dynamic XML mapping
• http//db.apache.org/ojb/

5
Castor

• Castor XML Java object model to and from XML
  (XML databinding).
• Castor JDO Java object persistence to RDBMS
• In memory caching and write-at-commit
• Two phase commit transactions, object rollback
  and deadlock detection
• OQL query mapping to SQL queries
• http//castor.exolab.org

6
Hibernate

• Support for inheritance, polymorphism,
  composition and the Java collections framework
• A variety of mappings for collections and
  dependent objects
• No build-time bytecode enhancement
• Dual-layer cache architecture
• Support for "application" transactions
• http//www.hibernate.org/

7
Simple ORM

• Object/relational mapping on top of JDBC
• No XML, 100 Java
• Allows for raw JDBC and non-Java database access
  and constraints without compromising database
  integrity
• http//simpleorm.org

8
Ammentos

• Explicitely meant for JDK5 developers
• Works with JDK5 annotations
• Automatic validation
• Event-driven programming supported
• Supports inheritance
• Supports transactions
• http//ammentos.biobytes.it/

9
Visual Paradigm for UML

• Model sharing among diagrams
• Imports from ROSE
• Customizable SQL
• EJB diagram support and EJB code generation and
  deployment
• Integrates with Eclipse/IBM WebSphere, JBuilder,
  NetBeans IDE/Sun ONE, IntelliJ IDEA, JDeveloper
  and WebLogic Workshop.
• http//www.visual-paradigm.com/product/vpuml

10
ADF BC (BC4J)

• Lightweight Java classes and corresponding
  XML-driven bean factories
• Declaratively design master/detail UI data model,
  including only data needed by client for optimum
  performance
• Declaratively enforce required fields, primary
  key uniqueness, data precision/scale, and foreign
  key references
• Simplify multi-step web-based business
  transactions with automatic web-tier state
  management
• http//www.oracle.com/technology/products/jdev/tip
  s/muench/keybenefits/index.html

11
Toplink

• Offers developers excellent performance and
  choice, working with any database, any
  application server, any development toolset and
  process, and any J2EE architecture.
• Allows Oracle hints to specify items such as the
  join order of a join statement or the
  optimization approach of a SQL call
• Hierarchical queries
• Support for Oracle Database Types
• http//www.oracle.com/technology/products/ias/topl
  ink