Skip to Content
Pattern-Oriented Software Architecture: A Pattern Language for Distributed Computing, 4th Volume
book

Pattern-Oriented Software Architecture: A Pattern Language for Distributed Computing, 4th Volume

by Frank Buschmann, Kevlin Henney, Douglas C. Schmidt
May 2007
Intermediate to advanced
637 pages
14h 8m
English
Wiley
Content preview from Pattern-Oriented Software Architecture: A Pattern Language for Distributed Computing, 4th Volume

Chapter 21. Database Access

Database Access

Frank and some of his books © Frank Buschmann

Many business systems need to persist some or all of the data they use. Distributed systems are no exception. There is a mismatch, however, between the relational model, the dominant persistence paradigm, and the object-oriented model, the favored paradigm for distributed application development. This chapter presents five patterns that help to bridge these two models, to support mapping between object-oriented applications and relational databases.

Many software systems use databases to store their persistent data. In most of these systems the databases follow the relational model for the following reasons, mainly due to economic factors:

  • Existing legacy data and IT infrastructures. Databases are a common and long-standing feature of many IT organizations. As a result, the cost of transferring data to a different database model, or even to a different relational database, often outweigh the benefits of such a change, even if another database is technically superior.

  • Customer support. Due to the maturity of relational databases and the ecosystem that supports them, users typically receive competent and timely customer support world-wide. This level of service is not necessarily available for other database models.

  • Experience. Developers, administrators, and users of databases are often most familiar with the relational ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Pattern-Oriented Software Architecture, A System of Patterns

Pattern-Oriented Software Architecture, A System of Patterns

Frank Buschmann, Regine Meunier, Hans Rohnert, Peter Sommerlad, Michael Stal
Asynchronous Programming in Java

Asynchronous Programming in Java

Richard Warburton, Raoul-Gabriel Urma
Architecture Patterns with Python

Architecture Patterns with Python

Harry Percival, Bob Gregory

Publisher Resources

ISBN: 9780470059029Purchase book