Data processing: database and file management or data structures – Database design – Data structure types
Patent
1998-04-24
2000-08-08
Breene, John E.
Data processing: database and file management or data structures
Database design
Data structure types
707202, 705400, 711100, G06F 1730
Patent
active
061015040
ABSTRACT:
A method in a symmetric multi-processor computer system for increasing database transaction log performance by reducing semaphore contention while waiting to transfer the contents of log buffers stored in a volatile memory of the system to a persistent storage device. The method includes the steps of clearing a switch and resetting an event indicating that no process tasks are waiting completion of a transfer of information in one of the log buffers to the persistent storage. Next, an atomic test-and-set of the switch is performed to determine if this process task is the first task to attempt the waiting completion. Following this, if it is the first task, then it assumes responsibility for guaranteeing that the contents in the log buffer are in persistent storage and causes the event. However, if it is not the first task, a wait is imposed on the process until the event has been caused. This will allow all of the "Not First" tasks that may be waiting to continue their operation.
REFERENCES:
patent: 4507751 (1985-03-01), Gawlick et al.
patent: 5201044 (1993-04-01), Frey, Jr. et al.
patent: 5465328 (1995-11-01), Dievendorff et al.
patent: 5754888 (1998-05-01), Yang et al.
patent: 5832484 (1998-11-01), Sankaran et al.
Breene John E.
Lewis Cheryl
Richebourg J. Ronald
Samuels Steven B.
Starr Mark T.
LandOfFree
Method for reducing semaphore contention during a wait to transf 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 reducing semaphore contention during a wait to transf, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for reducing semaphore contention during a wait to transf will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1159791