JPH0573381A - Update processing system for index - Google Patents

Abstract

PURPOSE:To decrease the frequency of index block input and output and speed up an index updating process by changing the dividing process of an index block from a conventional two-dividing process to a three-dividing process. CONSTITUTION:When an index block free area decision means 1-1 decides that there is no free area, a division quantity decision means 1-2 decides the number of divisions of the index block. Namely, when the frequency of division is larger than a decision number defined by a user, the three-dividing processing is performed, but when not, the two dividing process is performed. In the three- dividing process, a two-index block generating means 1-5 secures two lowest- order index block areas newly in an index file. Then an index record three- divion transfer means 1-6 divides the total number of index records in the index block by three and transfers the records to corresponding index blocks. A division frequency updating means 1-7 updates the frequency of division and a block position information updating means 1-8 updates the next block address of the index block. Consequently, the frequency of index block input and output is decreased.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an index updating means system, and more particularly to an index updating means system hierarchically constructed in block units in a randomly accessible storage device.

[0002]

2. Description of the Related Art In the conventional update processing of this kind of index, when an index record is added to an index block having no free space, the index record is added to each index block in consideration of the additional index record. The index block was divided into two so as to have a free area in each half.

The method of division is to create a new index block, transfer half of the index records in the index block with no free space to the index block, and create half free space in each index block. Is.

[0004]

In the above-described conventional index update processing method, the division is repeated while always creating a half empty area in the index block regardless of the index value of the index record to be registered.

Particularly, when the index value of the index record to be registered deviates to a certain value, a large number of division processes occur in a specific index block and the number of input / output of the index block increases, so that the index record registration process is performed. There is a problem of being late.

[0006]

According to the index update processing method of the present invention, an m-th index block is added when an index record consisting of a combination of an index value and a record number having the value is added to the m-th index block. Index block free area determining means for determining whether or not there is a free area that can be added, and whether the number of divisions of the index block recorded in the mth index block exceeds the determination number d defined by the user. Division determining means for performing the above-mentioned operation, one index block creating means for reserving a new n-th index block area, and a new n-th index block,
Two index block creating means for securing the area of two index blocks numbered n + 1, and two index record split transfer means for moving half of the total number of index records stored in the index block number m to the index block number n. , An index record 3-division transfer means for dividing the total number of index records stored in the m-th index block into 3 parts, and transferring them equally to the m-th, n-th, and n + 1-th index blocks, and the m-index block and newly secured The number of divisions updating means for adding 1 to the number of divisions of the nth index block and the n + 1th index block, and the block position for updating the position information pointing to the next index block in each hierarchy of the mth index index and the newly created index block Information updating means, index record addition block determining means for determining an index block to be added based on the index value of the index record to be added, and index record Index record adding means for adding an index record to the index block determined by the index addition block determining means, and when the nth and n + 1th index blocks are created or the index value of the index record to be added is within the mth index block If it is less than the minimum index value, the upper index block update determination means determines that the upper index block needs to be updated, and the minimum index value in the mth index block and the position information indicating the mth index block. It has an upper index block updating means for updating the upper index block by adding the upper index record to the upper index block.

[0007]

The present invention will be described below with reference to the drawings.

FIG. 1 is a flow chart for explaining the control operation of the present invention, FIG. 2 shows an index file, and FIGS. 3, 4 and 5 are diagrams used for explaining the steps of the processing method according to the present invention. is there. FIG. 6 is a diagram of an index file after adding an index record to the index file of FIG. 2 according to the processing method of the present invention.

The index file shown in FIG. 2 is hierarchically composed of index blocks, and comprises the lowest index blocks i1 and i2 in the hierarchy and the upper index block iu1 which manages the lowest index block. .

Each index block is composed of an address (hereinafter referred to as a next block address) indicating the position of the next index block in the same hierarchy as a plurality of index records, and the number of divisions of the index block. If the next index block does not exist, the next block address has a NULL value.

In the lowest index block i1 in FIG. 2, index records iR1, iR2, iR3, iR4, iR5 are included.
iR6 is stored, and i is stored in the next block address n1.
2 is included in the division number d1.

Index records iR7, iR8, iR9, and iR10 are stored in the lowest index block i2. The next block address n2 contains a NULL value and the index block division count d2 contains 5.

Each index record is composed of an index value and a record number, and the index record iR1 contains 1 for the index value.
0, the record number includes R1, and similarly, the index record iR2 has the index value 20, the record number R2, the index record iR3 has the index value 30, the record number R3, ...
The index record iR10 contains the index value 100 and the record number R10.

The upper index block is composed of an upper index record, a next block address and the number of divisions.

The upper index block iu1 of FIG. 2 stores the upper index records iRu1 and iRu2, the next block address nu1 contains a NULL value, and the division count du1 contains 2.

The upper index record is composed of an index value and a lower index block address, and the upper index record iRu1
Has an index value of 10, and the lower index block address is iRu.
2 has an index value of 70, and the lower index block address has i2
Is included.

If the number of divisions of the index block is equal to or greater than the number of determinations d defined by the user and the number of divisions is set to three, the number of divisions determination means 1-2 of FIG. 1 determines. It is assumed that this index block can store up to 6 index records.

An index record iR11 having an index value of 45 is added to the index file shown in FIG. 2, and an example of the process of the present invention which becomes the index file shown in FIG. 6 through FIGS. 2 to 3, 4 and 5 is performed. It demonstrates in order of (1)-(10) according to FIG.

(1) Index block free area determination means The index block free area determination means 1-1 adds the index record iR11 having the index value 45 and the record number R11 to the index block i1.
It is determined that there is no free area to be added to.

(2) Division number determination means The division number determination means 1-2 performs three divisions because the value of the division number d1 of the index block to which iR11 is to be added is 10 or more defined by the user. judge.

(3) 2 index block creating means As shown in FIG. 3, the 2 index block creating means 1-5
Two new lowest index blocks i in the index file
Confirm the area of m and im + 1.

(4) Index record 3-division transfer means As shown in FIG. 4, index record 3-division transfer means 1-6
Divides the total number of index records in the index block i1 into three, transfers iR3 and iR4 to the index block im, and also transfers the index records iR5 and iR6 to the index block im + 1.
Transfer to.

(5) Division number updating means The division number updating means 1-7 is a division circuit of i1 d1.
Index block i1 obtained by dividing l1 by adding 1 to the value of
The number of divisions of im and im + 1 is d2, dm, and dm + 1.
To store.

(6) Block Position Information Updating Means As shown in FIG. 5, the index record block position information updating means 1-8 newly creates the value of n1 which is the next block address of the index block i1 in im. The value of nm, which is the next block address of the index block im, is im + 1
Then, the value of nm + 1 which is the next block address of the index block im + 1 is updated to i2.

(7) Index record addition block determining means The index record addition block determining means 1-9 uses i1, i
The index block to be added is determined by comparing the smallest index value in each index block of m and im + 1 with the index value of the index record iR11 to be added.

Since the index value of the index record iR9 is 45, the addition destination is the index block of im.

(8) Index Record Adding Means As shown in FIG. 6, the index record adding means 1-10 is
The index record iR is added to the index block im determined in 1-9.
Add 11.

(9) Upper Index Block Update Judgment Unit The upper index block update judgment unit 1-11 judges that the updating unit of the upper index block is necessary in accordance with the dividing unit of the index block.

(10) Upper Index Block Updating Unit As shown in FIG. 6, upper index block updating unit 1-12
Is the smallest index value in the newly created index block,
Add to the upper index block of the upper index record consisting of the index block address.

In the newly created index block im, the minimum index value 30 and the upper index record iRu3 consisting of the index block address im, the smallest index value 50 in the index block im + 1 and the upper index record iRu4 consisting of the San'in block address im + 1 are set. Add to upper index block iu1.

[0031]

As described above, according to the present invention, when the index record is newly registered in the index block having no open area, the index block division is performed in the conventional index update process in consideration of the number of divisions of the index block. When the number of divisions exceeds the number of determinations defined by the user based on the information on the number of divisions possessed for each index block, the division processing of the index block is divided into two according to the present invention from the conventional processing of dividing into two. The change to the processing makes it possible to take a lot of open areas in the index block in advance when many index records having an index value deviated to a certain value are registered.

Therefore, when the index record is registered, the number of times the index block is divided and the number of input / output operations of the index block is reduced, which speeds up the index update process.

[Brief description of drawings]

FIG. 1 is a flow chart for explaining a control operation of the present invention.

FIG. 2 is a diagram showing an index file for explaining a processing example of the present invention.

FIG. 3 is a diagram showing an index file of one processing progress of the present invention.

FIG. 4 is a diagram showing a process progress index file of the present invention.

FIG. 5 is a diagram showing an index file of one processing progress of the present invention.

FIG. 6 is a diagram showing an index file after adding an index record to the index file of FIG. 2 by the processing method of the present invention.

[Explanation of symbols]

 1-1 Index Block Free Area Determining Means 1-2 Division Number Determining Means 1-3 1 Index Block Creating Means 1-4 Index Record 2-Division Transfer Means 1-5 2 Index Block Creating Means 1-6 Index Record 3-Division Transfer Means 1-7 Division number updating means 1-8 Block position information updating means 1-9 Index record addition block determining means 1-10 Index record adding means 1-11 Upper index block update determining means 1-12 Upper index block updating means

Claims (1)

[Claims] 1. In an update processing method of an index hierarchically configured in block units in a randomly accessible storage device, an index record consisting of a combination of an index value and a record number having the value is used as an mth index block. An index block open area determination means for determining whether or not there is a free area that can be added to the m-th index block when adding, and the number of divisions of the index block recorded in the m-th index block are defined by the user. The number of divisions determining means for determining whether or not the number of determinations d is exceeded, one index block creating means for newly allocating an area for the nth index block, and two new index blocks of nth and n + 1th index blocks. 2 index block creating means for securing an area and half of the total number of index records stored in the mth index block are transferred to the nth index block Argument record 2
A division transfer means, an index record three-division transfer means for dividing the total number of index records stored in the m-th index block into three, and transferring them equally to those m-th, n-th, and n + 1 index blocks; A division number updating means for adding 1 to the division number of the index block and the newly secured n-th and n + 1-th index blocks, and m-th position information indicating the next index block in each hierarchy of the newly created index block Block position information updating means for updating, the index record addition block determining means for determining the index block to be added according to the index value of the index record to be added, and the index record added to the index block determined by the index record addition block determining means Index record adding means and index record to be added when the nth and n + 1th index blocks are created If the index value of is less than the minimum index value in the m-th index block, the upper index block update determination means that determines that the upper index block needs to be updated; An index update processing method comprising: an upper index block updating means for updating the upper index block by adding an upper index record consisting of position information indicating the index block of number m to the upper index block.