公开(公告)号：US09239741B2

公开(公告)日：2016-01-19

申请号：US13653308

申请日：2012-10-16

Applicant: FutureWei Technologies, Inc.

Inventor： Yuan Dai ,  Siew Sim-Tang ,  Kamini Jagtiani ,  Yang Sun ,  Gangavara Prasad Varakur ,  Bai Yang

IPC: G06F9/50 ,  G06F17/30

CPC classification number: G06F9/5061 ,  G06F17/30312 ,  G06F17/30445 ,  G06F17/30557 ,  G06F2209/505

Abstract: An embodiment method for massively parallel processing includes initiating a management instance on an initial machine, the management instance generating an initial partition corresponding to the initial machine, determining a total number of partitions desired for processing a database, the total number of partitions including the initial partition, determining a number of additional machines available to process the database, grouping the initial machine and the additional machines together in a pod, and launching the management instance on the additional machines in the pod to generate the total number of partitions desired for the database. Additional embodiment methods and an embodiment system operable to perform such methods are also disclosed.

Abstract translation: 用于大规模并行处理的实施例方法包括在初始机器上启动管理实例，所述管理实例生成对应于初始机器的初始分区，确定处理数据库所需的分区的总数，包括初始 分区，确定可用于处理数据库的多个附加机器，将起始机器和附加机器分组到一个pod中，并在该pod中的其他机器上启动管理实例以生成数据库所需的分区总数 。 还公开了另外的实施例方法和可操作以执行这些方法的实施例系统。

公开(公告)号：US09195701B2

公开(公告)日：2015-11-24

申请号：US13663237

申请日：2012-10-29

Applicant: FutureWei Technologies, Inc.

Inventor： Kamini Jagtiani ,  Yang Sun ,  Siew Sim-Tang ,  Gangavara Prasad Varakur

IPC: G06F17/30

CPC classification number: G06F17/30339

Abstract: An embodiment method for massively parallel processing includes assigning a primary key to a first table in a database and a foreign key to a second table in the database, the foreign key of the second table identical to the primary key of the first table, determining a number of partition groups desired for the database, partitioning the first table into first partitions based on the primary key assigned and the number of partition groups desired, partitioning the second table into second partitions based on the foreign key assigned and the number of partition groups desired, and distributing the first partitions and the second partitions to the partition groups as partitioned. An embodiment system for implementing the embodiment methods is also disclosed.

Abstract translation: 用于大规模并行处理的实施例方法包括：将主密钥分配给数据库中的第一表，将外键分配给数据库中的第二表，第二表的外键与第一表的主键相匹配， 数据库所需的分区组数量，基于分配的主键和所分配的分组数将第一分区划分成第一分区，基于所分配的外键划分第二分区到第二分区，以及期望的分组数量 并且将第一分区和第二分区分配给分区的分区组。 还公开了用于实现实施方式的实施例系统。

公开(公告)号：US20140122484A1

公开(公告)日：2014-05-01

申请号：US13663237

申请日：2012-10-29

Applicant: FUTUREWEI TECHNOLOGIES, INC.

Inventor： Kamini Jagtiani ,  Yang Sun ,  Siew Sim-Tang ,  Gangavara Prasad Varakur

IPC: G06F17/30

CPC classification number: G06F17/30339

Abstract: An embodiment method for massively parallel processing includes assigning a primary key to a first table in a database and a foreign key to a second table in the database, the foreign key of the second table identical to the primary key of the first table, determining a number of partition groups desired for the database, partitioning the first table into first partitions based on the primary key assigned and the number of partition groups desired, partitioning the second table into second partitions based on the foreign key assigned and the number of partition groups desired, and distributing the first partitions and the second partitions to the partition groups as partitioned. An embodiment system for implementing the embodiment methods is also disclosed.

Abstract translation: 用于大规模并行处理的实施例方法包括：将主密钥分配给数据库中的第一表，将外键分配给数据库中的第二表，第二表的外键与第一表的主键相匹配， 数据库所需的分区组数量，基于分配的主键和所分配的分组数将第一分区划分成第一分区，基于所分配的外键划分第二分区到第二分区，以及期望的分组数量 并且将第一分区和第二分区分配给分区的分区组。 还公开了用于实现实施方式的实施例系统。

公开(公告)号：US08799284B2

公开(公告)日：2014-08-05

申请号：US13691402

申请日：2012-11-30

Applicant: FutureWei Technologies, Inc.

Inventor： Kamini Jagtiani ,  Siew Sim-Tang ,  Yang Sun ,  Gangavara Prasad Varakur

IPC: G06F17/30

CPC classification number: G06F17/30707 ,  G06F17/30445 ,  G06F17/30584

Abstract: A massively parallel processing (MPP) database can be re-partitioned/re-balanced while remaining on-line through a staged migration procedure. Staged migration may include a first stage and a second stage. During the first stage, entries in an existing partition are reallocated to the new partition, and the catalog is updated to associate the re-allocated entries with both the existing partition and the new partition such that queries for the re-allocated entries are directed toward the existing partition and the new partition. During the second stage, the re-allocated entries are migrated from the existing partition to the new partition, and after the migration is complete, the catalog is re-updated to associate the migrated entries with the new partition such that new queries are directed toward the new partition.

Abstract translation: 大规模并行处理（MPP）数据库可以重新分区/重新平衡，同时通过分阶段迁移过程保持在线状态。 分期迁移可以包括第一阶段和第二阶段。 在第一阶段，将现有分区中的条目重新分配到新分区，并更新目录以将重新分配的条目与现有分区和新分区相关联，以使重新分配的条目的查询指向 现有分区和新分区。 在第二阶段，重新分配的条目将从现有分区迁移到新分区，迁移完成后，重新更新目录以将迁移的条目与新分区相关联，以使新查询指向 新的分区。

公开(公告)号：US20140156666A1

公开(公告)日：2014-06-05

申请号：US13691402

申请日：2012-11-30

Applicant: FUTUREWEI TECHNOLOGIES, INC.

Inventor： Kamini Jagtiani ,  Siew Sim-Tang ,  Yang Sun ,  Gangavara Prasad Varakur

IPC: G06F17/30

CPC classification number: G06F17/30707 ,  G06F17/30445 ,  G06F17/30584

Abstract: A massively parallel processing (MPP) database can be re-partitioned/re-balanced while remaining on-line through a staged migration procedure. Staged migration may include a first stage and a second stage. During the first stage, entries in an existing partition are reallocated to the new partition, and the catalog is updated to associate the re-allocated entries with both the existing partition and the new partition such that queries for the re-allocated entries are directed toward the existing partition and the new partition. During the second stage, the re-allocated entries are migrated from the existing partition to the new partition, and after the migration is complete, the catalog is re-updated to associate the migrated entries with the new partition such that new queries are directed toward the new partition.

Abstract translation: 大规模并行处理（MPP）数据库可以重新分区/重新平衡，同时通过分阶段迁移过程保持在线状态。 分期迁移可以包括第一阶段和第二阶段。 在第一阶段，将现有分区中的条目重新分配到新分区，并更新目录以将重新分配的条目与现有分区和新分区相关联，以使重新分配的条目的查询指向 现有分区和新分区。 在第二阶段，重新分配的条目将从现有分区迁移到新分区，迁移完成后，重新更新目录以将迁移的条目与新分区相关联，以使新查询指向 新的分区。