Patent ID: 9323796
Filing Date: 2016-04-26
CPC Classification: G06F

Claim Text:
1. A data partitioning method, comprising: receiving mixed loads and structure information of a database that are input by a user, wherein the mixed loads comprise at least one transaction load and/or at least one analytical load, and wherein the structure information of the database comprises at least one tuple associated with the mixed loads; determining tuple relationship information according to the mixed loads and the structure information of the database, wherein the tuple relationship information comprises a transaction correlation between any two tuples in the structure information of the database; determining tuple split cost information according to the tuple relationship information and a feature about whether the mixed loads are executable in parallel, wherein the tuple split cost information comprises a split cost between any two tuples having a transaction correlation in the structure information of the database, and wherein the split cost is used to indicate a degree of an impact on efficiency of the mixed loads in accessing the two tuples having the transaction correlation when the two tuples having the transaction correlation are stored in different partitions; obtaining multiple partitioning schemes according to the tuple split cost information; determining, from the partitioning schemes, that a partitioning scheme with a minimum total cost value is an optimum partitioning scheme, wherein a total cost value of each partitioning scheme is a sum of split costs between tuples having transaction correlations in the structure information of the database when the partitioning scheme is used; and performing, according to the optimum partitioning scheme, partitioning processing on data stored in the database.