JP2872734B2 - Search and analysis method of quality data - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Application Field] The present invention collects information on product quality of customers and searches / analyzes accumulated information.
Related to analysis method.

[Conventional technology]

Collection of information on product quality by traditional customers
Regarding the analysis method, for example, Japanese Patent Application Laid-Open No. 63-40962 proposes a method of inputting product failure information using a bar code, but does not clarify a method of storing and managing data and a method of searching and analyzing data. In addition, the failure information is simply described as “defect contents”.

The “quality information system that communicates the manufacturing process and the market” described on pages 5 to 10 of “August 1987 ENGINEERS” (published by the Japan Science and Technology Federation) uses the quality data of the market as the host of the factory. It is managed by a computer and analyzed by statistical methods.
This is a method in which the analysis function is activated by S, and the user has little flexibility in data editing and analysis functions.

[Problems to be solved by the invention]

In the above prior art, in the method of inputting product failure information using a barcode, consideration is not given to a method of accumulating / managing and searching for quality data, so that operation including cost performance and scalability of the system is performed. There was an unlikely problem.

Also, in the quality information system that links the manufacturing process and the market, the user starts the TSS or batch analysis function from the host terminal, so no consideration is given to system response or analysis turnaround time. However, there is a problem that the cost performance of the system is low, and since the functions on the host computer are used directly by the user, no consideration is given to detailed conditions for search and analysis, and the data editing and analysis functions for the user There was a problem that the dynamics or flexibility of the system was small.

SUMMARY OF THE INVENTION An object of the present invention is to provide a quality data search / analysis method that allows a user to set detailed search / analysis conditions in accordance with the request, and also enables quick search / analysis.

[Means for solving the problem]

In order to achieve the above object, a method for searching and analyzing quality data according to the present invention is characterized in that a whole set of quality data is managed in units of records on a large-scale storage device accommodated in a large-scale computer, and With some quality data pre-registered in the database on the workstation,
The quality data is searched from the database according to the search condition from the work station, and the quality data is analyzed according to the analysis condition from the work station. When the quality data is searched, if it is determined that at least a part of the quality data among the quality data to be searched is insufficient, a search condition formula for only the insufficient quality data is generated by a logical operation. In addition, a transfer request including the search condition expression is issued from the workstation to the large computer via the network, and in response to the transfer request, the insufficient quality data read from the large storage device is transmitted to the large computer, the high-speed network, Once transferred and stored on the database via the station, On read on tio emission is obtained by with the quality data other than insufficient quality data to be analyzing process as a search target. That is, more specifically, all of the quality data is stored in a large-scale storage device of a large-scale computer, and a part of the data is registered in a database on a workstation, and all of the search and analysis are performed on the workstation. Here, when a request for data that does not exist in the database of the workstation is issued, the workstation issues a data transfer request to the large-scale computer and transfers the data over the network. In order to minimize the data, the transfer request is issued only for the parts that are not common to the database search conditions and the database, that is, only those parts of the request that do not exist in the database. Can be searched by record It performs analysis for the items of, yet these icon
This is realized by a user interface combining cursor movement with a table / graph and a mouse and input.

(Operation)

The above-mentioned quality data search and analysis method enables all data search and analysis at the workstation, so the search and analysis request and the sequence of processing and output are executed in real time, reducing the turnaround time of analysis work. When a request for data that does not exist in the database of the workstation is issued, a transfer request is issued only for a part of the request that does not exist in the database, and the system response time is reduced by transferring the request through the network. Minimization can be achieved, and data can be searched on a record basis at the workstation and all items can be analyzed, thereby improving the flexibility of analysis work. Tables and graphs It is possible to improve the operability by which to perform the input specification of the scan.

〔Example〕

An embodiment of the present invention will be described below with reference to FIGS.

1 (a) and 1 (b) are hardware configuration diagrams showing one embodiment of a method for searching and analyzing quality data according to the present invention. FIG. 1 (a) shows the overall configuration of a large computer network system from a customer inputting quality data base to a factory. In FIG. 1 (a), quality data of a customer is input from a terminal 1 of each dealer,
The results edited by the computers 2 at each office are sent to the same large computer 3 from all offices, and the results edited for each factory are stored in the large-scale storage device 4 connected to the large computers 3. It is memorized. The large-scale storage device 4 has a mailbox function and can be constantly referred to from the large-scale computers 5 of the factories 1, 2, 3, 4,... Via a network.

FIG. 1B shows a large-scale computer of each factory which issues a transfer request to the large-scale storage device 4 of FIG. 1A and stores and manages quality data corresponding to each factory received from the large-scale storage device 4. 5 and the configuration of a workstation for searching and analyzing quality data. In FIG. 1B, a large-scale storage device 6 is connected to a large-scale computer 5 in each factory.
It accumulates quality data for all customers of all products in the factory in the past. The search and analysis of the quality data are performed in the workstation 7, and a database for registering a part of the quality data in the external storage device 8 is provided. The result of the search and analysis is output to the external storage device 9 or the printer 10. Workstation 7 is a large computer 5
When a request for data that does not exist in the database of the external storage device 8 of the workstation 7 occurs, a portion that does not exist in the database is transferred through this network.

FIG. 2 is a configuration diagram of software for performing search and analysis of quality data in the workstation 7 in FIG. 1B. FIG. 2 shows the modules that share the individual functions. (1) The user interface 201 manages activation and termination of each module. (2) The screen display application 202 controls display on a color graphic monitor using a graphic package.
(3) The screen management module 203 manages activation and termination of the screen display application 202. (4) The application start / management module 204 starts /
Manage termination. (5) The failure analysis module 205 has analysis functions such as distribution, correlation, and trend. (6) The failure occurrence prediction module 206 has a prediction function based on hazard analysis. (7) The alarm management module 207 has a function of managing the progress status of the budget / part regarding the defect with respect to the target set value. (8) The free search module 208 instructs the search of the intermediate file or the database by the specified search item. (9) Intermediate file management module 209
Performs intermediate file management and database search language activation. (10) The database management module 210 manages, updates, and searches the database.
I'm a manager. (11) Host-WS communication module 211
Is for controlling data communication between the large-scale computer 5 and the workstation 7 using the inter-file communication package.

FIG. 3 is a configuration diagram of processing contents of a function for performing search and analysis of quality data in the workstation of FIG. 1 (b). FIG. 3 shows the processing contents of each procedure along the flow of the case of performing search and analysis. First, the procedure 301 sets search conditions, and the procedure 302 is the procedure 30
A search is performed based on the search conditions set in 1 and the database management function of procedure 303 is started. Procedure 303
Searches the database (external storage device) 8 in accordance with the search condition. If the data set of the database does not satisfy the search condition, the procedure 304 searches for a portion other than the common portion of the search condition and the database 8, that is, a portion that does not exist in the database 8. The data is transferred from the large computer 5 and registered in the database 8 by the host access function. The procedure 305 selects the next item of the data set 306, and the result retrieved by the procedure 302 is written to the core memory as the source data set 306. At this time, the data value is directly referred to for the item selected in the procedure 305 can do.
Here, the data set written in the core memory is analyzed. First, a procedure 307 specifies an analysis method, then a procedure 308 selects a parameter to be analyzed, and an analysis procedure 309 performs a numerical operation of the operation module 310 in accordance with the analysis method specified in the procedure 307. The calculation result is output as a drawing data set 311 by an output model 312 according to the analysis method.

FIGS. 4 (a) and 4 (b) are explanatory diagrams of management items (a) and data items (b) which serve as references when performing a numerical operation according to an analysis request in the analysis procedure 309 of FIG. . 4 (a) and 4 (b), the numerical operation according to each analysis method in the analysis procedure 309 of FIG. 3 is based on the number of failures, the total number of failures, the repair cost, and the number of failures of the management items shown in FIG. 4 (a). One of the total repair cost, monthly failure rate, cumulative failure rate, average failure rate, etc. is calculated for each data item such as categorical data, order data, quantity data, etc. of the classification shown in FIG. Is what you do.

The method of managing and searching the database in the flow of the processing for searching and analyzing the quality data shown in FIG. 3 will be described below. When a search request is generated in the workstation 7 by the procedure 302 in FIG. 3 as described above, the database management function of the procedure 303 in FIG. 3 is started to search the database 8 in accordance with the search condition. If the data set of the database (external storage device) 8 does not satisfy the search condition, the portion other than the common portion of the search condition and the database 8, that is, the portion not existing in the database 8, is stored in the procedure shown in FIG.
The data is transferred from the large computer 5 by 304 and registered in the database 8, and the processing procedure in this case is shown in FIG.

FIG. 5 shows a case where a search request is generated in the workstation 7 by the procedure 302 in FIG. FIG. 7 is a schematic flowchart of a process for transferring. In FIG. 5, the conditional expression management program creates a missing conditional expression from the retrieval conditional expression in the higher-level program, searches the large computer 5 according to the condition, and transfers the result. If there is enough space in the external storage (database) 8 of the workstation 7, the transferred data is registered. If there is not enough space in the external storage device (database) 8 of the workstation 7, a conditional expression representing a data group that can be deleted from the external storage device (database) 8 is selected, and the corresponding data is deleted. Register the data later.

FIGS. 6 (a) and 6 (b) show the product of the set generated when calculating the inclusion relation between the data set and the search condition in FIG. 5 and when creating a condition expression for the missing part from the search condition expression. It is explanatory drawing which shows all the cases. 6A and 6B, in each case A to J, the product of the condition shown in the first column (leftmost column) and the condition shown in the second column (middle column) is taken. The results are shown in the third column (rightmost column). Next, each case will be described in order.

In the case A (upper part) of FIG. 6A, the product of the condition of being equal to x and the condition of being equal to x is a condition of being equal to x, and in the case A (lower part) the product of the condition of being equal to x is empty. Be a set. In case B, the product of the condition of being equal to x and the condition of being smaller than y is a condition of being equal to x if x <y, and is an empty set if x> y. In case C, the product of the condition of being equal to x and the condition of being larger than y is a condition of being equal to x if x> y,
If x <y, it is an empty set. In case D, the product of the condition of being equal to x and the condition of being greater than y and less than z is an empty set if x <y, an empty set if x> z, and x in other cases. The condition is equal. Case E is less than x and y
If the product of the conditions of smaller than x is y> y, the condition is smaller than y, and if x <y, the condition is smaller than x. Case F is less than x and y
If the product of the conditions being greater than x is greater than y, then the condition is greater than y and less than x, and if x <y, the set is empty. Case G is less than x and y
If the condition of greater than and less than z is x <y, it is an empty set; if x> z, the condition is greater than y and less than z; otherwise, greater than y and less than x It shows that it becomes the condition.

In the case H of FIG. 6 (b), the product of the condition of being larger than x and the condition of being larger than y is a condition of being larger than y if x <y, and is a condition of being larger than x if x> y. In case I, the product of the condition of being larger than x and the condition of being larger than y and smaller than z is x>
If z is an empty set, if x <y, the condition is greater than y and less than z; otherwise, the condition is greater than x and less than z. Case J is an empty set if the product of the condition of being greater than x and less than y and the condition of being greater than z and less than w is y <z, an empty set if w <x, and x <z and w If <y, the condition is larger than z and smaller than w, and if x <z and w> y, z
The condition is larger and smaller than y, and x>
If z and w> y, the condition is larger than x and smaller than y, and if x> z and w <y, the condition is larger than x and smaller than w.

FIG. 7 is a functional configuration diagram of a conditional expression management program which is an external specification of the entire system of FIG. In FIG. 7, the conditional expression management program includes (1) creation of an insufficient conditional expression, (2) deletion of a conditional expression, creation of a deleted conditional expression, and (3)
It consists of adding a conditional expression and (4) changing and registering a resident conditional expression. Further, (1) creation of a shortage conditional expression includes (1-1) reading of a conditional expression file, (1-2) calculation of a product of the conditional expressions, and (1-3) calculation of a product of the complement set. . (1-
2) The calculation of the product of the conditional expressions is a combination of the calculation of the product of (1-2-1) elements, and the calculation of the product with the (1-3) complement set is the complement set of the (1-3-1) element And (1-3-2)
Combination with calculation of product of elements. (2) Deletion of a conditional expression and creation of a deleted conditional expression involve (2-1) creation of an insufficient conditional expression.

8 (a) to 8 (e) are PAD diagrams in which the configuration of the main functions of FIG. 7 is further detailed. FIG. 8A shows (1) creation of an insufficient conditional expression, (2) deletion of a conditional expression and creation of a deleted conditional expression, and (3) when the conditional expression management program is started, depending on the value of an input parameter. Indicates that one of the functions of adding a conditional expression or (4) changing and registering a resident conditional expression operates.

FIG. 8 (b) shows a procedure in which the functions of (1) inquiry of a conditional expression and creation of an insufficient conditional expression in FIG. 8 (a) operate. In FIG. 8B, a step 1 opens the conditional expression file in the reference mode. Step 2 creates a conditional expression table. Step 3 checks the input conditional expression. In step 4, the product of all the conditional expressions in the conditional expression table and each input conditional expression is calculated, and if the result is empty, it is deleted from the conditional expression table. Step 5 computes the product of the complement of all the conditional expressions in the conditional expression table and each input conditional expression, outputs the message "included" if the result is empty, and outputs the message if it is not empty Is gradually multiplied by the product.

FIG. 8 (c) shows a procedure in which the functions of (2) deleting a conditional expression and creating a deleted conditional expression in FIG. 8 (a) operate.
In FIG. 8C, step 1 opens the conditional expression file in the update mode. Step 2 deletes the input conditional expression from the conditional expression file. Step 3 activates the functions of (1) inquiry of a conditional expression and creation of an insufficient conditional expression.

FIG. 8 (d) shows a procedure in which the function of (4) changing and registering the resident conditional expression in FIG. 8 (a) operates. In FIG. 8 (d), step 1 opens the conditional expression file in the update mode. Step 2 writes the input conditional expression in the conditional expression file. Step 3 closes the conditional expression file.

FIG. 8E shows a procedure in which the additional function of the conditional expression (3) in FIG. 8A operates. In FIG. 8 (e), step 1 opens the conditional expression file in the addition mode. Step 2 adds input conditions to the conditional expression file. Step 3 closes the conditional expression file.

FIG. 9 (a) is an explanatory diagram showing the file specifications of a conditional expression file for storing a search conditional expression to be processed in FIGS. 8 (a) to (e). FIG. 9 (b) is an explanatory diagram showing the file specifications of an input / output parameter file for storing the elements of the conditional expressions for exchanging data with the higher-level programs of FIGS. 8 (a) to (e).

〔The invention's effect〕

According to the present invention, since the search and analysis of quality data can all be performed at the workstation, the sequence of the search and analysis request and the processing and output are executed in real time, so that the turnaround time of the analysis work can be reduced. .

In addition, when a request for data that does not depend on the database of the workstation is issued, a transfer request is issued only for a portion of the request that does not exist in the database, and the request is transferred through the network, thereby minimizing the system response time. is there.

BRIEF DESCRIPTION OF THE DRAWINGS FIGS. 1 (a) and 1 (b) are hardware configuration diagrams showing one embodiment of a method for searching and analyzing quality data according to the present invention, and FIG.
FIG. 3 is a software configuration diagram for searching and analyzing quality data at the workstation shown in FIG. 1B, and FIG. 3 is a processing content of a function for searching and analyzing quality data at the workstation shown in FIG. FIG. 4 (a) and FIG. 4 (b) are explanatory diagrams of management items and data items which are the basis for performing a numerical operation according to the analysis request in the analysis procedure of FIG. 3, and FIG. 5 is FIG. 6 (a) and 6 (b) are schematic flow charts of processing for searching for a large computer and transferring the result when a search request is generated at the workstation by the procedure 302 of FIG. Explanatory diagram showing all cases of the product of the set of
FIG. 7 is a functional configuration diagram of the conditional expression management program of FIG. 5,
8 (a) to 8 (e) are detailed PADs of the main functions of FIG.
FIGS. 9 (a) and 9 (b) are explanatory diagrams of the file specifications of the conditional expression file and the input / output parameter file of FIGS. 8 (a) to 8 (e). 1 ... terminal of dealership, 2 ... computer at office, 3 ... large-scale computer, 4 ... large-scale storage device, 5 ... large-scale computer at factory, 6 ... large-scale storage device, 7 ... work Station 8, external storage device (database) 9, external storage device 10, printer.

 ──────────────────────────────────────────────────続 き Continuation of front page (56) References JP-A-1-187632 (JP, A) JP-A-62-61119 (JP, A) Hitachi Review 71 [2] (1989.2) pp. 79-83 “Technology” A comprehensive production technology management system that embodies the strategic concept

Claims (1)

(57) [Claims] An overall set of quality data is managed on a large-scale storage device accommodated in a large-scale computer in a record unit, and a part of the quality data of the entire set is registered in a database on a workstation in advance. In this state, the quality data is searched from the database according to the search condition from the workstation, and the quality data is searched and analyzed according to the analysis condition from the workstation. In the analysis method, when the quality data is searched on the database by the search condition, if it is determined that at least a part of the quality data is insufficient in the quality data as a search target,
A search condition expression for only the insufficient quality data is generated by a logical operation, and a transfer request including the search condition expression is issued from a workstation to a large-scale computer via a network. The insufficient quality data read from the database is temporarily transferred and stored in a database via a large computer, high-speed network, and workstation, then read out to the workstation and analyzed as a search target together with the quality data other than the insufficient quality data How to search and analyze quality data.