Database search, retrieval, and classification with sequentially applied search algorithms

• US 6,321,224 B1
• Filed: 02/28/2000
• Issued: 11/20/2001
• Est. Priority Date: 04/10/1998
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: Requisite Technology, Inc. (Huron Consulting Group Incorporated)
• Inventors: Beall, Christopher Wade, Neal, Michael Renn, Wilmsen, James Michael
• Primary Examiner(s): Lintz, Paul R.
• Application Number:
  US09/514,524
• Time in Patent Office: 631 Days
• Field of Search: 707/5, 707/3, 707/6
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/334 Query execution G06F16/335 takes precedence
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

An electronic catalog requisition system includes software for efficiently selecting items from a database. The software accepts search terms from a user, and then executes a sequence of search strategies on the database which may include a proximity search, a word count search, and a fuzzy logic search. The sequence is terminated when a search algorithm has uncovered at least one match. Each database entry has a corresponding product category. A list of categories from each of the matching products is dynamically compiled and displayed to the user. The user can page through the list of displayed matches, or alternatively can create a subset of the list by selecting only the items within one of the categories. In addition, the user can further refine the list of items by selecting those items having a particular attribute. The software can also maintain a list of synonyms for attributes as an aid for finding appropriate matches within the database. Natural adjectives to certain of the attributes are recognized as further refinements to the search criteria. The invention has the advantage that users with a wide range of skills and/or familiarity with products can quickly find the products that they need. The software has the additional feature of creating electronic requisitions for the products listed in the database.

Claims

1. A method of selecting data records in a database, the method comprising:

inputting a search string, comprising at least one search term, to a user interface;

testing the search string against the data records using an ordered sequence of search algorithms, the search algorithms being used sequentially and in order, wherein each search algorithm compares the search string against the data records to identify matching data records;

after application of each search algorithm, terminating the test if at least one matching data record is identified by using the respective search algorithm;

upon terminating the test, compiling a list of identified data records; and

displaying the list of identified data records.

2. The method according to claim 1, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

3. The method according to claim 1, wherein the sequence of search algorithms comprises at least one algorithm in which the at least one search term is replaced by a synonym.

4. The method according to claim 1, wherein each data record may contain at least one predefined query, and wherein inputting a search string executes the predefined query.

5. The method according to claim 1, further comprising ranking each identified data record of the list according to search string match quality.

6. The method according to claim 1, wherein each data record has associated attributes, and further comprising:

selecting at least a first attribute;

selecting at least a first value of the first attribute; and

refining the list of identified data records to include only members having at least the first value of the first attribute.

7. The method according to claim 1, wherein each data record is associated with a classification, the method further comprising compiling a list of classifications associated with the identified data records, and displaying the list of classifications along with the list of identified data records.

8. The method according to claim 1, further comprising selecting a classification and displaying a list of only those identified data records associated with the selected classification.

9. The method according to claim 1, wherein each data record has an associated manufacturer, the method further comprising creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

10. The method according to claim 1, wherein at least one data record has an associated web link to a source of detailed product information, and wherein displaying the list further comprises displaying the link for the at least one data record.

11. The method according to claim 1, wherein displaying the list further comprises displaying price and supplier information for each identified data record of the list.

12. The method according to claim 1, further comprising connecting the user interface to the database through a wide area network.

13. An apparatus for selecting data records in a database, the apparatus comprising:

means for inputting a search string, comprising at least one search term, to a user interface;

means for testing the search string against the data records using an ordered sequence of search algorithms, the search algorithms being used sequentially and in order, wherein each search algorithm compares the search string against the data records to identify matching data records;

means after application of each search algorithm, for terminating the test if at least one matching data record is identified by using the respective search algorithm;

means, upon terminating the test, for compiling a list of identified data records; and

means for displaying the list of identified data records.

14. The apparatus according to claim 13, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

15. The apparatus according to claim 13, wherein the sequence of search algorithms comprises at least one algorithm in which the at least one search term is replaced by a synonym.

16. The apparatus according to claim 13, wherein each data record may contain at least one predefined query, and wherein the means for inputting a search string executes the predefined query.

17. The apparatus according to claim 13, further comprising means for ranking each identified data record of the list according to search string match quality.

18. The apparatus according to claim 13, wherein each data record has associated attributes, and further comprising:

means for selecting at least a first attribute;

means for selecting at least a first value of the first attribute; and

means for refining the list of identified data records to include only members having at least the first value of the first attribute.

19. The apparatus according to claim 13, wherein each data record is associated with a classification, the apparatus further comprising means for compiling a list of classifications associated with the identified data records, and means for displaying the list of classifications along with the list of identified data records.

20. The apparatus according to claim 13, further comprising means for selecting a classification and displaying a list of only those identified data records associated with the selected classification.

21. The apparatus according to claim 13, wherein each data record has an associated manufacturer, the apparatus further comprising means for creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

22. The apparatus according to claim 13, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the means for displaying the list further comprises means for displaying the link for the at least one data record.

23. The apparatus according to claim 13, wherein the means for displaying the list further comprises means for displaying price and supplier information for each identified data record of the list.

24. The apparatus according to claim 13, further comprising means for connecting the user interface to the database through a wide area network.

25. A machine-readable medium having stored thereon data representing sequences of instructions which, when executed by a machine, cause the machine to perform operations comprising:

inputting a search string, comprising at least one search term, to a user interface;

testing the search string against the data records using an ordered sequence of search algorithms, the search algorithms being used sequentially and in order, wherein each search algorithm compares the search string against the data records to identify matching data records;

after application of each search algorithm, terminating the test if at least one matching data record is identified by using the respective search algorithm;

upon terminating the test, compiling a list of identified data records; and

displaying the list of identified data records.

26. The medium according to claim 25, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

27. The medium according to claim 25, wherein the sequence of search algorithms comprises at least one algorithm in which the at least one search term is replaced by a synonym.

28. The medium according to claim 25, wherein each data record may contain at least one predefined query, and wherein the instructions for inputting a search string execute the predefined query.

29. The medium according to claim 25, wherein the instructions further comprise instructions causing the machine to perform operations comprising ranking each identified data record of the list according to search string match quality.

30. The medium according to claim 25, wherein each data record has associated attributes, and wherein the instructions further comprise instructions causing the machine to perform operations comprising:

selecting at least a first attribute;

selecting at least a first value of the first attribute; and

refining the list of identified data records to include only members having at least the first value of the first attribute.

31. The medium according to claim 25, wherein each data record is associated with a classification, the instructions further comprising instructions causing the machine to perform operations comprising compiling a list of classifications associated with the identified data records, and displaying the list of classifications along with the list of identified data records.

32. The medium according to claim 25, wherein the instructions further comprise instructions causing the machine to perform operations comprising selecting a classification and displaying a list of only those identified data records associated with the selected classification.

33. The medium according to claim 25, wherein each data record has an associated manufacturer, the instructions further comprising instructions causing the machine to perform operations comprising creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

34. The medium according to claim 25, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the instructions for displaying the list further comprise instructions causing the machine to perform operations comprising displaying the link for the at least one data record.

35. The medium according to claim 25, wherein the instructions for displaying the list further comprise instructions causing the machine to perform operations comprising displaying price and supplier information for each identified data record of the list.

36. The medium according to claim 25, wherein the instructions further comprise instructions causing the machine to perform operations comprising connecting the user interface to the database through a wide area network.

37. A method of selecting data records, the method comprising:

inputting a search string comprising at least one search term, to a user interface;

testing the search string against the data records using a first search algorithm, wherein the search algorithm compares the search string against the data records to identify matching data records;

terminating the test using the first search algorithm when at least one data record is identified;

if no data record is identified, then testing the search string against the data records using a second search algorithm, wherein the search algorithm compares the search string against the data records to identify matching data records;

terminating the test using the second search algorithm when at least one data record is identified;

if no data record is identified, testing the search string against the data records sequentially using further search algorithms in order to identify matching data records;

terminating the test using any one of the further search algorithms when, after application of any one of the further ordered search algorithms, at least one data record is identified;

compiling a list of identified data records; and

displaying at least a portion of the list.

38. The method according to claim 37, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

39. The method according to claim 37, wherein the sequence of search algorithms comprises at least one algorithm in which the at least one search term is replaced by a synonym.

40. The method according to claim 37, wherein each data record may contain at least one predefined query, and wherein inputting a search string executes the predefined query.

41. The method according to claim 37, further comprising ranking each identified data record of the list according to search string match quality.

42. The method according to claim 37, wherein each data record has associated attributes, and further comprising:

selecting at least a first attribute;

selecting at least a first value of the first attribute; and

refining the list of identified data records to include only members having at least the first value of the first attribute.

43. The method according to claim 37, wherein each data record is associated with a classification, the method further comprising compiling a list of classifications associated with the identified data records, and displaying the list of classifications along with the list of identified data records.

44. The method according to claim 37, further comprising selecting a classification and displaying a list of only those identified data records associated with the selected classification.

45. The method according to claim 37, wherein each data record has an associated manufacturer, the method further comprising creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

46. The method according to claim 37, wherein at least one data record has an associated web link to a source of detailed product information, and wherein displaying the list further comprises displaying the link for the at least one data record.

47. The method according to claim 37, wherein displaying the list further comprises displaying price and supplier information for each identified data record of the list.

48. The method according to claim 37, further comprising connecting the user interface to the database through a wide area network.

49. An apparatus for selecting data records, the apparatus comprising:

means for inputting a search string comprising at least one search term, to a user interface;

means for testing the search string against the data records using a first search algorithm, wherein the search algorithm compares the search string against the data records to identify matching data records;

means for terminating the test using the first search algorithm when at least one data record is identified;

means for testing the search string against the data records using a second search algorithm, if no data record is identified, wherein the search algorithm compares the search string against the data records to identify matching data records;

means for terminating the test using the second search algorithm when at least one data record is identified;

means for testing the search string against the data records sequentially using further search algorithms in order to identify matching data records if no data record is identified;

means for terminating the test using any one of the further search algorithms when, after application of any one of the further ordered search algorithms, at least one data record is identified;

means for compiling a list of identified data records; and

means for displaying at least a portion of the list.

50. The apparatus according to claim 49, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

51. The apparatus according to claim 49, wherein the sequence of search algorithms comprises at least one algorithm in which the at least one search term is replaced by a synonym.

52. The apparatus according to claim 49, wherein each data record may contain at least one predefined query, and wherein the means for inputting a search string executes the predefined query.

53. The apparatus according to claim 49, further comprising means for ranking each identified data record of the list according to search string match quality.

54. The apparatus according to claim 49, wherein each data record has associated attributes, and further comprising:

means for selecting at least a first attribute;

means for selecting at least a first value of the first attribute; and

means for refining the list of identified data records to include only members having at least the first value of the first attribute.

55. The apparatus according to claim 49, wherein each data record is associated with a classification, the apparatus further comprising means for compiling a list of classifications associated with the identified data records, and means for displaying the list of classifications along with the list of identified data records.

56. The apparatus according to claim 49, further comprising means for selecting a classification and means for displaying a list of only those identified data records associated with the selected classification.

57. The apparatus according to claim 49, wherein each data record has an associated manufacturer, the apparatus further comprising means for creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

58. The apparatus according to claim 49, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the means for displaying the list further comprises means for displaying the link for the at least one data record.

59. The apparatus according to claim 49, wherein the means for displaying the list further comprises means for displaying price and supplier information for each identified data record of the list.

60. The apparatus according to claim 49, further comprising means for connecting the user interface to the database through a wide area network.

61. A machine-readable medium having stored thereon data representing sequences of instructions which, when executed by a machine, cause the machine to perform operations comprising:

inputting a search string, comprising at least one search term, to a user interface;

testing the search string against a plurality of data records using a first search algorithm, wherein the search algorithm compares the search string against the data records to identify matching data records;

terminating the test using the first search algorithm when at least one data record is identified;

if no data record is identified, then testing the search string against the data records using a second search algorithm, wherein the search algorithm compares the search string against the data records to identify matching data records;

terminating the test using the second search algorithm when at least one data record is identified;

if no data record is identified, testing the search string against the data records sequentially using further search algorithms in order to identify matching data records;

terminating the test using any one of the further search algorithms when, after application of any one of the further ordered search algorithms, at least one data record is identified;

compiling a list of identified data records; and

displaying at least a portion of the list.

62. The medium according to claim 61, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

63. The medium according to claim 61, wherein the sequence of search algorithms comprises at least one algorithm in which the at least one search term is replaced by a synonym.

64. The medium according to claim 61, wherein each data record may contain at least one predefined query, and wherein the instruction for inputting a search string executes the predefined query.

65. The medium according to claim 61, further comprising instructions causing the machine to perform operations comprising ranking each identified data record of the list according to search string match quality.

66. The medium according to claim 61, wherein each data record has associated attributes, the instructions further causing the machine to perform operations comprising:

selecting at least a first attribute;

selecting at least a first value of the first attribute; and

refining the list of identified data records to include only members having at least the first value of the first attribute.

67. The medium according to claim 61, wherein each data record is associated with a classification, the instructions further causing the machine to perform operations comprising compiling a list of classifications associated with the identified data records, and displaying the list of classifications along with the list of identified data records.

68. The medium according to claim 61, further comprising instructions causing the machine to perform operations comprising selecting a classification and displaying a list of only those identified data records associated with the selected classification.

69. The medium according to claim 61, wherein each data record has an associated manufacturer, the instructions further causing the machine to perform operations comprising creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

70. The medium according to claim 61, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the instructions for displaying the list further comprise instructions causing the machine to perform operations comprising displaying the link for the at least one data record.

71. The medium according to claim 61, wherein the instructions for displaying the list further comprise instructions causing the machine to perform operations comprising displaying price and supplier information for each identified data record of the list.

72. The medium according to claim 61, further comprising instructions causing the machine to perform operations comprising connecting the user interface to the database through a wide area network.

73. A method of selecting data records in a database, each data record having a classification, the method comprising:

inputting a search string, comprising at least one search term, to a user interface;

testing the search string against the data records using a search algorithm to identify matching data records, the search algorithm including a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records, the identified matching data records comprising a set;

compiling a list of classifications from members of the set, said list comprising at least a first classification;

displaying at least a portion of the set along with the list of classifications;

selecting data records having the first classification, the selected data records comprising a second set having only data records that have the first classification; and

displaying at least a portion of the second set.

74. The method according to claim 73, wherein selecting data records having the first classification comprises selecting only members of the set having the first classification so that the second set is a subset of the first set.

75. The method according to claim 73, wherein selecting data records having the first classification comprises selecting all data records having the first classification so that the second set contains more data records having the first classification than the first set.

76. The method according to claim 73, wherein the search algorithm comprises an algorithm for testing at least one search term against the data records according to fuzzy logic.

77. The method according to claim 73, wherein the search algorithm comprises at least one algorithm in which the at least one search term is replaced by a synonym.

78. The method according to claim 73, wherein each data record may contain at least one predefined query, and wherein inputting a search string executes the predefined query.

79. The method according to claim 73, further comprising ranking each identified data record of the list according to search string match quality.

80. The method according to claim 73, wherein each data record has associated attributes, and further comprising:

selecting at least a first attribute;

selecting at least a first value of the first attribute; and

refining the set of identified data records to include only members having at least the first value of the first attribute.

81. The method according to claim 73, wherein each data record has an associated manufacturer, the method further comprising creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

82. The method according to claim 73, wherein at least one data record has an associated web link to a source of detailed product information, and wherein displaying the list further comprises displaying the link for the at least one data record.

83. The method according to claim 73, wherein displaying the list further comprises displaying price and supplier information for each identified data record of the list.

84. The method according to claim 73, further comprising connecting the user interface to the database through a wide area network.

85. The method according to claim 73, further comprising creating a subset of the set by selecting members having a second classification and displaying data records of the subset.

130. The method according to claim 73, wherein the search algorithm comprises a series of test string matching algorithms and wherein the search halts when all exact matches have been identified.

86. An apparatus for selecting data records in a database, each data record having a classification, the apparatus comprising:

means for inputting a search string, comprising at least one search term, to a user interface;

means for testing the search string against the data records using a search algorithm to identify matching data records, the search algorithm including a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records, the identified matching data records comprising a set;

means for compiling a list of classifications from members of the set, said list comprising at least a first classification;

means for displaying at least a portion of the set along with the list of classifications;

means for selecting data records having the first classification, the selected data records comprising a second set having only data records that have the first classification; and

means for displaying at least a portion of the second set.

87. The apparatus according to claim 86, wherein the means for selecting data records having the first classification comprises means for selecting only members of the set having the first classification so that the second set is a subset of the first set.

88. The apparatus according to claim 86, wherein the means for selecting data records having the first classification comprises means for selecting all data records having the first classification so that the second set contains more data records having the first classification than the first set.

89. The apparatus according to claim 86, wherein the search algorithm comprises an algorithm for testing at least one search term against the data records according to fuzzy logic.

90. The apparatus according to claim 86, wherein the search algorithm comprises at least one algorithm in which the at least one search term is replaced by a synonym.

91. The apparatus according to claim 86, wherein each data record may contain at least one predefined query, and wherein the means for inputting a search string executes the predefined query.

92. The apparatus according to claim 86, further comprising means for ranking each identified data record of the list according to search string match quality.

93. The apparatus according to claim 86, wherein each data record has associated attributes, and further comprising:

means for selecting at least a first attribute;

means for selecting at least a first value of the first attribute; and

means for refining the set of identified data records to include only members having at least the first value of the first attribute.

94. The apparatus according to claim 86, wherein each data record has an associated manufacturer, the apparatus further comprising means for creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

95. The apparatus according to claim 86, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the means for displaying the list further comprises means for displaying the link for the at least one data record.

96. The apparatus according to claim 86, wherein the means for displaying the list further comprises means for displaying price and supplier information for each identified data record of the list.

97. The apparatus according to claim 86, further comprising means for connecting the user interface to the database through a wide area network.

98. The apparatus according to claim 86, further comprising means for creating a subset of the set by selecting members having a second classification and means for displaying data records of the subset.

131. The apparatus according to claim 86, wherein the search algorithm comprises a series of test string matching algorithms and wherein the search halts when all exact matches have been identified.

99. A machine-readable medium having stored thereon data representing sequences of instructions which, when executed by a machine, cause the machine to perform operations comprising:

inputting a search string, comprising at least one search term, to a user interface;

testing the search string against data records, each data record having a classification, using a search algorithm to identify matching data records, the search algorithm including a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records, the identified matching data records comprising a set;

compiling a list of classifications from members of the set, said list comprising at least a first classification;

displaying at least a portion of the set along with the list of classifications;

selecting data records having the first classification, the selected data records comprising a second set having only data records that have the first classification; and

displaying at least a portion of the second set.

100. The medium according to claim 99, wherein the instructions for selecting data records having the first classification comprise instructions causing the machine to perform operations comprising selecting only members of the set having the first classification so that the second set is a subset of the first set.

101. The medium according to claim 99, wherein the instructions for selecting data records having the first classification comprise instructions causing the machine to perform operations comprising selecting all data records having the first classification so that the second set contains more data records having the first classification than the first set.

102. The medium according to claim 99, wherein the search algorithm comprises an algorithm for testing at least one search term against the data records according to fuzzy logic.

103. The medium according to claim 99, wherein the search algorithm comprises at least one algorithm in which the at least one search term is replaced by a synonym.

104. The medium according to claim 99, wherein each data record may contain at least one predefined query, and wherein the instructions for inputting a search string execute the predefined query.

105. The medium according to claim 99, the instructions further comprising instructions causing the machine to perform operations comprising ranking each identified data record of the list according to search string match quality.

106. The medium according to claim 99, wherein each data record has associated attributes, the instructions further comprising instructions causing the machine to perform operations comprising:

selecting at least a first attribute;

selecting at least a first value of the first attribute; and

refining the set of identified data records to include only members having at least the first value of the first attribute.

107. The medium according to claim 99, wherein each data record has an associated manufacturer, the instructions further comprising instructions causing the machine to perform operations comprising creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

108. The medium according to claim 99, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the instructions for displaying the list further comprise instructions causing the machine to perform operations comprising displaying the link for the at least one data record.

109. The medium according to claim 99, wherein the instructions for displaying the list further comprise instructions causing the machine to perform operations comprising displaying price and supplier information for each identified data record of the list.

110. The medium according to claim 99, the instructions further comprising instructions causing the machine to perform operations comprising connecting the user interface to the database through a wide area network.

111. The medium according to claim 99, the instructions further comprising instructions causing the machine to perform operations comprising creating a subset of the set by selecting members having a second classification and displaying data records of the subset.

132. The medium according to claim 99, wherein the search algorithm comprises a series of test string matching algorithms and wherein the search halts when all exact matches have been identified.

112. An apparatus comprising:

a workstation operable to receive an input search string, the string comprising at least one search term;

a database containing an electronic catalog having records of catalog items,

a server connected to the workstation and to the database, to test the search string against the records using an ordered sequence of search algorithms, the search algorithms being used sequentially and in order, wherein each search algorithm compares the search string against the records to identify matching records, after application of each search algorithm, terminating the test if at least one matching data record is identified by using the respective search algorithm and upon terminating the test, compiling a list of identified data records; and

a display at the workstation to display the list of identified data records compiled by the server.

113. The apparatus according to claim 112, further comprising a wide area network coupled between the workstation and the server.

114. The apparatus according to claim 112, further comprising a browser interface to receive the input search string and convey it to the server.

115. The apparatus according to claim 112, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

116. The apparatus according to claim 112, wherein each record has associated attributes, and wherein the server is operable to:

select at least a first attribute;

select at least a first value of the first attribute; and

refine the list of identified records to include only members having at least the first value of the first attribute.

117. The apparatus according to claim 112, wherein each data record is associated with a classification, wherein the server is operable to compile a list of classifications associated with the identified records, and wherein the display displays the list of classifications along with the list of identified records.

118. The apparatus according to claim 112, wherein the workstation is operable to receive a selection of a classification and in response thereto the display displays a list of only those identified data records associated with the selected classification.

119. The apparatus according to claim 112, wherein each data record has an associated manufacturer and wherein the server is operable to create a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

120. The apparatus according to claim 112, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the display displays the link for the at least one record.

121. An apparatus comprising:

means for receiving an input search string, the string comprising at least one search term;

means for storing an electronic catalog having records of catalog items,

means connected to the workstation and to the database, for testing the search string against the records using an ordered sequence of search algorithms, the search algorithms being used sequentially and in order, wherein each search algorithm compares the search string against the records to identify matching records, after application of each search algorithm, terminating the test if at least one matching data record is identified by using the respective search algorithm and upon terminating the test, compiling a list of identified data records; and

means associated with the receiving means for displaying the list of identified data records compiled by the testing means.

122. The apparatus according to claim 121, further comprising a wide area network coupled between the receiving means and the testing means.

123. The apparatus according to claim 121, wherein the receiving means further comprises means for presenting a browser interface to receive the input search string and for conveying the search string to the testing means.

124. The apparatus according to claim 121, wherein the sequence of search algorithms comprises a first algorithm for testing the search string for exact matches against the data records, and a subsequent algorithm for testing at least one search term, including stems thereof, for matches against the data records.

125. The apparatus according to claim 121, wherein each record has associated attributes, and wherein the testing means further comprises:

means for selecting at least a first attribute;

means for selecting at least a first value of the first attribute; and

means for refining the list of identified records to include only members having at least the first value of the first attribute.

126. The apparatus according to claim 121, wherein each data record is associated with a classification, wherein the testing means comprises means for compiling a list of classifications associated with the identified records, and wherein the displaying means displays the list of classifications along with the list of identified records.

127. The apparatus according to claim 121, wherein the receiving means comprises means for receiving a selection of a classification and in response thereto the displaying means displays a list of only those identified data records associated with the selected classification.

128. The apparatus according to claim 121, wherein each data record has an associated manufacturer and wherein the testing means comprises means for creating a subset of the list of identified records by selecting identified data records having a selected associated manufacturer.

129. The apparatus according to claim 121, wherein at least one data record has an associated web link to a source of detailed product information, and wherein the displaying means displays the link for the at least one record.