Database generation and use aid apparatus

• US 20080082527A1
• Filed: 09/12/2007
• Published: 04/03/2008
• Est. Priority Date: 09/29/2006
• Status: Abandoned Application

• Current Assignee: Omron Corporation
• Original Assignee: Omron Corporation
• Inventors: Abe, Masayoshi, Konishi, Hidefumi, Yachiku, Hideki, Moriya, Toshihiro
• Application Number:
  US11/900,804
• Publication Number:
  US 20080082527A1
• Time in Patent Office: Days
• US Class Current: 707/5
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases

Abstract

A precedent database is generated by registering location indicating information that shows location of each of a plurality of precedent data. A knowledge database is generated by repeating processes of carrying out a search of this precedent database according to a specified condition formula and registering knowledge names representing results of the search in correlation with the condition formula. Component and failure names in the knowledge database are inserted as items of a generated FMEA sheet. Items of the FMEA sheet are specified and displayed such that corresponding text data can be referenced.

Claims

1. A database generation apparatus comprising:

precedent database generating means for generating a precedent database by registering location indicating information that shows location of each of a plurality of precedent data;

knowledge database generating means for generating a knowledge database by repeating processes of carrying out a search of said precedent database according to a specified condition formula and registering knowledge names representing results of said search in correlation with said condition formula;

input means for specifying said condition formula; and

display means for displaying contents of said precedent database and said knowledge database.

2. The database generation apparatus of claim 1 wherein said precedent database generating means extracts text data contained in said precedent data and registers said location indicating information and said text data in correlation.

3. The database generation apparatus of claim 2 wherein said precedent data include at least one selected from the group consisting of documents and images related to past troubles.

4. The database generation apparatus of claim 1 which uses a keyword as a condition of said condition formula, said keyword being the name of one selected from the group consisting of components of a product, work processes for producing said product, failures corresponding to said components and failures corresponding to said work processes.

5. The database generation apparatus of claim 2 wherein said knowledge database generating means serves to correct the results of said search carried out according to said condition formula and to register contents of the corrected results in correlation with said condition formula.

6. The database generation apparatus of claim 5 wherein said knowledge database generating means serves to generate a knowledge database with a hierarchical structure by carrying out a further search on the results of said search represented by the knowledge name according to said specified condition formula.

7. The database generation apparatus of claim 6 wherein said knowledge database includes frequency data of a precedent matching said condition formula;

and

wherein said display means displays said frequency data numerically or graphically based on said frequency data.

8. A database use aid apparatus comprising:

a precedent database that stores location indicating information that shows location of each of a plurality of precedent data;

a knowledge database that stores a plurality of knowledge names representing results of searches carries out according to specified condition formulas in correlation with said condition formulas corresponding individually to said results of said searches;

display means for displaying contents of said precedent database and said knowledge database;

input means for specifying said knowledge names of said knowledge database displayed on said display means; and

search processing means for carrying out a search of said precedent database according to the condition formula corresponding to one of said knowledge names of said knowledge database specified by said input means and causing results of said search on said display means.

9. The database use aid apparatus of claim 8 wherein said precedent database stores text data contained in said precedent data in correlation with said location indicating information.

10. The database use aid apparatus of claim 8 wherein said precedent data include at least one selected from the group consisting of documents and images related to past troubles.

11. The database use aid apparatus of claim 9 wherein said precedent database stores records that include items corresponding to said location indicating information for each of said precedent data;

wherein said knowledge database stores records that include items corresponding to said knowledge names; and

wherein said search processing means causes said display means to display said results of said search as a list of the records of corresponding ones of said precedent data.

12. The database use aid apparatus of claim 11 wherein said search processing means carries out said search of said precedent database based on the location indicating information showing the location of a record of said list displayed on said display means and specified by said input means and causes said display means to display the contents of corresponding precedent data.

13. The database use aid apparatus of claim 12 wherein a keyword is used as a condition of said condition formula, said keyword being the name of one selected from the group consisting of components of a product, work processes for producing said product, failures corresponding to said components and failures corresponding to said work processes;

and

wherein the record of said knowledge database contains at least an item corresponding to said knowledge name selected from the group consisting of items of components of a product, items of work processes for producing said product, items of failures corresponding to said components and items of failures corresponding to said work processes.

14. The database use aid apparatus of claim 8 wherein said knowledge database stores contents of corrections on search results on said precedent database carried out according to said condition formula in correlation with said condition formula;

and

wherein said search processing means corrects and displays on said display means the search results on said precedent database according to the condition formula corresponding to said knowledge name according to said contents of corrections.

15. The database use aid apparatus of claim 14 wherein said knowledge database is of a hierarchical structure, a further search being carried out according to said specified condition formula on the search results represented by said knowledge name.

16. The database use aid apparatus of claim 15 wherein said knowledge database includes frequency data of a precedent matching said condition formula;

and wherein said display means displays said frequency data numerically or graphically based on said frequency data.

17. The database use aid apparatus of claim 13 further comprising FMEA sheet generating means for generating an FMEA sheet that includes records with items and serves to retrieve component and failure items of the record of said knowledge database, to insert the reprieved component as items of said FMEA sheet and to cause said FMEA sheet to be displayed on said display means;

wherein said input means serves to specify items of said FMEA sheet; and

wherein said search processing means serves to carry out a search of said precedent database according to a condition formula corresponding to an item of said FMEA sheet specified by said input means and to cause results of said search displayed on said display means.

18. The database use aid apparatus of claim 17 wherein said display means serves to display said results of said search as a list of records containing an item of said location indicating information;

wherein said input means serves to specify records of said list displayed on said display means; and

wherein said search processing means serves to search precedent data corresponding to a record specified by said input means and to cause contents of said searched precedent data on said display means.