Data table partitioning management method and apparatus
US11226986B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 25, 2017 |
| Grant date | Jan 18, 2022 |
| Priority date | — |
| Expiry date | Jan 18, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/25
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.