×

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
First Claim
Patent Images

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.

View all claims
  • 5 Assignments
Timeline View
Assignment View
    ×
    ×