Back to results
US 8,949,178 B2Granted
Method and system for efficient data synchronization
AssigneeAlibaba Group Holding Limited
InventorsLin Zhao, Hai Wang, Qing Zhang, Yina Zhang
Life of this patent
Estimating the term…
Abstract
Data synchronization includes establishing a plurality of target data tables based on a source data table in which data to be synchronized is stored, determining a current target data table from the plurality of target data tables, synchronizing the source data table and the current target data table, and directing an application server to access the current target data table upon successful completion of synchronization.
Claims15
A data synchronization method, comprising:
- establishing a plurality of target data tables based on a source data table in which data to be synchronized is stored;
- determining a current target data table from the established plurality of target data tables that is not referenced by an upper view, wherein determining the current target data table comprises counting respective numbers of data records in the plurality of target data tables, and selecting one of the target data tables with the number of data records being zero as the current target data table;
- synchronizing the source data table and the current target data table, comprising:
- determining several storage extents occupied by data to be synchronized in the source data table;
- determining storage address information of the data to be synchronized in the respective storage extents;
- and
- synchronizing the data to be synchronized in the respective storage extents into the current target data table using the storage address information, comprising:
- for at least one storage extent:
- determining whether the synchronizing of the data for the at least one storage extent is successful;
- and
- in the event that the synchronizing of the data for the at least one storage extent is not successful:
- determining whether the number of unsuccessful synchronizations exceed a threshold;
- and
- in the event that the number of unsuccessful synchronizations exceed the threshold, terminating the synchronizing of the data;
- configuring the upper view to reference or point to the current target data table;
- and
- directing an application server to access the current target data table via the upper view upon successful completion of synchronization.
14 more elements
A data synchronization system, comprising:
- one or more processors configured to:
- establish a plurality of target data tables based on a source data table in which data to be synchronized is stored;
- determine a current target data table from the established plurality of target data tables that is not referenced by an upper view, wherein determining the current target data table comprises counting respective numbers of data records in the plurality of target data tables, and selecting one of the target data tables with the number of data records being zero as the current target data table;
- synchronize the source data table and the current target data table, comprising:
- determine several storage extents occupied by data to be synchronized in the source data table;
- determine storage address information of the data to be synchronized in the respective storage extents;
- and
- synchronize the data to be synchronized in the respective storage extents into the current target data table using the storage address information, comprising:
- for at least one storage extent:
- determine whether the synchronizing of the data for the at least one storage extent is successful;
- and
- in the event that the synchronizing of the data for the at least one storage extent is not successful:
- determine whether the number of unsuccessful synchronizations exceed a threshold;
- and
- in the event that the number of unsuccessful synchronizations exceed the threshold, terminate the synchronizing of the data;
- configure the upper view to reference or point to the current target data table;
- and
- direct an application server to access the current target data table via the upper view upon successful completion of synchronization;
- and
- a memory coupled to the one or more processors, configured to provide the one or more processors with instructions.
17 more elements
Dependencies are inferred from the claim text.