Automated logistical relational database support system for engineering drawings and artwork

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.

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.

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.