DATA TABLE PARTITIONING MANAGEMENT METHOD AND APPARATUS

    公开(公告)号:US20180121532A1

    公开(公告)日:2018-05-03

    申请号:US15853952

    申请日:2017-12-25

    CPC classification number: G06F16/278 G06F16/221 G06F16/2282 G06F16/25

    Abstract: 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.

Patent Agency Ranking