Pruning index for optimization of pattern matching queries
US10997179B1 · kind B1 · utility
25Cited by
8References
30Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Oct 30, 2020 |
| Grant date | May 4, 2021 |
| Priority date | — |
| Expiry date | Oct 30, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F17/18
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query directed at a source table organized into a set of batch units is received. The query includes a pattern matching predicate that specifies a search pattern. A set of N-grams are generated based on the search pattern. A pruning index associated with the source table is accessed. The pruning index comprises a set of filters that index distinct N-grams in each column of the source table. The pruning index is used to identify a subset of batch units to scan for matching data based on the set of N-grams generated for the search pattern. The query is processed by scanning the subset of batch units.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.