JPH09204477A - Device and method for checking data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily set a complicated algorithm in a data check by composing a device of a data check program and a check master. SOLUTION: Concerning check object data 101 read by a data check program 102, with its data attribute 106 as a key, a check master 103 is indexed. Next, the table of a first node number in a processing control table 109 is referred to, the contents of a check to be executed for that node are recognized while referring to a check condition table 110 and based on that conditional expression, YES, NO or any other discrimination is executed by the program. When the setting of OK end or error end is performed to show the presence of reliability as the measured value of the inspected result while referring to the number of the next node set for each discrimination based on that discrimination, the data check to this data attribute 106 is finished, and the result of these data is outputted.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention performs a check on collected data based on an algorithm set in advance for each attribute indicating a test type, as is carried out by test data in a clinical test system, for example. The present invention relates to a data check device and a method thereof which are suitable for a business that requires confirmation of the reliability of the data and the like and flexible setting of the check algorithm.

[0002]

2. Description of the Related Art In the conventional data check, it is general that the check algorithm is described in its logic in the form of a programming language using a program editing function and the program is executed to perform the data check. It was In addition, JP-A-62-191510 and JP-A-5-73
422, if the check condition is not described in the program logic, define it in the screen definition information or the input data information, and when the data is input to the system via the keyboard, the data check is performed based on that information. It was carried out. FIG. 16 schematically shows an item check condition table in which various check conditions are set for each data input item defined in the screen format table in JP-A-62-191510. For various data input items, various check conditions such as input date check presence, auto release designation, range check presence, and the like are preset.

[0003]

Since the conventional data check method is as described above, when the check algorithm is set in the program logic, the same check algorithm is used because the logic is managed by each program. In spite of the application, if the target data and the processing control are different and the programs are different, it is necessary to set the same algorithm separately in each program. If not described in the program logic, the check is just an enumeration of conditions, and it is difficult to set a complicated check algorithm that requires a combination of multiple conditions and its control. There were many restrictions.

The present invention has been made in order to solve the above-mentioned problems, and it is possible to set a complicated check algorithm without depending on the knowledge and technology of the programming language, and to use the same check algorithm. The object is to enable unified management of the algorithm for the group, and further to realize a data check device and a data check method capable of executing data check at any timing.

[0005]

In a data check device according to the present invention, a check target data consisting of a data attribute and a data value, a check master consisting of the data attribute and a processing control table, the check target data is read and the data is read. It comprises a data check means for searching the above-mentioned check master by using the attribute as a key and performing a check by the obtained check master.

Further, the processing control table has a condition number,
Consists of a conditional expression, a first pointer that indicates the next node number to which processing is to be performed when this conditional expression is satisfied, and a second pointer that indicates the next node number to which processing is to be moved when the above conditional expression is not satisfied. It is a thing.

Further, the processing control table is provided with a condition number, a conditional expression, a first pointer indicating the next node number to which processing is to be performed when this conditional expression is satisfied, and a next pointer to which processing is moved if the conditional expression is not satisfied. It is composed of a second pointer indicating a node number and a discriminator indicating that the data type is other than the data type to be checked in each node.

Further, the processing control table includes an identifier for identifying a check condition when an error occurs or a check condition when the process ends normally.

Furthermore, the data attribute is composed of an attribute indicating an inspection type and a section indicating a different check condition.

Data to be checked consisting of data attributes and data values, a check master consisting of the above data attributes and processing control table and a check condition table for setting the check conditions of this processing control table, the above data to be read and the above data to be read. It comprises a data check means for searching the above-mentioned check master by using the attribute as a key and performing a check by the obtained check master.

Further, the processing control table comprises a condition number, a first pointer, a second pointer, and a conditional expression number designating a conditional expression in the check condition table.

The check condition table is made up of the conditional expression number and the conditional expression.

In the data check method according to the present invention, the check target data is checked by the first conditional expression, an error signal is output when the conditional expression is not satisfied, and the check target data is output when the conditional expression is satisfied. This step consists of checking this check target data with the second conditional expression, outputting an error signal when the conditional expression is not satisfied, and outputting the check target data when the conditional expression is satisfied, and satisfies all conditional expressions. In this case, it is determined that the measurement value can be used.

When the conditional expression is not satisfied, the conditional expression of the related item related to the check target data is used for checking.

Furthermore, the step of reading the check target data consisting of the data attribute and the data value, the step of retrieving the check master using the data attribute as a key, the conditional expression in the first condition number of the record of the processing control table in the above data attribute The step of searching the check condition table with the number as a key, the step of checking with the first conditional expression obtained from the check condition table, and the result of this check, the second pointer designated by the first pointer or the second pointer. It comprises a step of searching the check condition table with the condition expression number of the condition number as a key, and a step of checking with the second condition expression obtained from the check condition table.

Further, a check master composed of a data attribute and a processing control table, first check target data composed of the data attribute and data value, the first check target data is read, and the check master is defined using the data attribute as a key. First data check means for checking by the check master obtained by retrieval, second check target data consisting of the above data attribute and data value, the second check target data is read, and the above check is performed using the above data attribute as a key It comprises a second data checking means for searching the master and checking with the obtained check master.

[0017]

BEST MODE FOR CARRYING OUT THE INVENTION

Embodiment 1. FIG. 1 is a block diagram showing an embodiment of the present invention. In the figure, 101 is data to be checked,
It is composed of a data attribute 106 indicating the inspection type and a data value 107 of the inspection result. 102 is the check target data 10
It is a data check program having a function as a data check means for checking whether or not the data read as 1 has reliability as a measurement value. A check master 103 is composed of a data attribute 106, a processing control table 109 that defines a check procedure for the data attribute 106, and a check condition table 110 that sets a conditional expression of the processing control table 109. 104 is post-check data, which is composed of a data attribute 106, a data value 107, and a result 113 indicating whether or not the data is reliable as a measurement value. Reference numeral 105 is a master maintenance program that changes the contents of the check master 103.

FIG. 2 is a layout example showing a schematic configuration of the check master 103. The check master 103 has a record formed for each data attribute, and the record is roughly divided into a key unit 201, a process control table unit 202, and a check condition table unit 203.

The key section 201 is a data check program 102.
It consists of data attributes 106 for better indexing. The process control table unit 109 includes a check number 206 and a check number 207 for indexing a node number 205 as a condition number indicating each node, which is one step of data check, and a check condition table 110 indicating the check contents to be executed there. , And node numbers 208 to 210 to be processed next based on the check result. The node referred to here is a basic constituent processing unit of a check algorithm that controls the branch of the next processing based on the check condition and the check result, and the conditional expression 213 and the check target data 1
If 01 is compared and conditional expression 213 is satisfied, YES is set and the next node number that is the first pointer is indicated.
If the conditional expression 213 is not satisfied by moving the processing to the next node indicated by 208, NO is indicated as NO, which indicates the next node number which is the second pointer, and the processing is moved to the next node indicated by the next node 209 or an error occurs. It is a display. Furthermore, there is the other next node 210 as a discriminator when it cannot be determined because of data other than numerical values. The check condition table 110 is a field that defines the check contents to be executed in each node, and specifically, the check type 206 for checking from each node, the check number 207, and the item 213 that is the detail of the check contents, the upper limit value. Set 214 and lower limit 215.

FIG. 3 is a flow chart showing the operation of the data check program 102. The check target data 101 read by the data check program 102 (step 301) indexes the check master 103 using the data attribute 106 as a key as described above (step 30).
2).

Next, the table of the first node number of the processing control table 109 is referred to (step 303), and the check contents to be checked at that node are checked in the check condition table 11.
It is recognized by referring to 0 (step 304), and based on the conditional expression, YES, NO or any other judgment is executed by the program (step 305).

Based on the judgment, the number of the next node set for each judgment is referred to (step 306), and if the OK end or the error end is set to be reliable as the measurement value of the inspection result, it is concerned. The data check for the data attribute 106 is completed, and the result of the data is output (step 307).

If the next node number is set in step 306, the node number of the process control table 109 is referred to (step 303), the data check shown there is similarly performed, and this is performed for the data attribute 106. Repeat until the data check is completed.

This processing for each data attribute 106 is repeatedly executed until the check target data 101 is completed (step 3
08).

Embodiment 2 FIG. 4 is a flowchart showing a specific check algorithm for the data type “GOT” indicating the function of the liver, for example, and FIG. 5 shows the setting contents of the check master 103 corresponding to the algorithm. Now, based on this algorithm, the current value is “80” and the previous value is “6” as the data type “GOT”.
The case where the data is checked when it is set to "0" will be described.

First, the record of the check master is indexed using the data type "GOT" 401, which is the data attribute 106, as a key.

Next, the record 402 of the node number 01 is referred to, and from there, the check condition "upper limit value" 40 at that node is obtained.
3 and the condition value “100” 404 are referenced.

Since the current value of the check target data is "80", this current value is within the range of "the upper limit of the value is 100" indicated by the check condition. Therefore, the check judgment at this node is "YES". It will be.

Based on the judgment, the check master YE
Since the reference to the S-th node 405 indicates “02”, the record 406 of the node number “02” is then referred to.
Hereinafter, similar to the “01” node, the process by the check determination is continued until it is completed.

In the case of the node "02", the check judgment is "YES" because the current value "80" is more than the check condition "lower limit of value 10", and the next node is "03". . In the node “03”, the check value “difference from the previous value is ± 15”, the current value is “80”, and the previous value is “60”, which is 80−60, and the difference +20 is against the range ± 15 of the condition. The check judgment is "NO", the next node becomes "99" as an error end, and this data is judged to be error data.

If there is the next check target data 101, the same processing as above is performed, and this is repeated until there is no target data.

FIG. 4 is a flow chart showing a specific check algorithm for the data type "GOT", which has a form in which nodes, which are one unit for determination, are connected. At each node, if the result of the check by the conditional expression is YES, the process is moved to the next node, and N
In the case of O, an error is displayed like node numbers 01, 03 and 05, or related items like node numbers 02 and 04 are checked. In the case of the present embodiment, “GPT” related to the data type “GOT” indicating the function of the liver is also included in the check target data 101 as a series of personal data, and therefore a check is performed.
Here, when the result of the related item "GPT" is OK, "GOT" and "GPT" usually have the same check result.
Since "PT" is OK, it is necessary to examine the measurement data of both of them again. When OK is determined in all the nodes, it is finally OK, and the measured value of the inspection result is determined to be reliable.

Embodiment 3 FIG. 7 shows the check master of FIG. 5 with return items added. Now, based on this algorithm, the same data type "GOT" as before
Now, a case will be described in which the check target data 101 is checked when the current value is “80” and the previous value is “60”.

After performing the same processing as that of the second embodiment described above, the node number "03" of the check master in FIG.
Refer to the next node field of NO in the record. From there "9
At the same time that the error end status of "9" is found, a return code "!" 501 can be newly inquired. This data has a return code! Error data,
That is, it can be determined that an error has occurred in the node 3. Also,
Even if the process ends normally, that is, even if it is OK, there may be a plurality of nodes that end in OK. In this case, YE of the node number “04” record of the check master 103 in FIG.
By referring to the next node column of S, a normal end status of "00" is found, and at the same time, a return code "*" can be inquired. From this, it can be determined that this data is normal data with a return code of *, that is, it has been normally completed at the node 4. As described above, since it is possible to know the node in which the error has occurred and the node that has ended normally, it is possible to immediately know the state of the measurement data. Furthermore, by inputting test data during a system test, it is possible to easily know whether or not a predetermined result is obtained. FIG. 6 is a flowchart showing a specific check algorithm based on the check master of FIG.

Embodiment 4 FIG. FIG. 9 is a diagram in which an OTHER field is added to the next node of the check master of FIG. Now, based on this algorithm, the data type "GO
Consider a case where the data of the current value "ABC" is checked in "T". Originally, the value of "GOT" is premised only on the numerical value, and therefore the algorithm is set only on the numerical value. However, this data is assumed to be error information in which the value “ABC” has entered due to some cause.

The check master node number "0" in FIG.
1 ”, since the current value is“ ABC ”with respect to the check condition“ upper limit value is 100 ”in this node, the check determination in this node is impossible.
Refer to the next node column of HER. From there "99" 604
Return code "?" 605, which is the discriminator for the error end
Can be inquired. What is the return code for this data? Error data, that is, data other than numerical values.

In the case of the data type "GOT", the target data is premised only on numerical values, but in the case of another data type, data such as +-, etc. also exist. In that case, if the data type is other than +-, an error end occurs, and the return code "?" Can be queried by referring to the next node column of OTHER. As described above, in the case of the data type other than the data type to be checked in each node, it is determined that there is an error and the discriminator is displayed. FIG. 8 is a flowchart showing a specific check algorithm based on the check master of FIG.

Embodiment 5 FIG. 11 shows a key section 201 of the check master according to the fourth embodiment in which a data division column is added. Now, based on this algorithm, a case will be considered in which two pieces of data having the same current value “120” and different data divisions “01” and “02” in the data type “GOT” are checked.

First, the record of the check master 103 is indexed using the data type "GOT" 701 and the data classification "01" 702 as keys. Next, the record of the node number “01” 703 is referred to, and from there, the check item “upper limit value” 704 and the condition value “100” 705 at that node are referred to. Since the current value of the check target data is "120",
The value this time is "the upper limit of the value is 100" indicated by the check condition.
Since it is outside the range of, the check judgment at this node is “NO”. Based on the judgment, referring to the node next to NO, the "99" 706 error end status and the return code of "@" 707 can be inquired, and this data is the error data of the return code @, that is, the node number "01". It can be determined as error data that has occurred.

Next, for the other data, the data type "GOT" 708 and the data division "02" 709 are used as keys.
The record of the check master 103 is indexed. Next, the record of the node number “01” 710 is referenced, and from there, the check condition “upper limit value” 711 and condition value “3” at that node are set.
00 "712. Since the current value of the check target data is “120”, this current value is within the range of “the upper limit of the value is 300” indicated by the check condition.
The check judgment at this node is “YES”. Based on that judgment, if the next node of YES is referred, "02"
713 is shown next, the record of the node number “02” 714 is referred to, and thereafter, the check is continued according to the check master 103.

In this way, if different check conditions are to be applied to the same data, it is possible to apply completely different check conditions by distinguishing the index records by the data division when the check master 103 is indexed. . FIG.
11 is a flowchart showing a specific check algorithm based on the check master of FIG.

Sixth Embodiment FIG. 13 shows the second to fifth embodiments.
Instead of defining the check items and condition values of the check master 103 described above for each node in the process control table 109, by using the parameters of the check type and the check condition defined in advance as shown in FIG. 13B. The check condition table 110 is separately defined, and a key for indexing the table is set for each node number in FIG. 13 (A).

Specifically, for the check condition to be executed by the node "01" 801, the check condition table 110 is referred from the check type "A" 802 and the check number "01" 803, and the conditional expression "KON" 804 there. From the lower limit value “10” 805 and the upper limit value “100” 806, it is found that “the current value of the data is 10 or more and 100 or less”. Since this condition is defined as a parameter, it is possible to flexibly define the condition when setting the master even if this conditional expression is not defined on the program side. Further, since this table can be referred to by each node, the table can be indexed any number of times by defining the table once under the same check condition. FIG. 12 is a flowchart showing a specific check algorithm based on the check master of FIG.

Embodiment 7. FIG. 14 shows the positioning of the master maintenance program 105 and an example of its processing flow. As shown in the figure, this program adds, corrects, and deletes each record of the check master 103, which enables efficient management of the check master 103 and reduction of the check algorithm setting work. Become.

Embodiment 8. Figure 15 shows Check Master 103
And the relationship between each of the data check programs 102 and. As shown in the figure, since each data check program 102 controls the input of the check target data 101 and the control thereafter, the data check program 102 needs different programs for each input / output type. In the example shown in the figure, the program 1102 has screens for input and a list of outputs, the program 2102 has a list for inputs and a list of outputs, the program 3102 has both screens for input and output, and the program 4102 has disks for both input and output.

On the other hand, since the check master 103 has a one-to-one relationship with the check algorithm, when the check algorithm used in each data check program 102 is common, the same check master 103 is sent from each data check program 102 as shown in the figure. Data can be checked by the same check algorithm by indexing. Therefore, if only the check master 103 performs the work associated with the change of the check algorithm, the check program can be dealt with without changing the check program.

As described above, in each of the embodiments, the conditional expressions at each node are all conditional expressions that indicate that the measured values are appropriate. However, as a matter of course, this is an incorrect measured value. May be a conditional expression indicating that, and in that case, YES and N of the check master 103
It goes without saying that the content of O is the reverse of the case where it is a conditional expression indicating that the measured value is appropriate.

[0048]

Since the present invention is constructed as described above, it has the following effects.

Since it is composed of a data check program and a check master, a complicated algorithm for data check can be easily set.

Further, by providing the first pointer and the second pointer, it is possible to set the processing such that the processing is shifted to the next processing depending on the result of the conditional expression or the processing is stopped without shifting and is displayed as an error. Can be easy.

Further, by providing the discriminator, when the check target data is other than numerical data, it is possible to discriminate that fact and display an error.

By providing the identifier, it is possible to identify the check condition in which the error has occurred.

Furthermore, by providing the data attribute with a partition, the index records can be distinguished by the data partition, so that different check conditions can be applied to the same data.

Further, since the check condition table for setting the check condition of the processing control table is provided in the check master, the table can be indexed any number of times by defining the table once under the same check condition. Is.

Further, since the conditional expression number is set in the processing control table, the necessary data check flow can be formed by combining the conditional expressions.

Further, since the check condition table is composed of the condition expression number and the condition expression, it is possible to set an arbitrary condition expression used for checking.

Furthermore, by continuously connecting the conditional expressions, it is possible to determine that the measured values can be used when all the conditional expressions are satisfied.

Further, since the check is performed by the conditional expression of the related item, the reliability as the measured value can be further checked.

Further, since the check condition table is searched using the conditional expression number in the processing control table as a key and the check is performed by the obtained conditional expression, complicated algorithm setting and fine control in data checking can be performed. Easy to implement.

Since the same check master can be referred to by a plurality of data check programs, the same algorithm can be efficiently provided to a plurality of check programs.

[Brief description of drawings]

FIG. 1 is a system configuration diagram showing a first embodiment of the present invention.

FIG. 2 is a file layout diagram of a check master according to the first embodiment of the present invention.

FIG. 3 is a flowchart showing the first embodiment of the present invention.

FIG. 4 is a flowchart showing a second embodiment of the present invention.

FIG. 5 is a file configuration diagram showing a second embodiment of the present invention.

FIG. 6 is a flowchart showing a third embodiment of the present invention.

FIG. 7 is a file configuration diagram showing a third embodiment of the present invention.

FIG. 8 is a flowchart showing a fourth embodiment of the present invention.

FIG. 9 is a file configuration diagram showing a fourth embodiment of the present invention.

FIG. 10 is a flowchart showing a fifth embodiment of the present invention.

FIG. 11 is a file configuration diagram showing a fifth embodiment of the present invention.

FIG. 12 is a flowchart showing a sixth embodiment of the present invention.

FIG. 13 is a file configuration diagram showing a sixth embodiment of the present invention.

FIG. 14 is a flowchart and a file configuration diagram showing an embodiment 7 of the present invention.

FIG. 15 is a flow chart and a file configuration diagram showing an eighth embodiment of the present invention.

FIG. 16 is a check item diagram showing a conventional data check device.

[Explanation of symbols]

101 check target data, 102 data check program, 103 check master, 106 data attribute, 109 process control table, 110 check condition table

Claims (12)

[Claims] 1. A check target data composed of a data attribute and a data value, a check master composed of the data attribute and a processing control table, a check obtained by reading the check target data and searching the check master using the data attribute as a key. A data check device in a clinical test system comprising data check means for checking by a master. 2. The processing control table includes a condition number, a conditional expression, a first pointer indicating the next node number to which processing is to be performed when this conditional expression is satisfied, and a next pointer to which processing is moved when the conditional expression is not satisfied. 2. The data check device according to claim 1, further comprising a second pointer indicating a node number. 3. The processing control table includes a condition number, a conditional expression, a first pointer indicating the next node number to which processing is to be performed when this conditional expression is satisfied, and a next pointer to which processing is moved when the conditional expression is not satisfied. 2. The data check device according to claim 1, further comprising a second pointer indicating a node number and a discriminator indicating that the data type of each node is other than the data type to be checked. 4. The data according to claim 2, wherein the processing control table includes an identifier for identifying a check condition when an error occurs or a check condition when the process ends normally. Checking device. 5. The data check apparatus according to claim 1, wherein the data attribute includes an attribute indicating an inspection type and a section indicating a different check condition. 6. A check target data consisting of a data attribute and a data value, a check master consisting of the data attribute and a processing control table and a check condition table for setting a conditional expression of this processing control table, and the above-mentioned data by reading the check target data. A data check device in a clinical examination system comprising a data check means for searching the check master by using the attribute as a key and checking the check master obtained. 7. The processing control table comprises a condition number, a first pointer, a second pointer, and a conditional expression number designating a conditional expression in the check condition table. 6. The data check device described in 6. 8. The data check apparatus according to claim 6 or 7, wherein the check condition table includes the conditional expression number and the conditional expression. 9. The check target data is checked by a first conditional expression indicating that it is appropriate as a measurement value, and if the conditional expression is not satisfied, it is judged as an error and the processing is terminated. Step to transfer processing to conditional expression,
Check the check target data with the second conditional expression that indicates that it is appropriate as a measured value.If the conditional expression is not satisfied, judge it as an error and terminate the processing. If the conditional expression is satisfied, process it with the next conditional expression. The method for checking data in a clinical test system, comprising determining that the measurement value can be used when all the preset conditional expressions are satisfied. 10. The data checking method according to claim 9, wherein when the conditional expression is not satisfied, the conditional expression of the related item related to the check target data is used for checking. 11. A step of reading check target data consisting of a data attribute and a data value, a step of searching a check master using the data attribute as a key, and a conditional expression in a first condition number of a record of a processing control table in the data attribute. The step of searching the check condition table using the number as a key, the step of checking by the first conditional expression obtained from the check condition table, and the result of this check, the second pointer designated by the first pointer or the second pointer. A data check method comprising a step of searching a check condition table using a condition expression number of a condition number as a key, and a step of checking with a second conditional expression obtained from the check condition table. 12. A check master including a data attribute and a processing control table, first check target data including the data attribute and data value, the first check target data is read, and the check master is set using the data attribute as a key. First data check means for checking by the check master obtained by retrieval, second check target data consisting of the above data attribute and data value, this second check target data is read, and the above check is performed using the above data attribute as a key A data check device in a clinical examination system comprising a second data check means for searching a master and checking by the check master obtained.