REVIEW - Data Access Patterns - Database Interactions in Object-Oriented Applications


Data Access Patterns

Database Interactions in Object-Oriented Applications


Clifton Nock



Edward Elgar Publishing (2004)




Huw Lloyd


February 2004



If you have ever puzzled over how to implement persistence code in a well-factored reusable configurable manner this is a book for you.

Each pattern teaches us about the persistence problems that manifest themselves between object-oriented applications and relational databases. Each pattern tends to deal with one prevalent problem, along with an appropriate class-based solution to deal with it.

Unlike the original 'Design Patterns', where patterns focused on domain-generic software problems, each pattern is framed by a particular domain problem. Many of the patterns are described as specialisations of the original patterns. Indeed, few of the patterns are new class relationships; it is their application and appropriateness to particular problems that gives them their name and value.

The elegance of the patterns is manifest by their clarity and the simplicity with which they are integrated to resolve problems of persistence. I found the text to read smoothly with a consistent level of difficulty - interesting but not demanding.

The examples are provided in Java; a little imagination will be required for C++ purists to reinterpret some of the author's style, such as a tendency to use class Object to pass arguments. The example domain objects are overly basic - a few pages are wasted listing get/set operations for all class members - but their simplicity may reduce the clutter of the patterns' presentation.

You will need to know about OO programming, design patterns, the basics of using relational databases and SQL to benefit most from this book. Recommended.

Book cover image courtesy of Open Library.

Your Privacy

By clicking "Accept All Cookies" you agree ACCU can store cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

By clicking "Share IP Address" you agree ACCU can forward your IP address to third-party sites to enhance the information presented on the site, and that these sites may store cookies on your device.