Design Patterns for Large-Scale Database Management

Robert Hodges (
Location: Portland 256 Level: Intermediate
Average rating: ****.
(4.25, 4 ratings)
Slides:   1-PDF 

Design patterns revolutionized object-oriented programming and are important for service-oriented-architectures. However, there are also design patterns that work well for database systems. In this talk we will present six important design patterns that are used across highly successful data-driven applications:

  • Transactional data service
  • Fault-tolerant data service
  • Multi-site data service
  • Sharded data service
  • Real-time Data Bridge
  • Fabric Connector

We will look at the details of each design pattern, then show you how to combine them to create a new kind of database architecture called a “data fabric.” Our focus is relational databases like MySQL and PostgreSQL, but the design patterns and data fabric architectures apply to a wide range of DBMS types.

Photo of Robert Hodges

Robert Hodges

Robert Hodges is CEO of Continent, Inc., a leading provider of clustering solutions for open source databases. He has over 30 years of experience in database and application development. Robert has worked on cutting edge software for DBMS vendors, including reliable messaging, development tools, and object-relational databases. Robert is the main designer of Continuent’s Tungsten clustering and the lead committer for Tungsten Replicator, an open source replication engine.


Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or

Contact Us

View a complete list of OSCON contacts