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 grouping to assign first and second criteria to a first group according to a logical relationship between the first and second criteria, the first and second criteria received in a search request;
means for identifying which of the first and second 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 included in the database;
means for generating 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
means for searching the reduced set of records from the database, the reduced set of records reducing a search time associated with the search request, at least one of the grouping means, the identifying means, the generating means or the searching means are implemented via a processor.
2. The apparatus as defined in claim 1 , further including means for sending results of the search to a requester, the search request received from the requester.
3. The apparatus as defined in claim 1 , further including means for counting to regenerate the plurality of counts when a new product has been entered into the database.
4. The apparatus as defined in claim 1 , wherein the database includes a product database, and the first and second criteria are characteristic-value pairs.
5. The apparatus as defined in claim 1 , wherein the logical relationship between the first and second criteria is defined by an AND operator.
6. The apparatus as defined in claim 1 , further including means for receiving a second search request and to determine whether the second search request includes more than one criteria.
7. The apparatus as defined in claim 6 , wherein the searching means is to search the database without generating the reduced set of records when the second search request includes only one criterion.
8. A method, comprising:
receiving, by executing an instruction with a processor, a search request having at least two criteria;
assigning, by executing an instruction with the processor, first and second criteria to a first group according to a logical relationship between the first and second criteria;
determining, by executing an instruction with the processor, which of the first and second criteria in the first group is satisfied by a least amount of records in a database based on a plurality of counts, the plurality of counts respectively indicative of a number of corresponding records in the database satisfying a respective one of criteria exhibited by the database;
identifying, by executing an instruction with the processor, 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, by executing an instruction with the processor, the reduced set of records from the database.
9. The method as defined in claim 8 , further including sending results of the search to a requester, the search request received from the requester.
10. The method as defined in claim 8 , further including regenerating the plurality of counts when a new product has been entered into the database.
11. The method as defined in claim 8 , wherein the database includes a product database having characteristic-value pairs.
12. The method as defined in claim 8 , wherein the logical relationship between the first and second criteria is defined by an AND operator.
13. The method as defined in claim 8 , further including:
receiving a second search request and determining whether the second search request includes more than one criterion; and
searching the database without generating the reduced set of records when the second search request includes only one criterion.
14. A tangible machine readable storage medium comprising instructions that, when executed, cause a processor to at least:
receive a search request having at least two criteria;
assign first and second criteria to a first group according to a logical relationship between the first and second criteria;
determine which of the first and second 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 present in the database;
identify 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
reduce a search time associated with the search request by searching the reduced set of records from the database.
15. The storage medium as defined in claim 14 , wherein the instructions, when executed, cause the processor to send results of the search to a requester, the search request received from the requester.
16. The storage medium as defined in claim 14 , wherein the instructions, when executed, cause the processor to regenerate the plurality of counts when a new product has been entered into the database.
17. The storage medium as defined in claim 14 , wherein the database includes a product database, and the first and second criteria are characteristic-value pairs.
18. The storage medium as defined in claim 14 , wherein the logical relationship between the first and second criteria is defined by an AND operator.
19. The storage medium as defined in claim 14 , wherein the instructions, when executed, further cause the processor to:
receive a second search request;
determine whether the second search request includes more than one criterion; and
search the database without generating the reduced set of records when the second search request includes only one criterion.