SYNCHRONIZING A DISASTER-RECOVERY SYSTEM OF A DATABASE

摘要

A method and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

主权项

1. A method for synchronizing a disaster-recovery system of a database, the method comprising:
a processor of a computer system monitoring a set of transactions associated with the database, wherein the database comprises a set of data blocks, and wherein each transaction of the set of transactions identifies an alteration to one or more data blocks of the set of data blocks; the processor choosing a subset of transactions of the set of transactions, wherein each transaction of the subset of transactions identifies an alteration to a first data block of the set of data blocks; the processor creating a set of block images, wherein a first image of the set of block images corresponds to the first data block; the processor generating a set of change vectors, wherein each vector of the set of change vectors corresponds to one transaction of the subset of transactions; the processor updating the first block image as a function of changes made to the first block image by the subset of transactions; the processor determining whether transmitting the updated first block image to the disaster-recovery system is more efficient than transmitting the set of change vectors to the disaster-recovery system; the processor transmitting either the first block image or the set of change vectors to the disaster-recovery entity as a function of the determining.