Synchronizing a disaster-recovery system of a database
View Patent ↗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,
wherein a first change vector of the set of change vectors corresponds to a first transaction of the subset of transactions,
and wherein the first change vector comprises a block identifier that identifies the first data block and a change identifier that identifies the first transaction;
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.
2. The method of claim 1 , wherein the choosing a subset comprises discarding an undo/redo transaction.
3. The method of claim 1 , wherein the choosing a subset comprises discarding a transaction that was not completed.
4. The method of claim 1 , wherein the choosing a subset comprises discarding a plurality of transactions that do not together effect a net change to data comprised by the first data block.
5. The method of claim 1 , wherein the transmitting is performed only if the updating results in a net change to data comprised by the first data block.
6. The method of claim 1 , wherein the determining is a function of comparing a first quantity of data comprised by the updated first block image to a second quantity of data comprised by the set of change vectors.
7. The method of claim 1 , wherein the determining is a function of comparing a first quantity of data, which must be communicated in order to transmit the updated first block image to the disaster-recovery system, to a second quantity of data, which must be communicated in order to transmit the set of change vectors to the disaster-recovery system.
8. The method of claim 1 , further comprising providing at least one support service for at least one of creating, integrating, hosting, maintaining, and deploying computer-readable program code in the computer system, wherein the computer-readable program code in combination with the computer system is configured to implement the monitoring, choosing, creating, generating, updating, determining, and transmitting.
9. A computer program product, comprising a computer-readable hardware storage device having a computer-readable program code stored therein, said program code configured to be executed by a processor of a computer system to implement a method for synchronizing a disaster-recovery system of a database, the method comprising:
the processor 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 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,
wherein a first change vector of the set of change vectors corresponds to a first transaction of the subset of transactions,
and wherein the first change vector comprises a block identifier that identifies the first data block and a change identifier that identifies the first transaction;
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.
10. The computer program product of claim 9 , wherein the choosing a subset comprises discarding an undo/redo transaction.
11. The computer program product of claim 9 , wherein the choosing a subset comprises discarding a transaction that was not completed.
12. The computer program product of claim 9 , wherein the determining is a function of comparing a first quantity of data comprised by the updated first block image to a second quantity of data comprised by the set of change vectors.
13. The computer program product of claim 9 , wherein the determining is a function of comparing a first quantity of data, which must be communicated in order to transmit the updated first block image to the disaster-recovery system, to a second quantity of data, which must be communicated in order to transmit the set of change vectors to the disaster-recovery system.
14. A computer system comprising a processor, a memory coupled to said processor, and a computer-readable hardware storage device coupled to said processor, said storage device containing program code configured to be run by said processor via the memory to implement a method for synchronizing a disaster-recovery system of a database, the method comprising:
the processor 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,
wherein a first change vector of the set of change vectors corresponds to a first transaction of the subset of transactions,
and wherein the first change vector comprises a block identifier that identifies the first data block and a change identifier that identifies the first transaction;
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.
15. The computer system of claim 14 , wherein the choosing a subset comprises discarding an undo/redo transaction, discarding a transaction that was not completed, or discarding a plurality of transactions that do not together effect a net change to data comprised by the first data block.
16. The computer system of claim 14 , wherein the determining is a function of comparing a first quantity of data comprised by the updated first block image to a second quantity of data comprised by the set of change vectors.
17. The computer system of claim 14 , wherein the determining is a function of comparing a first quantity of data, which must be communicated in order to transmit the updated first block image to the disaster-recovery system, to a second quantity of data, which must be communicated in order to transmit the set of change vectors to the disaster-recovery system.