System and method for a data dictionary

• US 8,620,936 B2
• Filed: 05/05/2008
• Issued: 12/31/2013
• Est. Priority Date: 05/05/2008
• Status: Active Grant

• Current Assignee: The Boeing Co.
• Original Assignee: The Boeing Co.
• Inventors: Lake, Peter J., Herman, Diana L., Bouvier, Kenneth D., Fay, Matthew K.
• Primary Examiner(s): OBISESAN, AUGUSTINE KUNLE
• Application Number:
  US12/115,456
• Publication Number:
  US 20090276438A1
• Time in Patent Office: 2,066 Days
• Field of Search: None
• US Class Current: 707/756
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/2452 Query translation

Abstract

In accordance with one or more embodiments, a system for facilitating transfer of data and information over a network includes a database component for storing data and information related to a machine and at least one part thereof, a communication component adapted to communicate with a user via a user device over the network, and a processing component adapted to receive a request for data and information from the user over the network via the user device and process the request by retrieving data and information from the database component related to the machine or the at least one part thereof specified by the user passed with the request. The communication component is adapted to transfer the data and information related to the machine or the at least one part thereof from the database component to the user device for viewing by the user on the user device.

Claims

1. A system for extracting aircraft maintenance logbook data from aircraft maintenance logbooks according to aircraft engineering component nomenclature, the system comprising:

a database component for storing the aircraft maintenance logbooks;

a communication component adapted to communicate with a user via a user device over network; and

a processor adapted to;

receive, from the user via the user device over the network, a request to extract the aircraft maintenance logbook data according to the aircraft engineering component nomenclature, wherein at least some of the engineering component nomenclature is abbreviated and wherein the engineering component nomenclature includes an assigned part number (ASN), and translate the component nomenclature and the ASN into non-abbreviated proper English language terms,

translate the non-abbreviated proper English language terms into operational jargon used in the aircraft maintenance logbooks and into one or more synonyms for the operational jargon,

formulate a database query statement comprising the operational jargon, the one or more synonyms, and the non-abbreviated proper English language terms, and

retrieve the aircraft maintenance logbook data from the database component using the database query statement,

wherein the communication component transfers the aircraft maintenance logbook data from the database component to the user device for viewing by the user on the user device, and wherein the processor is further adapted to determine the non-abbreviated proper English terms for the component nomenclature based on at least a portion of the ASN.

2. The system of claim 1, wherein the processor is adapted to identify technical synonyms of the proper English language terms.

3. The system of claim 1, wherein the system comprises a server.

4. The system of claim 1, wherein the user device comprises a mobile communication device having a display component for displaying the transferred aircraft maintenance logbook data or the at least one part thereof.

5. The system of claim 1, wherein the user device comprises a database component for storage of the transferred aircraft maintenance logbook data or the at least one part thereof.

6. The system of claim 1, wherein the user device comprises a user input component that receives input from the user.

7. The system of claim 1, wherein the engineering component nomenclature includes aircraft engineering component acronyms, and wherein the formulated database query statement further comprises the aircraft engineering component acronyms.

8. A method for extracting aircraft maintenance logbook data from aircraft maintenance logbooks according to aircraft engineering nomenclature over a network, the method comprising:

communicating with a user via a user device over the network;

receiving a request to extract the aircraft maintenance logbook data according to the aircraft engineering component nomenclature over the network, wherein at least some of the aircraft engineering component nomenclature is abbreviated and wherein the engineering component nomenclature includes an assigned part number (ASN);

translating the aircraft engineering component nomenclature into non-abbreviated proper English language terms;

translating the non-abbreviated proper English language terms into operational jargon used in the aircraft maintenance logbooks and into one or more synonyms for the operation jargon;

formulating a database query statement comprising the operational jargon, the one or more synonyms, and the non-abbreviated proper English language term; and

retrieving the aircraft maintenance logbook data from a database of the aircraft maintenance logbooks using the database query statement; and

transferring the aircraft maintenance logbook data to the user device for viewing by the user on the user device, wherein the translating the aircraft engineering component nomenclature comprises determining the non-abbreviated proper English terms for the component nomenclature based on at least a portion of the ASN.

9. The method of claim 8, wherein processing the request includes identifying technical synonyms of the common English language terms.

10. The method of claim 8, wherein the method is performed by a server in communication with the user via the user device over the network.

11. The method of claim 8, wherein the user device comprises a mobile communication device having a display component, a database component and an input component.

12. The method of claim 11, further comprising displaying the aircraft maintenance logbook data to the user via the display component of the user device.

13. The method of claim 11, further comprising storing the aircraft maintenance logbook data in the database component of the user device.

14. The method of claim 11, further comprising receiving input from the user via the input component of the user device.

15. The method of claim 8, wherein the aircraft engineering component nomenclature includes engineering component acronyms, and wherein the formulated database query statement further comprises the aircraft engineering component acronyms.