This article presents Cayenne - a fast, scalable and easy-to-learn open source Object Relational Mapping (ORM) framework. Cayenne is a rare kind of a Java open source project. It is not just an "edit your own XML" runtime library, but an integrated suite that includes modeling and deployment tools. This article shows how to quickly create an ORM application with Cayenne and discusses its core features and design principles.

The Persevere persistent object framework brings persistent object mapping to the browser JavaScript environment. Object persistence has seen great popularity in the Java™ programming and Ruby worlds, and the dynamic JavaScript language is naturally well suited to mapping objects to persisted data. Persevere automates mapping and communication in Asynchronous JavaScript + XML (Ajax)-based Web applications in addition to simplifying much of the development challenge by providing a manageable data model, transparent client-server Ajax interchanges, automatic state change storage, and implicit transaction management.

The objective of this paper is to present the Whitemarsh approach to the definition of function points within database-centric business information systems, the process of counting function points, and the use of two metrics derived from function point counts to accomplish business information system estimating.

Optional XML elements—for example, online forms—are special in that they might or might not appear in XML files. Representing such optional elements is a challenge both in programming languages and in databases. In many cases, null values are inserted in databases to represent empty optional elements, but null database XML values can be difficult to retrieve. Discover alternative, less-invasive approaches to handling optional XML elements without the need for data overloading or inserting null or other sentinel values.

This article shares some thoughts on type metamodels and propose some novel perspectives on scalar types and potential non-scalar types.

Creating an effective data migration testing strategy is critical to reducing risk and delivering a successful migration. This article offers thoughts and recommendations on how to create a more consistent data migration testing methodology using either a black box or a white box approach.

The inception of the Extreme Programming methodology has brought test-driven development and continuous integration into mainstream Java development practices. Applying these techniques to Java server-side development can quickly become a nightmare if you don't have the right tools. This article describes how to deal with continuous integration and how to use DbUnit in conjunction with JUnit to control the test environment end-to-end by setting up the state of the database before each test.

Java developers can get a lot of mileage out of storing objects directly in an object-oriented database like db4o. Learn how db4o handles three concerns central to Java enterprise development: transactions, distributed data management, and Web application security.

Database auditing can be a crucial component of database security and compliance with government regulations. Database auditing helps to answer questions like “Who accessed or changed data?” and “When was it actually changed?” and “What was the old content prior to the change?” Your ability to answer such questions can make or break a compliance audit. Sometimes it may be necessary to review certain audit data in greater detail to determine how, when and who changed the data.

This article identifies enterprise data architecture dimensions that are used to analyze the requirements, constraints and boundaries in deciding an appropriate solution. This article explains in detail the various dimensions used in that reference that could yield richer insights when viewed using these perspectives.