Patent ID: 9213728
Filing Date: 2015-12-15
Classification: G06F

Abstract:
1. A system comprising: at least one processor; a non-transitory computer-readable medium storing executable instructions that when executed by the at least one processor implement: a logging table generator configured to generate a logging table corresponding with an original table targeted for an upgrade, the logging table including a first partition for logging changes to the original table during a first time period and a second partition for logging changes to the original table during a second time period; a control table generator configured to generate a control table configured to store a batch identifier, the batch identifier having a first value for changes logged in the first partition of the logging table during the first time period, the batch identifier having a second value for changes logged in the second partition of the logging table during the second time period, the control table being separate from the logging table, wherein only the batch identifier is stored in the control table; a batch identifier generator configured to set the first value as the batch identifier in the control table; a key recorder configured to store, in the first partition of the logging table, primary keys of records for the changes during the first time period, wherein only the primary keys are stored in the first partition of the logging table, the batch identifier generator configured to replace the first value with the second value for the batch identifier in the control table, the key recorder configured to store, in the second partition of the logging table, primary keys of records for the changes during the second time period, wherein only the primary keys are stored in the second partition of the logging table; and a change transfer module configured to transfer, from the first partition of the logging table to a target system, the changes associated with the first value during the second time period during which the primary keys of records associated with the second value are stored in the second partition.