Data table partitioning management method and apparatus
AssigneeHuawei Technologies Co., Ltd.
InventorsZhe LIU, Ke SHEN, Tieying WANG
Life of this patent
Estimating the term…
Loading patent…
AssigneeHuawei Technologies Co., Ltd.
InventorsZhe LIU, Ke SHEN, Tieying WANG
Estimating the term…
A data table partitioning management method and apparatus are disclosed. The method includes: determining a type and a join key of each data table in a table group, where the type of the data table includes a one-dimensional table, a multidimensional table, or a fact table; and performing one-dimensional partitioning on row replica space of each data table in the table group, and performing one-dimensional or multidimensional partitioning on column replica space of the data table according to the type of the data table and based on the join key of the data table. Different partitioning management methods are applied to data tables of different types and different dimensions, so that data processing mechanisms of OLTP and OLAP are efficiently implemented in a system, and resource consumption is reduced.
A data table partitioning management method, wherein a table group comprises a fact table and at least one one-dimensional table, the fact table is not a table having any dimension in the table group, each dimensional table in the table group is associated with the fact table, a field that associates each dimensional table with the fact table is used as a join key between the fact table and the dimensional table, and the method comprises:
A data table partitioning management apparatus, wherein a table group configured in the apparatus comprises one fact table and at least one one-dimensional table, the fact table is not a table having any dimension in the table group, each dimensional table is a dimensional table associated with the fact table, a field that associates each dimensional table with the fact table is used as a join key between the fact table and the dimensional table, and the apparatus comprises a network interface, a memory, and a processor, wherein the memory has a set of program code stored thereon, that when processed by the processor, cause the processor to:
Dependencies are inferred from the claim text.