SQL double counting resolver
US10621170B2 · kind B2 · utility
1Cited by
0References
21Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Nov 9, 2017 |
| Grant date | Apr 14, 2020 |
| Priority date | — |
| Expiry date | Mar 31, 2038 |
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.