Problem solving in a database
US12086135B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 17, 2021 |
| Grant date | Sep 10, 2024 |
| Priority date | — |
| Expiry date | Sep 17, 2041 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/21
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method includes receiving, by a computing device, a Structured Query Language (SQL) query from a user; generating, by the computing device, execution structures from the SQL query; generating, by the computing device, test results by running the SQL query with the execution structures; building, by the computing device, logs which record information of the running of the SQL query; generating, by the computing device, a candidate execution structure using the information from the logs; normalizing, by the computing device, the SQL query using the candidate execution structure; running, by the computing device, the normalized SQL query in a database; and comparing, by the computing device, results of the normalized SQL query to the test results.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.