US6453325B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and means for backup and restoration of a database system linked to a system for filing data
Assignee: International Business Machines Corp
•
Filing: 1997-02-03
•
Granted: 2002-09-17
•
Expires: 2017-02-03
Abstract
Abstract In a database system with linkage between data in the database system and files in a system for filing data which is external to the database system (“the filing system”), backup and restoration of the database are coordinated with the filing system. Backup of a referenced file is initiated when the file is linked to the database system. The file backup is asynchronous to the linking process. When database backup occurs, all unfinished file backups are accelerated and completed before the database backup is declared successful. When a database is restored to a state with reference to files in a file manager, the database system causes the file manager to ensure that referenced files are linked to the database system.
Inventors
- 👤 Luis Felipe Cabrera
- 👤 Chandrasekaran Mohan
- 👤 Inderpal Singh Narang
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 03:31
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1446; G06F11/1458; G06F11/1461; G06F2201/00; G06F2201/80; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953; Y10S707/99955
Claims Analysis
Total Claims: 13
Claim 1
Independent Claim
163 words
A method of restoring a database system having references to files stored in at least one file system external to the database system, comprising the steps of: placing in the database a reference to a file in the file system; making a record in the file system of the reference, the record initially indicating the existence of the reference, the records being changed to indicate deletion of the reference if the reference is deleted from the database system; initiating a restoration of database contents that existed at a time of database system operation (restore time); and (a) if the reference is placed in the database system prior to the restore time and the record indicates that the reference was deleted, changing the reference to indicate that the reference exists; or (b) if the reference was placed in the database system subsequent to the restore time and the record indicates that the reference exists, changing the record to indicate that the reference is deleted.
Claim 2
Independent Claim
163 words
A method of restoring a database system having references to files stored in at least one file system external to the database system, comprising the steps of: placing in the database a reference to a file in the file system; making a record in the file system of the reference, the record initially indicating the existence of the reference, the records being changed to indicate deletion of the reference if the reference is deleted from the database system; initiating a restoration of database contents that existed at a time of database system operation (restore time); and (a) if the reference is placed in the database system prior to the restore time and the record indicates that the reference was deleted, changing the reference to indicate that the reference exists; or (b) if the reference was placed in the database system subsequent to the restore time and the record indicates that the reference exists, changing the record to indicate that the reference is deleted.
Claim 3
Dependent Claim
45 words
The method of claim 1 , the record including a recovery time having a value corresponding to a time when the reference was placed in the database system, step 10 ( a ) being performed if the recovery time is earlier than the restoration time.
Claim 4
Dependent Claim
26 words
The method of claim 2 , step 10 ( b ) being performed if the recovery time is later than, or equal to, the restored time.
Claim 5
Dependent Claim
52 words
The method of claim 1 , wherein the step of initiating includes providing to the file system a list of references to files in the file system that exist in the restored database contents and step 10 ( a ) is performed if a reference to the file is in the list.
Claim 6
Dependent Claim
24 words
The method of claim 4 , wherein step 10 ( b ) is performed if no reference to the file is in the list.
Claim 7
Dependent Claim
59 words
The method of claim 1 , further including the steps of: determining that either step 10 ( a ) or 10 ( b ) cannot be performed; providing to the database system an indication that either step 10 ( a ) or step 10 ( b ) cannot be performed; and removing the references from the restored database contents.
Claim 8
Independent Claim
186 words
A method performed in a file system to reconcile file data indicating references made in the contents of a database system to files in the file system, the method comprising the steps of: making a record in the file system of a reference made in the contents of a database system to a file in the file system, the record initially indicating the existence of the reference in the database system, the record being changed to indicate deletion of the reference if the reference is deleted from the database system; receiving an indication from the database system of the restoration of a database system with database contents that existed at a time of database system operation (restore time); and (a) if the reference was placed in the database system prior to the restore time and the record indicates that the reference was deleted, changing the reference to indicate that the reference exists; or (b) if the reference was placed in the database system subsequent to the restore time and the record indicates that the reference exists, changing the reference to indicate that the reference is deleted.
Claim 9
Independent Claim
186 words
A method performed in a file system to reconcile file data indicating references made in the contents of a database system to files in the file system, the method comprising the steps of: making a record in the file system of a reference made in the contents of a database system to a file in the file system, the record initially indicating the existence of the reference in the database system, the record being changed to indicate deletion of the reference if the reference is deleted from the database system; receiving an indication from the database system of the restoration of a database system with database contents that existed at a time of database system operation (restore time); and (a) if the reference was placed in the database system prior to the restore time and the record indicates that the reference was deleted, changing the reference to indicate that the reference exists; or (b) if the reference was placed in the database system subsequent to the restore time and the record indicates that the reference exists, changing the reference to indicate that the reference is deleted.
Claim 10
Dependent Claim
45 words
The method of claim 7 , the record including a recovery time having a value corresponding to a time when the reference was placed in the database system, step 16 ( a ) being performed if the recovery time is earlier than the restore time.
Claim 11
Dependent Claim
26 words
The method of claim 8 , step 16 ( b ) being performed if the recovery time is later than, or equal to, the restore time.
Claim 12
Dependent Claim
53 words
The method claim 7 , wherein the step of receiving an indication includes receiving from the database system a list of references to files in the file system that exist in the restored database contents, and step 16 ( a ) is performed if a reference to the file is in the list.
Claim 13
Dependent Claim
24 words
The method of claim 10 , wherein step 16 ( b ) is performed if no reference to the file is in the list.
References Cited (Backward Citations)
US4354269A
Cited
US4587628A
Cited
US4686620A
Cited
GB2184267A
Cited
US5060185A
Cited
JPH0289256A
Cited
US5095420A
Cited
US5321832A
Cited
US5237661A
Cited
US5163148A
Cited
US5241648A
Cited
US5341498A
Cited
US5301286A
Cited
US5394539A
Cited
US5355477A
Cited
US5446884A
Cited
US5317739A
Cited
US5390328A
Cited
US5331673A
Cited
US5448718A
Cited
US5386545A
Cited
EP0593341A1
Cited
US5530855A
Cited
US5504883A
Cited
US5469503A
Cited
US5515502A
Cited
US5673382A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-09-16 | 2006-03-18 | 2006-09-17 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-09-16 | 2010-03-18 | 2010-09-17 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-09-16 | 2014-03-18 | 2014-09-17 | $7700.00 | Window Closed / Lapsed |