JPH0785094A - Method for automatically matching distributed data - Google Patents

Abstract

PURPOSE:To automatically match the same data as the changed distributed data with the changed data when any of the distribued data is changed. CONSTITUTION:When the contents of data in a database 32 is changed, whether the changed data and the data with the same contents are stored in either local database 38 or 42 is retrieved and rewriting is performed so that the retrieved data and the changed data can have the same contents. When the contents of the local database 38 and 42 are changed, whether the changed data and the data with the same contents are stored in database 32 or local database 38 or 42 is retrieved. The retrieved data is rewritten so that it has the same contents with the changed data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a distributed data automatic matching method which is effective when applied to a process control computer system used in, for example, a production factory.

[0002]

2. Description of the Related Art Conventionally, in a production plant such as an automobile, a production plan is made according to the order situation collected from each sales company and the operation of various production machines installed in the factory is based on this production plan. Are in control.

A computer system is provided to perform such control. As an example of such a computer system, a system as shown in FIG. 8 can be exemplified.

This computer system is of a distributed type, and the main computer 10 has master data 12 which functions as a database. The subsystem 14 is, for example, a computer that controls a production line such as a factory, and this computer mainly has local data 16 that functions as a database storing data for the computer. On the other hand, the computer 20 creates, for example, production instructions for all factories, and this computer 20 also has local data 22 that mainly functions as a database that stores data for this computer. Local data 16 and local data 22
Stores the data from the master data 12 sent from the computer 10 as it is, and also stores the data independently generated by the subsystem 14 or the computer 20.

Therefore, the same data as the master data 12 exists in the local data 16 and 22,
The subsystem 14 and the computer 20 perform various calculations based on this data.

[0006]

However, in the conventional system as described above, the master data 12
Since the same data as that possessed by each computer will be distributed to each local data, if this distributed data is modified by any computer, Since the data cannot be matched, the system will not start up and other problems will occur.Therefore, it is necessary to modify the same data on all computers in the same way. Not only was it time-consuming, but there was also a problem with the reliability of the modified data.

For example, when a part of the data of the local data 16 is changed due to a line abnormality in the subsystem 14 which controls the production line, the master data 12 or the local data 22 is changed. The same data as the data needs to be the same as the changed data, but the work needs to be performed manually by a human based on a list in which the data before the change and the data after the change are described. Therefore, it takes a lot of time for the work, and there is a problem in the reliability of the data after the change because the input error is inherent.

[0008]

The present invention for achieving the above object provides a host computer having master data, and a local computer having local data having the same contents as the master data and connected to the host computer. When the content of the master data is changed in an automatic distributed data matching method used in a computer system configured by, the local data having the same content as the master table is stored in any local computer. It is characterized in that the searched local data is rewritten so as to have the same contents as the changed master data.

Further, automatic distributed data used in a computer system comprising a host computer having master data and local data having the same contents as the master data and connected to the host computer A matching method,
When the content of the local data is changed, the local data and the master data searched for which local data and master data having the same content as the local data are stored, and the searched local data and master data are searched. Is rewritten to have the same contents as the changed local data.

[0010]

According to the present invention thus constructed, when the content of the master data is changed, it is searched for which local computer stores the local data having the same content as the master table, and the search is performed. Since the written local data is rewritten so as to have the same content as the changed master data, not only the input work becomes unnecessary, but also the element of erroneous input of data is completely eliminated. When the content of the local data is changed, the local data and the master data having the same content as the local data are searched for, and the retrieved local data and the master data are changed. Since the data is rewritten so as to have the same content as the subsequent local data, not only the input work becomes unnecessary, but also the element of erroneous input of data is completely eliminated.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 shows an example of an apparatus that executes the distributed data automatic matching method according to the present invention. A database 32 is connected to the process management host computer 30 that controls and manages the devices arranged on the production line. The database 32 includes one day's worth of data on the types of vehicles to be produced on that day and Master data such as a data relational table described later is stored. The line management online processing unit 35 and the line management batch processing unit 36 perform online processing or batch processing on the control information from the process management host computer 30. A local database 38 is connected to the line management online processing unit 35. In this local database 38, data obtained by processing the data A stored in the database 32 corresponds to one tact, that is, data A ′. It is remembered for half a day. The PLC 39 is a so-called sequencer that directly controls the equipment 40, and a local database 42 is connected to it. In this local database 42, data obtained by processing the data A'stored in the local database 38 is stored as data A "for 30 minutes. The existing data is local data.

FIG. 2 is a schematic block diagram for explaining an automatic matching method for distributed data according to the present invention. In the configuration shown in FIG. 1, only a portion required for executing the method of the present invention is extracted. It is described conceptually. The host computer 45 constitutes a part of the above-mentioned process control computer 30, and the host computer 45 has databases 32A, 3A constituting a database 32.
2B are respectively connected. The database 32A stores a data relational table described later, and the database 32B stores data A. The data A ′ processing unit 47 is provided in the line management online processing unit 35 and is a unit that processes the data A into data A ′.
The data A'inverse processing unit 49 converts the data A'to the data A based on the connected input data and output data databases 50A and 50B.

The general construction of the apparatus for executing the distributed data automatic matching method of the present invention is as described above.
How the data consistency is obtained by this method will be described with reference to the flowcharts shown in FIG.

FIG. 3 shows an example of a data relational table, and this table shows which program or data is stored where. For example, master data
ScheduleA is stored in the process management host computer 30, and is the relation data Sc.
It indicates that hedule A ′ is stored in the support host computer, the assembly instruction host computer, and the PLC # 1 which are subordinate computers of the process management host computer 30, and Schedule A ″ is stored in the PLC # 2. ing.

The flow chart shown in FIG. 4 shows a process for matching the local data with the master data when the master data is changed. This processing is performed by the host computer 45.

When the master data is changed, the host computer 45 refers to the data relational table (RT) to find out where the same data as the changed master data is, and to modify the data. Understand whether or not separation has been performed (S
1, S2). If the processing is performed, the processing is re-executed and the location of the relation data is grasped from the RT (S3 to S5). Next, the data of all the relational data is divided, and the re-transfer of all the relational data is performed until all the data is completed (S6, S7). If the master data is changed by this processing, The changed data is automatically changed to the changed data. At this time, this change is performed even if the target data has already been processed.

Next, the flow chart shown in FIG. 5 shows the process of collating the changed data with the data before the change.

When the data in the master table is changed, the data relational table is searched to ascertain where the changed data is, and the location of the relational data is ascertained. For example, when the master data is Schedule A, the location of the relational data Schedule A'is searched by referring to the data relational table. In this case, the relational data is the support host computer, the assembly host computer PLC
It can be seen that they exist in # 1 (S11, S1).
2). Next, if you retrieve all the relational data retrieved, and if the retrieved data has been processed, perform the same processing as that on each of the changed master data, Check the data. The collation result is displayed on the screen so that the collation result can be confirmed (S13 to S).
17). The above collation is performed until all the data are completed (S18).

Further, the flow chart shown in FIG. 6 shows a process for adjusting the master data and the like to the changed data when the relational data is forcibly changed.

First, the host computer 45 refers to the data relational table to search whether the relevant relational data, that is, the relational data after the change is set as the master data. For example, if the relational data is Schedule A ', a search is made as to whether this Schedule A'exists in the master data column (S31). After this search is completed, the relational data under the master data is changed. This process is shown in FIG.
The process is exactly the same as that shown in the flowchart (S32). Next, the relational data that is the same as this relational data is searched for while referring to the data relational table, and the retrieved relational data is subjected to the same processing as the forcibly changed relational data. It is determined whether or not it has been performed (S33, S34). If the same processing is being performed, the relational data after the change can be forcibly replaced with the relational data after the change. Therefore, the relational data before the change is replaced with the relational data after the change. (S35). On the other hand, when the same processing is not performed, the flowchart shown in FIG. 7 is executed (S36).

This flow chart shows the processing for changing the master data, and this processing is performed in the data A'inverse calculation processing section 49 shown in FIG. In order to match the relational data that has been processed differently from the forcibly changed relational data with the forcibly changed relational data, it is necessary to once convert back to the data before the processing.
Input / output collation of processing is performed based on the input data 50A and the input data 50B (S41). If the processing data is grasped based on this input / output collation and the processing is performed, that is, if the input is not the same as the output,
Back calculation is performed so that the input and output are the same, and the corresponding item in the master data is changed. on the other hand. If the processing is not done, there is no need for back calculation,
Perform processing to change the corresponding item in the master data (S
43-S45). The above processing is performed until all the items of the corresponding master data are changed.

When the above processing is completed, the corresponding master data is returned to the original data before processing, so that the corresponding processing is re-executed, and the data after the execution is re-executed at the predetermined position grasped by the data relational table. Is replaced with the data (S37, S38). The above processing is performed for all the retrieved relational data (S39).

As described above, according to the embodiment of the present invention, when the master data is changed, all the same data as the master data before the change becomes the same data as the master data after the change. Will be adjusted. on the other hand,
When the local data is changed, all the same local data and master data as the local data before the change are rewritten to the changed data. Therefore, it is possible to completely eliminate the problem that the conventional work for adjusting the changed data is unnecessary and the computer cannot be started up due to a work error or the like.

[0024]

As described above, according to the present invention, when the content of the master data is changed, it is searched which local computer stores the local data having the same content as the master table. Since the retrieved local data is rewritten so as to have the same content as the changed master data, the distributed data can be made consistent with this change.

Further, when the contents of the local data are changed, it is searched which local computer stores the local data and the master data having the same contents as the local data, and the searched local data and master data are searched. Since the data is rewritten so as to have the same content as the changed local data, the distributed data can be made consistent with this change.

[Brief description of drawings]

FIG. 1 is a diagram showing an example of an apparatus for implementing the method of the present invention.

FIG. 2 is a diagram showing an example of an apparatus for realizing the method of the present invention.

FIG. 3 is a diagram showing an example of a data relational table for realizing the method of the present invention.

FIG. 4 is a flowchart showing the procedure of the method of the present invention.

FIG. 5 is a flowchart showing the procedure of the method of the present invention.

FIG. 6 is a flowchart showing the procedure of the method of the present invention.

FIG. 7 is a flowchart showing the procedure of the method of the present invention.

FIG. 8 is a diagram showing an example of an apparatus that carries out a conventional method.

[Explanation of symbols]

30 ... Process control host computer (host computer) 32 ... Database (master data) 39 ... PLC (local computer) 42 ... Local database (local data) 45 ... Host computer

─────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] September 22, 1993

[Procedure Amendment 1]

[Document name to be corrected] Drawing

[Name of item to be corrected] Figure 6

[Correction method] Change

[Correction content]

[Figure 6]

[Procedure Amendment 2]

[Document name to be corrected] Drawing

[Name of item to be corrected] Figure 7

[Correction method] Change

[Correction content]

[Figure 7]

[Procedure 3]

[Document name to be corrected] Drawing

[Correction target item name] Figure 8

[Correction method] Change

[Correction content]

[Figure 8]

Claims (2)

[Claims] 1. Automatic distributed data used for a computer system comprising a host computer having master data and local data having the same contents as the master data and connected to the host computer. A matching method, when the content of the master data is changed, a search is made to which local computer local data having the same content as the master table is stored,
An automatic matching method for distributed data that rewrites the retrieved local data so that it has the same content as the changed master data. 2. Automatic distributed data used in a computer system comprising a host computer having master data and local data having the same contents as the master data and connected to the host computer. In the matching method, when the content of the local data is changed, the local data and master data having the same content as the local data are searched and searched for in which local computer and host computer. A method for automatically matching distributed data, characterized in that the local data and master data are rewritten to have the same contents as the changed local data.