SQL double counting resolver
US11416488B2 · kind B2 · utility
0Cited by
9References
20Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Feb 28, 2020 |
| Grant date | Aug 16, 2022 |
| Priority date | — |
| Expiry date | Mar 18, 2040 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24535
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
This disclosure proposes systems, methods, and apparatus that identify raw SQL queries that are likely to cause a double counting error, and if such a SQL query is identified, then convert the raw SQL query into SQL queries that account for and avoid double counting. In some embodiments, this process uses queries and subqueries that refer back to a common table expression (CTE) in order to reduce code length and increase query execution speed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.