Method for managing logging and locking of page free space infor

Details Method for managing logging and locking of page free space infor Method for managing logging and locking of page free space infor

Filed on

1993-03-15

Date issued

1995-10-03

Examiner

Black, Thomas G.

Patent Class

Boots, shoes, and leggings

Other Related Categories

364DIG1, 39518217, 39549701, 395419, G06F 1730, G06F 1200, G06F 1216

Type

Patent

Status

active

Patent number

054559448

Description

ABSTRACT:
Database files containing records include pages called free space inventory pages (FSIPs) describing field space information relating to data pages. In a transaction processing system, the invention provides correct sequences for logging of updates to FSIPs when the updates are required by updates or UNDOs to data records. If, during operation to insert a data record to a data page, the FSIP containing free space information for the page indicates that the page is empty and there are no uncommitted deletes to the page, page I/O is avoided by formatting the page directly in a data buffer pool without reading the page from disk. During a cursor stability-level table scan with data record-level locking, excessive I/O and some record locking are avoided by using space reservation fields on an FSIP to ensure that there is no space reserved on the data page for a later undo of uncommitted data records deletes from the page.

REFERENCES:
patent: 4507751 (1985-03-01), Gawlick et al.
patent: 4604694 (1986-08-01), Hough
patent: 4961134 (1990-10-01), Crus et al.
patent: 5140685 (1992-08-01), Sipple et al.
patent: 5193162 (1993-03-01), Bordsen et al.
patent: 5222235 (1993-06-01), Hintz et al.
patent: 5247672 (1993-09-01), Mohan
patent: 5280612 (1994-01-01), Lorie et al.
Data Recovery In IBM Database 2, R. A. Crus, vol. 23, No. 2, 1984, pp. 178-188.
Research Report, Computer Science, C. Mohan, Aries: A transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging, pp. 1-52 (Nov., 1990).
IBM Technical Disclosure Bulletin, No. 11, Method for Reserving Space Needed for "Rollback" actions, Lindsay, Mohan, Pirahest, 1986.

Affiliated with

Also associated with

Rating

Method for managing logging and locking of page free space infor 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 managing logging and locking of page free space infor, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for managing logging and locking of page free space infor will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1083372