Method, apparatus, and product to associate computer aided design data and bill of materials data

• US 6,999,965 B1
• Filed: 04/10/2002
• Issued: 02/14/2006
• Est. Priority Date: 04/10/2001
• Status: Expired due to Term

• Current Assignee: Arena Solutions, Inc
• Original Assignee: Arena Solutions, Inc
• Inventors: Larkin, Eric, Topolovac, Michael, Cesarotti, William A.
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US10/120,897
• Time in Patent Office: 1,406 Days
• Field of Search: 707/100, 707/101, 707/104.1, 707/10, 705/28, 705/29
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

A method of associating CAD data of an item with an item in a bill of material (BOM). The BOM is stored remotely in a database containing BOMS, not necessarily having the same owner. The method includes for a selected item collecting data from the CAD data of the item, formatting the collected data for transfer, transferring the formatted collected data to a remote location from where the BOM database is accessible, retrieving matching BOM items from a database containing one or more BOMs, comparing the BOM data of the matching items with the corresponding collected transfer data to obtain a match, and associating the matched BOM item with the CAD data of the item. The BOM uniquely identifies items using a unique identifier, and the associating is by attaching to the CAD data of the item the unique identifier used in the BOM database for the item.

Claims

1. A computer-implemented method of associating CAD data of an item with a corresponding BOM item in a particular bill of material (BOM) stored with at least one other BOM, the CAD data of the item including CAD information, the method comprising:

collecting the CAD information from the CAD data of the item;

securely transferring the collected CAD information;

retrieving matching data of the corresponding BOM item in the particular BOM from a BOM database containing at least two BOMs, including the particular BOM;

comparing the BOM retrieved matching data with the corresponding collected transferred CAD information to ascertain if there is a match between the CAD data information and the retrieved matching data; and

in the case a match is obtained, associating the particular BOM item with the CAD data of the item,

wherein each BOM is describable as a tree with each node a BOM item, wherein each BOM has an owner, and wherein the particular BOM and at least one other BOM stored in the BOM database with the particular BOM have different owners.

2. A method as recited in claim 1, wherein each BOM has a set of items, and each item in any BOM has a unique identifier in the BOM database, wherein in the case of a match, the associating of the particular BOM item includes associating the unique identifier of the item with the CAD data.

3. A computer-implemented method comprising:

associating CAD data of at least one item with a BOM item of at least one or more bills of material (BOMs) in a BOM database stored in a processing system, the BOM database arranged for storing a plurality of BOMs, each BOM describable as a tree with each node a BOM item, each BOM item in the BOM database having a unique identifier; and

providing remote access to one or more elements of information in the BOM database to one or more users,

wherein at least one BOM item in at least one of the BOMs is associated with an owner of a set of owners, and wherein two or more of the BOMs are associated with a respective owner of the set of owners,

such that the database may contain BOMs associated with different respective owners.

4. A method as recited in claim 3, wherein the CAD data is stored remotely from the BOM database.

5. A method as recited in claim 3, wherein more than one set of CAD data exists for a particular item, the method including associating each set of data of the particular item with the one related BOM item in at least one BOM, such that the one BOM item is associated to more than one different CAD data sets for associated item.

6. A method as recited in claim 3, further comprising re-associating CAD data of a particular item when one or more conditions are met.

7. A method as recited in claim 6, wherein the one or more conditions include at least one member of the set consisting of:

a settable amount of time has passed since the CAD data of the particular item was last associated,

the CAD data of the particular item is saved, and

the CAD data of the particular item is backed up.

8. A method as recited in claim 3, further comprising automatically updating the BOM data of a particular BOM item in the BOM database when at least some of the CAD data for the item associated with the particular BOM item is modified.

9. A method as recited in claim 3, wherein the associating of a particular BOM item includes adding information in the data in the BOM database for the BOM item about the associated CAD data of the particular BOM item.

10. A method as recited in claim 9, wherein the added information includes one or more of the identifier for the associated CAD data.

11. A method as recited in claim 9, wherein the added information includes a link to associated CAD data.

12. A method as recited in claim 9, wherein the adding information in the data in the BOM database includes securely transferring the information to be added in the data in the BOM database.

13. A method as recited in claim 3, wherein associating the CAD data of a particular item includes providing a mapping of one or more CAD data fields for the item to the corresponding data fields for the associated item in the BOM that includes the item.

14. A method as recited in claim 13, wherein associating the mapping includes mapping the CAD identifier to the unique identifier of the associated item in the BOM database, such that the BOM data for an item is available to a user of the CAD data.

15. A method as recited in claim 14, further comprising securely moving CAD data about an item to be available to a user of the BOM database such that accessing the BOM data about a particular item provides access to the moved CAD data about the associated item to a user of the BOM data.

16. A method as recited in claim 13, wherein the mapping from the CAD data fields to the corresponding BOM data fields is attached to the CAD data of the particular item.

17. A method as recited in claim 16, wherein the mapping attached to the CAD data of the particular item is in the form of a meta-tag.

18. A method as recited in claim 17, wherein the meta-tag includes an identification key for the unique identifier for the particular item in the BOM data.

19. A method as recited in claim 18, wherein the meta-tag further includes one or more of the set consisting of version information, modification date/time data, location data, and user information data.

20. A method as recited in claim 13, wherein one of the corresponding BOM data fields is the unique identifier used in the BOM for a particular item, and wherein the unique identifier used in the BOM for the particular item is attached to the CAD data of the particular item such that the BOM data related to an item is made available to CAD data for the item.

21. A method as recited in claim 3, wherein the CAD data of at least one item is in a CAD part list such that one or more items in a CAD part list are associated with items in one or more BOMs.

22. A method as recited in claim 21, wherein the associating for a particular item in a part list provides a user accessing the CAD data access to the BOM data of the item that the particular item is associated with in one or more BOMS.

23. A method as recited in claim 3, wherein the associating of a particular CAD item includes:

collecting CAD information on the item from the CAD data of the item for secure transfer.

24. A method as recited in claim 23, wherein the collecting is carried out when one or more conditions are met.

25. A method as recited in claim 23, wherein the associating of a particular CAD item includes:

securely transferring the collected CAD information for matching with BOM data in the BOM database;

identifying matching information in the transferred information;

comparing the matching information in the transferred information with the corresponding BOM data to obtain a match; and

associating the matched BOM item with the CAD data of the item.

26. A method as recited in claim 25, further comprising:

formatting the collected CAD information for transfer if required prior to secure transfer.

27. A method as recited in claim 25, wherein the associating the matched BOM item includes securely transferring data to the CAD data.

28. A method as recited in claim 25, wherein the associating of the matched BOM item includes associating the unique identifier of the item in the database containing the BOMs with the CAD data.

29. A method as recited in claim 25, wherein in the case the comparing leads to more than one match, the method further comprises:

presenting information on the matching BOM items to the user such that the user can select one or more matched BOM item for association with the CAD data item.

30. A method as recited in claim 3, wherein the at least one item is a standard part that may be re-used.

31. A computer-implemented method comprising:

comparing one or more features of an item to find matching existing items in one or more of CAD data and in a BOM database, the CAD data for each existing item associated with an existing item in the BOM database, the BOM database storing one or more bills of material (BOMs), each BOM describable as a tree with each node an item, each item in the BOM database having a unique identifier, the BOM database stored remotely from the CAD data;

wherein the BOM database is for storing a plurality of BOMs, wherein at least one item in at least some of BOMs is associated with an owner of a set of owners, and wherein two or more of the BOMs are associated with a respective owner of the set of owners, such that the database may contain BOMs associated with different respective owners.

32. A method as recited in claim 31, wherein the comparison is based on features that include one or more features stored in the BOM database.

33. A method as recited in claim 31, wherein the comparison is based on features that include one or more features stored with the CAD data.

34. A method as recited in claim 31, wherein the comparison includes comparing date information in the CAD data with data in the BOM database.

35. A method as recited in claim 34, wherein the comparing date information requires no user intervention.

36. A method as recited in claim 31, further comprising securely transferring data associated with the CAD data from the BOM database.

37. A carrier medium carrying one or more computer readable code segments to instruct one or more processors of a processing system to implement a method comprising:

associating CAD data of at least one item with an item of at least one or more bills of material (BOMs) in a BOM database stored in a processing system, the BOM database arranged for storing a plurality of BOMs, each BOM describable as a tree with each node an item, each item in the BOM database having a unique identifier; and

providing remote access to one or more items of information in the BOM database to one or more users,

wherein at least one item in at least some of BOMs is associated with an owner of a set of owners, and wherein two or more of the BOMs are associated with a respective owner of the set of owners,

such that the database may contain BOMS associated with different respective owners.

38. A carrier medium as recited in claim 37, wherein more than one set of CAD data exists for a particular item, the method including associating each set of data of the particular item with the one related item in at least one BOM, such that the one BOM item is associated to more than one different CAD data sets for associated item.

39. A carrier medium as recited in claim 37, wherein the associating of a particular item includes adding information in the data in the BOM database for the item about the associated CAD data of the particular item.

40. A carrier medium as recited in claim 37, wherein associating the CAD data of a particular item includes providing a mapping of one or more CAD data fields for the item to the corresponding data fields for the associated item in the BOM that includes the item.

41. A carrier medium as recited in claim 40, wherein associating the mapping includes mapping the CAD identifier to the unique identifier of the associated item in the BOM database, such that the BOM data for an item is available to a user of the CAD data.

42. A carrier medium as recited in claim 37, wherein the associating of a particular CAD item includes:

collecting CAD formation of the item from the CAD data of the item for secure transfer.

43. A carrier medium as recited in claim 42, wherein the associating of a particular CAD item includes:

securely transferring the collected CAD information for matching with BOM data in the BOM database;

identifying matching information in the transferred information;

comparing the matching information in the transferred information with the corresponding BOM data to obtain a match; and

associating the matched BOM item with the CAD data of the item.

44. An apparatus comprising:

means for storing a BOM database, the BOM database arranged for storing a plurality of bills of material (BOMs), each BOM describable as a tree with each node an item, each item in the BOM database having a unique identifier

means for associating CAD data of at least one item with an item of at least one or more BOMs in the BOM database; and

means for providing remote access to one or more items of information in the BOM database to one or more users,

wherein at least one item in at least some of BOMs is associated with an owner of a set of owners, and wherein two or more of the BOMs are associated with a respective owner of the set of owners,

such that the database may contain BOMs associated with different respective owners.

45. An apparatus as recited in claim 44, wherein more than one set of CAD data exists for a particular item, the apparatus including means for associating each set of data of the particular item with the one related item in at least one BOM, such that the one BOM item is associated to more than one different CAD data sets for associated item.

46. An apparatus as recited in claim 44, wherein the means for associating a particular item includes means for adding information in the data in the BOM database for the item about the associated CAD data of the particular item.

47. An apparatus as recited in claim 44, wherein the means for associating the CAD data of a particular item includes means for providing a mapping of one or more CAD data fields for the item to the corresponding data fields for the associated item in the BOM that includes the item.

48. An apparatus as recited in claim 47, wherein the means for associating the mapping includes means for mapping the CAD identifier to the unique identifier of the associated item in the BOM database, such that the BOM data for an item is available to a user of the CAD data.

49. An apparatus as recited in claim 44, wherein the means for associating a particular CAD item includes:

means for collecting CAD information on the item from the CAD data of the item for secure transfer.

50. An apparatus as recited in claim 49, wherein the means for associating a particular CAD item includes:

means for securely transferring the collected CAD information for matching with BOM data in the BOM database;

means for identifying matching information in the transferred information;

means for comparing the matching information in the transferred information with the corresponding BOM data to obtain a match; and

means for associating the matched BOM item with the CAD data of the item.