JPH096660A - Correlation check method for common data in plural departments - Google Patents

Abstract

PURPOSE: To suppress the duplicate application of data among the relative departments and to improve the accuracy of data bases of these departments by checking the correlation among these relative departments when the data are applied in a certain department and then performing the synchronous updating of data bases of all departments after the correlation check is completed in a normal way. CONSTITUTION: A correlation management table 14 is included in a computer 10 which performs the on-line processing. Then the processing identification number, the correlation check information (the updating necessity information on every department, the check items, etc.) and the check state information are registered on the table 14 and undergo the centralized control. Thus the updating information can be grasped in a unitary way when the data are applied through the terminals 11 of all departments, so that the duplicate application of data can be suppressed. When the data are applied in a certain department via the table 14, the correlation check is carried out with other relative departments if the updating is needed for these departments. Then the data bases 12 of the departments are simultaneously updated as long as the correlation check is completed in a normal way. Thus the duplicate application of data can be suppressed among the departments.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing system that manages data for each department, and relates to a system for checking the correlation of data between departments. The present invention relates to a common data correlation check method in a plurality of departments suitable for improving accuracy.

[0002]

2. Description of the Related Art FIGS. 2 and 3 are images of online processing of a data processing system according to the prior art. In a general system, data is independently input for each department (for example, input from the terminal 11a of the department A), and simple input error check is performed on the input data online.
If there is an error, an error message is displayed to prompt the operator to correct it. The corrected data is processed in the same manner, and if the input check is normal, the database 12a of department A
Registered in. The updated contents for each department will be notified by reports. Each department that has received the notification determines whether or not the update is necessary and, if necessary, registers it in the database of its own department (for example, registers from the terminal 11b of department B in the database 12b).
For registration, data is input in the same manner as above, and after checking the input error online, if normal, it is registered in the database of each department. Many more systems perform cross-functional correlation checks on database data. A simple input error has already been checked in each department, and here a correlation check between departmental data is performed.
The correlation check between departmental data is performed regularly because the data may be input for each department, so the timing of completion of data input may not be immediate or the database that stores the data for each department may not be on the same computer. In general, the data is normally saved in a magnetic tape (15a and 15b in FIGS. 2 and 3) and the like, and the batch processing is usually performed. Check error information is output to a list and notified to each department.

[0003]

[Problems to be Solved by the Invention] As OA work progresses,
The amount of input data in each department tends to increase, and the relation between data in each department tends to be complicated. In the above-mentioned conventional technology, since the data is individually input for each department, the input data is duplicated between the departments. Moreover, since the triggers for updating the databases of the respective departments are different, there is a drawback in that data inconsistencies between departments are likely to occur. An object of the present invention is to improve such problems, to suppress duplication of data in each department, and to improve the accuracy of the database without trouble, and to check the correlation of common data in multiple departments. To provide a method.

[0004]

In order to achieve the above object, a method of checking correlation of common data in a plurality of departments of the present invention centrally manages correlation check information of common data of each department in an online data processing system ( For example, at 14 in FIG. 1), when data is input for each department,
Whether or not it is necessary to update other related departments is determined based on the correlation check information, and if the update is necessary, a correlation check between the departments is performed. If the result is normal, common data of each department is updated at the same time ( (For example, on 12 of FIG. 1).

[0005]

In the present invention, for example, a correlation management table is provided in a computer for performing online processing, and the processing identification number, correlation check information (update necessity information and check items for each department, etc.), check status information are provided. Register and manage centrally. As a result, the update information at the time of data input by the terminals of the respective departments can be grasped in a unified manner, and duplication of data input can be suppressed. Using this correlation management table, when inputting data in a certain department, if it is necessary to update other related departments, check the correlation with the related departments,
If the check is normal, the database of each department is updated at the same time. As a result, duplication of data input of each department can be suppressed and the accuracy of the database can be improved.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a configuration example of an online system according to the present invention. The electronic computer 10 includes a terminal system 11 used for online processing, a database 12, a business program 13 that performs transaction processing, and a correlation management table 14 that manages the correlation between departments. In the present embodiment, it is assumed that the plurality of terminal systems 11 are arranged for each department and have a database 12 for each department. For example, when the ratio of the sales (cumulative) of each department to the total sales of all departments (self department sales / total sales of all departments) is sequentially registered in the database 12 and can be referred to, the sales of other departments and the self department are mutually Databases that influence each other
It is necessary to update 2 sequentially.

FIG. 4 shows an example of the configuration of the correlation management table 14. The processing identification number 21 of the data input from the terminal 11 and the update necessity code 22 for each department (update:
0, update required: 1), check contents (check item etc.) column 23 for each department, and check status code 24 (checking: S, error: E, completion: F). The initial value of the check status code 24 guarantees a space indicating a check unexecuted status. For example, in the check content column 23, the "department sales", "all department sales", and "sales occupancy" items are provided, and the update necessity code 22 for them is "
Set to 1 ”.

FIG. 5 shows an image of online processing of this embodiment and transition of the correlation management table 14. In this embodiment, an input message including a process identification number is received from the terminal system (step 401) and the input message is checked (step 402). If the check is normal, the information of the own department is acquired from the database, registered in the work-in-progress database (if normal in step 403), and then updated with the contents of the input message (step 40).
4). In the case of an error, an error message is output (in the case of an error in step 403). Next, the correlation management table is searched by using the received process identification number as a key to obtain the correlation information of each department regarding the process identification number (step 405), and the check status code 24 is "S".
Set (Under correlation check). Also, referring to the update necessity code 22 of each department, the update necessity code 22 is "1".
In the case of (check required), the information of the corresponding department is acquired from the database and registered in the in-process database (step 406). Further, a correlation check between each department is performed based on the check content 23 (step 407). If the correlation check is normal, "F" (completed) is set in the check status code 24, and the database of each department is updated (steps 409 to 411). In the case of an error, the check status code 24 is set to "E" (with error), and the error content is output (step 408). If an error is detected, the error content is displayed on the screen of the terminal system or an adjacent printer to prompt the operator to correct the data. For example, when the terminal system of the department N inputs a message for updating, after the sales in the work-in-progress database of the department N, the sales of all departments, etc. are updated, the correlation management is performed using the preset process identification number 21 as a key. The table is searched, and the items “department sales”, “all department sales”, and “sales share ratio” in the check content column 23 of the department N are updated, and “all department sales” and “sales share ratio” of other departments are updated. Update the item and set the check status code 24 to "F".
And In this case, at the time of completion of the in-process database registration and the correlation check by the update request from the department N, the database management system (not shown) sends an update communication to the database of each department, and the progress of each database is in progress. When the in-process processing ends, new processing is suppressed. Then, the update processing is performed with the time point when the in-process processing is completed in the databases of all departments as the synchronization start point, and the access prohibition is released after the update is completed.

[0009]

According to the present invention, when data is input in a certain department, a correlation check with a related department is performed, and after the check is normally completed, the databases of all the departments are synchronized and updated, so that It is possible to reduce the duplication of data input in each department and improve the accuracy of the database between departments.

[Brief description of drawings]

FIG. 1 is a configuration diagram of an online system according to an embodiment of the present invention.

FIG. 2 is a part of a diagram showing a data processing image in a conventional online system.

FIG. 3 is a part of a diagram showing a data processing image in a conventional online system.

FIG. 4 is a diagram showing the contents of a correlation management table in an embodiment of the present invention.

FIG. 5 is a diagram showing a processing image of an online system and a transition of a correlation management table according to an embodiment of the present invention.

[Explanation of symbols]

11, 11a, 11b: terminal system, 12, 12a,
12b: database, 13: business program for performing transaction processing, 14: correlation management table, 15
a, 15b: magnetic tape.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Hidesuke Mannami 5030 Totsuka-cho, Totsuka-ku, Yokohama, Kanagawa Prefecture Software Development Division, Hitachi, Ltd. (72) Hiroyuki Kurimoto 5030 Totsuka-cho, Totsuka-ku, Yokohama, Kanagawa Bachi Co., Ltd. Hitachi, Ltd. Software Development Division

Claims (1)

[Claims] 1. A common data correlation check method for an online data processing system that stores and manages data for each department, and when data is input for each department, it is determined whether or not to update other related departments. When the update is necessary, the correlation check between departments is performed. If the check result is normal, the common data stored in each department is updated at the same time. Method.