DBMS backup without suspending updates and corresponding...

Details DBMS backup without suspending updates and corresponding... DBMS backup without suspending updates and corresponding...

2003-06-19

2008-08-12

Breene, John (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000, C714S047300

Reexamination Certificate

active

07412460

ABSTRACT:
A method for performing a system level backup of a log-ahead database management system (DBMS) without suspending updates by application programs is described. The DBMS comprises a database mainline system, a backup utility and a restore utility. The data and log records are stored on separate storage volumes. Log records are written to identify objects that require special handling during the point-in-time recovery. The database engine operates normally during a backup except for suspending actions that would alter the file system catalog or write updates across a storage volume boundary; and by freezing the REDO log point in its checkpoint information. The backup utility copies the data volumes first and optionally the log volumes second while updates are allowed. The resulting inconsistencies are resolved either during a DBMS restart or during a point-in-time (PIT) recovery performed by the restore utility.

REFERENCES:
patent: 5448718 (1995-09-01), Cohn et al.
patent: 5778388 (1998-07-01), Kawamura et al.
patent: 6078932 (2000-06-01), Haye et al.
patent: 6212531 (2001-04-01), Blea et al.
patent: 6785696 (2004-08-01), Mosher et al.

Affiliated with

Also associated with

Rating

DBMS backup without suspending updates and corresponding... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with DBMS backup without suspending updates and corresponding..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and DBMS backup without suspending updates and corresponding... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4006089