SYSTEMS AND METHODS FOR QUERY OPTIMIZATION
First Claim
1. A computer-implemented method of querying a database, comprising:
- receiving, at a server, a query from a client;
applying a default query range to the query;
executing the query upon the database in a first execution, wherein the query is executed using an index comprising a category of information stored in the database and is executed subject to the default query range;
determining if the number of query results from the first execution is outside a predetermined range;
when it is determined that the number of query results from the first execution is outside the predetermined range, adjusting the query range to obtain a number of query results closer to or within the predetermined range;
executing the query upon the database in a second execution, wherein the query is executed using the index comprising the category of information stored in the database and is executed subject to the adjusted query range; and
sending the query results obtained from the second execution of the query to the client.
7 Assignments
0 Petitions
Accused Products
Abstract
In accordance with certain embodiments, a query from a client may be received at a server, and a default query range may be applied to the query. The query may be executed in a first execution using an index comprising a category of information stored in the database and subject to the default query range. If the number of query results from the first execution is outside a predetermined range, then the query range may be adjusted to obtain a number of query results closer to or within the predetermined range. Additionally, the query may be executed in a second execution using the index comprising the category of information stored in the database and subject to the adjusted query range. Thereafter, the query results obtained from the second execution of the query may be sent to the client.
-
Citations
22 Claims
-
1. A computer-implemented method of querying a database, comprising:
-
receiving, at a server, a query from a client; applying a default query range to the query; executing the query upon the database in a first execution, wherein the query is executed using an index comprising a category of information stored in the database and is executed subject to the default query range; determining if the number of query results from the first execution is outside a predetermined range; when it is determined that the number of query results from the first execution is outside the predetermined range, adjusting the query range to obtain a number of query results closer to or within the predetermined range; executing the query upon the database in a second execution, wherein the query is executed using the index comprising the category of information stored in the database and is executed subject to the adjusted query range; and sending the query results obtained from the second execution of the query to the client. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 21)
-
-
11. A computer-based system comprising at least one processor and one or more storage media storing a plurality of instructions, the plurality of instructions being executable by the at least one processor for:
-
receiving a query from a client; applying a default query range to the query; executing the query upon the database in a first execution, wherein the query is executed using an index comprising a category of information stored in the database and is executed subject to the default query range; determining if the number of query results from the first execution is outside a predetermined range; when it is determined that the number of query results from the first execution is outside the predetermined range, adjusting the query range to obtain a number of query results closer to or within the predetermined range; executing the query upon the database in a second execution, wherein the query is executed using the index comprising the category of information stored in the database and is executed subject to the adjusted query range; and sending the query results obtained from the second execution of the query to the client. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20, 22)
-
Specification