公开(公告)号：US09323796B2

公开(公告)日：2016-04-26

申请号：US14297968

申请日：2014-06-06

Applicant: Huawei Technologies Co., Ltd.

Inventor： Yu Wen ,  Haoyang Che ,  Yong Zhang

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30312 ,  G06F17/30286 ,  G06F17/30539 ,  G06F17/30592 ,  G06F17/30595

Abstract: A data partitioning method and apparatus. The method includes: determining tuple relationship information according to received mixed loads and structure information of a database; determining tuple split cost information according to the tuple relationship information and a feature about whether the mixed loads are executable in parallel; obtaining multiple partitioning schemes according to the tuple split cost information, and determining, from the partitioning schemes, a partitioning scheme with a minimum total cost value as an optimum partitioning scheme to perform partitioning processing on data stored in the database. In the data partitioning method and apparatus, optimum partitioning is performed on data associated with the mixed loads in a database, after partitioning, data has features of a transaction load and an analytical load in the mixed loads, thereby improving working performance of the database system oriented to the mixed loads.

Abstract translation: 数据分割方法和装置。 该方法包括：根据接收到的混合负载和数据库的结构信息确定元组关系信息; 根据元组关系信息确定元组分割成本信息，以及关于混合负载是否可并行执行的特征; 根据元组分割成本信息获得多个分割方案，以及从划分方案中确定具有最小总成本值的划分方案作为对存储在数据库中的数据执行分区处理的最佳分区方案。 在数据分割方法和装置中，对与数据库中的混合负载相关联的数据执行最佳分区，分区后，数据具有事务负载的特征和混合负载中的分析负载，从而提高数据库系统的工作性能 面向混合负载。

公开(公告)号：US20140365492A1

公开(公告)日：2014-12-11

申请号：US14297968

申请日：2014-06-06

Applicant: Huawei Technologies Co., Ltd.

Inventor： Yu Wen ,  Haoyang Che ,  Yong Zhang

IPC: G06F17/30

CPC classification number: G06F17/30312 ,  G06F17/30286 ,  G06F17/30539 ,  G06F17/30592 ,  G06F17/30595

Abstract: A data partitioning method and apparatus. The method includes: determining tuple relationship information according to received mixed loads and structure information of a database; determining tuple split cost information according to the tuple relationship information and a feature about whether the mixed loads are executable in parallel; obtaining multiple partitioning schemes according to the tuple split cost information, and determining, from the partitioning schemes, a partitioning scheme with a minimum total cost value as an optimum partitioning scheme to perform partitioning processing on data stored in the database. In the data partitioning method and apparatus, optimum partitioning is performed on data associated with the mixed loads in a database, after partitioning, data has features of a transaction load and an analytical load in the mixed loads, thereby improving working performance of the database system oriented to the mixed loads.

Abstract translation: 数据分割方法和装置。 该方法包括：根据接收到的混合负载和数据库的结构信息确定元组关系信息; 根据元组关系信息确定元组分割成本信息，以及关于混合负载是否可并行执行的特征; 根据元组分割成本信息获得多个分割方案，以及从划分方案中确定具有最小总成本值的划分方案作为对存储在数据库中的数据执行分区处理的最佳分区方案。 在数据分割方法和装置中，对与数据库中的混合负载相关联的数据执行最佳分区，分区后，数据具有事务负载的特征和混合负载中的分析负载，从而提高数据库系统的工作性能 面向混合负载。