JPH0573378A - Data base record layout conversion system - Google Patents

Abstract

PURPOSE:To improve the use efficiency of a data base by converting the record layout of data during the execution of a transaction program when the record layout of part of the data base is altered, and eliminating use restrictions of the data base accompanying batch conversion. CONSTITUTION:A layout control table which stores and controls the latest record layout information is provided and a layout Rev check processing part 3 compares record layout information on data, read out by a data base read processing part 2 with the indication of the transaction program 1, with record layout information in a layout control table 2. The record layout is unchanged when they match each other, but converted into the latest layout by a layout conversion processing part 4 when not.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database record layout conversion system.

[0002]

2. Description of the Related Art In the conventional database record layout conversion method, when the record layout of a part of the database is changed and the data in the database is converted to a new layout, first the record whose layout is to be converted and that record are converted. All records that are logically related to are once saved to another medium such as a magnetic tape.

Then, the saved records are sequentially read, and if the record is a conversion target, a conversion process is performed from the old record layout to the new record layout. If the record is not the conversion target, the same layout is output without conversion. ..

Since the record output through the record layout conversion processing has a new layout, the original database restoration processing is executed based on this and the data in the database is converted to the new RAID layout. Converting.

[0005]

The above-mentioned conventional database record layout conversion method saves the record of the layout change required and the record related to the layout change to another medium, and saves them before the restoration after the conversion process. Even if the updated record is updated, the update process becomes invalid because the restore process is executed, and the update process cannot be performed.

Further, if the business process program refers to the record of the database with the new layout before executing the conversion process of the database layout, the business process program will execute an abnormal process.

As described above, when changing the record layout, the conventional method has a drawback that the use of the database is limited until the conversion processing is executed.

[0008]

A database record layout conversion method of the present invention is a database for storing a plurality of data including record layout information, a record layout information management means for storing and managing the latest record layout information, and a business operation. Database reading means for reading the data designated by the program from the database, and a record for comparing the record layout information supplied from the database reading means with the latest record layout information stored in the record layout information managing means. Layout information comparing means, and record layout converting means for converting the data read by the database reading means to the latest record layout when the comparison results of the record layout information comparing means do not match. Equipped and are configured.

[0009]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a database record layout conversion system of the present invention.

As shown in FIG. 1, the database record layout conversion method of the present embodiment operates when referring to a business program 1 that executes a business and refers to or updates the database 8 and records in the database 8. The database read processing unit 2 that reads records from the database 8 and sets the contents of the records in the database input / output area unit 5, and the layout number added to the beginning of the records in the database 8 (indicating the type of layout)
And a layout Rev (indicating the number of times the layout has been changed) are taken out, the layout number in the layout management table 7 is compared with the layout Rev, and the result is returned, and the record layout is changed. Works on the old record layout 9
A layout conversion processing unit 4 for converting the record layout to the new record layout 10 and setting the latest layout Rev,
The database I / O area unit 5 used by the business program 1 to refer to and update the contents of the record of the beta base 8 and the database I / O area unit 5 operates when updating the record, and the database I / O area unit 5 moves to the database 8. It is composed of a database writing processing unit 6 for writing back contents, a layout management table 7 for managing layout numbers and layout Rev, and a database 8 for storing various data.

FIG. 2 shows the layout number and the layout Re.
old record layout 9 consisting of v, items A, B and C, FIG. 3 shows layout number, layout Re
A new record layout 10 is shown that is made up of v, items A, D, B and C.

In order for the business program 1 to refer to the information in the record of the database 8 while the process is being executed, the database read processing unit 2 is operated. The database read processing unit 2 reads the record instructed by the business program 1 from the database 8.

The layout Rev check processing unit 3 determines the layout number at the beginning of the record and the layout Rev.
And the layout number managed on the layout management table 7 is compared with the layout Rev, and if they are the same, it is determined that the layout is the latest record layout. If the read record is the latest record layout, the database read processing unit 2 sets the read record in the database input / output area unit 5 so that the business program 1 can refer to it, and ends.

If the comparison result in the layout Rev check processing unit 3 does not match, it is determined that the read record has the old record layout. For example, if the read record is the old record layout 9, the layout Rev check processing unit 3 extracts the layout number (m) and layout Rev (n-1) from this and manages the layout number in the layout management table 7. (M)
It is determined that the layout is the old record layout. When it is determined that the layout is the old record layout, the layout conversion processing unit 4 operates.

The layout conversion processing unit 4 judges that the layout Rev of the read record is (n-1) and the latest layout Rev is (n), and the layout from (n-1) to (n) is determined. Execute the conversion process. The difference between the layouts Rev (n-1) and (n) is that item D is added between item A and item B. Therefore, in the layout conversion processing unit 4, item A of the old record layout 9
B and C are items A of the new record layout 10,
The new record layout 10 is created by setting B and C and newly setting the information of the item D. Then, the latest layout Rev (n) is set in the layout Rev, and the process ends.

The business program 1 refers to the new record layout 10 set in the database input / output area section 5 to execute business processing. The contents of the database read by the business program 1 are changed and written in the database input / output area section 5. The database write process is executed after updating all the changed items.

The database write processing unit 6 takes out a write record from the database input / output area unit 5, issues a database update command to write it in the database 8, updates the database 8 and ends the process.

The business program 1 determines that the database write processing unit 6 has normally written to the database 8 and terminates.

[0020]

As described above, in the database record layout conversion method of the present invention, the record layout information (layout number and layout Rev in the embodiment) is added to all the records forming the database,
This is checked every time the database is referenced, and the data for which the layout has been changed is converted to the latest record layout and passed to the business program, so even if the record layout is changed, business processing can be performed without stopping the use of the database. There is an effect that the record layout conversion processing can be performed during execution, and the efficiency of use of the database can be improved.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a database record layout conversion system of the present invention.

FIG. 2 is a layout diagram showing an old record layout.

FIG. 3 is a layout diagram showing a new record layout.

[Explanation of symbols]

 1 business program 2 database read processing unit 3 layout Rev check processing unit 4 layout conversion processing unit 5 database input / output area unit 6 database writing processing unit 7 layout management table 8 database 9 old record layout 10 new record layout

Claims (4)

[Claims] 1. A database for storing a plurality of data including record layout information, a record layout information managing means for storing and managing the latest record layout information, and a database reading for reading out data designated by a business program from the database. Means, a record layout information comparing means for comparing the record layout information supplied from the database reading means with the latest record layout information stored in the record layout information managing means, and a comparison between the record layout information comparing means. A database record layout conversion method, comprising: record layout conversion means for converting the data read by the database reading means into the latest record layout when the results do not match. 2. The database record layout conversion method, wherein the record layout information of claim 1 includes record layout type information and version number information indicating the number of times the record layout has been changed for each type. 3. The database record layout conversion method according to claim 2, wherein the record layout information comparing means compares the version number information with respect to the same record layout type information. 4. A database record layout conversion method comprising a database writing means for writing the data for which layout conversion has been performed in claim 1, 2 or 3 in a database.