Patent US3558474A successfully refreshed from Google Patents.
Patent US6567928B1 successfully refreshed from Google Patents.
US6567928B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for efficiently recovering from a failure in a database that includes unlogged objects
Assignee: GlobalFoundries Inc
•
Filing: 2000-05-23
•
Granted: 2003-05-20
•
Expires: 2020-05-23
Abstract
Abstract Database tables which are to be loaded with large data objects (LOBs) are defined with a special logging attribute value. This attribute value causes the database management system to suspend recovery logging for the databases so defined, but to continue with the logging of control information, such as space management changes. Certain control information recovery log entries have a special status indicator. For LOBs, this status indicator is set to cause the associated LOB entry to be marked as invalid when the log entry is reapplied, for example, during a recovery operation from a media failure. Rather than invalidating the entire table, the database management system will only prevent access to the entries which have been invalidated during the recovery process.
Inventors
- 👤 Robert W. Lyle
- 👤 James Z. Teng
- 👤 Jay A. Yothers
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-03 18:22
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1471; G06F11/1446; G06F11/1458; G06F11/1461; G06F11/1469; G06F2201/00; G06F2201/80; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 24
Claim 1
Independent Claim
163 words
A method for efficiently recovering from a failure in a database in which a first set of entries have been made with control information recovery logging, but without data recovery logging and a second set of entries have been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the method comprising: (a) including a status indicator field in control information log entries associated with the first set of entries; (b) setting the status indicator field to a first value when the associated data entry was made without data recovery logging and to a second value when the associated data entry was made with data recovery logging; and (c) during a recovery from a failure, marking a data entry invalid when the associated status indicator field has a first value and marking a data entry valid when the associated status indicator field has a second value.
Claim 2
Independent Claim
163 words
A method for efficiently recovering from a failure in a database in which a first set of entries have been made with control information recovery logging, but without data recovery logging and a second set of entries have been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the method comprising: (a) including a status indicator field in control information log entries associated with the first set of entries; (b) setting the status indicator field to a first value when the associated data entry was made without data recovery logging and to a second value when the associated data entry was made with data recovery logging; and (c) during a recovery from a failure, marking a data entry invalid when the associated status indicator field has a first value and marking a data entry valid when the associated status indicator field has a second value.
Claim 3
Dependent Claim
23 words
The method according to claim 1 further comprising: (d) preventing the database management system from accessing data entries which are marked as invalid.
Claim 4
Dependent Claim
32 words
The method according to claim 2 wherein step (d) comprises: (d1) returning a resource unavailable code when the database management system attempts to access a data entry which is marked as invalid.
Claim 5
Dependent Claim
23 words
The method according to claim 1 further comprising: (e) allowing the database management system to access data entries which are marked as valid.
Claim 6
Dependent Claim
17 words
The method according to claim 1 wherein data entries are made using conventional insert and delete commands.
Claim 7
Dependent Claim
168 words
Apparatus for efficiently recovering from a failure in a database in which a first set of entries have been made with control information recovery logging, but without data recovery logging and a second set of entries have been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the apparatus comprising: a status indicator field in control information log entries associated with the first set of entries; a logging mechanism that sets the status indicator field to a first value when the associated data entry was made without data recovery logging and to a second value when the associated data entry was made with data recovery logging; and a recovery mechanism that operates during a recovery from a failure and marks a data entry invalid when the associated status indicator field has a first value and marks a data entry valid when the associated status indicator field has a second value.
Claim 8
Dependent Claim
168 words
Apparatus for efficiently recovering from a failure in a database in which a first set of entries have been made with control information recovery logging, but without data recovery logging and a second set of entries have been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the apparatus comprising: a status indicator field in control information log entries associated with the first set of entries; a logging mechanism that sets the status indicator field to a first value when the associated data entry was made without data recovery logging and to a second value when the associated data entry was made with data recovery logging; and a recovery mechanism that operates during a recovery from a failure and marks a data entry invalid when the associated status indicator field has a first value and marks a data entry valid when the associated status indicator field has a second value.
Claim 9
Dependent Claim
26 words
The apparatus according to claim 6 further comprising: a database control that prevents the database management system from accessing data entries which are marked as invalid.
Claim 10
Dependent Claim
36 words
The apparatus according to claim 7 wherein the database control comprises a retrieval mechanism that returns a resource unavailable code when the database management system attempts to access a data entry which is marked as invalid.
Claim 11
Dependent Claim
27 words
The apparatus according to claim 6 further comprising a database access system that allows the database management system to access data entries which are marked as valid.
Claim 12
Dependent Claim
17 words
The apparatus according to claim 6 wherein data entries are made using conventional insert and delete commands.
Claim 13
Dependent Claim
164 words
A computer program product for efficiently recovering from a failure in a database in which some entries have been made with control information logging including a status indicator field, but without data recovery logging and other entries have been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the computer program product comprising a computer usable medium having computer readable program code thereon, including: program code for setting the status indicator field to a first value when the associated data entry was made without data recovery logging and to a second value when the associated data entry was made with data recovery logging; and program code operable during a recovery from a failure, for marking a data entry invalid when the associated status indicator field has a first value and for marking a data entry valid when the associated status indicator field has a second value.
Claim 14
Dependent Claim
164 words
A computer program product for efficiently recovering from a failure in a database in which some entries have been made with control information logging including a status indicator field, but without data recovery logging and other entries have been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the computer program product comprising a computer usable medium having computer readable program code thereon, including: program code for setting the status indicator field to a first value when the associated data entry was made without data recovery logging and to a second value when the associated data entry was made with data recovery logging; and program code operable during a recovery from a failure, for marking a data entry invalid when the associated status indicator field has a first value and for marking a data entry valid when the associated status indicator field has a second value.
Claim 15
Dependent Claim
27 words
The computer program product according to claim 11 further comprising program code for preventing the database management system from accessing data entries which are marked as invalid.
Claim 16
Dependent Claim
47 words
The computer program product according to claim 12 wherein the program code for preventing the databases management system from accessing invalid entries comprises program code for returning a resource unavailable code when the database management system attempts to access a data entry which is marked as invalid.
Claim 17
Dependent Claim
27 words
The computer program product according to claim 11 further comprising program code for allowing the database management system to access data entries which are marked as valid.
Claim 18
Dependent Claim
19 words
The computer program product according to claim 11 wherein data entries are made using conventional insert and delete commands.
Claim 19
Independent Claim
173 words
A method for efficiently recovering from a failure in a database in which large data objects have been inserted and updated with a first set of entries having been made with control information logging, but without data recovery logging and a second set of entries having been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the method comprising: (a) including a status indicator field in control information log entries associated with the first set of entries; (b) setting the status indicator field to a first value when a large data object is inserted into the database without data recovery logging and to a second value when another data entry is made with data recovery logging; and (c) during a recovery from a failure, marking a data entry invalid when the associated status indicator field has a first value and marking a data entry valid when the associated status indicator field has a second value.
Claim 20
Independent Claim
173 words
A method for efficiently recovering from a failure in a database in which large data objects have been inserted and updated with a first set of entries having been made with control information logging, but without data recovery logging and a second set of entries having been made with both control information and data recovery logging, the method being for use in a computer system having a database management system for accessing the database, the method comprising: (a) including a status indicator field in control information log entries associated with the first set of entries; (b) setting the status indicator field to a first value when a large data object is inserted into the database without data recovery logging and to a second value when another data entry is made with data recovery logging; and (c) during a recovery from a failure, marking a data entry invalid when the associated status indicator field has a first value and marking a data entry valid when the associated status indicator field has a second value.
Claim 21
Dependent Claim
24 words
The method according to claim 16 further comprising: (d) preventing the database management system from accessing large data objects which are marked as invalid.
Claim 22
Dependent Claim
33 words
The method according to claim 17 wherein step (d) comprises: (d1) returning a resource unavailable code when the database management system attempts to access a large data object which is marked as invalid.
Claim 23
Dependent Claim
23 words
The method according to claim 16 further comprising: (e) allowing the database management system to access data entries which are marked as valid.
Claim 24
Dependent Claim
18 words
The method according to claim 16 wherein all data entries are made using conventional insert and delete commands.
References Cited (Backward Citations)
US4868744A
Cited
US5280611A
Cited
US5625820A
Cited
US5794229A
Cited
US5999943A
Cited
US6243718B1
Cited
US6343286B1
Cited
US6343293B1
Cited
US6470359B1
Cited
US6502086B2
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2006-05-19 | 2006-11-18 | 2007-05-20 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2010-05-19 | 2010-11-18 | 2011-05-20 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2014-05-19 | 2014-11-18 | 2015-05-20 | $7700.00 | Window Closed / Lapsed |