O'Reilly Open Source Convention
oreilly.comO'Reilly Network
Conferences International Safari: Books Online

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Press
Arrow Mail List
Kids World

From the Frontiers of Research to the Heart of the Enterprise
O'Reilly Open Source Convention
Sheraton San Diego Hotel and Marina
July 22-26, 2002 -- San Diego, CA



Building Journaling Databases With PostgreSQL
Hans-Juergen Schoenig, Cybertec Geschwinde & Schoenig OEG

Track: Databases
Date: Thursday, July 25
Time: 4:30pm - 5:15pm
Location: Grande Ballroom C

Databases usually store the latest version of a certain piece of data. If information is deleted accidentally or if data is deleted it is hard to go back to a prior status of the data. When working with backups you can restore groups of tables but it is nearly impossible to undo transactions which have already been committed.

With the help of databases built on journals it is possible to go restore the status of a database as it was in a certain moment. This way it is possible to recover data as it was during a defined period of time with just a few commands and without causing downtimes. In addition to that the applications built on top of the database are not influenced by this feature.

In combination with PostgreSQL databases, this is a secure method of protecting data. The system can be compared with CVS for databases.

Presentation Outline:

  1. A Brief Introduction To The Problem
  2. Basic Concepts For Solving The Problem
  3. Implementing Database Journaling
  4. Benefits

Download presentation file

oreilly.com Home | O'Reilly Bookstores | How to Order | O'Reilly Contacts
International | About O'Reilly | Affiliated Companies | Privacy Policy

© 2001, O'Reilly Media, Inc.