Exploiting conditions to optimize expensive database queries
US8645406B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 11, 2008 |
| Grant date | Feb 4, 2014 |
| Priority date | — |
| Expiry date | Oct 12, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24534
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A fallback query mechanism that serves as a way to recover from query conditions (or criteria) that break due to excessively large result sets relative to a preset threshold. The fallback query mechanism detects when a query has failed to execute because the query requested more items from the database (or list) than allowed by the threshold, rewrites the query to examine no more than the threshold number of most recently created items that match one of the indexed filter criteria specified in a view, and then applies one or more of the other filter criteria. The mechanism then reruns the query and displays the results to the user.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.