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

• US 8,103,694 B1
• Filed: 06/08/2009
• Issued: 01/24/2012
• Est. Priority Date: 04/10/2000
• Status: Expired due to Fees

• Current Assignee: Arena Solutions, Inc (PTC Inc.)
• Original Assignee: Arena Solutions, Inc (PTC Inc.)
• Inventors: Yu, Janet, Topolovac, Michael, Larkin, Eric
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US12/480,595
• Time in Patent Office: 960 Days
• Field of Search: 707/999.009, 707/705, 707/764, 707/770, 707/783, 707/785, 707/786, 705/29, 705/28
• US Class Current: 707/786
• 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 method of storing and managing BOMs of different owners in the same environment. One or more BOMs have an owner. An owner'"'"'s BOM may include confidential information such that unrestricted access to the confidential information is limited to the owner and any designates of the owner. In particular, one embodiment of the invention maintains a list of items that include the items in the BOMs of the different owners. A unique identifier is used for each item of the list. The item identifiers thus form one namespace. BOMs of different owners share data including confidential data within the same namespace.

Claims

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

storing the plurality of BOMs in the processing system, each BOM including information describable as a tree with each node an element, each element in each BOM associated with an owner of a set of owners, each BOM associated with an owner of the set of owners;

providing access to at least some of the information of one or more of the plurality of BOMs, the providing access to information in a particular BOM controlled by at least one of;

the owner of the BOM, and any entity or user designated by the owner of the BOM,

such that BOMS associated with at least two different owners are stored in the same processing system, wherein the at least two different owners need not be related except that the different owners each have information stored in the same processing system.

2. A method as recited in claim 1, wherein at least one of the BOMs includes confidential information of the owner of the BOM such that that unrestricted access to the confidential information is limited to at least one of:

the owner, and any entity or user designated by the owner of the BOM.

3. A method as recited in claim 1, wherein the BOMs are stored remotely, and wherein access to the BOMs is provided remotely.

4. A method as recited in claim 1, wherein the BOMs are stored remotely, and wherein access to the BOMs is provided remotely via the Internet.

5. A method as recited in claim 1, wherein the processing system is a distributed system.

6. A method as recited in claim 1, wherein the storing of the BOMs includes:

storing one or more data structures in the processing system to store the plurality of BOMs,

the method further comprising;

storing a list of elements in the processing system, each element in the list of elements having a unique element identifier, each element in each BOM being one of the elements in the list of elements,

such that the list of elements and the one or more data structures are part of a database stored in the same processing system.

7. A method as recited in claim 6, wherein one or more elements in the element list are associated with a respective owner of a set of owners, and wherein the list of elements includes an indication of ownership for each element associated with one of the owners, the method further comprising:

restricting access to information about a particular element in the element list that is associated with a particular owner to at least one of;

the particular owner, and any entity or user designated by the particular owner.

8. A method as recited in claim 6, wherein 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.

9. A method as recited in claim 6,

wherein 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 confidential information of an owner that owns an element in the list of elements includes confidential information in the list of elements,

such that unrestricted access to confidential information about a particular element in the element list that is associated with a particular owner is limited at least one of;

to the particular owner, and any entity or user designated by the particular owner.

10. A method as recited in claim 6,

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 a BOM, and

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

11. A method as recited in claim 6, 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.

12. A method as recited in claim 11, wherein the parent child relationships for all the BOMS are stored in a single BOM data structure.

13. A method as recited in claim 11, wherein the database is a relational database, and wherein the list of elements and the BOM data structure are each a table in the relational database, and wherein the element identifier is a single field in the table of the list of elements forming a primary key for the table of the list of elements.

14. A computer-readable storage medium configured with instructions that, when executed by one or more processors of a processing system, cause carrying out a method for managing a plurality of bills of material (BOMs), the method comprising:

storing the plurality of BOMs in the processing system, each BOM including information describable as a tree with each node an element, each element in each BOM associated with an owner of a set of owners, each BOM associated with an owner of the set of owners;

providing access to at least some of the information of one or more of the plurality of BOMs, the providing access to information in a particular BOM controlled by one or more of;

the owner of the BOM, and any entity or user designated by the owner of the BOM,

such that BOMS associated with at least two different owners are stored in the same processing system, wherein the at least two different owners need not be related except that the different owners each have information stored in the same processing system.

15. A computer-readable storage medium as recited in claim 14, wherein at least one of the BOMs includes confidential information of the owner of the BOM such that that unrestricted access to the confidential information is limited to one or more of:

the owner, and any entity or user designated by the owner of the BOM.

16. A computer-readable storage medium as recited in claim 14, wherein the BOMs are stored remotely, and wherein access to the BOMs is provided remotely via a network.

17. A computer-readable storage medium as recited in claim 14, wherein the storing of the BOMs includes:

storing one or more data structures in the processing system to store the plurality of BOMs,

the method further comprising;

storing a list of elements in the processing system, each element in the list of elements having a unique element identifier, each element in each BOM being one of the elements in the list of elements,

such that the list of elements and the one or more data structures are part of a database stored in the same processing system.

18. A computer-readable storage medium as recited in claim 17, wherein one or more elements in the element list are associated with a respective owner of a set of owners, and wherein the list of elements includes an indication of ownership for each element associated with one of the owners, the method further comprising:

restricting access to information about a particular element in the element list that is associated with a particular owner to at least one of;

the particular owner, and any entity or user designated by the particular owner.

19. A computer-readable storage medium as recited in claim 17, wherein 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.

20. A computer-readable storage medium as recited in claim 17,

wherein 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 confidential information of an owner that owns an element in the list of elements includes confidential information in the list of elements,

such that unrestricted access to confidential information about a particular element in the element list that is associated with a particular owner is limited to at least one of;

the particular owner, and any entity or user designated by the particular owner.

21. A computer-readable storage medium as recited in claim 17, 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.

22. A computer-readable storage medium as recited in claim 21, wherein the database is a relational database, and wherein the list of elements and the BOM data structure are each a table in the relational database, and wherein the element identifier is a single field in the table of the list of elements forming a primary key for the table of the list of elements.

23. A processing system for managing a plurality of bills of material (BOMs), the processing system comprising:

one or more processors;

a storage subsystem including one or more memory elements;

wherein the storage subsystem is configured with instructions that when executed by at least one or more processors cause;

storing the plurality of BOMs in the processing system, each BOM including information describable as a tree with each node an element, each element in each BOM associated with an owner of a set of owners, each BOM associated with an owner of the set of owners; and

providing access to at least some of the information of one or more of the plurality of BOMs, the providing access to information in a particular BOM controlled by at least one of;

the owner of the BOM, and any entity or user designated by the owner of the BOM,

such that BOMS associated with at least two different owners are stored in the same processing system, wherein the at least two different owners need not be related except that the different owners each have information stored in the same processing system.

24. A processing system as recited in claim 23, wherein at least one of the BOMs includes confidential information of the owner of the BOM such that that unrestricted access to the confidential information is limited to at least one of:

the owner, and any entity or user designated by the owner of the BOM.

25. A processing system as recited in claim 23, wherein the BOMs are stored remotely, and wherein access to the BOMs is provided remotely via a network.

26. A processing system as recited in claim 23, wherein the storing of the BOMs includes:

storing one or more data structures in the processing system to store the plurality of BOMs,

and wherein the instructions when executed further cause;

storing a list of elements in the processing system, each element in the list of elements having a unique element identifier, each element in each BOM being one of the elements in the list of elements,

such that the list of elements and the one or more data structures are part of a database stored in the same processing system.

27. A processing system as recited in claim 26,

wherein one or more elements in the element list are associated with a respective owner of a set of owners, and wherein the list of elements includes an indication of ownership for each element associated with one of the owners, and

wherein the instructions when executed further cause:

restricting access to information about a particular element in the element list that is associated with a particular owner to at least one of the particular owner, and any entity or user designated by the particular owner.

28. A processing system as recited in claim 26, wherein 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.

29. A processing system as recited in claim 26,

wherein 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 confidential information of an owner that owns an element in the list of elements includes confidential information in the list of elements,

such that unrestricted access to confidential information about a particular element in the element list that is associated with a particular owner is limited to at least one of:

the particular owner, and any entity or user designated by the particular owner.

30. A processing system as recited in claim 26, 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.

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

32. A processing system as recited in claim 30, wherein the database is a relational database, and wherein the list of elements and the BOM data structure are each a table in the relational database, and wherein the element identifier is a single field in the table of the list of elements forming a primary key for the table of the list of elements.

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

a client terminal accepting information for a particular BOM, the particular BOM being one of a plurality of BOMS, each BOM including information describable as a tree with each node an element, each element in each BOM associated with an owner of a set of owners, each BOM associated with 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, the providing access to information in a particular BOM controlled by at least one of;

the owner of the BOM, and any entity or user designated by the owner of the BOM,

such that BOMS associated with at least two different owners are stored in the same processing system, wherein the at least two different owners need not be related except that the different owners each have information stored in the same server processing system.

34. A system as recited in claim 33, wherein at least one of the BOMs includes confidential information of the owner of the BOM such that that unrestricted access to the confidential information is limited to at least one of:

the owner, and any entity or user designated by the owner of the BOM.

35. A system as recited in claim 33, 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.

36. A system as recited in claim 35, 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 to restrict access to information about a particular element in the element list that is associated with a particular owner to at least one of:

the particular owner, and to one or more designates of the particular owner.

37. A system as recited in claim 36,

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.

38. A system as recited in claim 36, 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.

39. A system as recited in claim 36, 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.

40. A system as recited in claim 36, 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.

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

42. A system as recited in claim 36, 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, and 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.

43. A system as recited in claim 42, 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.

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

45. A system as recited in claim 44, 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 vendor list.

46. A system as recited in claim 45, 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.

47. A system as recited in claim 45, wherein a level of access is provided to the particular user associated with the particular vendor and is set by at least one of:

the owner associated with the particular element, and one or more designates of the owner.

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

accepting in a computer system information for a particular BOM, the particular BOM being one of a plurality of BOMS, each BOM including information describable as a tree with each node an element, each element in each BOM associated with an owner of a set of owners, each BOM associated with an owner of the set of owners, the particular BOM having a particular owner, the computer system being coupled to a network;

sending by the computer system of the information over the network to a server processing system also coupled to the network, the server processing system having stored therein the plurality of BOMs, including the particular BOM, the server processing 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, the providing access to information in a particular BOM controlled by at least one of;

the owner of the BOM, and any entity or user designated by the owner of the BOM,

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

such that BOMS associated with at least two different owners are stored in the same processing system, wherein the at least two different owners need not be related except that the different owners each have information stored in the same server processing system.

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

50. A computer implemented method as recited in claim 48, wherein at least one of the BOMs includes confidential information of the owner of the BOM such that that unrestricted access to the confidential information is limited to at least one of:

the owner, and any entity or user designated by the owner of the BOM.

51. A computer implemented method as recited in claim 48, 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.

52. A computer implemented method as recited in claim 51, 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 to restrict access to information about a particular element in the element list that is associated with a particular owner to at least one of:

the particular owner, and to one or more designates of the particular owner.

53. A computer implemented method as recited in claim 52,

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.

54. A computer implemented method as recited in claim 52, 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.

55. A computer implemented method as recited in claim 52, 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.

56. A computer implemented method as recited in claim 52, 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.

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

58. A computer implemented method as recited in claim 52, 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, and 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.

59. A computer implemented method as recited in claim 52, 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, and 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.

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

61. A computer implemented method as recited in claim 60, 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, and 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 vendor list.

62. A computer implemented method as recited in claim 61, 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.

63. A computer implemented method as recited in claim 61, wherein a level of access is provided to the particular user associated with the particular vendor and is set by at least one of:

the owner associated with the particular element, and one or more designates of the owner.