JP2001344139A5

JP2001344139A5 -

Info

Publication number: JP2001344139A5
Application number: JP2000166758A
Authority: JP
Filing date: 2000-06-02
Publication date: 2005-01-20
Anticipated expiration: 2020-06-02

Description

【発明の名称】データベース管理装置及び方法 Patent application title: Database management apparatus and method

Claims

A management table holding management information on each data registered in the database;
Means for updating the management table according to the operation performed on the database;
Snapshot means for storing a copy of the contents of the management table at that time as snapshot information at each predetermined backup timing,
At each backup timing, the contents of the management table at that time are compared with the snapshot information created at the previous backup timing to determine the change content of the database from the previous time to the current time, and Backup means for creating and storing backup information representing the contents of change;
Database management device comprising:

The database according to claim 1, further comprising a restoration means for restoring the contents of the database before the failure by applying the backup information to the database contents at the reference time in the order of creation when the failure of the database is recovered. Management device.

2. The database according to claim 1, wherein said snapshot means overwrites the contents of said management table at that point in time with the snapshot information of the previous backup timing after the creation of backup information by said backup means is completed. Management device.

A management table holding management information on each data registered in the database;
Means for storing the contents of the management table of the database at a predetermined reference time;
Means for updating the management table according to the operation performed on the database;
At a predetermined backup timing, the contents of the management table are compared with the contents of the management table at the reference time point, the change contents of the database from the reference time point to the current time are determined, and a backup showing the change contents Backup means for creating and storing information;
Database management device comprising:

Means for monitoring the frequency of operations performed on said database;
Timing setting means for automatically setting the backup timing in the backup means according to the frequency of the operation;
The database management apparatus according to any one of claims 1 to 4, comprising:

6. The database management apparatus according to claim 5, wherein the timing setting unit reduces the interval of the backup timing as the frequency of the operation increases.

6. The database management apparatus according to claim 5, wherein said timing setting means statistically determines a time zone in which the frequency of the operation is low, and sets a backup timing in this time zone.

  A first step of updating the management table holding management information on each data registered in the database according to the operation performed on the database;
  A second step of storing, as snapshot information, a copy of the content of the management table at that point in time, at a predetermined backup timing, the snapshot means;
  The contents of change of the database from the previous time to the current time by comparing the contents of the management table at that point in time with the snapshot information created at the previous backup timing at each backup timing by the backup means. A third step of obtaining and storing backup information representing the contents of the change, and
  Database management method including:

  A first step of updating the management table holding management information on each data registered in the database according to the operation performed on the database;
  At a predetermined backup timing, backup means compares the contents of the management table at the backup timing with the contents of the management table at a predetermined reference time, and changes the database from the reference time to the present time A second step of obtaining contents and creating and storing backup information representing the contents of change;
  Database management method including: