Optimizing relational database queries with multi-table predicate expressions
US9411806B2 · kind B2 · utility
2Cited by
3References
2Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 6, 2014 |
| Grant date | Aug 9, 2016 |
| Priority date | — |
| Expiry date | Dec 20, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/951
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Responding to relational database queries (for example, SQL queries) in a new way. More specifically, qualifying queries are written (for example, written by a human individual) in a way so that a join operation precedes a row limiting operation. Notwithstanding the fact that the join operation precedes the row limiting operation, when responding to the query, machine logic (for example, software) performs the row limiting operation before the join operation. This can improve time and processing efficiency.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.