METHOD AND SYSTEM FOR UPDATING DATABASE

摘要

PURPOSE: To improve parallelism, to efficiently use a change content and to guarantee the consistency of a replica data base and an original data base by using peculiar ordering for recovery records on a transaction log. CONSTITUTION: The change processing of the replica data base is realized by dividing the REDO (re-issued) records from the transaction log of the primary data base into queues. The REDO records are divided so that all the transaction records in the transfer unit (page) of the primary data base are registered in the same queues 68 and 69 in a log sequence. The queue servers 68 and 69 apply the REDO records in the queues which the servers exclusively handle to the replica data base. Thus, the replica data base becomes consistent with primary data with a lock free update mechanism for processing the pages in parallel.