Techniques for increasing the usefulness of transaction logs

Details Techniques for increasing the usefulness of transaction logs Techniques for increasing the usefulness of transaction logs

2011-02-15

2011-02-15

Lee, Wilson (Department: 2163)

Data processing: database and file management or data structures

File or database maintenance

Database backup

Reexamination Certificate

active

07890466

ABSTRACT:
Techniques for making light-weight checkpoints in logs of streams of transactions and for extending the logs from the checkpoints. The state saved in the light weight checkpoint need only include the state of all transactions that are active at a prior point in the log and are still active at the checkpoint. A log is extended from the checkpoint by processing new transactions in the transaction stream beginning at the prior point to produce the extending log. When the checkpoint is reached, the state saved at the checkpoint is used to continue to produce the extending log. Techniques are further disclosed for selecting points in the stream of transactions at which the checkpoints may be made and for determining the distance between checkpoints. As disclosed, the log in which the checkpoints are used is a logical log made from a physical log produced by a relational database system. The logical log may be used for replication and for data mining.

REFERENCES:
patent: 5317731 (1994-05-01), Dias et al.
patent: 5907848 (1999-05-01), Zaiken et al.
patent: 6122640 (2000-09-01), Pereira

Affiliated with

Also associated with

Rating

Techniques for increasing the usefulness of transaction logs does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Techniques for increasing the usefulness of transaction logs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Techniques for increasing the usefulness of transaction logs will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2626336