Extraction, aggregation and query of maintenance data for a manufactured product

• US 10,324,958 B2
• Filed: 03/17/2016
• Issued: 06/18/2019
• Est. Priority Date: 03/17/2016
• Status: Active Grant

• Current Assignee: The Boeing Co.
• Original Assignee: The Boeing Co.
• Inventors: Floyd, Joseph Frank, Eames, Patrick J., Hadley, Brent Louis, Martin, Robert James
• Primary Examiner(s): Ly, Cheyne D
• Application Number:
  US15/073,451
• Publication Number:
  US 20170270182A1
• Time in Patent Office: 1,188 Days
• Field of Search: 707602, 707736
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: G06F 16/81 Indexing, e.g. XML tags; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06Q 10/06316 Sequencing of tasks or work
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 10/20 Administration of product repair or maintenance

Abstract

A method is provided that includes receiving a first electronic document for a manufactured product, with the first electronic document including first data regarding the manufactured product. The method includes extracting the first data from the first electronic document. And the method includes correlating the first data so extracted and second data regarding the manufactured product to produce aggregated data including the first data and second data, and storing the aggregated data in a storage from which the aggregated data is queryable.

Claims

1. An apparatus comprising a processor and a memory storing executable instructions that, in response to execution by the processor, cause the apparatus to at least:

receive a task card manual with first maintenance data including a description of maintenance tasks on or using parts of a manufactured product, and an illustrated parts catalog with second maintenance data including a description of parts of the manufactured product;

extract the first maintenance data from the task card manual, and the second maintenance data from the illustrated parts catalog;

correlate the first maintenance data and second maintenance data so extracted to produce aggregated maintenance data including the first maintenance data and second maintenance data, correlation of the first maintenance data and second maintenance data including correlation of items of the first maintenance data and items of the second maintenance data;

configure a storage with the aggregated maintenance data to enable a query of the aggregated maintenance data;

receive an electronic document with third maintenance data regarding the manufactured product;

extract the third maintenance data from the electronic document;

correlate the aggregated maintenance data and the third maintenance data so extracted to produce further aggregated maintenance data including the aggregated maintenance data and third maintenance data, correlation of the aggregated maintenance data and third maintenance data including correlation of the items of the first maintenance data and items of the third maintenance data, and thereby correlation of the items of the second maintenance data and the items of the third maintenance data, the items of the third maintenance data otherwise being incapable of correlation with the items of the second maintenance data; and

configure the storage with the further aggregated maintenance data to enable a query of the further aggregated maintenance data.

2. The apparatus of claim 1, wherein the first maintenance data and second maintenance data are in a markup language format, and items of the first maintenance data and items of the second maintenance data are encapsulated by tags of the markup language format, and

wherein the apparatus being caused to correlate the first maintenance data and second maintenance data includes being caused to correlate the items of first maintenance data and items of the second maintenance data based at least in part on the tags.

3. The apparatus of claim 1, wherein the first maintenance data is in a markup language format, and the apparatus being caused to correlate the first maintenance data and second maintenance data includes being caused to recognize items of the first maintenance data and their relationship to items of the second maintenance data independent of the markup language format.

4. The apparatus of claim 1, wherein the memory stores further executable instructions that, in response to execution by the processor, cause the apparatus to further at least:

receive a search query;

execute the search query on the aggregated maintenance data, including retrieval of items of first maintenance data and correlated items of second maintenance data; and

produce a response to the search query including the items of first maintenance data and correlated items of second maintenance data.

5. The apparatus of claim 1,

wherein the memory stores further executable instructions that, in response to execution by the processor, cause the apparatus to further at least:

receive a search query for a task card from the task card manual;

execute the search query on the aggregated maintenance data, including retrieval of a description of a maintenance task covered by the task card from the first maintenance data, and a list of parts for the maintenance task from the second maintenance data; and

produce a response to the search query including the description of the maintenance task and the list of parts for the maintenance task.

6. A method comprising:

receiving a task card manual with first maintenance data including a description of maintenance tasks on or using parts of for a manufactured product, and an illustrated parts catalog with second maintenance data including a description of parts of the manufactured product;

extracting the first maintenance data from the task card manual, and the second maintenance data from the illustrated parts catalog;

correlating the first maintenance data and second maintenance data so extracted to produce aggregated maintenance data including the first maintenance data and second maintenance data, correlation of the first maintenance data and second maintenance data including correlation of items of the first maintenance data and items of the second maintenance data;

configuring a storage with the aggregated maintenance data to enable a query of the aggregated maintenance data;

receiving an electronic document with third maintenance data regarding the manufactured product;

extracting the third maintenance data from the electronic document;

correlating the aggregated maintenance data and the third maintenance data so extracted to produce further aggregated maintenance data including the aggregated maintenance data and third maintenance data, correlation of the aggregated maintenance data and third maintenance data including correlation of the items of the first maintenance data and items of the third maintenance data, and thereby correlation of the items of the second maintenance data and the items of the third maintenance data, the items of the third maintenance data otherwise being incapable of correlation with the items of the second maintenance data; and

configuring the storage with the further aggregated maintenance data to enable a query of the further aggregated maintenance data.

7. The method of claim 6, wherein the first maintenance data and second maintenance data are in a markup language format, and items of the first maintenance data and items of the second maintenance data are encapsulated by tags of the markup language format, and

wherein correlating the first maintenance data and second maintenance data includes correlating the items of first maintenance data and items of the second maintenance data based at least in part on the tags.

8. The method of claim 6, wherein the first maintenance data is in a markup language format, and correlating the first maintenance data and second maintenance data includes recognizing items of the first maintenance data and their relationship to items of the second maintenance data independent of the markup language format.

9. The method of claim 6 further comprising:

receiving a search query;

executing the search query on the aggregated maintenance data, including retrieving items of first maintenance data and correlated items of second maintenance data; and

producing a response to the search query including the items of first maintenance data and correlated items of second maintenance data.

10. The method of claim 6

further comprising:

receiving a search query for a task card from the task card manual;

executing the search query on the aggregated maintenance data, including retrieval of a description of a maintenance task covered by the task card from the first maintenance data, and a list of parts for the maintenance task from the second maintenance data; and

producing a response to the search query including the description of the maintenance task and the list of parts for the maintenance task.

15. The computer-readable storage medium of claim 9,

wherein the computer-readable storage medium has further computer-readable program code portions stored therein that in response to execution by the processor, cause the apparatus to further at least:

receive a search query for a task card from the task card manual;

execute the search query on the aggregated maintenance data, including retrieval of a description of a maintenance task covered by the task card from the first maintenance data, and a list of parts for the maintenance task from the second maintenance data; and

produce a response to the search query including the description of the maintenance task and the list of parts for the maintenance task.

11. A computer-readable storage medium that is non-transitory and has computer-readable program code portions stored therein that in response to execution by a processor, cause an apparatus to at least:

receive a task card manual with first maintenance data including a description of maintenance tasks on or using parts of a manufactured product, and an illustrated parts catalog with second maintenance data including a description of parts of the manufactured product;

extract the first maintenance data from the task card manual, and the second maintenance data from the illustrated parts catalog;

correlate the first maintenance data and second maintenance data so extracted to produce aggregated maintenance data including the first maintenance data and second maintenance data, correlation of the first maintenance data and second maintenance data including correlation of items of the first maintenance data and items of the second maintenance data;

configure a storage with the aggregated maintenance data to enable a query of the aggregated maintenance data;

receive an electronic document with third maintenance data regarding the manufactured product;

extract the third maintenance data from the electronic document;

correlate the aggregated maintenance data and the third maintenance data so extracted to produce further aggregated maintenance data including the aggregated maintenance data and third maintenance data, correlation of the aggregated maintenance data and third maintenance data including correlation of the items of the first maintenance data and items of the third maintenance data, and thereby correlation of the items of the second maintenance data and the items of the third maintenance data, the items of the third maintenance data otherwise being incapable of correlation with the items of the second maintenance data; and

configure the storage with the further aggregated maintenance data to enable a query of the further aggregated maintenance data.

12. The computer-readable storage medium of claim 11, wherein the first maintenance data and second maintenance data are in a markup language format, and items of the first maintenance data and items of the second maintenance data are encapsulated by tags of the markup language format, and

wherein the apparatus being caused to correlate the first maintenance data and second maintenance data includes being caused to correlate the items of first maintenance data and items of the second maintenance data based at least in part on the tags.

13. The computer-readable storage medium of claim 11, wherein the first maintenance data is in a markup language format, and the apparatus being caused to correlate the first maintenance data and second maintenance data includes being caused to recognize items of the first maintenance data and their relationship to items of the second maintenance data independent of the markup language format.

14. The computer-readable storage medium of claim 11 having further computer-readable program code portions stored therein that in response to execution by the processor, cause the apparatus to further at least:

receive a search query;

execute the search query on the aggregated maintenance data, including retrieval of items of first maintenance data and correlated items of second maintenance data; and

produce a response to the search query including the items of first maintenance data and correlated items of second maintenance data.