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

• US 7,610,312 B1
• Filed: 05/17/2007
• Issued: 10/27/2009
• 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, Larkin, Eric, Topolovac, Michael
• Primary Examiner(s): Trujillo; James
• Assistant Examiner(s): Spieler; William
• Application Number:
  US11/750,254
• Time in Patent Office: 894 Days
• Field of Search: 707/1, 707/9, 707/100, 707/102, 707/104.1
• US Class Current: 1/1
• 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 computer implemented method for storing and managing a plurality of bills of material (BOMs) comprising:

accepting information for 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;

storing the plurality of BOMs in a database in a processing system; and

providing 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 and/or 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 and/or by 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 and/or to 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 method as recited in claim 1, wherein the BOMs are stored remotely, and wherein access to the BOMs is provided remotely.

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

storing one or more data structures in the processing system for storing 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.

4. A method as recited in claim 3, further comprising:

providing unrestricted access to any confidential information in a particular stored BOM only to the owner associated with the particular BOM and to none or more designates of the owner.

5. A method as recited in claim 3, wherein each of one or more elements in the element list is associated with a respective owner of the 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 the particular owner and none or more designates of the particular owner.

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

accepting information for a database, the database including;

a list of elements, each element having a unique identifier, one or more elements of the list of elements being for inclusion in one or more of the plurality of BOMs; and

one or more data structures for storing the plurality of BOMs, each BOM describable as a tree with each node an element of the list of elements, at least two of the BOMs being associated with different respective owners of a set of owners;

storing the database in a processing system; and

providing remote access to one or more elements of information in the database to one or more users according to control information, control information for providing access to elements of a particular BOM being received from an entity that is the owner of the particular BOM and/or 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 and/or by any entity that the owner of the BOM designates,

such that the database is arranged to contain BOMs associated with different owners,

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 and any designates of the owner of the BOM, and

wherein the different owners need not be related other than in that they each have information 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 the 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 the particular owner and none or more designates of the particular owner.

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

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

accepting information for a database, the database including;

a list of elements, each element having a unique identifier, one or more of the elements being for inclusion in at least one of the BOMs; and

one or more BOM data structures for storing the plurality of BOMs, each BOM describable as a tree with each node an element of the list of elements and each branch of the tree defining a parent-child relationship, the one or more BOM data structures storing information on the parent-child relationships of the plurality of BOMs, two or more of the BOMs associated with a respective owner of a set of owners;

storing the database in a processing system; and

providing remote access to one or more elements of information in the database to one or more users according to control information, control information for providing access to elements of a particular BOM being received from an entity that is the owner of the particular BOM and/or 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 and/or by any entity that the owner of the BOM designates,

such that the database is arranged to contain BOMs having different owners,

wherein the database includes confidential information of at least two of the owners such that unrestricted access to the confidential information is limited to the respective owner of the confidential information and any designates of the owner, and

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

10. A method as recited in claim 9, wherein a BOM of a particular owner includes confidential information, and wherein the confidential information of the particular owner includes the BOM confidential information.

11. A method as recited in claim 9, wherein providing remote access includes providing remote access via a public network.

12. A method as recited in claim 11, wherein the public network is the Internet.

13. A method as recited in claim 9, 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 a 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 the particular owner and none or more designates of the particular owner.

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

15. A method as recited in claim 9, wherein each element in the element list is one 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.

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

17. A method as recited in claim 16, wherein the parent child relations for all the BOMs are stored in a single BOM data structure.