Automated logistical relational database support system for engineering drawings and artwork

• US 5,493,679 A
• Filed: 10/29/1993
• Issued: 02/20/1996
• Est. Priority Date: 10/29/1993
• Status: Expired due to Term

• Current Assignee: Raytheon Company (Rtx Corporation)
• Original Assignee: Hughes Aircraft Company (Rtx Corporation)
• Inventors: Brown, Roger L., Merriman, James P., June, Philip J., Harker, Walter R., Baron, Albert D., Virgil, Kenneth W., Zucco, Anthony F.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/146,279
• Time in Patent Office: 844 Days
• Field of Search: 395/600, 395/148, 395/919, 364/486, 364/489
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 706/919 Designing, planning, programming, CAD, CASE
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A process for establishing a relationship between the Logistics Support Analysis Record (LSAR) database and a released engineering drawing database. The process includes establishing several database pointer tables for relating the drawings to appropriate end items, task and subtasks. As a result of the process, Logistics Support Analysis functions can be performed in less time, for less cost and with fewer errors. The query aspects of the LSAR database can be used to relate specific hardware to its maintenance procedures, special tool requirements and special handling equipment. Source engineering documents are related to publications art, and engineering drawings are related to task/subtask. The process facilitates automated change notification procedures.

Claims

1. A method for storing engineering drawings and artwork in a logistical relational database for subsequent retrieval and use, the logistical relational database holding data regarding hardware items and one or more work tasks involving the operation or maintenance of the hardware items, the method comprising the following steps:

creating one or more engineering drawings of a given hardware item on a computer aided design (CAD) system, and storing said one or more engineering drawings in CAD system memory in a drawing CAD file, wherein said CAD system memory and said drawing CAD file is not accessible to said relational database;

using said stored one or more engineering drawings to prepare artwork regarding said given hardware item on said CAD system and storing said artwork in CAD system memory in an artwork CAD file, wherein said artwork CAD file is not accessible to said relational database;

transforming said drawing CAD file and said artwork CAD file into a digital data graphics drawing file and a digital data graphics artwork file, wherein a format of said digital data graphics drawing and artwork files is specified by requirements of said relational database;

providing access to said logistical relational database;

transferring into one or more tables comprising said relational database digital data representing an image of said one ore more engineering drawings of said given hardware item, said digital data comprising said digital data graphics drawing file, and digital data representing an image of said artwork and comprising said digital data graphics artwork file;

preparing control files specifying control data regarding said stored one or more engineering drawings and said artwork to be added to files comprising said relational database; and

adding said control data to pointer tables comprising said database, said control data specifying a relationship between said artwork and a corresponding engineering drawing, a relationship between said artwork and a corresponding task or subtask, and a relationship between said engineering drawing and a corresponding task or subtask.

2. The method of claim 1 wherein said pointer tables comprises a pointer table containing data defining images of said engineering drawing, wherein said data from said engineering drawing graphics file is transferred to said pointer table.

3. The method of claim 1 wherein said pointer tables comprise a pointer table containing data providing a cross-reference between engineering drawing numbers and part numbers associated with said hardware item.

4. The method of claim 1 wherein said pointer tables comprise a pointer table containing data defining said artwork images.

5. The method of claim 1 wherein said pointer tables comprise a pointer table comprising data providing a cross-reference between said artwork and corresponding engineering drawings.

6. The method of claim 1 wherein said pointer tables comprise a pointer table comprising data providing a cross-reference between engineering drawings and corresponding subtasks regarding said hardware item.

7. The method of claim 1 wherein said pointer tables comprise a pointer table comprising data providing a cross-reference between artwork and corresponding subtasks regarding said hardware item.

8. The method of claim 1 wherein said relational database complies with MIL-STD-1388-2B.

9. A method for storing engineering drawings and artwork in a logistical relational database for subsequent retrieval and use, the logistical relational database holding data regarding hardware items and one ore more work tasks involving the operation of maintenance of the hardware items, the method comprising the following steps:

creating one or more engineering drawings of a given hardware item on a computer aided design (CAD) system, and storing said one or more engineering drawings in CAD system memory in a drawing CAD file, wherein said CAD system memory and said drawing CAD file is not accessible to said relational database;

using said stored one or more engineering drawings to prepare artwork regarding said given hardware item on said CAD system and storing said artwork in CAD system memory in an artwork CAD file, wherein said artwork CAD file is not accessible to said relational database;

transforming said drawing CAD file and said artwork CAD file into a digital data graphics drawing file and a digital data graphics artwork file, wherein a format of said digital data graphics drawing and artwork files is specified by requirements of said relational database;

providing access to said logitical relational database;

transferring said graphics drawing file and said digital data graphics artwork file to said relational database, and populating respective engineering drawing and artwork tables with digital data defining images of said respective engineering drawing and said artwork;

preparing control files specifying control data regarding said stored one or more engineering drawings and said artwork to be added to files comprising said relational database; and

adding said control data to pointer tables comprising said database, said control data specifying a relationship between said artwork and a corresponding engineering drawing, a relationship between said artwork and a corresponding task or subtask, and a relationship between said engineering drawing and a corresponding task or subtask.

10. A method for storing engineering drawings and artwork in a logistical relational database for subsequent retrieval and use, the logistical relational database holding data regarding hardware items and one or more work tasks involving the operation or maintenance of the hardware items, the method comprising the following steps:

creating one or more engineering drawings of a given hardware item on a computer aided design (CAD) system, and storing said one or more engineering drawings in CAD system memory in a drawing CAD file, wherein said CAD system memory and said drawing CAD file is not accessible to said relational database;

transforming said drawing CAD file into a digital data graphics drawing file, wherein a format of said digital data graphics drawing file is specified by requirements of said relational database;

providing access to said logistical relational database;

transferring into one or more tables comprising said relational database digital data representing an image of said one or more engineering drawings of said given hardware item, said digital data comprising said digital data graphics drawing file;

preparing control files specifying control data regarding said stored one or more engineering drawings to be added to files comprising said relational database; and

adding said control data to pointer tables comprising said database, said control data specifying a relationship between said engineering drawing and a corresponding task or subtask.

11. A method for storing engineering drawings and artwork in a logistical relational database for subsequent retrieval and use, the logistical relational database holding data regarding hardware items and one or more work tasks involving the operation or maintenance of the hardware items, the method comprising the following steps:

creating one or more engineering drawings of a given hardware item on a computer aided design (CAD) system, and storing said one or more engineering drawings in CAD system memory in a drawing CAD file, wherein said CAD system memory and said drawing CAD file is not accessible to said relational database;

using said stored one or more engineering drawings to prepare artwork regarding said given hardware item on said CAD system and storing said artwork in CAD system memory in an artwork CAD file, wherein said artwork CAD file is not accessible to said relational database;

transforming said drawing CAD file and said artwork CAD file into a digital data graphics drawing file and a digital data graphics artwork file, wherein a format of said digital data graphics drawing and artwork files is specified by requirements of said relational database;

providing access to said logistical relational database;

transferring into one or more tables comprising said relational database digital data representing an image of said one or more engineering drawings of said given hardware item, said digital data comprising said digital data graphics drawing file, and digital data representing an image of said artwork and comprising said digital data graphics artwork file;

preparing control files specifying control data regarding said stored one or more engineering drawings and said artwork to be added to files comprising said relational database; and

adding said control data to pointer tables comprising said database, said control data specifying a relationship between said artwork and a corresponding task or subtask, and a relationship between said engineering drawing and a corresponding task or subtask.