Workflow driven database partitioning
US11449509B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Feb 21, 2020 |
| Grant date | Sep 20, 2022 |
| Priority date | — |
| Expiry date | Oct 8, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/2423
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database is configured to analyze user queries to dynamically partition the database according to a partition scheme. User queries can be rewritten based on the partition scheme so that, in response to queries, partitions including relevant data are read while partitions including irrelevant data can be skipped, reducing latency. Files can be named according to the partition scheme and stored on respective partitions so that low partition management can be implemented by underlying systems. Blocks within files can be sorted and statistics can be determined. The statistics can be used to find and read relevant blocks and skip irrelevant blocks.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.