Efficient optimization of SQL queries having set operators with a multi-set semantic
US11650991B2 · kind B2 · utility
0Cited by
1References
21Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Nov 30, 2020 |
| Grant date | May 16, 2023 |
| Priority date | — |
| Expiry date | Nov 30, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/248
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Disclosed is a system, method, and computer program product to efficiently process multi-set operations in a database system. An approach is described to perform a group-by operation with a counter to efficiently process such queries. Techniques are described to optimize multi-set operations into regular-set operations.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.