Methods and apparatus to search datasets
Methods and apparatus to search datasets are disclosed. An example disclosed method includes receiving a search request having at least two criteria and assigning the criteria to a first group according to a logical relationship between the criteria. The example method further includes determining which of the criteria in the first group is satisfied by a least amount of records in a database based on a plurality of counts, the counts respectively indicative of a number of corresponding records in the database satisfying a respective one of criteria exhibited by the database, and identifying a reduced set of records in the database to be searched, the reduced set of records corresponding to the first or second criteria that is satisfied by the least amount of records in the database, and reducing a search time associated with the search request by searching the reduced set of records from the database.
1. An apparatus comprising:
means for obtaining to, in response to a search request including a first criterion and a second criterion, determine a first quantity of records in a database satisfying the first criterion and a second quantity of the records in the database satisfying the second criterion;
means for driving criterion selecting to:
when the first quantity of the records is less than the second quantity of the records, select the first criterion as a basis for generating a subset of the records of the database;
when the second quantity of the records is less than the first quantity of the records, select the second criterion as the basis for the generating of the subset of the records of the database; and
means for searching the subset of the records;
wherein at least one of the obtaining means, the selecting means, or the searching means are implemented via logic circuitry.
2. The apparatus of claim 1 , wherein the searching means is to search the subset of the records for the second criterion when the driving criterion selecting means selects the first criterion as the basis for the generating of the subset of the records.
3. The apparatus of claim 1 , wherein the searching means is to search the subset of the records for the first criterion when the driving criterion selecting means selects the second criterion as the basis for the generating of the subset of the records.
4. The apparatus of claim 1 , wherein the obtaining means is to determine the first quantity of records in the database satisfying the first criterion and the second quantity of the records in the database satisfying the second criterion based on the first and second quantities from a plurality of statistics generated before receipt of the search request.
5. The apparatus of claim 4 , further including a means for statistic generating to generate the plurality of statistics according to a schedule.
6. The apparatus of claim 1 , further including means for grouping to generate a group of criteria including the first criterion and second criterion based on a logical relationship between the first criterion and the second criterion.
7. The apparatus of claim 6 , wherein the grouping means is to assign the logical relationship between the first criterion and the second criterion if the first criterion is not related to the second criterion via a logical operation.
8. The apparatus of claim 1 , wherein the first criterion and second criterion are characteristic-value pairs.
9. The apparatus of claim 1 , wherein the first criterion are related to the second criterion via a logical operator.
10. The apparatus of claim 1 , wherein the database corresponds to a product database, and the records of the database correspond to a consumer good.
11. An apparatus comprising:
memory;
machine readable instructions; and
a processor to execute the machine readable instructions to:
in response to a search request including a first criterion and a second criterion, determine a first quantity of records in a database satisfying the first criterion and a second quantity of records in the database satisfying the second criterion;
when the first quantity is less than the second quantity, select the first criterion as a basis for generating a subset of the records of the database;
when the second quantity is less than the first quantity, select the second criterion as the basis for the generating of the subset of the records of the database; and
search the subset of the records.
12. The apparatus of claim 11 , wherein the processor is to execute the machine readable instructions to, when the first criterion is selected as the basis for the generating of the subset of the records, search the subset of the records for the second criterion.
13. The apparatus of claim 11 , wherein the processor is to execute the machine readable instructions to, when the second criterion is selected as the basis for the generating of the subset of the records, search the subset of records for the first criterion.
14. The apparatus of claim 11 , wherein the processor is to execute the machine readable instructions to obtain the first and second quantities from a plurality of statistics generated before receipt of the search request.
15. The apparatus of claim 14 , wherein the processor is to execute the machine readable instructions to generate the plurality of statistics according to a schedule.
16. The apparatus of claim 11 , wherein the processor is to execute the machine readable instructions to generate a group of criteria to include the first criterion and the second criterion based on a logical relationship between the first criterion and the second criterion.
17. The apparatus of claim 16 , wherein the processor is to execute the machine readable instructions to assign the logical relationship between the first criterion and the second criterion if the first criterion is not related to the second criterion via a logical operator.
18. The apparatus of claim 11 , wherein the first criterion and the second criterion are characteristic-value pairs.
19. The apparatus of claim 11 , wherein the first criterion is related to the second criterion via a logical operator.
20. The apparatus of claim 11 , wherein the database corresponds to a product database, and the records of the database correspond to a consumer good.