Apparatus for and method of managing the availability of items

• US 5,727,164 A
• Filed: 12/13/1991
• Issued: 03/10/1998
• Est. Priority Date: 12/13/1991
• Status: Expired due to Fees

• Current Assignee: Max Software Incorporated (Broadcom, Inc.)
• Original Assignee: Max Software Incorporated (Broadcom, Inc.)
• Inventors: Cabana, Joe, Song, Steve, Kaye, Eugene G.
• Primary Examiner(s): Hayes, Gail O.
• Assistant Examiner(s): Tkacs, Stephen R.
• Application Number:
  US07/806,637
• Time in Patent Office: 2,279 Days
• Field of Search: 364/401, 364/403, 364/408, 364/479, 235/385, 395/600, 395/200, 395/650, 395/201, 395/228, 395/229, 395/602, 395/603, 395/610, 395/615
• US Class Current: 705/28
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Apparatus and method for managing the availability of items using a computer system. The system permits various computers to access databases located at offsite computers to retrieve/transmit preselected information pertaining to the availability of items from/to each accessed database. Categories of items are selected by a user prior to communicating with offsite computers so that only the categories of interest are selected and only data pertaining to those categories is downloaded to the requesting computer or uploaded from a called computer. Once data has been retrieved by the requesting computer, the user can use various parameters to select and display the received information in the selected categories. In addition, the requesting computer can automatically retrieve information from offsite computers at a predetermined time each day of the week.

Claims

1. A method of exchanging information of electronic components among different vendors each having a vendor controlled data base through a communication network, said method comprising the steps of:

storing a universal set of categories of the electronic components at each of a plurality of vendor sites;

storing at each vendor site a local inventory of electronic components of at least one category of the universal set of categories in the vendor controlled data base and data identifying other vendor sites permitted to access the vendor controlled data base of the vendor site;

selecting, at each vendor site, at least one category of the inventory of electronic components independently controlled data base of other of the selected from the universal set of categories as available to other vendors

automatically interconnecting vendor site data bases identified as permitted to access each other'"'"'s vendor controlled data base at scheduled times to exchange information on electronic components of the at least one selected category available to other vendors through the communication network;

transmitting information regarding the electronic components of the selected at least one category available to other vendors directly from the vendor controlled data base of each automatically interconnected vendor site to each other automatically interconnected vendor site through the communication network;

receiving information regarding electronic components of the selected at least one category available to other vendors at each automatically interconnected vendor site directly from each of the other automatically interconnected vendor controlled data bases in searchable offsite data bases assigned to the other automatically interconnected vendor sites through the communication network.

2. A method according to claim 1, wherein the information received in response to the request for information regarding electronic components of the selected at least one category includes formatted data of the electronic components from the other selected vendor sites, and

further comprising the step of entering the formatted data into the off-site data base of the selected vendor site receiving the information.

3. A method according to claim 2, wherein the formatted data of electronic components includes a family/subfamily name and an electronic component name.

4. A method according to claim 2, wherein the formatted data includes for each electronic component in each category an electronic component name, an electronic component quantity, a manufacturer name, a date of manufacture, a price of electronic component and a comment section to describe any non-standard parameters.

5. A method according to claim 1, further comprising the step of preselecting acceptable electronic component quantities and costs to form the request for information regarding electronic components of the selected at least one category to be sent to the other selected vendor sites.

6. A method according to claim 1, wherein only updated information is received from the other selected vendor site databases.

7. A method according to claim 1, further comprising the step of printing a transaction report for all transactions indicating the time and date and the other selected vendor databases.

8. A method according to claim 1, further comprising the steps of:

entering search criteria including an electronic component name, a quantity, a manufacture name, a date code and a price; and

searching the offsite database for information matching the entered criteria.

9. A method according to claim 1, wherein the step of selecting the at least one category comprises the step of specifying a family/subfamily category.

17. A method according to claim 1, wherein the electronic components include at least one of digital components, linear components, memory components, interface components and optical components.

10. An apparatus for exchanging information on electronic components among different vendors each having a vendor controlled data base at a site of the vendor via a communication network, comprising:

means for storing a universal set of categories at each of a plurality of vendor sites;

means for storing at each of the plurality of vendor sites a local inventory of electronic components of at least one category of the universal set of categories in the vendor controlled data base of the vendor and data identifying other vendors with permission to access to the vendor site;

means at each vendor site for selecting at least one category of the inventory of electronic components in the vendor controlled data base from the universal set of categories as available to other vendors;

means for automatically interconnecting vendor site data bases having permission to access each other'"'"'s vendor controlled data base at scheduled times to exchange information on electronic components of the at least one selected category available to other vendors through the communication network;

means for transmitting information regarding the electronic components of the selected at least one category available to other vendors directly from each automatically interconnected vendor site to the other automatically interconnected vendor sites through the communication network; and

means at each automatically interconnected vendor site for receiving information regarding electronic components available to other vendors directly from the vendor controlled data bases of the other automatically interconnected vendor sites in searchable offsite data bases assigned to the other automatically interconnected vendors through the communication network.

18. Apparatus according to claim 10, wherein the electronic components include at least one of digital components, linear components, memory components, interface components and optical components.

11. A method of exchanging information on electronic components among vendors each having vendor controlled data base at a vendor site, said method comprising the steps of:

storing a universal set of categories at each vendor site;

storing at each vendor site a local inventory of electronic components of at least one category of the universal set of categories in the vendor controlled data base of the vendor site and data identifying other vendor sites given permission to access to the vendor site;

selecting at each vendor site at least one category of the inventory of electronic components in the local inventory of the vendor controlled data base of the vendor site as available to other vendors; and

automatically interconnecting first and second vendor sites identified as having permission to access each other'"'"'s vendor controlled data bases at prescheduled times for exchanging information between the first and second vendor sites regarding the electronic components of the at least one category available to other vendors in the local inventory of the vendor controlled data bases at the first and second vendor sites through a communication network;

transmitting information directly from the first vendor site to the second vendor site regarding the electronic components of the selected at least one category at the first vendor site available to other vendors through the communication network;

receiving information at the first vendor site regarding the electronic components of the selected at least one category available to other vendors from the second vendor site directly from the local inventory of the vendor controlled data base of the second vendor site in a searchable offsite data base of the first vendor site through the communication network;

transmitting information directly from the second vendor site to the first vendor site regarding the electronic components of the selected at least one category available to other vendors from the second vendor site through the communication network; and

receiving information at the second vendor site regarding the electronic components of the selected at least one category available to other vendors from the first vendor site directly from the vendor controlled inventory data base of the first vendor site in a searchable offsite data base assigned to the first vendor site through the communication network.

12. A method according to claim 11, wherein the information received at the first and second vendor sites in response to the request for information regarding the selected at least one category from the other of the first and second sites includes formatted local inventory data from the other of the first and second sites, and

further comprising the step of entering the formatted local inventory data from the first vendor site into the offsite data base of the second vendor site;

and

the step of entering the formatted local inventory data from the second vendor site into the offsite data base of the first vendor site.

13. A method according to claim 11, further comprising the step of preselecting acceptable electronic component quantities and costs to form each request for information regarding the selected at least one category to be transmitted.

14. A method according to claim 11, wherein only updated information is transmitted to and received from the first and second sites.

15. A method according to claim 11, wherein the step of selecting the at least one category comprises the step of specifying a family/subfamily category.

16. Apparatus for exchanging information on electronic components among a plurality of vendors each having a vendor controlled data base at a vendor site, comprising:

means for storing a universal set of categories at each of the plurality of vendor sites;

means for storing at each vendor site a local inventory of electronic components of at least one category of the universal set of categories in the vendor controlled data base and data identifying other vendor sites given to access to the vendor site;

means at each vendor site for selecting at least one category of the inventory of electronic components in the local inventory of the vendor site as available to other vendors;

means for automatically interconnecting first and second vendor site data bases identified as having permission to access each other'"'"'s vendor controlled data base at prescheduled times for exchanging information between the first and second vendor sites regarding the electronic components of the at least one category available to other vendors in the local inventory of the vendor controlled data bases at the first and second vendor sites through a communication network;

means at each of the automatically interconnected first and second vendor sites for transmitting directly to the other of the first and second vendor sites information regarding the electronic components of the selected at least one category available to other vendors through the communication network;

means at each of the automatically interconnected first and second vendor sites for receiving information directly from the independently controlled data base of the other of the automatically interconnected first and second vendor sites in a searchable offsite data base assigned to the other of the first and second vendor sites through the communication network.