US6976022B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and mechanism for batch processing transaction logging records
Assignee: Oracle International Corp
•
Filing: 2002-09-16
•
Granted: 2005-12-13
•
Expires: 2022-09-16
Abstract
Abstract A method and mechanism is disclosed for implementing transaction logging in a database system. In-memory undo records are maintained to log undo information for the database system. Redo records are batch processed, with multiple redo records for a transaction stored on disk at commit time.
Inventors
- 👤 Srinivas Vemuri
- 👤 Amit Ganesh
- 👤 Arvind Nithrakashyap
- 👤 Roger Bamford
- 👤 Jonathan Klein
- 👤 Vikram Joshi
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-03 17:22
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2365; G06F16/2358; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99938
Claims Analysis
Total Claims: 52
Claim 1
Independent Claim
100 words
A method for implementing redo records in a database system, comprising: receiving a request to process a first transaction, the first transaction comprising one or more updates to a database; forming a set of redo information corresponding to the one or more updates to the database by the first transaction, the set of redo information comprising one or more redo information items; generating the set of redo information in memory, wherein the one or more redo information items are not individually persisted; and upon a commit of the first transaction, batch persisting the set of redo information as a group.
Claim 2
Independent Claim
100 words
A method for implementing redo records in a database system, comprising: receiving a request to process a first transaction, the first transaction comprising one or more updates to a database; forming a set of redo information corresponding to the one or more updates to the database by the first transaction, the set of redo information comprising one or more redo information items; generating the set of redo information in memory, wherein the one or more redo information items are not individually persisted; and upon a commit of the first transaction, batch persisting the set of redo information as a group.
Claim 3
Dependent Claim
12 words
The method of claim 1 in which the memory comprises shared memory.
Claim 4
Dependent Claim
22 words
The method of claim 2 in which the set of redo information is stored in a private region of the shared memory.
Claim 5
Dependent Claim
25 words
The method of claim 1 in which the one or more redo information items are created in a final format instead of an intermediate format.
Claim 6
Dependent Claim
20 words
The method of claim 1 in which the set of data acted upon by the first transaction is exclusively locked.
Claim 7
Dependent Claim
20 words
The method of claim 5 in which second transaction acts upon the set of data updated by the first transaction.
Claim 8
Dependent Claim
30 words
The method of claim 6 in which selected ones of the one or more redo information items for which dependency exists for the second transaction are removed from batch processing.
Claim 9
Dependent Claim
21 words
The method of claim 6 in which all of the one or more redo information items are removed from batch processing.
Claim 10
Dependent Claim
22 words
The method of claim 6 in which the first transaction is downgraded such that it no longer continue batch processing redo information.
Claim 11
Dependent Claim
16 words
The method of claim 6 in which the first transaction continues to batch process redo information.
Claim 12
Dependent Claim
17 words
The method of claim 1 in which the set of redo information is optimized before being persisted.
Claim 13
Dependent Claim
26 words
The method of claim 11 in which the set of redo information is optimized by collapsing redo information items to remove intermediate changes to data items.
Claim 14
Dependent Claim
23 words
The method of claim 1 in which the set of redo information is batch persisted by writing to a redo log on disk.
Claim 15
Dependent Claim
23 words
The method of claim 1 in which the set of one or more redo information items is persisted as a single redo record.
Claim 16
Dependent Claim
12 words
The method of claim 1 in which undo information is not persisted.
Claim 17
Dependent Claim
25 words
The method of claim 1 in which the act of processing an update to the database is separated from the act of generating redo information.
Claim 18
Dependent Claim
23 words
The method of claim 1 in which the one or more updates are not persisted until the set of redo information is persisted.
Claim 19
Dependent Claim
116 words
A computer program product comprising a computer usable medium having executable code to execute a process for implementing redo records in a database system, the process comprising: receiving a request to process a first transaction, the first transaction comprising one or more updates to a database; forming a set of redo information corresponding to the one or more updates to the database by the first transaction, the set of redo information comprising one or more redo information items; generating the set of redo information in memory, wherein the one or more redo information items are not individually persisted; and upon a commit of the first transaction, batch persisting the set of redo information as a group.
Claim 20
Dependent Claim
116 words
A computer program product comprising a computer usable medium having executable code to execute a process for implementing redo records in a database system, the process comprising: receiving a request to process a first transaction, the first transaction comprising one or more updates to a database; forming a set of redo information corresponding to the one or more updates to the database by the first transaction, the set of redo information comprising one or more redo information items; generating the set of redo information in memory, wherein the one or more redo information items are not individually persisted; and upon a commit of the first transaction, batch persisting the set of redo information as a group.
Claim 21
Dependent Claim
14 words
The computer program product of claim 18 in which the memory comprises shared memory.
Claim 22
Dependent Claim
24 words
The computer program product of claim 19 in which the set of redo information is stored in a private region of the shared memory.
Claim 23
Dependent Claim
27 words
The computer program product of claim 18 in which the one or more redo information items are created in a final format instead of an intermediate format.
Claim 24
Dependent Claim
22 words
The computer program product of claim 18 in which the set of data acted upon by the first transaction is exclusively locked.
Claim 25
Dependent Claim
22 words
The computer program product of claim 22 in which second transaction acts upon the set of data updated by the first transaction.
Claim 26
Dependent Claim
32 words
The computer program product of claim 23 in which selected ones of the one or more redo information items for which dependency exists for the second transaction are removed from batch processing.
Claim 27
Dependent Claim
23 words
The computer program product of claim 23 in which all of the one or more redo information items are removed from batch processing.
Claim 28
Dependent Claim
24 words
The computer program product of claim 23 in which the first transactioin is downgraded such that it no longer continue batch processing redo information.
Claim 29
Dependent Claim
18 words
The computer program product of claim 23 in which the first transaction continues to batch process redo information.
Claim 30
Dependent Claim
19 words
The computer program product of claim 18 in which the set of redo information is optimized before being persisted.
Claim 31
Dependent Claim
28 words
The computer program product of claim 28 in which the set of redo information is optimized by collapsing redo information items to remove intermediate changes to data items.
Claim 32
Dependent Claim
25 words
The computer program product of claim 18 in which the set of redo information is batch persisted by writing to a redo log on disk.
Claim 33
Dependent Claim
24 words
The computer program product of claim 18 which the set of one or more redo information items is persisted as a single redo record.
Claim 34
Dependent Claim
14 words
The computer program product of claim 18 in which undo information is not persisted.
Claim 35
Dependent Claim
27 words
The computer program product of claim 18 in which the act of processing an update to the database is separated from the act of generating redo information.
Claim 36
Dependent Claim
25 words
The computer program product of claim 18 in which the one or more updates are not persisted until the set of redo information is persisted.
Claim 37
Independent Claim
108 words
A system for implementing redo records in a database system, comprising: means for receiving a request to process a first transaction, the first transaction comprising one or more updates to a database; means for forming a set of redo information corresponding to the one or more updates to the database by the first transaction, the set of redo information comprising one or more redo information items; means for generating the set of redo records in memory, wherein the one or more redo records are not individually persisted; and means for impolementing, upon a commit of the first transaction, batch persisting the set of redo information as a group.
Claim 38
Independent Claim
108 words
A system for implementing redo records in a database system, comprising: means for receiving a request to process a first transaction, the first transaction comprising one or more updates to a database; means for forming a set of redo information corresponding to the one or more updates to the database by the first transaction, the set of redo information comprising one or more redo information items; means for generating the set of redo records in memory, wherein the one or more redo records are not individually persisted; and means for impolementing, upon a commit of the first transaction, batch persisting the set of redo information as a group.
Claim 39
Dependent Claim
12 words
The system of claim 35 in which the memory comprises shared memory.
Claim 40
Dependent Claim
22 words
The system of claim 36 in which the set of redo information is stored in a privated region of the shared memory.
Claim 41
Dependent Claim
25 words
The system of claim 35 in which the one or more redo information items are created in a final format instead of an intermediate format.
Claim 42
Dependent Claim
20 words
The system of claim 35 in which the set of data acted upon by the first transaction is exclusively locked.
Claim 43
Dependent Claim
19 words
The system of claim 39 in which second transaction acts upon the set data updated by the first transaction.
Claim 44
Dependent Claim
30 words
The system of claim 40 in which selected ones of the one or more redo information items for which dependency exists for the second transaction are removed from batch processing.
Claim 45
Dependent Claim
21 words
The system of claim 40 in which all of the one or more redo information items are removed from batch processing.
Claim 46
Dependent Claim
22 words
The system of claim 40 in which the first transaction is downgraded such that it no longer continue batch processing redo information.
Claim 47
Dependent Claim
16 words
The system of claim 40 in which the first transaction continues to batch process redo information.
Claim 48
Dependent Claim
17 words
The system of claim 35 in which the set of redo information is optimized before being persisted.
Claim 49
Dependent Claim
26 words
The system of claim 45 in which the set of redo information is optimized by collapsing redo information items to remove intermediate changes to data items.
Claim 50
Dependent Claim
23 words
The system of claim 35 in which the set of redo information is batch persisted by writing to a redo log on disk.
Claim 51
Dependent Claim
23 words
The system of claim 35 in which the set of one or more redo information items is persisted as a single redo record.
Claim 52
Dependent Claim
12 words
The system of claim 35 in which undo information is not persisted.
References Cited (Backward Citations)
US5485608A
Cited
US5524205A
Cited
US5499367A
Cited
US5452445A
Cited
US5737601A
Cited
US5806075A
Cited
US5870758A
Cited
US6182241B1
Cited
US5850507A
Cited
US6647510B1
Cited
US5903898A
Cited
US5870759A
Cited
US5870765A
Cited
US5884325A
Cited
US5926816A
Cited
US5963960A
Cited
US6041423A
Cited
US5864849A
Cited
US5845292A
Cited
US5974425A
Cited
US6292808B1
Cited
US5832516A
Cited
US5933593A
Cited
US5996088A
Cited
US5937414A
Cited
US5963959A
Cited
US6728747B1
Cited
US6199110B1
Cited
US6490610B1
Cited
US6026406A
Cited
US5956704A
Cited
US6289335B1
Cited
US5991772A
Cited
US6055546A
Cited
US5946700A
Cited
US6182086B1
Cited
US6144983A
Cited
US6351754B1
Cited
US6253212B1
Cited
US6678704B1
Cited
US6185577B1
Cited
US6295610B1
Cited
US6631371B1
Cited
US6487552B1
Cited
US6684223B1
Cited
US6510421B1
Cited
US6493726B1
Cited
US6738971B2
Cited
US6353828B1
Cited
US6363403B1
Cited
US6618822B1
Cited
US6615220B1
Cited
US6631374B1
Cited
US6832229B2
Cited
US6574717B1
Cited
US6823347B2
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2008-12-12 | 2009-06-13 | 2009-12-13 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2012-12-12 | 2013-06-13 | 2013-12-13 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2016-12-12 | 2017-06-13 | 2017-12-13 | $7700.00 | Window Closed / Lapsed |