JPH0721064A - Data base reorganizing system - Google Patents

Abstract

PURPOSE:To remarkably improve the update performance of an index part by updating the index part in physical sequence by classifying the update content of the index part comprehensively after the reorganization of a data part is performed. CONSTITUTION:A data record copying means 4 copies the record of the data part 3-1a in a data base file 3-1 on the data part 3-2a in a data base file 3-2. A copy destination address setting means 5 sets a post-copy address for a copied record on the corresponding record of the data base file 3-1. A data base file re-reading means 2 deals with the request of access from a job application program 1 by re-reading the data base files 3-1, 3-2. A file generating means 6 for index part update stores the record for update of the index part 3-1b in a file 7 for index part update. An index part update means 8 classifies the content of the file 7 for index part update after the copying of the data part 3-1a, and updates the index part 3-2b in physical sequence.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database reorganization method, and more particularly to a database reorganization method in which the contents of a database file having a data part and an index part are copied and reorganized during execution of various processes such as online processing. Regarding the organization method.

[0002]

2. Description of the Related Art A conventional database reorganization method in which the contents of a database file having a data section and an index section are copied and reorganized is used to reorganize the data section in order to enable access from a business application program. In parallel, the index section is constantly updated.

FIG. 3 is a block diagram showing an example of a conventional database reorganization method. As shown in FIG. 3, in the information processing system using the conventional database reorganization method, the business application program 31 copies data records while executing various processes such as online process using the database file 32-1. Using the means 33 and the index part updating means 34, the contents of the database file 32-1 are copied to the database file 32-2 to reorganize the file.

That is, the data record copying means 33
Is the data portion 32-1 of the database file 32-1.
Search for the record in a and search the database file 3
Every time the content of the record is stored in the data section 32-2a of 2-2, the index section updating means 34 retrieves the index record related to the record from the index section 32-1b in the database file 32-1. By searching and converting the read content, it is stored in the index section 32-2b of the database file 32-2.

[0005]

However, in the above-mentioned conventional database reorganization method, the index part is updated in parallel with the reorganization of the data part.
Since it is not performed in physical order but is performed randomly, the update performance of the index part deteriorates, and it takes too much time to update the index part, resulting in a problem in operation. are doing.

An object of the present invention is to
By updating the index part at once, the update contents can be classified and the index part can be updated in the physical order.
An object of the present invention is to provide a database reorganization method capable of significantly improving the update performance of the index part.

[0007]

A database reorganization system according to the first invention is a data section having various records and an index section for directly accessing the records during execution of various processing such as online processing. First having
In the database reorganization method in which the contents of the database file of (1) are copied into the second database file and reorganized, (A) a record in the data section of the first database file is searched for and the second database file is reorganized. A data record copying means for copying into the database file, and (B) an address of the second database file after copying the record copied by the data record copying means to the corresponding record in the first database file (C) Copy destination address setting means to be set in the inside, and (C) When a record in the first database file is requested to be accessed by the business application program, it is copied into the corresponding record in the first database file. Determine whether the subsequent address is set or not When to, not been set,
(D) the data record copying means for accessing the record of the first database file and accessing the record of the second database file using the address when the record is set. An index part update file for receiving an address of the second database file after the copy for the record copied in step 1, creates an update record for the index part of the first database file, and stores the record in the index part update file. And (E) after copying the data portion by the data record copying means, the contents of the index updating file created by the index updating file creating means are reorganized by classifying, The index part of the second database file And the index part updating means for updating in order,
It is configured with.

In the database reorganization method of the second invention, the contents of the first database file having the data part and the index part are copied into the second database file and re-executed during execution of various processes. In the database reorganization method for organizing, (A) a record in the data part of the first database file is searched and copied in the second database file, and (B) the copied record is copied to the record. When an address in the second database file is set in the corresponding record of the first database file, and (C) when an access request is made to the record in the first database file from the business application program, The address after copying is set in the corresponding record of the first database file If it is not set, access is made to the record of the first database file, and if it is set, access is made to the record of the second database file using that address. (D) Receiving an address in the second database file after copying the copied record, creating an update record for the index section of the first database file and storing it in the index section update file. And (E) after the copying of the data part is completed, the contents of the created index part update file are classified and reorganized, and the index part of the second database file is updated in physical order. I'm out.

[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 an information processing system to which the database reorganization method of the present invention is applied.

In the information processing system of this embodiment, as shown in FIG. 1, the business application program 1 uses the database file replacement means 2 to directly access the data section 3-1a having various records and those records. Using the database file 3-1 having the index section 3-1b for performing, while executing various processing such as online processing, the contents of the database file 3-1 are changed to the data section 3-2a and the index section 3-. 2b
The file is reorganized by copying it into the database file 3-2 having

The database files 3-1 and 3-
In No. 2, in order to improve the access performance, a record having a logical relationship with the root record is arranged in the vicinity of the storage area centering on the root record.

That is, when the file reorganization is instructed, the data record copying means 4 sequentially searches the records in the data section 3-1a in the database file 3-1 to find the database file 3-2. Data section 3-
It is copied in 2a.

Then, the copy destination address setting means 5 sets the address in the database file 3-2 after copying the record copied by the data record copying means 4 in the corresponding record in the database file 3-1. are doing.

FIG. 2 is a diagram showing an example of the contents of the reorganized records in the database file 3-1 of this embodiment. As shown in FIG. 2, the post-reorganization record has the post-reorganization address in the database file 3-2 at a specific position.

Therefore, when there is an access request from the business application program 1 to a record in the database file 3-1, the database file replacement means 2 copies the address in the corresponding record of the database file 3-1. Is set, and when it is not set, the record of the database file 3-1 is accessed. When it is set, the address is used to access the record of the database file 3-2. It is carried out.

As a result, the business application program 1 only needs to access the database file 3-1 during the reorganization, and it is not always necessary to access the database file 3-1 in parallel with the reorganization of the data section 3-1a. It is not necessary to update the section 3-1b.

On the other hand, the index part updating file creating means 6
Receives the address of the database file 3-2 after the copy for the record copied by the data record copying means 4, and the index unit 3 of the database file 3-1.
-1b update record is created and stored in the index part update file 7.

Finally, the index part updating means 8 stores the contents of the index part updating file 7 created by the index part updating file creating means 6 after the end of the copying by the data record copying means 4 and the database file 3-2. Index part 3 in
-2b is reorganized by categorizing them so that they can be stored in physical order, and the index section 3-2b is updated.

[0019]

As described above, the database reorganization method of the present invention for copying and reorganizing the contents of a database file having a data section and an index section during execution of various processing such as online processing is as follows. By updating the index part collectively after the reorganization of the data part, the update contents can be classified and the index part can be updated in the physical order, so that the update performance of the index part can be greatly improved. have.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of an information processing system using a database reorganization method of the present invention.

FIG. 2 is a diagram showing an example of the contents of records after reorganization in the database file 3-1 of this embodiment.

FIG. 3 is a block diagram showing an example of a conventional database reorganization method.

[Explanation of symbols]

1, 31 Business application program 2 Database file replacement means 3-1, 3-2, 32-1, 32-2 Database file 3-1a, 3-2a, 32-1a, 32-2a Data section 3-1b, 3 -2b, 32-1b, 32-2b Index part 4,33 Data record copying means 5 Copy destination address setting means 6 Index part updating file creating means 7 Index part updating file 8,34 Index part updating means

Claims (2)

[Claims] 1. A first part having a data part having various records and an index part for performing direct access to the records during execution of various processes such as online processes.
In the database reorganization method in which the contents of the database file of (1) are copied into the second database file and reorganized, (A) a record in the data section of the first database file is searched for and the second database file is reorganized. A data record copying means for copying into the database file, and (B) an address of the second database file after copying the record copied by the data record copying means to the corresponding record in the first database file (C) Copy destination address setting means to be set in the inside, and (C) When a record in the first database file is requested to be accessed by the business application program, it is copied into the corresponding record in the first database file. Determine whether the subsequent address is set or not When to, not been set,
(D) the data record copying means for accessing the record of the first database file and accessing the record of the second database file using the address when the record is set. An index part update file for receiving an address of the second database file after the copy for the record copied in step 1, creates an update record for the index part of the first database file, and stores the record in the index part update file. And (E) after copying the data portion by the data record copying means, the contents of the index updating file created by the index updating file creating means are reorganized by classifying, The index part of the second database file And the index part updating means for updating in order,
A database reorganization method comprising: 2. The contents of the first database file having the data part and the index part are executed while the various processes are being executed.
In the database reorganization method of copying and reorganizing in the database file of (A), (A) a record in the data part of the first database file is searched and copied in the second database file; ) Setting the address in the second database file after copying for the copied record in the corresponding record in the first database file, and (C) setting the business application program in the record in the first database file. When there is an access request from the first database file, it is determined whether or not the address after copying is set in the corresponding record of the first database file. Access to the record and, if set, the For accesses to the record of the second database files using a dress,
(D) Receiving an address in the second database file after copying the copied record, creating a record for updating the index section of the first database file, and storing the record in the index section updating file, (E) After the copying of the data part is completed, the contents of the created index part update file are classified and reorganized, and the index part of the second database file is updated in physical order. Database reorganization method.