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:
- A Brief Introduction To The Problem
- Basic Concepts For Solving The Problem
- Implementing Database Journaling
- Benefits
Download presentation file
