Representing Bill of Material and Where-Used Product Structure Data Using an ISAM Data Base With Two Indices
Original Publication Date: 1988-Nov-01
Included in the Prior Art Database: 2005-Feb-15
A technique is described to represent bills of material using an Indexed Sequential Access Method (ISAM) data base as opposed to building a tree structure in memory. Using the same data base, but with a different index (derived from the bill of material index), where-used information can be easily retrieved. (Image Omitted) Assume that a product called part number A in Fig. 1 consists of three parts: B, C, and D. Further assume that parts B and D are also assemblies made up of other parts. B is made up of J and D; and D is made up of F, G, and H. Notice that the part number D is found in the "tree" structure in more than one place. Finally, part G is made up of parts H and I.