Synopsis based advanced partition elimination
US11468093B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 27, 2017 |
| Grant date | Oct 11, 2022 |
| Priority date | — |
| Expiry date | Feb 25, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24565
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.