Methods and apparatus to search datasets
View Patent ↗Methods and apparatus to search datasets are disclosed. Example methods include in response to a search request including first and second logically related criteria, determining a first number of records in a database satisfying the first criterion and a second number of records in the database satisfying the second criterion; when the first number is less than the second number, selecting the first criterion as a basis for generating a subset of the records of the database; when the second number is less than the first number, selecting the second criterion as the basis for the identification of the subset of the records of the database; and searching the subset of the records.
1. A method, comprising:
in response to a search request including first and second logically related criteria, determining, via a processor, a first number of records in a database satisfying the first criterion and a second number of records in the database satisfying the second criterion;
when the first number is less than the second number, selecting, via the processor, the first criterion as a basis for generating a subset of the records of the database;
when the second number is less than the first number, selecting, via the processor, the second criterion as the basis for the generating of the subset of the records of the database; and
searching the subset of the records.
2. A method as defined in claim 1 , wherein, when the first criterion is selected as the basis for the generating of the subset of records, searching the subset of the records comprises searching the subset of records for the second criterion.
3. A method as defined in claim 1 , wherein, when the second criterion is selected as the basis for the generating of the subset of records, searching the subset of the records comprises searching the subset of records for the first criterion.
4. A method as defined in claim 1 , wherein determining the first number of records in the database satisfying the first criterion and the second number of records in the database satisfying the second criterion comprises obtaining the first and second numbers from a plurality of statistics generated before receipt of the search request.
5. A method as defined in claim 4 , further comprising generating the plurality of statistics according to a schedule.
6. A method as defined in claim 1 , further comprising generating a group of criteria to include the first and second search criteria based on a logical relationship between the first criterion and the second criterion.
7. A method as defined in claim 1 , wherein the first and second criteria are characteristic-value pairs.
8. A tangible computer readable storage medium comprising instructions that, when executed, cause a machine to at least:
in response to a search request including first and second logically related criteria, determine a first number of records in a database satisfying the first criterion and a second number of records in the database satisfying the second criterion;
when the first number is less than the second number, select the first criterion as a basis for generating a subset of the records of the database;
when the second number is less than the first number, 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.
9. A storage medium as defined in claim 8 , wherein, when the first criterion is selected as the basis for the generating of the subset of the records, searching the subset of the records comprises searching the subset of the records for the second criterion.
10. A storage medium as defined in claim 8 , wherein, when the second criterion is selected as the basis for the generating of the subset of records, searching the subset of the records comprises searching the subset of records for the first criterion.
11. A storage medium as defined in claim 8 , wherein determining the first number of records in the database satisfying the first criterion and the second number of records in the database satisfying the second criterion comprises obtaining the first and second numbers from a plurality of statistics generated before receipt of the search request.
12. A storage medium as defined in claim 11 , wherein the instructions, when executed, cause the machine to generate the plurality of statistics according to a schedule.
13. A storage medium as defined in claim 8 , wherein the instructions, when executed, cause the machine to generate a group of criteria to include the first and second search criteria based on a logical relationship between the first criterion and the second criterion.
14. A storage medium as defined in claim 8 , wherein the first and second criteria are characteristic-value pairs.
15. An apparatus, comprising:
a statistics obtainer to, in response to a search request including first and second logically related criteria, determine a first number of records in a database satisfying the first criterion and a second number of records in the database satisfying the second criterion;
a driving criterion selector to:
when the first number is less than the second number, select the first criterion as a basis for generating a subset of the records of the database; and
when the second number is less than the first number, select the second criterion as the basis for the generating of the subset of the records of the database; and
an analyzer to search the subset of the records, wherein at least one of the statistics obtainer, the driving criterion selector, or the analyzer is implemented via a processor.
16. An apparatus as defined in claim 15 , wherein the analyzer is to search the subset of the records by searching the subset of the records for the second criterion when the driving criterion selector selects the first criterion as the basis for the generating of the subset of the records.
17. An apparatus as defined in claim 15 , wherein the analyzer is to search the subset of the records by searching the subset of the records for the first criterion when the driving criterion selector selects the second criterion as the basis for the generating of the subset of records.
18. An apparatus as defined in claim 15 , wherein the statistics obtainer is to determine the first number of records in the database satisfying the first criterion and the second number of records in the database satisfying the second criterion by obtaining the first and second numbers from a plurality of statistics generated before receipt of the search request.
19. An apparatus as defined in claim 18 , further comprising a statistics generator to generate the plurality of statistics according to a schedule.
20. An apparatus as defined in claim 15 , further comprising a grouper to generate a group of criteria to include the first and second search criteria based on a logical relationship between the first criterion and the second criterion.
21. An apparatus as defined in claim 15 , wherein the first and second criteria are characteristic-value pairs.