Exploiting conditions to optimize expensive database queries
First Claim
Patent Images
1. A computer-implemented query system, comprising:
- a processor for executing computer-executable components; and
memory storing computer-executable components including;
a detection component for detecting a failure condition when a number of items to be returned from a data source in response to an original query exceeds a maximum number of items that can be returned from the data source and for terminating query execution processing of the original query against the data source; and
a query component for automatically returning, in response to the detected failure condition, a partial result set having a number of items that does not exceed the maximum number of items by;
automatically selecting a particular query term from a plurality of query terms specified in the original query,automatically generating a reduced result set limited to a threshold number of most recently created items of the data source that match the particular query term selected from the original query, wherein the threshold number does not exceed the maximum number of items,automatically generating the partial result set from the reduced result set by applying one or more remaining query terms specified in the original query to filter the reduced result set, andautomatically returning the partial result set for viewing.
2 Assignments
0 Petitions
Accused Products
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.
16 Citations
20 Claims
-
1. A computer-implemented query system, comprising:
a processor for executing computer-executable components; and
memory storing computer-executable components including;a detection component for detecting a failure condition when a number of items to be returned from a data source in response to an original query exceeds a maximum number of items that can be returned from the data source and for terminating query execution processing of the original query against the data source; and a query component for automatically returning, in response to the detected failure condition, a partial result set having a number of items that does not exceed the maximum number of items by; automatically selecting a particular query term from a plurality of query terms specified in the original query, automatically generating a reduced result set limited to a threshold number of most recently created items of the data source that match the particular query term selected from the original query, wherein the threshold number does not exceed the maximum number of items, automatically generating the partial result set from the reduced result set by applying one or more remaining query terms specified in the original query to filter the reduced result set, and automatically returning the partial result set for viewing. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
8. A computer-implemented method, comprising:
-
detecting, by a server computer, a failure condition when a number of items to be returned from a data source in response to an original query exceeds a maximum number of items that can be returned from the data source; terminating, by the server computer, query execution processing of the original query against the data source; and automatically returning, by the server computer in response to the detected failure condition, a partial result set having a number of items that does not exceed the maximum number of items by; automatically selecting a particular query term from a plurality of query terms specified in the original query, automatically generating a reduced result set limited to a threshold number of most recently created items of the data source that match the particular query term selected from the original query, wherein the threshold number does not exceed the maximum number of items, automatically generating the partial result set from the reduced result set by applying one or more remaining query terms specified in the original query to filter the reduced result set, and automatically returning the partial result set for viewing. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A computer storage medium storing computer-executable instructions that, when executed, cause a computing device to perform steps comprising:
-
detecting a failure condition when a number of items to be returned from a data source in response to an original query exceeds a maximum number of items that can be returned from the data source; terminating query execution processing of the original query against the data source; and automatically returning, in response to the detected failure condition, a partial result set having a number of items that does not exceed the maximum number of items by; automatically selecting a particular query term from a plurality of query terms specified in the original query, automatically generating a reduced result set limited to a threshold number of most recently created items of the data source that match the particular query term selected from the original query, wherein the threshold number does not exceed the maximum number of items, automatically generating the partial result set from the reduced result set by applying one or more remaining query terms specified in the original query to filter the reduced result set, and automatically returning the partial result set for viewing. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification