Method and apparatus for publishing part datasheets

• US 6,484,182 B1
• Filed: 06/11/1999
• Issued: 11/19/2002
• Est. Priority Date: 06/12/1998
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: MacDonald, Josh, Dunphy, Betsy D., Evart, Louis, Lund, George, Rogers, Jim L.
• Primary Examiner(s): Rones, Charles L.
• Assistant Examiner(s): PARDO, THUY N
• Application Number:
  US09/330,805
• Time in Patent Office: 1,257 Days
• Field of Search: 707/2, 707/3, 707/100, 707/5, 707/201, 707/515, 707/101, 707/102, 707/104, 705/2, 705/7, 705/26, 705/500, 395/701, 700/231
• US Class Current: N/A
• CPC Class Codes: G06F 16/9024 Graphs; Linked lists G06F16/9027 takes precedence
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing
• CPC Class Codes: G06Q 99/00 Subject matter not provided for in other groups of this subclass
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A method and apparatus are provided for publishing part datasheets. A part characterization database is created, and the technical characteristics of parts in the database are ascertained. In addition to parts, part groups are created based on common technical characteristics of parts, and a database tree is created based on the technical characteristics of parts and part groups. A publishing interface coupled to the part characterization database is provided for coupling a publishing tool to the part characterization database so as to provide context to the technical characteristics of one or more parts characterized within the part characterization database. A computer program product also is provided for publishing part datasheets. The computer program product comprises means for creating the part characterization database, means for ascertaining the technical characteristics of parts in the database and means for creating part groups based on common technical characteristics of parts. The computer readable medium also comprises means for creating a database tree based on the technical characteristics of parts and part groups and means for providing a publishing interface for coupling a publishing tool to the part characterization database so as to provide context to the technical characteristics of one or more parts characterized within the part characterization database.

Claims

1. A method for publishing part datasheets comprising the steps of:

creating a parts classification database;

ascertaining the technical characteristics of parts in the database;

creating part groups based on common technical characteristics of parts;

linking each part to the identifying characteristics of each part, said linking comprising associating each part with one or more part groups that each part belongs to;

creating a database tree based on the technical characteristics of parts; and

providing a presentation table database linked to the technical characterization and part groups which provides context to the technical characteristics and part group accessing the database tree through a part'"'"'s technical characterization.

2. The method of claim 1, wherein creating a database tree comprises creating the database tree such that nodes of the database tree are organized according to parent-child hierarchical relationships between the technical characterizations and such that identifying characteristics of a child tree node include the identifying characteristics of a parent tree node.

3. A method for publishing part datasheets comprising the steps of:

creating a part characterization database;

ascertaining the technical characteristics of parts in the database;

creating part groups based on common technical characteristics of parts;

linking each part to the identifying characteristics of each part, said linking comprising associating each part with one or more part groups that each part belongs to;

creating a database tree based on the technical characteristics of parts; and

providing a publishing interface coupled to the part characterization database, the publishing interface for coupling a publishing tool to the part characterization database so as to provide context to the technical characteristics of one or more parts characterized within the part characterization database.

4. The method of claim 3 wherein the part characterization database comprises a relational database.

5. The method of claim 3 wherein ascertaining the technical characteristics of parts in the database comprises defining each part within the database by the identifying characteristics of each part.

6. The method of claim 5 further comprising providing one or more parts within the database with one or more non-identifying characteristics.

7. The method of claim 3 wherein creating part groups based on common technical characteristics of parts comprises defining each part group within the database by a set of identifying characteristics.

8. The method of claim 7 further comprising providing one or more part groups within the database with one or more non-identifying characteristics.

9. The method of claim 3 further comprising associating part and part groups with the tree nodes of the database tree.

10. The method of claim 3 wherein providing a publishing interface coupled to the part characterization database comprises providing at least one presentation table which provides context to the technical characteristics of one or more parts characterized within the part characterization database.

11. The method of claim 10 wherein providing at least one presentation table comprises providing a presentation table database having a plurality of user-selectable presentation tables each of which provides context to the technical characteristics of one or more parts characterized within the part characterization database.

12. The method of claim 10 further comprising

providing a publishing tool;

coupling the publishing tool to the part characterization database with the publishing interface; and

generating a part datasheet employing the publishing tool, the publishing interface and the part characterization database.

13. The method of claim 12 wherein generating a part datasheet comprises:

opening an existing part datasheet with the publishing tool;

connecting to the part characterization database with the publishing interface; and

updating at least one presentation table within the part datasheet with technical characteristics from the part characterization database.

14. The method of claim 12 wherein generating a part datasheet comprises:

generating a new part datasheet with the publishing tool;

connecting to the part characterization database with the publishing interface;

accessing part information stored within the part characterization database;

transferring part information from the part characterization database to the publishing tool; and

employing at least one presentation table of the publishing interface to format the retrieved part information within the part datasheet.

15. The method of claim 14 wherein accessing part information stored within the part characterization database comprises;

selecting a part characterized within the part characterization database;

retrieving characteristics for the selected part;

determining all part groups of which the part is a member; and

retrieving characteristics from each part group of which the part is a member.

16. The method of claim 3, wherein creating a database tree comprises creating the database tree such that nodes of the database tree are organized according to parent-child hierarchical relationships between the technical characterizations and such that identifying characteristics of a child tree node include the identifying characteristics of a parent tree node.

17. A computer program product for use in publishing part datasheets comprising:

a medium readable by a computer, the computer readable medium having;

means for creating a part characterization database;

means for ascertaining the technical characteristics of parts in the database;

means for creating part groups based on common technical characteristics of parts;

means for linking each part to the identifying characteristic of each part, said linking comprising associating each part with one or more part groups that each part belongs to;

means for creating a database tree based on the technical characterization of parts; and

means for providing a publishing interface coupled to the part characterization database, the publishing interface for coupling a publishing tool to the part characterization database so as to provide context to the technical characteristics of one or more parts characterized within the part characterization database.

18. The computer program product of claim 17 wherein the means for ascertaining the technical characteristics of part in the database comprises means for defining each part within the database by the identifying characteristics of each part.

19. The computer program product of claim 17 wherein the means for creating part groups based on common technical characteristics of parts comprises means for defining each part group within the data by a set of identifying characteristics.

20. The computer program product of claim 17 wherein the means for providing a publishing interface coupled to the part characterization database comprises means for providing at least one presentation table which provides context to the technical characteristics of one or more parts characterized within the part characterization database.

21. The computer program product of claim 17 wherein the means for determining if a part is a member of a part group.

22. The computer program product of claim 21 wherein the means for determining if a part is a member of a part group comprises:

means for developing a list of all possible identifying characteristics for the part group;

means for determining which identifying characteristics for the part group actually have values;

means for developing a list of values for the part group'"'"'s identifying characteristics;

means for developing a list of identifying characteristics for the part;

means for developing a list of values for the part'"'"'s identifying characteristics; and

means for comparing the two lists of values to determine if the qualifies for membership in the group.

23. The method of claim 17, wherein creating a database tree comprises creating the database tree such that nodes of the database tree are organized according to parent-child hierarchical relationships between the technical characterizations and such that identifying characteristics of a child tree node include the identifying characteristics of a parent tree node.

24. A method of storing characteristics associated with data item within a database comprising:

defining a data item group within the database by a set of identifying characteristics;

providing the data item group with one or more non-identifying characteristics;

defining the data item within the database by a set of identifying characteristics;

assigning the data item as a member of the data item group if the data item has identifying characteristics that match the identifying characteristics of the data item group;

linking each data item to the identifying characteristics of each data item, said linking comprising associating each data item with one or more data item groups that each data item belongs to; and

associating one or more non-identifying characteristics of the data item group with the data item if the data item is a member of the data item group.

25. The method of claim 24 wherein assigning the data item as a member of the data item group if the data item has identifying characteristics that match the identifying characteristics of the data item group comprises:

developing a list of all possible identifying characteristics for the data item group;

determining which identifying characteristics for the data item group actually have values;

developing a list of values for the data item group'"'"'s identifying characteristics;

developing a list of identifying characteristics for the data item;

developing a list of values for the data item'"'"'s identifying characteristics; and

comparing the two lists of values to determine if the data item qualifies for membership in the group.

26. The method of claim 24 wherein the data item comprises a part and wherein the data item group comprises a part group.

27. A computer program product for use in storing characteristics associated with a data item within a database comprising:

a medium readable by a computer, the computer readable medium having;

means for defining a data item group within the database by a set of identifying characteristics;

means for providing the data item group with one or more non-identifying characteristics;

means for defining the data item within the database by a set of identifying characteristic;

means for assigning the data item as a member of the data item group of the data item has identifying characteristics that match the identifying characteristics of the data item group;

means for linking each data to the identifying characteristics of each data item, said linking comprising associating data item with one or more data item groups that each data item belongs to; and

means for associating one or more non-identifying characteristics of the data item group with the data item if the data item is a member of the data item group.

28. The computer program product of claim 27 wherein the means for associating one or more non-identifying characteristics of the data item group with the data item if the data item is a member of the data item group comprises means for supplying one or more non-identifying characteristic of any data item groups of which the data item is a member along with the data item'"'"'identifying characteristics during a query of the database to obtain the characteristics of a data item.

29. The computer program product of claim 27 wherein the data item comprises a part and wherein the data item group comprises a part group.

30. An apparatus adapted to publish part datasheets comprising:

a part characterization database adapted to store technical characteristics of parts, adapted to facilitate creation of part groups based on common technical characteristics of parts, adapted to link each part to the identifying characteristics of each part by associating each part with one or more part groups that each part belongs to, and adapted to facilitate creation of a database tree based on the technical characteristics of parts; and

a publishing interface coupled to the part characterization database and adapted to couple a publishing tool to the part characterization database so sa to provide context to the technical characteristics of one or more parts characterized within the part characterization database.

31. The apparatus of claim 30 wherein each part group within the part characterization database is defined by a set of identifying characteristics.

32. The apparatus of claim 31 wherein one or more part groups within the part characterization database comprises one or more non-identifying characteristics.