SQL double counting resolver
US9846725B2 · kind B2 · utility
1Cited by
7References
21Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Mar 24, 2017 |
| Grant date | Dec 19, 2017 |
| Priority date | — |
| Expiry date | Mar 24, 2037 |
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.