×

Method for deallocating a log in database systems

  • US 5,832,508 A
  • Filed: 11/14/1996
  • Issued: 11/03/1998
  • Est. Priority Date: 09/18/1996
  • Status: Expired due to Term
First Claim
Patent Images

1. In a database system, said database system maintaining a log for recording transactions which occur in said system, an improved method for deallocating log pages during archiving of the log, the method comprising:

  • storing information about the transactions which occur in the system as a plurality of log records, said log records being stored together on a plurality of log pages, a number of said log pages being stored together as an allocation unit;

    receiving a request to dump certain ones of said log records to an archive device;

    determining which allocation units stores said certain ones of said log records to archive;

    for said determined allocation units, determining first and last log pages for said certain ones of said log records to be dumped to the archive device; and

    for each allocation unit determine to store said certain ones of said log records, deallocating log pages by at least performing;

    if an allocation unit is completely filled with log records to be deallocated, deallocating those log records by marking the allocation unit as having deallocated log pages, the step being performed without fetching any log pages for the allocation unit.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×