Computer-implemented procurement of items using parametric searching

• US 7,330,852 B2
• Filed: 11/05/2004
• Issued: 02/12/2008
• Est. Priority Date: 05/18/2000
• Status: Expired due to Fees

• Current Assignee: Caterpillar Incorporated
• Original Assignee: Caterpillar Incorporated
• Inventors: Cassel, David J., Bailey, Steven C., Blessin, Stephen W.
• Primary Examiner(s): Wong; Leslie
• Application Number:
  US10/982,358
• Publication Number:
  US 20050065982A1
• Time in Patent Office: 1,194 Days
• Field of Search: 707/3, 707/10, 707/104.1, 709/203, 709/219, 705/26, 705/27
• US Class Current: 1/1
• 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/284 Relational databases
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: Y10S 707/915 Image
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

A computer-implemented method for procuring one or more items includes, in response to user-provided data and after user selection of a search module using a client system, providing an item category. Based on user selection of the item category using the client system, one or more attributes associated with: all items in the item category are provided. Based on user input identifying an attribute value for at least one attribute, search results including one or more items matching the attribute value are generated. In response to user selection of a particular item from among the search results using the client system, an order request for the selected item is then generated.

Claims

1. A computer-implemented system for parametric searching of one or more item catalogs, comprising a server associated with one or more software components collectively configured to:

provide a hierarchically organized keyword tree comprising a first level and a second level, the first level being higher than the second level;

allow a user to navigate the keyword tree to select a keyword specifying one or more attributes common to all items in a corresponding class, the keyword being at the second level of the keyword tree;

receive the keyword specifying the one or more attributes common to all items in the corresponding class, the one or more common attributes being left unconstrained by the keyword;

determine, based on the keyword, one or more of the common attributes that are left unconstrained by the keyword;

receive attribute values for one or more of the determined common attributes, wherein at least one of the received attribute values is received using a corresponding attribute field, the field corresponding to an unconstrained attribute and into which the user may input an attribute value for the unconstrained attribute to specify its attribute value;

parametrically search an item catalog based on the received keyword and the received attribute values;

generate search results according to the parametric search, the search results comprising a table listing a plurality of items, each listed item having attributes matching the attributes specified by the keyword and attribute values matching the received attribute values, the table further listing, for each item, attribute values for the item; and

receive a selection of an item from among the search results.

2. The system of claim 1, further comprising a database containing at least a portion of an item catalog to be searched, the database comprising:

an item table identifying all items in the portion of the item catalog and identifying attribute values for all searchable attributes of each item, each item being linked to its attribute values using the item table; and

a keyword table identifying one or more keywords that each correspond to a class of items, each keyword being linked to one or more searchable attributes common to all items in the corresponding class using the keyword table;

wherein the parametric search is performed using the item table and the keyword table.

3. The system of claim 2, wherein the database includes both one or more internal catalogs and one or more external catalogs.

4. The system of claim 1, wherein the one or more software components are further configured to receive a selection of either an internal item catalog for an enterprise associated with a user for whom searching is being performed or an external item catalog associated with another enterprise and to restrict the parametric search accordingly.

5. The system of claim 1, wherein the one or more software components are further configured to receive a selection of a search module from among a plurality of available search modules comprising a keyword search module, a manufacturer search module, and a global search module.

6. The system of claim 1, wherein at least one of the received attribute values is received using a corresponding attribute menu, the menu comprising all acceptable attribute values for the corresponding unconstrained attribute and from which the user may select a particular attribute value for the unconstrained attribute to specify its attribute value.

7. The system of claim 1, wherein the server is configured to:

receive a logon request from a client system associated with a user, the user being one of multiple concurrent users associated with multiple client systems; and

communicate the one or more software components for operation on the client system in response to the logon request, the software components being configured to parametrically search the item catalog independent of the server.

8. The system of claim 7, wherein at least one software component comprises an applet.

9. The system of claim 1, wherein the one or more software components are further configured to:

retrieve a cached image of the selected item; and

generate a display for presentation on a client system associated with a user, the display comprising at least the image of the selected item.

10. The system of claim 1, wherein the software components are further configured to generate an order request for the selected item in response to a user associated with a client system selecting the item from among the search results.

11. The system of claim 10, wherein the software components are further configured to send the order request for fulfillment in response to electronic approval of the order request by one or more supervisors of the user.

12. The system of claim 10, wherein the software components are further configured to generate an approval and routing status of the order request in response to the user selecting an order status module.

13. The system of claim 10, wherein generating the order request varies according to whether the item is selected from an internal or an external catalog.

14. A computer-implemented system for parametric searching of one or more item catalogs, comprising:

means for providing a hierarchically organized keyword tree comprising a first level and a second level, the first level being higher than the second level;

means for allowing a user to navigate the keyword tree to select a keyword specifying one or more attributes common to all items in a corresponding class, the keyword being at the second level of the keyword tree;

means for receiving the keyword specifying the one or more attributes common to all items in the corresponding class, the one or more common attributes being left unconstrained by the keyword;

means for determining, based on the keyword, one or more of the common attributes that are left unconstrained by the keyword;

means for receiving attribute values for one or more of the determined common attributes using one or more corresponding attribute fields, each field corresponding to an unconstrained attribute and into which the user may input an attribute value for the unconstrained attribute to specify its attribute value;

means for parametrically searching at least a portion of an item catalog according to the received keyword and the received attribute values;

means for generating search results according to the parametric search, the search results comprising a table listing a plurality of items, each listed item having attributes matching the attributes specified by the keyword and attribute values matching the received attribute values, the table further listing, for each item, attribute values for the item; and

means for receiving a selection of an item from among the search results.

15. A method of searching a database, comprising:

displaying a hierarchically organized keyword tree comprising a first level and a second level, the first level being higher than the second level;

allowing a user to navigate the keyword tree to select a keyword specifying one or more attributes common to all items in a corresponding class, the keyword being at the second level of the keyword tree;

receiving the keyword, specifying the one or more attributes;

displaying the one or more attributes;

receiving one or more attribute values for at least one of the one or more attributes by receiving one or more user-inputted attribute values into one or more corresponding attribute fields;

based on the keyword and the one or more attribute values, performing a textual search on the database;

obtaining results from the textual search as a table listing a plurality of items, each listed item having attributes matching the one or more attributes specified by the keyword and attribute values matching the one or more received attribute values, the table further listing, for each item, attribute values for the item;

selecting an item from the list of items generated according to the textual search; and

viewing the one or more attributes for the selected item.

16. The method of claim 15, further comprising viewing one or more attribute values for the one or more attributes.

17. The method of claim 15, wherein the database includes both internal and external catalogs.

18. The method of claim 15, wherein the textual search is entered as a number, a text string, a name, a description, or a part number of an item.

20. The method of claim 15, wherein the one or more attributes include one or more physical characteristics of a class of manufactured items associated with the keyword.

19. A computer-implemented method for procuring one or more items, comprising:

in response to user-provided data and after user selection of a search module using a client system, providing an item category by displaying a hierarchically organized tree comprising a first level and a second level, the first level being higher than the second level, and allowing a user to select a category specifying one or more attributes common to all items in a corresponding class, the category being referenced at the second level of the tree;

based on user selection of the item category using the tree at the client system, providing one or more attributes associated with all items in the item category;

based on user input into an attribute field corresponding to one of the one or more attributes, the user input identifying an attribute value for at least one attribute, generating search results comprising a table listing a plurality of items matching the attribute value, each item having attributes matching the one or more attributes and having an attribute value matching the attribute value, the table further listing, for each item, the attribute value; and

in response to user selection of a particular item from among the search results using the client system, generating an order request for the selected item.