Method for deallocating a log in database systems

Details Method for deallocating a log in database systems Method for deallocating a log in database systems

1996-11-14

1998-11-03

Black, Thomas G.

Data processing: database and file management or data structures

Database design

Data structure types

G06F 1730

Patent

active

058325085

ABSTRACT:
A SQL database server system having an enhanced logging system is described. The logging system implements a "private log cache" (PLC) for reducing the contention on the system's "log" resource (which is protected by a log semaphore). An area of memory private to a user's task is set aside as a PLC--a cache where log records are built and stored before being posted to the log. Each PLC may hold multiple log records for a single transaction before they are flushed to the log (page chain) through the log semaphore. When a transaction commits or the memory fills with log records, the PLC associated with the transaction is flushed to the log. Also described is improved log deallocation methodology provided by the system which alleviates the needs to read each of the log pages to be deallocated, as was conventionally required. The operation to do the deallocation occurs at the allocation page, not at the individual pages (which are to be deallocated). In accordance with this method, the system writes a log record which includes the first page and the last page of the run (i.e., the number of those pages). The system need not, however, read any of the pages of the run, other than the first page and the last page. In a common case of a completely filled allocation unit, the system reads two pages--the first page and the last page--and writes one log record. As a result, the system reads far fewer log pages and writes but a single log record.

REFERENCES:
patent: 4961134 (1990-10-01), Crus et al.
patent: 5008786 (1991-04-01), Thatte
patent: 5155678 (1992-10-01), Fukumoto et al.
patent: 5455946 (1995-10-01), Mohan et al.
patent: 5493668 (1996-02-01), Elko et al.
patent: 5537574 (1996-07-01), Elko et al.
patent: 5717919 (1998-02-01), Kodavalla et al.
Gray, J. and Reuter, A., "Transaction Processing: Concepts and Techniques, " Morgan Kaufmann Publishers, Inc., 1993, pp. 493-524.

Affiliated with

Also associated with

Rating

Method for deallocating a log in database systems does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for deallocating a log in database systems, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for deallocating a log in database systems will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-704303