Database server system with improved methods for logging transactions
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Nov 20, 2001
Grant Date -
N/A
app pub date -
Nov 8, 1996
filing date -
Sep 18, 1996
priority date (Note) -
In Force
status (Latency Note)
Importance
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. Because the log records for a complete transaction are immediately transferred through the log semaphore, contention on the log semaphore decreases. Contention alleviated by the PLC dramatically increases transaction throughput of the database server system.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully