Autonomously partitioning database tables
US11531704B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 11, 2020 |
| Grant date | Dec 20, 2022 |
| Priority date | — |
| Expiry date | Sep 11, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/90335
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
What is disclosed is an improved approach to perform automatic partitioning, without requiring any expertise on the part of the user. A three stage processing pipeline is provided to generate candidate partition schemes, to evaluate the candidate using real table structures that are empty, and to then implement a selected scheme with production data for evaluation. In addition, an improved approach is described to perform automatic interval partitioning, where the inventive concept implements interval partitioning that does not impose these implicit constraints on the partition key column.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.