JP2845886B2 - Management processing method for each generation data - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Application Field] The present invention relates to a computer system having a processing function of managing generations of data used by a program, and a management processing method of each generation data for managing generation data with difference information. About.

[Conventional technology]

Data such as system generation parameters is normally subjected to generation management. This is because it may be necessary to restore the operating environment of the system to a state several generations earlier due to operational reasons.

Generally, when performing data generation management, the following two methods are used.

(A) A method of recording all information for each generation.

Every time data has a generation, all information for each generation is stored in a file or the like and managed. In this method, it is easy to refer to each generation data, and simply select the specified generation.
The feature is that restoration to the specified generation can be realized at high speed. However, for data that has not been changed, the same data is duplicated for each generation, and the storage space tends to be squeezed.

(B) A method for managing differences.

By accumulating the difference (change data) between the old generation and the current generation when the data is changed and the timing of the change, a generation is formed and restoration is possible. Therefore, as a process for restoring the data to the old generation, it is necessary to execute the reverse procedure when the data is actually changed.
There is a problem that it takes time to restore the data.

[Problems to be solved by the invention]

As described above, conventionally, if all the information for each generation is recorded independently, there is a problem that the storage space is squeezed. If the generation data is managed by the difference information between the generations, the restoration to the old generation is performed. It takes a long time, and there is a problem that the man-machine interface is bad.

SUMMARY OF THE INVENTION It is an object of the present invention to solve the above problems and to provide means for efficiently managing generation data and increasing the speed of referring to a restored generation.

[Means for solving the problem]

 FIG. 1 shows a configuration example of the present invention.

In FIG. 1, 10 is a processing unit including a CPU and a memory, 11 is a display, 12 is a keyboard for inputting various data and instructions, 13 is a man-machine interface unit for controlling input and output with the display 11 and the keyboard 12, 14 is a management unit that manages change / restore triggers, 15 is a difference transmission processing unit that notifies the request source of difference information regarding generation data, 16 is a data use component such as a user program or system component that uses data, and 17 is a data use component. A control table used by each data usage component 16 when executing a program, 18 is a user information storage area for storing generation data, 19 is a generation management difference information database having generation data as difference information, and 20 is a program and data load. Represents various libraries with modules and the like.

A generation management difference information database 19 composed of a relational database is created in the user information storage area 18, and data added, changed, or deleted in each generation is sequentially stored in the same table in the relational database in the immediately preceding generation. This is stored as difference information between the new generation and the new generation.

The man-machine interface unit 13 immediately displays information necessary for generation management with reference to the user information storage area 18 in relation to input of change data or input of a restored generation.
At this time, in order to search the generation management difference information database 19, a relational database search language can be used. When there is an instruction of a change trigger or a restore trigger, the man-machine interface unit 13 notifies the management unit 14 of the trigger.

The management unit 14 monitors the time, and notifies the data use component 16 of the change or the restoration when the notified change or restoration is triggered.

The data use component 16 is a program that uses data in the control table 17 or the various libraries 20. When receiving an instruction to change or restore the data, the data use component 16 sends the data necessary for the change or restoration to the difference transmission processing unit 15. Contact

In response to a request from the data use component 16, the difference transfer processing unit 15 reads the designated difference information from the user information storage area 18 and transmits the read difference information to the data use component 16.

[Action]

 The process for inputting change data is as follows.

(1) The user selects menu input through conversation with the man-machine interface unit 13 and inputs change data and a change trigger.

(2) In the user information storage area 18, for example, a relational database type generation management difference information database 19
Is provided, and the man-machine interface unit 13
When change data is input, it is recorded as a tuple with a generation.

(3) The changed data is transmitted asynchronously with the input of the changed data, based on the designated change trigger, in the differential transmission processing unit.
The data use component 16 is notified via 15.

 The process for restoring the generation is as follows.

(1) The user selects a menu reference and inputs a restoration generation through a conversation with the man-machine interface unit 13.

(2) The man-machine interface unit 13 retrieves the generation data specified by the user from the generation management difference information database 19 and displays it.

(3) The user instructs whether or not to make the restored data valid, and the opportunity for restoration when making the data valid.

(4) The restoration trigger is notified to the management unit 14 and managed. When the restoration trigger is issued, an instruction for restoration to the data use component 16 is issued, and the data use component 16 is transmitted to the data use component 16 via the difference transmission processing unit 15. Difference information for restoration is transmitted.

As described above, since the reference process and the actual restoration process are divided, the man-machine interface unit 13 can provide the user with the same high-speed reference function for any generation. . In addition, since the generation data is managed by the difference information, the amount of data accumulated for the generation can be minimized. Since the actual reflection is performed at the specified timing, the user does not need to be aware of the time required for restoration.

〔Example〕

In this embodiment, generation data is managed by a relational database. First, generation updating will be described according to a specific example.

[Update of generation] The storage mechanism when data is added / changed / deleted is as follows.

(1) Assume that the database is configured as follows in the state of 1.1 generations.

(2) Next, assuming that data 1 = "C" is changed to "X" in the 1.2 generation, the above table becomes as follows.

(3) Next, in the 1.3 generation, data 1 = “Y”, data 2 =
When data “10” is added, the result is as follows.

(4) Next, in the 1.4 generation, data 1 = “Y”, data 2 =
When the data of "10" is deleted, the result is as follows.

The storage by the above-described mechanism is based on difference management, and it can be said that generation management is performed with a minimum necessary data amount.

The reference logic of the database when referring to the generation from the information in the 1.4 generation will be described below. As a search language, an existing database search language can be used.

[Regarding reference to generations] (1) When acquiring the latest information When a user wants to refer to information that is valid in the latest generation (1.4 generations), search is performed under the following conditions.

Condition Valid end generation = NULL The next valid data is extracted and displayed.

(2) When Restoring to 1.3 Generation When restoring to 1.3 generation, it is possible to check out the data created in 1.4 generation and refer to it by specifying the following.

Condition Valid start generation ≤ 1.3 AND (valid end generation> 1.
3 OR valid end generation = NULL) The difference at the time of restoration is as follows: Condition Effective start generation = 1.3 Therefore, when there is a restoration request, the difference transmission processing unit can asynchronously transmit the difference data for the restoration to the component that uses the data at the request.

The same process can be used to transmit the difference and restore the 1.2 and 1.1 generations.

As can be seen from the above example, the information necessary for generation management can be immediately retrieved from the latest generation by the conditional statement. As a result, the user information storage area 18 shown in FIG.
Therefore, the man-machine interface unit 13 can acquire all the data of the specified generation, and the difference transmission processing unit 15 can acquire the difference data at the time of change / restoration. Asynchronous processing with the difference transmission processing unit 15 can be realized.

FIG. 2 shows an example of generation restoration processing according to an embodiment of the present invention. Hereinafter, the flow of processing at the time of generation restoration will be described according to the processing shown in FIG. In addition,
The same applies to the processing for inputting change data. At the time of restoration, the generation goes in the negative direction, while at the time of change,
Generations can be considered positive.

When restoration of a generation is instructed by a menu or the like, the man-machine interface unit 13 inputs an identifier X of the generation to be restored and a reflection trigger Y for when to restore.

By inputting the identifier X and the reflection trigger Y, the generation data corresponding to the identifier X is extracted and acquired from the user information storage area by using a database search language or the like.

The extracted restoration data is edited, immediately displayed on the display screen, and presented to the user.

The management unit 14 is notified of the reflection trigger Y and the like, and the processing of the man-machine interface unit 13 ends.

The management unit 14 stores the reflection trigger Y notified from the man-machine interface unit 13 and performs time monitoring.

It is checked whether or not the reflection trigger Y has been reached. If the reflection trigger Y has been reached, the following processing is executed.

The generation identifier X is notified to the data use component 16 that uses the data to be restored.

In the data use component 16, the difference transmission processing unit
Requests the data of the generation identifier X from 15.

The difference transmission processing unit 15 determines whether the request is a request for restored data or a request for changed data. That is, it is determined whether or not the generation identifier X is specified. If the generation identifier X is specified, it is a request for restoration data.
Executes the process and executes the process if X is not specified.

The data corresponding to the generation identifier X and its size and data type are extracted from the user information storage area and transmitted to the requesting data use component 16.

If the generation identifier X is not specified, other processing such as notification of change data is executed.

When receiving the restored data corresponding to the generation identifier X, the data use component 16 acquires and analyzes a change table name or the like that should reflect the received data.

Determine whether there is a table to be restored. When the processing for all the target tables is completed, the processing shifts to the processing.

For each target table, search for the data record identifier of the data use component 16 and send the difference
Compare with the record identifier transmitted from 15.

Determines whether the record identifiers match, and skips the next process if they do not match.

The data record is replaced with the record transmitted from the difference transmission processing unit 15, and restored to the previous generation.

It is determined whether or not the record has been completed. If the record has been completed, control is transferred to the process. If not completed, control is transferred to the process.

When the processing for all the target data is completed, the processing for changing the operating environment for each data use component 16 is performed. That is, processing such as synchronization processing with the currently executed task and reflection on the memory are executed as necessary, and the restoration processing ends.

〔The invention's effect〕

As described above, according to the present invention, since the generation data reference and the actual restoration data or change data reflection processing are divided, the user is similarly required to perform high-speed processing for any generation. Can be presented with the data. Further, since the generation data is managed by the difference information, the amount of data accumulated for the generation can be reduced. The user need only specify the reflection trigger, and does not need to be aware of the time required for restoration.

[Brief description of the drawings]

FIG. 1 shows an example of the configuration of the present invention, and FIG. 2 shows an example of generation restoration processing according to an embodiment of the present invention. In the figure, 10 is a processing unit, 11 is a display, 12 is a keyboard,
13 is a man-machine interface unit, 14 is a management unit, 15 is a difference transmission processing unit, 16 is a data use component, 17 is a control table, 18 is a user information storage area, 19 is a generation management difference information database, and 20 is a library. Represent.

Claims (1)

(57) [Claims] In a computer system having a processing function of managing generations of data used by a program, data added / changed / deleted in each generation is sequentially stored as difference information between a previous generation and a new generation in a relational database. The user information storage area (18) stored in the same table and the information necessary for generation management related to the input of changed data or the input of the restored generation are requested by using the relational database database search language. A man-machine interface unit (13) that refers to the user information storage area and immediately displays it, and a management unit (14) that notifies a component that uses data related to change or restoration of a specified change or restoration opportunity. From the user information storage area due to a request from a component that uses data. And a difference transmission processing unit (15) for extracting and transmitting minute information.