System and method for managing data in multiple bills of material over a network

• US 7,801,916 B1
• Filed: 10/12/2009
• Issued: 09/21/2010
• Est. Priority Date: 04/10/2000
• Status: Expired due to Fees

• Current Assignee: Arena Solutions, Inc
• Original Assignee: Arena Solutions, Inc
• Inventors: Topolovac, Michael, Yu, Janet, Larkin, Eric
• Primary Examiner(s): Trujillo; James
• Assistant Examiner(s): Spieler; William
• Application Number:
  US12/577,590
• Time in Patent Office: 344 Days
• Field of Search: 707/783, 705/29
• US Class Current: 707/783
• 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

Abstract

A system for managing a bill of materials includes a data structure having at least one record with a primary key data field, an owner data field for indicating the owner of the record, the owner data field including data representative of one of a plurality of owners, and at least one other data field. In another aspect, the system for managing a bill of materials includes a database having a single namespace, and at least one record with a primary key data field, an owner data field for indicating the owner of the record, the owner data field including data representative of one of a plurality of owners, and at least one other data field.

Claims

1. A system for managing a plurality of bills of material (BOMs) comprising:

a client terminal accepting information for a particular BOM, the BOM being one of a plurality of BOMS, each BOM describable as a tree with each node an element, each element in each BOM having an owner of a set of more than one owner, and each BOM having an owner of the set of owners, the particular BOM having a particular owner, the client terminal coupled to a network;

a server processing system configured to store the plurality of BOMs, the server processing system coupled to the network such that the client terminal is coupled to the server system via the network; and

wherein the system is configured to provide access to at least some of the information of one or more of the plurality of BOMs to one or more users according to control information, control information for providing access to a particular BOM being received from an entity that is the owner of the particular BOM, or from any entity that the owner of the BOM designates, or from both the entity that is the owner and any entity that the owner of the BOM designates, such that the providing of further access to at least some of the information of a particular BOM is controlled by the entity that is the owner of the particular BOM, or by any entity that the owner of the BOM designates, or by both the entity that is the owner and any entity that the owner of the BOM designates,

such that BOMs associated with different owners are stored in the same processing system,

wherein for each of at least two different owners, at least one of the BOMs of the respective owner includes confidential information of the owner, such that unrestricted access to the confidential information is limited to the owner of the BOM, or to any entity that the owner of the BOM designates, or to both the owner of the BOM and any entity that the owner of the BOM designates; and

wherein the different owners need not be related except that they each have information stored in the same processing system.

2. A system as recited in claim 1, wherein the network coupling the client terminal to the server processing system includes a link via a public network.

3. A system as recited in claim 2, wherein the public network is the Internet.

4. A system as recited in claim 1, wherein the plurality of BOMS is stored in the server processing system as one or more BOM data structures in a database, and wherein the database further includes a list of elements, one or more of the elements being for inclusion in one or more of the plurality of BOMs.

5. A system as recited in claim 4, wherein each of one or more elements in the element list is associated with a respective owner of the set of owners, wherein the list of elements includes an indication of ownership for each element associated with one of the owners, and wherein the system is further configured such that access to information about a particular element in the element list that is associated with a particular owner may be restricted to the particular owner or to one or more designates of the particular owner, or to both the particular owner and one or more designates of the particular owner.

6. A system as recited in claim 5,

wherein each element has a unique identifier,

wherein the database further includes a list of owners in the set of owners, each owner having an entry including a unique owner identifier in the list of owners, and

wherein the providing access to one or more users includes providing access to one or more elements of information in the database, the access being remote from the server processing system, the remote access provided according to the control information.

7. A system as recited in claim 5, wherein the database is arranged such that a first BOM of a first owner may share one or more elements of the list of elements with a second BOM of a second owner.

8. A system as recited in claim 5, wherein an element in the element list is one of the set consisting of a physical element and a process,

wherein the physical element may itself be represented by a BOM, and

wherein the process may reference a set of steps or operations.

9. A system as recited in claim 5, wherein each BOM data structure is for storing the parent-child relationships for at least one BOM of the plurality of BOMs, and wherein a BOM data structure includes, for a particular BOM, an entry for each element in the particular BOM, said element entry including a reference to the element'"'"'s entry in the list of elements, an entry indicating the owner, and an entry indicating any child of the element in the case the element has a child in the tree representing the particular BOM.

10. A system as recited in claim 9, wherein the parent child relationships for all the BOMS are stored in a single BOM data structure.

11. A system as recited in claim 5, wherein the database further includes a list of users, each user having an entry in the list of users that includes a unique user identifier in the list of users, each user possibly being associated with one or more of the owners.

12. A system as recited in claim 11, wherein the particular owner or one or more designates of the particular owner may set different levels of access to information in the database associated with the particular owner to each user.

13. A system as recited in claim 11, wherein each entry for a user further includes a function of a user password, and wherein the remote terminal is configured to

accept a user password or other credentials, or both a password and other credentials provided by a user, and the system is configured to:

identify the user using said password or other credentials, or both a password and other credentials; and

provide access according to successfully identifying the user as one in the list of users and providing access according to the identity of one or more of the owners associated with the identified user in the case that the identified user is associated with at least one owner.

14. A system as recited in claim 5, wherein at least one owner is associated with one or more respective workspaces, each workspace containing data of the database that is associated with the workspace owner, wherein each BOM may belong to a workspace, and wherein each BOM data structure entry includes an indication of the workspace of the BOM.

15. A system as recited in claim 14, wherein the database includes, for each workspace, a private list of elements associated with the owner of the workspace.

16. A system as recited in claim 15, wherein each element in a private list of elements includes a reference to a corresponding element in the list of elements, such that the list of elements includes the elements in any private lists of elements, and elements that are in one or more BOMs that are associated with different owners.

17. A system as recited in claim 15,

wherein each element in a private list of elements includes a unique identifier within the private list of elements and a reference to a corresponding element in the list of elements,

such that two elements in two different private lists of elements that refer to the same one element in the list of elements may each have a different unique identifier in the respective private lists.

18. A system as recited in claim 5, wherein the database includes a list of vendors to provide data related to vendors for one or more elements of the element list.

19. A system as recited in claim 18, wherein the vendor list includes for one or more of the vendors, vendor identification data including one or more of a vendor name, vendor contact information, and a vendor identification number.

20. A system as recited in claim 18, wherein the vendor element relations list further includes information about the quantity of each element that the vendor of the element can supply.

21. A system as recited in claim 18, wherein the database includes a vendor element relations list that includes data relating one or more elements of the element list to one or more corresponding vendors of the vendor list such that the vendor element relations list provides the sourcing relationship between an element in the element list and a vendor in the of vendor list.

22. A system as recited in claim 21, wherein one or more users may be associated with a vendor in the vendor list, and wherein the system is further configured to a particular user associated with a particular vendor access to information about an element in the element list that is sourced by the particular vendor.

23. A system as recited in claim 21, wherein the level of access provided to the particular user associated with the particular vendor is set by the owner associated with the particular element or one or more designates of the owner.

24. A computer implemented method for managing a plurality of bills of material (BOMs) comprising:

a computer system accepting information for a particular BOM, the computer system being coupled to a network;

sending the information over the network to a server processing system also coupled to the network, the server processing system having stored therein a plurality of BOMs, including the particular BOM, each BOM describable as a tree with each node an element, each element in each BOM having an owner of a set of more than one owner, and each BOM having an owner of the set of owners, the particular BOM having a particular owner, the client terminal coupled to a network, the server processing system being configured to provide access to at least some of the information of one or more of the plurality of BOMs to one or more users according to control information, control information for providing access to a particular BOM being received from an entity that is the owner of the particular BOM, or from any entity that the owner of the BOM designates, or from both the entity that is the owner and any entity that the owner of the BOM designates, such that the providing of further access to at least some of the information of a particular BOM is controlled by the entity that is the owner of the particular BOM, or by any entity that the owner of the BOM designates, or by both the entity that is the owner and any entity that the owner of the BOM designates,

such that BOMs associated with different owners are stored in the same processing system,

wherein for each of at least two different owners, at least one of the BOMs of the respective owner includes confidential information of the owner, such that unrestricted access to the confidential information is limited to the owner of the BOM, or to any entity that the owner of the BOM designates, or to both the owner of the BOM and any entity that the owner of the BOM designates; and

wherein the different owners need not be related except that they each have information stored in the same processing system.

25. A computer implemented method as recited in claim 24, wherein the network coupling the computer system to the server processing system includes a link via a public network.

26. A computer implemented method as recited in claim 25, wherein the public network is the Internet.

27. A computer implemented method as recited in claim 24, wherein the plurality of BOMS is stored in the server processing system as one or more BOM data structures in a database, and wherein the database further includes a list of elements, one or more of the elements being for inclusion in one or more of the plurality of BOMs.

28. A computer implemented method as recited in claim 27, wherein each of one or more elements in the element list is associated with a respective owner of the set of owners, wherein the list of elements includes an indication of ownership for each element associated with one of the owners, and wherein the server processing system is further configured such that access to information about a particular element in the element list that is associated with a particular owner may be restricted to the particular owner or to one or more designates of the particular owner, or to both the particular owner and one or more designates of the particular owner.

29. A computer implemented method as recited in claim 28,

wherein each element has a unique identifier,

wherein the database further includes a list of owners in the set of owners, each owner having an entry including a unique owner identifier in the list of owners, and

wherein the providing access to one or more users includes providing access to one or more elements of information in the database, the access being remote from the server processing system, the remote access provided according to the control information.

30. A computer implemented method as recited in claim 28, wherein the database is arranged such that a first BOM of a first owner may share one or more elements of the list of elements with a second BOM of a second owner.

31. A computer implemented method as recited in claim 28, wherein an element in the element list is one of the set consisting of a physical element and a process,

wherein the physical element may itself be represented by a BOM, and

wherein the process may reference a set of steps or operations.

32. A computer implemented method as recited in claim 28, wherein each BOM data structure is for storing the parent-child relationships for at least one BOM of the plurality of BOMs, and wherein a BOM data structure includes, for a particular BOM, an entry for each element in the particular BOM, said element entry including a reference to the element'"'"'s entry in the list of elements, an entry indicating the owner, and an entry indicating any child of the element in the case the element has a child in the tree representing the particular BOM.

33. A computer implemented method as recited in claim 32, wherein the parent child relationships for all the BOMS are stored in a single BOM data structure.

34. A computer implemented method as recited in claim 28, wherein the database further includes a list of users, each user having an entry in the list of users that includes a unique user identifier in the list of users, each user possibly being associated with one or more of the owners.

35. A computer implemented method as recited in claim 34, wherein the particular owner or one or more designates of the particular owner may set different levels of access to information in the database associated with the particular owner.

36. A computer implemented method as recited in claim 34, wherein each entry for a user further includes a function of a user password, and wherein the remote terminal is configured to accept a user password or other credentials, or both a password and other credentials provided by a user, and the server processing system is configured to:

identify the user using said password or other credentials, or both a password and other credentials; and

provide access according to successfully identifying the user as one in the list of users and providing access according to the identity of one or more of the owners associated with the identified user in the case that the identified user is associated with at least one owner.

37. A computer implemented method as recited in claim 28, wherein at least one owner is associated with one or more respective workspaces, each workspace containing data of the database that is associated with the workspace owner, wherein each BOM may belong to a workspace, and wherein each BOM data structure entry includes an indication of the workspace of the BOM.

38. A computer implemented method as recited in claim 37, wherein the database includes, for each workspace, a private list of elements associated with the owner of the workspace.

39. A computer implemented method as recited in claim 38, wherein each element in a private list of elements includes a reference to a corresponding element in the list of elements, such that the list of elements includes the elements in any private lists of elements, and elements that are in one or more BOMs that are associated with different owners.

40. A computer implemented method as recited in claim 38,

wherein each element in a private list of elements includes a unique identifier within the private list of elements and a reference to a corresponding element in the list of elements,

such that two elements in two different private lists of elements that refer to the same one element in the list of elements may each have a different unique identifier in the respective private lists.

41. A computer implemented method as recited in claim 28, wherein the database includes a list of vendors to provide data related to vendors for one or more elements of the element list.

42. A computer implemented method as recited in claim 41, wherein the vendor list includes for one or more of the vendors, vendor identification data including one or more of a vendor name, vendor contact information, and a vendor identification number.

43. A computer implemented method as recited in claim 41, wherein the vendor element relations list further includes information about the quantity of each element that the vendor of the element can supply.

44. A computer implemented method as recited in claim 41, wherein the database includes a vendor element relations list that includes data relating one or more elements of the element list to one or more corresponding vendors of the vendor list such that the vendor element relations list provides the sourcing relationship between an element in the element list and a vendor in the of vendor list.

45. A computer implemented method as recited in claim 44, wherein one or more users may be associated with a vendor in the vendor list, and wherein the server processing system is further configured to a particular user associated with a particular vendor access to information about an element in the element list that is sourced by the particular vendor.