Method and system for managing multiple database storage units
First Claim
1. A method of managing a plurality of databases in response to continuous transactions, the databases including at least a first database, a second database and a third database, comprising:
- simultaneously maintaining first data in the first database and a duplicate set of second data in the second database in response to database transactions;
determining a point in time for a predetermined database management task;
discontinuing the database transactions to and from the second database;
continuing the database transactions to and from the first database;
rolling back the second data in the second database to the point in time;
connecting the second database to the third database;
extracting a portion of the rolled back second data;
updating the third data in the third database based upon the extracted from the second database;
rolling forward the second data in the second database to match the first data in the first database; and
resuming the database transactions to and from the second database.
1 Assignment
0 Petitions
Accused Products
Abstract
The system manages at least a database in multiple database storage units, and the database is duplicated for redundancy. The system maintains the database redundancy for security. The system enables the maintenance and reorganization of the database storage units without interrupting the on-going operations involving the access to the database storage units. The non-stop ongoing database access is available by allocating a pair of a main storage unit and an intermediate storage unit that maintains the substantially identical data. During certain predetermined operations, the main storage unit is being dedicating to the on-going transactions while the intermediate database storage unit is manipulated to contain data that corresponds to a specified time. For example, the content of the intermediate storage is subsequently copied or used to update another database. When the above duplication or incorporation is completed, the intermediate storage unit is updated for the transactions that have taken place during the above operations to be synchronized with the main storage unit.
-
Citations
17 Claims
-
1. A method of managing a plurality of databases in response to continuous transactions, the databases including at least a first database, a second database and a third database, comprising:
-
simultaneously maintaining first data in the first database and a duplicate set of second data in the second database in response to database transactions;
determining a point in time for a predetermined database management task;
discontinuing the database transactions to and from the second database;
continuing the database transactions to and from the first database;
rolling back the second data in the second database to the point in time;
connecting the second database to the third database;
extracting a portion of the rolled back second data;
updating the third data in the third database based upon the extracted from the second database;
rolling forward the second data in the second database to match the first data in the first database; and
resuming the database transactions to and from the second database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system for managing a plurality of databases in response to continuous transactions, the databases including at least a first database, a second database and a third database, comprising:
-
a first database storage unit for storing first data in first database;
a second database storage unit for storing a duplicate set of second data in second database;
a third database storage unit for storing a duplicate set of third data in third database; and
a database management unit connected to said first database storage unit, said second database storage unit and said third database storage unit for continuing database transactions to and from the first database as well as simultaneously maintaining the first data in the first database and the duplicate set of the second data in the second database, said database management unit determining a point in time for a predetermined database management task and discontinuing the database transactions to and from the second database so as to roll back the second data in the second database to said point in time, said database management unit connecting the second database to the third database and updating the third data in the third database based upon the rolled back second data in the second database, said database management unit further comprising a database extraction unit connected to said second database storage unit for extracting a portion of the second data from the second database and a database incorporating unit connected to said database extraction unit and said third database storage unit for incorporating the portion of the second data to the third data in the third database, said database management unit rolling forward the second data in the second database to match the first data in the first database so as to resume the database transactions to and from the second database in said second database storage unit. - View Dependent Claims (12, 13, 14, 15, 16, 17)
-
Specification