JPH03246737A - Data base update control system - Google Patents

Abstract

PURPOSE:To simulate the update processing of a data base without updating the data base really by registering updated data on an updated image file. CONSTITUTION:When the update requirement of data is issued following the retrieval requirement of the data, a data base managing system 22 updates the data already fetched in a main memory device based on the above retrieval requirement of the data by using a data update processing means 223. The updated data is written on the update image file 24 in an external memory device operated at high speed and small in capacity. In other words, only an update image is registered on the update image file 24 without updating the data base 23 itself. In such a manner, it is possible to simulate the update processing of the data base 24 used in a real job in the time zone of the real job.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database update control method, and particularly to a database update control method that simulates database update processing without updating the database itself.

[Conventional technology]

Conventionally, in this type of database update control method, when simulating a database update process, as shown in FIG. 5, the entire database is copied to a separate body and the update process is performed on the copied database. Alternatively, as shown in FIG. 6, the database itself is updated, the updated image is output as journal data, and after the update process is completed, the journal data is used to restore the database itself.

[Problem to be solved by the invention]

In the conventional database update control method described above, when simulating database update processing, if the entire database is copied to another medium and update processing is performed on the copied database, it is necessary to copy the entire database to another medium and perform update processing on the copied database. The disadvantage is that a large amount of file capacity is required in a secondary storage device as a separate medium.

Also, when updating the database itself, outputting the updated image as journal data, and restoring the database itself using the journal data after the update process is complete,
A database currently in use in an actual business has the drawback that the business operation must be stopped, and update processing cannot be simulated simultaneously during six business operations.

In view of the above, an object of the present invention is to provide a database update control method in which updated data is registered in an update image file and database update processing is simulated without actually updating the database. It's about doing.

[Means for Solving the Problems] The database update control method of the present invention provides a data position determination means for determining whether the latest image of data for which a search request is made is in the database or in an update image file in a database management system. and a data search processing means that retrieves the data from the database when the data position determining means determines that the latest image of the data is in the database and retrieves the data from the updated image file when it is determined that the latest image of the data is located in the updated image file. , a data update processing means for updating the data retrieved by this data search processing means and registering the updated data in an update image file; and a latest image of the data updated by this data update processing means is in the update image file. and a data location management means for managing the information.

[Effect]

In the database update control method of the present invention, the data position determination means determines whether the latest image of the data for which a search request is made is in the database or in the update image file, and the data search processing means uses the data position determination means to update the data. When it is determined that the latest image is in the database, the data is retrieved from the database; when it is determined that the latest image is in the update image file, the data is retrieved from the update image file, and the data update processing means retrieves the data by the data search processing means. and registers the updated data in the update image file, and the data position management means manages that the latest image of the data updated by the data update processing means is in the update image file.

〔Example〕

Next, the present invention will be explained in detail with reference to the drawings.

FIG. 2 is a block diagram showing the hardware configuration of a database processing system to which a database update control method according to an embodiment of the present invention is applied. This database processing system includes a main storage device 1, a central processing unit 2,
It is configured to include a database processing device 3, and hierarchized external storage devices including a high-speed/small-capacity external storage device 4 and a medium-low-speed/large-capacity external storage device 5.

FIG. 1 is a block diagram showing the configuration of a database management system 22 in which a database update control method according to an embodiment of the present invention is applied. This database management system 22 is installed on the database processing device 3, and includes input means 2 for making data search requests and update requests.
1, a database 23 provided on a medium/low speed/large capacity external storage device 5, and an update image file 24 provided on a high speed/small capacity external storage device 4.

The database management system 22 includes a data position determining means 221 that determines whether the latest image of the data for which a search request is made is on the database 23 or on the update image file 24 by referring to the data position managing means 224; A data search processing means 222 retrieves requested data from the database 23 or update image file 24 onto the main storage device fl, and updates the retrieved data onto the main storage device 1 and transfers the updated data to an update image file. Data update processing means 223 registered in 24
and a data location management means 224 that manages whether the latest image of data is on the database 23 or the updated image file 24.

The database 23 includes a record section 231 and an index section 23.
2.

The update image file 24 is the update image data 24
Contains 1.

Referring to FIG. 3, the processing at the time of a data search request in the database update control method of this embodiment includes a data search request step 31, a data latest image storage position determination step 32, and a data retrieval step 33 from the database. , and a data retrieval step 34 from the updated image file.

Referring to FIG. 4, the processing at the time of a data update request in the database update control method of this embodiment includes a data update request step 41, a data update step 42, an update data update image file write step 43, and a data update request step 41. and an image position management step 44.

Next, the operation of the database update control system of this embodiment configured as described above will be explained.

Data search requests and update requests for the database 23 are input to the database management system 22 through the input means 21 .

When there is a data search request prior to a data update request (step 31), the database management system 22
Using the data position determining means 221, the data position management means 224 is used to check whether the latest image of the requested data exists in the database 23 on the medium/low speed/large capacity external storage device 5. Storage device 4
It is determined whether the latest image of the search-requested data exists in the update image file 24 (step 32). If the latest image of the requested data does not exist in the update image file 24,
The database management system 22 retrieves data from the database 23 on the medium-low speed/large-capacity external storage device 5 onto the main storage device 1 using the data search processing means 222 (step 33), and retrieves the latest data requested for search. If the image exists in the update image file 24, the database management system 22 uses the data retrieval processing means 2.
22 is used to retrieve data from the update image file 24 on the high-speed, small-capacity external storage device 4 onto the main storage device 1 (step 34).

When a data update request follows a data search request (
Step 41), the database management system 22 uses the data update processing means 223 to update the data already retrieved on the main storage device 1 based on the previous data search request.Step 42), the updated data Update image file 2 on high-speed, small-capacity external storage device 4
Further, the database management system 22 uses the data location management means 224 to manage that the latest image of the updated data is in the updated image file 24 (step 44).

〔Effect of the invention〕

As explained above, the present invention registers only the update image in the update image file without updating the database itself in the database data update process, thereby making it possible to update the database in use in actual business. This has the effect of being able to simulate database update processing during business operation hours.

Furthermore, it is possible to speed up simulation processing time, reduce the file size on external storage devices required for simulation processing, and reduce the risk of data destruction by updating the database itself. There is.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of a database management system to which a database update control method according to an embodiment of the present invention is applied, and FIG. 2 is a block diagram of a database processing system equipped with the database management system shown in FIG. A block diagram showing the hardware configuration. FIG. 3 is a flowchart showing the processing at the time of a data search request in the database update control method of this embodiment. FIG. 4 is a flow chart showing the processing at the time of a data update request in the database update control method of this embodiment. FIG. 5 is an explanatory diagram showing an example of conventional data header update processing. FIG. 6 is an explanatory diagram showing another example of conventional database update processing. In the figure, ■...Main storage device, 2...Central processing unit, 3...Data search processing means, 4...High speed/small capacity external storage device, 5...Medium/low speed/large capacity external Storage device, 21. Input means, 22. Database management system, 23. Data database, 24. Update image file, 22. Data position determination means, 222. Data search processing means, 223. Data update processing means. 24 31 32 24 Data position management means: - record section; - index section; - update image data.

Claims (1)

[Scope of Claim] In a database management system, data position determining means determines whether the latest image of the data for which a search request is made is in the database or in an update image file; data search processing means for extracting data from the database when it is determined that the data is in the database and extracting the data from the update image file when it is determined that the data is in the update image file; It has a data update processing means for updating and registering the updated data in an update image file, and a data position management means for managing that the latest image of the data updated by the data update processing means is in the update image file. A database update control method characterized by: