US5493679A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Automated logistical relational database support system for engineering drawings and artwork
Assignee: Raytheon Co
•
Filing: 1993-10-29
•
Granted: 1996-02-20
•
Expires: 2013-10-29
Abstract
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.
Inventors
- 👤 Kenneth W. Virgil
- 👤 Anthony F. Zucco
- 👤 Walter R. Harker
- 👤 Roger L. Brown
- 👤 James P. Merriman
- 👤 Albert D. Baron
- 👤 Philip J. June
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 15:34
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S706/00; Y10S706/902; Y10S706/919; Y10S707/00; Y10S707/99941; Y10S707/99944; Y10S707/99945; Y10S707/99948
Claims Analysis
Total Claims: 15
Claim 1
Independent Claim
325 words
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.
Claim 2
Independent Claim
325 words
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.
Claim 3
Dependent Claim
36 words
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.
Claim 4
Dependent Claim
30 words
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.
Claim 5
Dependent Claim
19 words
The method of claim 1 wherein said pointer tables comprise a pointer table containing data defining said artwork images.
Claim 6
Dependent Claim
25 words
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.
Claim 7
Dependent Claim
28 words
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.
Claim 8
Dependent Claim
27 words
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.
Claim 9
Dependent Claim
12 words
The method of claim 1 wherein said relational database complies with MIL-STD-1388-2B.
Claim 10
Independent Claim
308 words
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.
Claim 11
Independent Claim
308 words
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.
Claim 12
Independent Claim
224 words
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.
Claim 13
Independent Claim
224 words
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.
Claim 14
Independent Claim
315 words
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.
Claim 15
Independent Claim
315 words
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.
References Cited (Backward Citations)
US4964060A
Cited
US4862376A
Cited
US5428727A
Cited
US5201046A
Cited
US5295261A
Cited
US5339247A
Cited
US5341469A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-02-19 | 1999-08-21 | 2000-02-20 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-02-19 | 2003-08-21 | 2004-02-20 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-02-19 | 2007-08-21 | 2008-02-20 | $7700.00 | Window Closed / Lapsed |