Reviews : Object-relational Mapping with Cayenne ORM :

Object-relational Mapping with Cayenne ORM

by Benoy Jose

As databases and applications become increasingly complex, application architects see value in having system-generated classes, compared to hard written value objects and data access objects. This trend towards using system-generated classes has fueledthe market for JDO-based systems and object-relational mapping (ORM) tools. Cayenne falls into the same category and competes with the best of the tools in this arena. Cayenne is an open source, production-quality ORM tool that provides an object-based access to relational databases. Cayenne's stand-out features are the fact that it's open source and its ease-of-use.

This article will take you through some of the features that make Cayenne a powerful choice for your ORM needs. Cayenne comes with a GUI-based ORM tool that generates Java classes and also provides an API to access thosesame classes.

Features

• Automatic code generation
• Support for multiple databases
• Support for non-RBDMS data sources like flat files and XML schemas
• Automatically manages batched transactions with integrity constraints
• Expression language support
• In-memory sorting for quicker pagination
• Query pre-fetching
• A Java Query API
• Simultaneously commits to multiple databases
• Local and distributed caching
• DataViews for composite user defined objects
• Integrated ANT support
• Validation of data objects before committing them to the database
• User Interface (CayenneModeler) for modeling
• Support for container managed transactions
• Generic event handling support
• Transparent and automatic primary key generation

Architecture

The DataNode is the lowest layer of abstraction in Cayenne and represents a physical data source. It directly interacts with the physical database and performs the actual database operations. The DataNode converts Cayenne queries into the target database specific queries and executes them against the target database. It then converts the resultant JDBC ResultSet into objects and sends them back to the calling program. It also takes handles target, database-specific features like, sequences, outer joins, and primary key generation.

The DataDomain is the next layer of abstraction that lies above the DataNode. It acts as a controller to multiple DataNodes and routes requests to appropriate DataNodes. DataDomain can abstract multiple databases and database types and transparently manage the connection to these different data sources.

The next higher level of abstraction is the DataContext and is directly exposed to the developer. The DataContext acts as a bridge to multiple data sources through the DataDomain. The DataContext keeps track of changes made to the database records (DataObjects) and synchronizes the changes with the database when the user commits the changes. You can batch multiple database operations without writing any SQLs and then decide to commit all of them to the database at one shot. The DataContext will analyze the changes and order them so that database integrity constraints are respected and data inconsistencies are resolved. You can also use the DataContext to pre-fetch primary data and use lazy loading to load the rest of the related data.

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.