Methods and apparatus to search datasets
View Patent ↗Methods and apparatus to search datasets are disclosed. An example disclosed apparatus includes a grouper to reference statistics associated with a database to identify which criterion of a group of logically related criteria of a search request satisfies fewer ones of records in the database, an identifier to select the identified criterion of the group of logically related criteria as a driving criterion for the group of logically related criteria, a reduced set generator to form a subset of the records of the database based on the driving criterion, and an analyzer to reduce a search time associated with the search request by searching the subset of the records for a non-driving criterion of the group of logically related criteria.
1. A method, comprising:
referencing, by executing an instruction with a processor, statistics associated with a database to identify which criterion of a group of logically related criteria of a search request satisfies fewer ones of records in the database;
selecting, by executing an instruction with the processor, the identified criterion of the group of logically related criteria as a driving criterion for the group of logically related criteria;
forming, by executing an instruction with the processor, a subset of the records of the database based on the driving criterion;
reducing a search time associated with the search request by searching, by executing an instruction with the processor, the subset of the records for a non-driving criterion of the group of logically related criteria, the searching identifying records in the database that satisfy the search request; and
responding, by executing an instruction with the processor, to the search request with the records from the database.
2. The method as defined in claim 1 , further including determining, by executing an instruction with the processor, a count for respective criteria of the database, the count representative of a corresponding number of records in the database including the respective criteria.
3. The method as defined in claim 1 , further including generating, by executing an instruction with the processor, the statistics before receiving the search request.
4. The method as defined in claim 1 , further including:
generating, by executing an instruction with the processor, static ones of the statistics before receiving the search request, and generating dynamic ones of the statistics in response to receiving the search request, wherein the dynamic statistics include a range of values specified in the search request.
5. The method as defined in claim 1 , further including identifying, by executing an instruction with the processor, the group of logically related criteria as having a logical relationship by analyzing a logical operator of the search request, the logical operator including at least one of AND or OR.
6. The method as defined in claim 1 , wherein the database corresponds to a product database, and the records of the database correspond to a consumer good.
7. The method as defined in claim 6 , wherein the records of the database include characteristic-value pairs.
8. An apparatus, comprising:
a grouper to reference statistics associated with a database to identify which criterion of a group of logically related criteria of a search request satisfies fewer ones of records in the database;
an identifier to select the identified criterion of the group of logically related criteria as a driving criterion for the group of logically related criteria;
a reduced set generator to form a subset of the records of the database based on the driving criterion; and
an analyzer to reduce a search time associated with the search request by searching the subset of the records for a non-driving criterion of the group of logically related criteria, the searching identifying records in the database that satisfy the search request, the analyzer to respond to the search request with the records from the database, at least one of the grouper, the identifier, the reduced set generator, or the analyzer including a processor and memory.
9. The apparatus as defined in claim 8 , further including:
a count generator to generate the statistics by determining a count for respective criteria of the database, the counts representative of a corresponding number of records in the database including the respective criteria.
10. The apparatus as defined in claim 9 , wherein the count generator is to:
generate static ones of the statistics before receiving the search request; and
generate dynamic ones of the statistics in response to receiving the search request, wherein the dynamic statistics include a range of values specified in the search request.
11. The apparatus as defined in claim 9 , wherein the count generator is to generate the statistics before receiving the search request.
12. The apparatus as defined in claim 8 , wherein the identifier is to identify the group of logically related criteria as having a logical relationship by analyzing a logical operator of the search request, the logical operator including at least one of AND or OR.
13. The apparatus as defined in claim 8 , wherein the database corresponds to a product database, and the records of the database correspond to a consumer good.
14. The apparatus as defined in claim 13 , wherein the records of the database include characteristic-value pairs.
15. A tangible machine readable storage medium comprising instructions that, when executed, cause a processor to at least:
reference statistics associated with a database to identify which criterion of a group of logically related criteria of a search request satisfies fewer ones of records in the database;
select the identified criterion of the group of logically related criteria as a driving criterion for the group of logically related criteria;
form a subset of the records of the database based on the driving criterion; and
reduce a search time associated with the search request by searching the subset of the records for a non-driving criterion of the group of logically related criteria, the searching identifying records in the database that satisfy the search request; and
respond to the search request with the records from the database.
16. The storage medium as defined in claim 15 , wherein the instructions, when executed, cause the processor to generate the statistics by determining a count for respective criteria of the database, the counts representative of a corresponding number of records in the database including the respective criteria.
17. The storage medium as defined in claim 15 , wherein the instructions, when executed, cause the processor to generate the statistics before receiving the search request.
18. The storage medium as defined in claim 15 , wherein the instructions, when executed, cause the processor to:
generate static ones of the statistics before receiving the search request; and
generate dynamic ones of the statistics in response to receiving the search request, wherein the dynamic statistics include a range of values specified in the search request.
19. The storage medium as defined in claim 15 , wherein the instructions, when executed, cause the processor to identify the group of logically related criteria as having a logical relationship by analyzing a logical operator of the search request, the logical operator including at least one of AND or OR.
20. The storage medium as defined in claim 15 , wherein the database corresponds to a product database, and the records of the database correspond to a consumer good.