The present invention is a searchable product/service database software system enabling complex multiple-product/service item query searching of databases, providing, in response to a single search query, search results for multiple products/services that are grouped and ranked by supplier based on which supplier(s) have inventory with respect to the greatest number of the queried products/services. The user can identify which vendor can best fill the entire order, simplifying the buying process. A single query can be entered by a user covering their entire required bill of materials list. The system is preferably implemented via a website server using known methods of Internet communication. The search results can be customized further to categorize suppliers by geographic location, supplier type, pricing or other criteria. Also disclosed and claimed is a method for providing complex multiple product/service item query searching with search results grouped and ranked by supplier based on which suppliers have inventory with respect to the greatest number of queried products/services.

Patent
   7480628
Priority
Jan 29 2002
Filed
Jan 29 2002
Issued
Jan 20 2009
Expiry
Aug 26 2023
Extension
574 days
Assg.orig
Entity
Small
0
22
all paid
4. In a computerized system for electronic commerce comprising one or more central processing units, system software for controlling said one or more central processing units and storage means containing one or more databases with information regarding suppliers and products/services available:
one or more software applications integrated thereto for use by system users to submit search queries to said system for multiple different types and quantities of products/services sought to be purchased via electronic commerce, said search queries being in the form of a single query including each of said multiple types of products/services sought to be purchased in said order, and receive as search results in response to said multiple product/service query a ranked listing of one or more suppliers that have inventory for the most types of said multiple products/services and the ranked listing of one or more suppliers indicating the types and quantities of said products/services in the inventory of each of said one or more suppliers.
1. A system for conducting multiple-item search queries in a system for engaging in electronic commerce, comprising:
one or more central processing units;
storage means communicating with said one or more central processing units containing one or more databases with information regarding suppliers and supplier inventories of products/services available for purchase;
one or more servers providing for Internet-based access and use of said system;
one or more software applications enabling buyers of products/services seeking to complete a purchase including multiple different types and quantities of products/services via electronic commerce to enter a single search query including each of said types of said multiple products/services sought to be purchased and then run a series of individual product/service searches for each of said multiple products/services in said query on said information regarding suppliers and supplier inventories of products/services available for purchasing, and render as search results a ranked listing of one or more suppliers that have inventory for the greatest number of said types of said multiple products/services sought to be purchased, and the ranked listing of one or more suppliers indicating the types and quantities of said products/services in the inventory of each of said one or more suppliers.
2. The system of claim 1, further comprising means for buyers to transmit requests for quotation to said system, means for said system to transmit requests for quotation to selected suppliers, means for suppliers to transmit quotations to buyers in response to requests for same.
3. The system of claim 1, further comprising means for buyers to purchase goods/services by linking directly to supplier ordering systems.

1. Field of the Invention

The present invention relates to a method and system for complex-query searching of databases. More specifically, the present invention relates to a method and system for complex multiple item query searching of databases whereby search results are grouped and ranked by suppliers based on which suppliers have inventory for the greatest number of queried items.

2. Description of Background Art

Buyers in need of goods and services often spend considerable time locating desired goods and services and the appropriate vendors therefor. Buyers typically use trade publications, directories, recommendations, and other means to locate vendors. If the type of vendor needed is in a foreign country, the problem compounds. Vendors advertise through various media and by direct sales methods to make known to potential buyers what they sell and how to contact them. Once a buyer identifies a few vendors, each must be contacted to obtain product or service price and availability information. These processes are costly, require experienced personnel and are time consuming for most businesses.

The market for goods and services in various industries is becoming increasingly global, with orders for such goods or services originating from several countries. It is therefore desirable to provide a quick and efficient way to order products or services through a global network of computers, such as those connected to each other via the Internet. The Internet is a collection of interconnected (public and/or private) networks that are linked together by a set of standard protocols, such as TCP/IP to form a global, distributed network. While this term is intended to refer to what is now commonly known as the Internet, it is also intended to encompass variations which may be made in the future, including changes and additions to existing standard protocols.

Online transactions are fairly cheaper than traditional channels and means of doing business. For example, a bank may charge on average one dollar for each transaction (such as every day transactions, from verifying the balance of a checking or savings account, to withdrawal of money from a local bank), versus an average of seven cents that it costs to do the same transaction on an online bank. For this reason, Internet and online trading is expected to grow significantly.

With the growth of electronic commerce via the Internet, several systems and methods have been developed for searching for and buying desired products and services. For example, U.S. Pat. No. 4,992,940 to Dworkin is directed to a computerized system for ordering products utilizing a product and service information searchable database. The system provides a menu of general product/service categories and upon user selection of an item, provides a template with various technical criteria for the products available. The user enters his or her preferences in the template and the system searches based on the criteria specified, providing the user with a list of products/services matching the specified criteria. The system shows the suppliers of each product appearing in the search results, as well as price.

Other systems are presented in the form of a catalog. For example, U.S. Pat. No. 5,319,542 to King, Jr., et al. is directed to a system for ordering items using an electronic catalog and an electronic requisition facility. The catalog comprises a public catalog for use by all users and a private catalog resident on user computer systems and may contain unique pricing data based on specific pricing agreements between the user and suppliers.

U.S. Pat. No. 5,694,551 to Doyle, et al. is directed to an electronic requisitioning system for channeling customer requisition orders to internal suppliers and outside vendors and processing invoices. Customer multiple item requisition requests are segregated by supplier and sent as purchase orders to appropriate suppliers.

Similarly, U.S. Pat. No. 5,966,697 to Fergerson, et al. is directed to a system and method for secure transaction management. It provides a system and method for shopping at a variety of different vendors, one at a time. U.S. Pat. No. 6,012,053 to Pant, et al. is directed to a computer system for performing searches on a collection of information including a mechanism through which results from a search query are ranked according to user specified relevance factors to allow the user to control how the search results are presented. The relevance factors are applied to the results for each query.

U.S. Pat. No. 6,128,626 to Beauchesne is directed to a method and database system utilized in generating a bill of materials document for a particular user designated customer product. The system responds to part queries by providing part details from approved vendors, including multiple vendors for the same part, and then generates a bill of materials.

Still other efforts include systems that attempt to make query formats for different databases compatible. For example, U.S. Pat. No. 6,233,586 to Chang et al. is directed to a computer method and system capable of searching multiple heterogeneous databases with heterogeneous data types by employing an object oriented data model to define a federated query object, a federated collection object and a federated database object. The system essentially permits searches in multiple databases having different formats.

Similarly, U.S. Pat. No. 6,263,328 to Coden, et al. is directed to a computer system enabling execution of complex database queries using a single query expression against a database without the use of intermediate results sets. Instead, the system uses a flexible and modular architecture to create a graphical user interface and a database-independent representation of a user query that can be used with heterogeneous databases.

Prior art systems and methods for searching for and buying products and services via the Internet fail to address the need for users to have more practical information in order to make multiple product and/or service purchases and to maximize potential savings from discounts obtained by dealing with certain vendors. The present invention addresses these needs and is an improvement over prior art systems and methods. The system and method of the present invention allows users to obtain, through one search query, results for searches of multiple products and services available from multiple vendors with the ability to rank the search results by vendors based on the number of queried products or services available from each.

The present invention is a searchable product/service database software system enabling complex multiple product/service item query searching of databases, providing, from a single search query, search results for multiple products and services that are grouped and ranked by product/service supplier. For example, in a database containing product inventory data for multiple suppliers, the system allows a user to search for availability of multiple products in one search query, and the search results will be grouped by supplier, showing which supplier(s) have inventory with respect to the greatest number of the desired products. The user can identify which vendor can best fill the entire order, simplifying the buying process. A single query can be entered by a user covering their entire required bill of materials list.

The system is preferably implemented via an Internet website server using known methods of Internet communication. It can be integrated into e-commerce systems in various fields where such functionality would be useful. The search results can be customized further to categorize suppliers by geographic location, pricing or other criteria.

The system of the invention is implemented via a computer system that communicates information over a network, such as the Internet. The computer system is programmed to run all necessary software, such as search and database applications or search and data-mining applications, for achieving the purpose of the invention.

The system of the present invention can be integrated into a system that processes requests for quotation for goods and/or services through one or more central processing units, said system comprising operating system software for controlling said one or more central processing units and storage means containing one or more databases with appropriate identity and other information about members of the network and the goods and services available, one or more servers providing for Internet-based access and use of the system by suppliers to upload their inventory data, request for quotation filtering conditions and means for responding to requests for quotations means for buyers to search the system's supplier and product/service databases and submit requests for quotation, means for said system's central processing unit to transmit requests for quotation to selected system supplier members, means for said supplier members to transmit quotations to the requesting potential buyers in response to their requests for same.

FIG. 1 is a diagram of the system components of the present invention in one embodiment.

FIG. 2 is a flow chart showing the overall process flow of the method of the present invention in one embodiment.

FIG. 3 is a sample website screen display of the system of the present invention depicting the multiple item query search screen.

FIG. 4 is a sample website screen display of the system of the present invention depicting the multiple item query search results screen with search results ranked by suppliers who can best fill each multiple item order.

FIG. 1 is a diagram of the elements of the system that implements the present invention in one embodiment. Communication between buyers, suppliers and the system computer(s) is effectuated using the Internet. A world wide web home page is set up to provide internet access to the system for members. A potential buyer or supplier user accesses the Internet using any standard web browser and becomes a member network user by completing a registration application providing necessary data about itself. Once registered, a member can access the system's search screen, results screen, and forms necessary for preparing an RFQ. The RFQ is sent through the system by the system server.

As shown in FIG. 1, a supplier information database 100 is connected through a server 200 to a network, such as the Internet 10. In this way, the Internet provides buyers with access to the suppliers via the system. Suppliers provide their product/service inventory database information to the system via the Internet 10 using computer terminals. A buyer interfaces with the system via a user interface 600, such as one that is developed using a well-known markup language protocol, e.g., HTML.

Referring now to FIG. 2, which is a flow diagram showing the overall process flow of the method of the present invention in a preferred embodiment, the method of the present invention begins when registered buyers interact with the system by accessing the system website 1100 and the supplier information database provided therein to search for desired items. Users can enter a single search query for multiple products and services 1110. The system responds to the user query by providing a list of product/service results grouped and ranked by supplier based on which suppliers have inventory with respect to the greatest number of queried products/services 1120. Ranking is based on the aggregate results of a series of individual part searches for each part specified in the query with suppliers having the most matches receiving the highest ranking.

The buyer can then select the supplier name to retrieve supplier contact information, and contact them directly to request a quotation, or “RFQ,” using traditional methods such as telephone, fax, e-mail RFQ, or purchase directly from the supplier 1140. If unfavorable terms are offered and/or for any other reason, the buyer may alternatively select a brokerage or fulfillment service to facilitate quotation request and/or purchase and accommodate the needs of the buyer. In one embodiment of the invention, a buyer, upon receiving a response to a request for quotation, provided with the option of purchasing goods or services offered by multiple suppliers by linking directly to each supplier's ordering system and accessing price and inventory data.

New system suppliers and other users may apply for membership online via the system website. New members would receive password information via e-mail to ensure that they have provided correct e-mail coordinates.

Standardization of product or service descriptions is done to avoid confusion. To this end preprogrammed menu information can be provided to classify products and services in categories broken down by functional class and subclass corresponding to the products as they are commercially known and identified. Such menus can be readily upgraded to include new and revised commercially available products and services from the manufacturers or suppliers of such products and services.

Buyers typically include buyers from original equipment manufacturers (“OEM's”), contract electronic manufacturers/contract assembly house's (“CEM's”), independent distributors/brokers, and other entities. Suppliers typically include franchised distributors and independent distributors. Since the website is published and marketed in many languages, buyers and suppliers can use it worldwide.

FIG. 3 depicts a sample system website screen display presenting the multiple item query search entry screen. The user can select the “smart multi-search” option and highlight displayed part numbers from a provided list, enter product/service identifier numbers manually, cut and paste part numbers, or import part numbers. Referring now to FIG. 4, which depicts a sample multiple item query search results screen, search results are provided indicating the items searched, and the corresponding results grouped and ranked by supplier based on which supplier has inventory with respect to the greatest number of queried items. If more than one supplier has similar amounts of inventory with respect to all of the queried items, the suppliers could be further ranked based on which one has the greatest quantity of inventory of each item, or other ranking criteria.

The system provides a method of searching, requesting quotations, ordering, purchasing, selling or otherwise transacting business associated with electronic components over the Internet. However, the present may equally apply to other goods or services.

According to some of the more detailed features of the invention, different options and sets of options can be associated with different classifications of buyers and/or sellers. Furthermore, the system can provide different levels of information as options and sets of options to different classifications of buyers and/or sellers.

While the present invention has been shown and described herein in what is considered to be a preferred embodiment there of, illustrating the results and advantages over the prior art obtained through in the present invention, the invention is not limited to the specific embodiments described above. Thus, the forms of the invention shown and described herein are to be taken as illustrative and other embodiments may be selected without departing from the spirit and scope of the present invention.

McGee, Todd

Patent Priority Assignee Title
Patent Priority Assignee Title
4799156, Oct 01 1986 Strategic Processing Corporation Interactive market management system
4992940, Mar 13 1989 H-Renee, Incorporated System and method for automated selection of equipment for purchase through input of user desired specifications
5319542, Sep 27 1990 International Business Machines Corporation System for ordering items using an electronic catalogue
5550746, Dec 05 1994 PNC BANK, A NATIONAL ASSOCIATION, AS COLLATERAL AGENT Method and apparatus for storing and selectively retrieving product data by correlating customer selection criteria with optimum product designs based on embedded expert judgments
5742931, Jan 15 1993 SS&D Corporation System and method for allocating resources of a retailer among multiple wholesalers
5873076, Sep 15 1995 BHW INFO EDCO COM, LLC Architecture for processing search queries, retrieving documents identified thereby, and method for using same
5966697, Oct 30 1997 Fidelity Information Services, LLC System and method for secure transaction order management processing
6012053, Jun 23 1997 RPX Corporation Computer system with user-controlled relevance ranking of search results
6032145, Apr 10 1998 International Business Machines Corporation Method and system for database manipulation
6128626, Jun 30 1998 Bull HN Information Systems Inc.; BULL HN INFORMATION SYSTEMS INC Method for minimizing storage requirements for production assembly information and updates
6233586, Apr 01 1998 KING COM LTD Federated searching of heterogeneous datastores using a federated query object
6263328, Apr 09 1999 International Business Machines Corporation Object oriented query model and process for complex heterogeneous database queries
6321224, Apr 10 1998 International Business Machines Corporation Database search, retrieval, and classification with sequentially applied search algorithms
6397212, Mar 04 1999 HANGER SOLUTIONS, LLC Self-learning and self-personalizing knowledge search engine that delivers holistic results
6631372, Feb 13 1998 OATH INC Search engine using sales and revenue to weight search results
20020010639,
20020069134,
20020087426,
20030033311,
20030093331,
20030130908,
20030184588,
//
Executed onAssignorAssigneeConveyanceFrameReelDoc
Jan 10 2002MCGEE, TODDNETCOMPONENTS, INC ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS 0128900371 pdf
Jan 29 2002netCOMPONENTS, Inc.(assignment on the face of the patent)
Date Maintenance Fee Events
Jun 20 2012M2551: Payment of Maintenance Fee, 4th Yr, Small Entity.
Jul 07 2016M2552: Payment of Maintenance Fee, 8th Yr, Small Entity.
Jul 09 2020M2553: Payment of Maintenance Fee, 12th Yr, Small Entity.


Date Maintenance Schedule
Jan 20 20124 years fee payment window open
Jul 20 20126 months grace period start (w surcharge)
Jan 20 2013patent expiry (for year 4)
Jan 20 20152 years to revive unintentionally abandoned end. (for year 4)
Jan 20 20168 years fee payment window open
Jul 20 20166 months grace period start (w surcharge)
Jan 20 2017patent expiry (for year 8)
Jan 20 20192 years to revive unintentionally abandoned end. (for year 8)
Jan 20 202012 years fee payment window open
Jul 20 20206 months grace period start (w surcharge)
Jan 20 2021patent expiry (for year 12)
Jan 20 20232 years to revive unintentionally abandoned end. (for year 12)