JPH0520143A - Information processor - Google Patents

Abstract

PURPOSE:To prevent the deterioration of the access efficiency by setting index information to a free area which is left after data of a data base file is stored, so that data added newly can be subjected to index control. CONSTITUTION:A user information obtaining part 6 obtains necessary information for setting index information to a free area designated through a parameter card 2 by a user, and informs its information to an index value calculating part 7. A free area information obtaining part 5 informs an index key value of a final index control area stored in a new data base file 3 by a data store means 4, to the index value calculating part 7. The index value calculating part 7 executes a calculation of the index key value to be set to the free area, based on those information, and an index information setting part 8 sets index information to the new data base file 3, based on the index key value calculated by the index value calculating part 7.

Description

Detailed Description of the Invention

[0001]

The present invention is used for reorganizing a database. The present invention relates to an information processing apparatus capable of setting index information in a free area after data storage of a database.

[0002]

2. Description of the Related Art Conventionally, when reorganizing a database, it is general that the empty area left after the data storage is completed is used as it is as an overflow area for storing additional data. The data that could not be stored was stored in the overflow area without any control.

[0003]

In such a conventional method, since all the additional data that cannot be stored are stored in the same overflow area, various data are mixed in the overflow area. In addition, since there is no control information for those data, there is a problem that direct access becomes impossible and the access efficiency of data is reduced. Must be organized.

The present invention has been made in order to solve such a problem, and will be added in the future by setting index information in an empty area left after the completion of data storage according to the designation of the user. An object of the present invention is to provide an information processing device that can perform index control on data, sort the data to some extent, and directly access the data to prevent a decrease in data access efficiency.

[0005]

The present invention provides a data storage means for storing data of a database file designated by a user in the database file as newly updated information while securing an area controlled by an index key. An information processing apparatus including: a free area information acquisition unit that acquires information including an index key value of a final index control area set by the data storage unit and a size of a free area left after data storage, The user information acquisition unit that acquires the size of the area for which index control is specified by the user, the number of set areas for index control, and the displacement of the index key value set for the area for index control, and this user information. An index value calculation unit that calculates an index key value of an area for index control based on the information acquired by the acquisition unit, the user information acquisition unit, and the search unit. Based on the information acquired by the value calculating unit, characterized in that an index information setting unit that sets the index information in the free space of the new database file.

The free space information acquisition unit calculates a size of the free space left in the new database file, the calculated value, and the index key value of the final index control area acquired from the data storage unit. Means for notifying the index value calculation unit, the index value calculation unit having a storage area for registering the displacement of the index key value acquired by the user information acquisition unit, and the empty area information acquisition unit It is preferable to include means for adding the difference of the index key values registered in the storage area to the index key value of the final index control area notified by the means to calculate the index key value of the area for index control.

[0007]

[Operation] Based on the necessary information for setting the index information in the empty area of the new database file specified by the user through the parameter card and the index key value of the final index control area stored in the new database file, the empty area is set. The index key value to be set is calculated, and the index information is set in the new database file based on the calculated index key value.

[0008] With this, index information can be set in advance in the free space left after the data is stored in the database file, and data to be added in the future can be stored by controlling based on this index. It will be possible. Further, the added data can be sorted and stored to some extent, and the added data can be directly accessed, so that it is possible to prevent a decrease in access efficiency that accompanies the addition of the data.

[0009]

Embodiments of the present invention will now be described with reference to the drawings. FIG. 1 is a block diagram showing the configuration of the embodiment of the present invention.

The embodiment of the present invention comprises a data storage means 4 for storing the data of the old database file 1 designated by the user in the new database file 3 while securing the area controlled by the index key. A free area information acquisition unit 5 that acquires information including the index key value of the final index control area set by the storage unit 4 and the size of the free area left after data storage, and the index control specified by the user are performed. A user information acquisition unit 6 that acquires the size of the region, the set number of regions for index control, and the displacement of the index key value set for the region for index control, and the information acquired by this user information acquisition unit 6. Based on the information acquired by the index value calculation unit 7 that calculates the index key value of the area for index control based on the user information acquisition unit 6 and the index value calculation unit 7, An index information setting unit 8 for setting index information in the free space of the database file 3, and the free space information acquisition unit 5 includes means for calculating the size of the free space left in the new database file 3. And a means for notifying the index value calculation unit 7 of the calculated value and the index key value of the final index control area acquired from the data storage unit 4, and the index value calculation unit 7 acquires the user information acquisition unit 6 The index key value of the final index control area notified from the free area information acquisition unit 5 is added with the difference between the index key values registered in the storage area. Means for calculating the index key value of the area for which index control is performed.

The data storage means 4 reads the data of the old database file 1 which is the object of database reorganization and stores it in the new database file 3 which is the object of storage while securing the area controlled by the index key.

The free area information acquisition unit 5 calculates the size of the free area remaining in the new database file 3 after the storage of all the data to be processed by the data storage unit 4 and calculates the index value calculation unit 7 To notify. Also, the index value calculation unit 7 is similarly notified of the value of the index key set in the last secured data storage index control area.

From the parameter card 2, the user inputs the number of index control areas to be newly set in the empty area, the number of pages per index control area, and the difference in the index key value set in each area.

The information input by the parameter card 2 is acquired by the user information acquisition unit 6, analyzed, and registered in the storage area of the index value calculation unit 7.

In the index value calculation section 7, the difference between the index key value registered by the user information acquisition section 6 and the index key value of the final index control area in which the data notified by the free area information acquisition section 5 is stored. Is added to calculate the value of the index key to be set in the leading index control area secured in the free area.

The index key value set in the second and subsequent index control areas is obtained by adding the difference between the index key values registered in the storage area to the index key value set in the area secured immediately before that. Ask.

This process is repeated by the number of index control areas that need to be newly set. The index key values set in all the index control areas set in the empty area are calculated and notified to the index information setting unit 8.

FIG. 2 shows an image of the index control area set in the free area according to the user's designation. For example, if the number of index control areas set by the user is 3
It is assumed that the size per one index control area is 2 pages and the difference between the index key values is 10. As a result, as shown in FIG. 2, the index control area is set in the free area immediately after the area where the data is already stored.

At this time, the index key value to be set in the newly provided area is acquired by the free area information acquisition unit 5 as in the case of the index key value specified as described above, and the data is stored. It is calculated by the index value calculation unit 7 based on the index key value of the final index control area. Therefore, as shown in this example, when the index key value of the data storage final index control area is 90, the index key value set in the leading index control area set in the empty area becomes 100, and the second index The index key value of the control area is 110, and the third one is 120.

Based on the information registered in the storage area by the user information acquisition unit 6 and the value of the index key notified by the index value calculation unit 7, the index information setting unit 8 determines that the new database file 3 is empty. The index control area is actually reserved in the area.

FIG. 3 is a diagram for explaining the setting of the index control area in the embodiment of the present invention. In the method, first, a pseudo data record is created, and the index key value set in the head index control area calculated by the index value calculation unit 7 is set in the key item on the record. When this data record is stored in the page next to the last page in which the actual data is stored, the value of the key and the value of the page are saved as index information under the control of the database side.

Once the index information has been saved, the pseudo data record is deleted because it becomes unnecessary at that time.
When setting the second and subsequent index control areas, the usage registered in the storage area by the user information acquisition unit 6 is stored in the page in which the pseudo data record for acquiring the index control area immediately before that is stored. The pseudo data record in which the index key value calculated in the same way as the first time is set is stored in the page obtained by adding the pages of the size of the index control area designated by the user. The stored pseudo data record is deleted immediately afterward. By repeating this process for the number of index control areas to be set, the index information is set in the empty area.

[0023]

As described above, according to the present invention, the index information can be set in advance in the empty area left after the data is stored in the database file, and the index will be used for the data to be added in the future. Can be stored while controlling. As a result, additional data can be sorted and stored to some extent, and
Since it becomes possible to directly access the additional data, it is possible to prevent a decrease in access efficiency due to the data addition.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.

FIG. 2 is a diagram showing an example of setting an index control area in the embodiment of the present invention.

FIG. 3 is a diagram illustrating a method of setting an index control area according to an embodiment of the present invention.

[Explanation of symbols]

1 Old database file 2 parameter card 3 New database file 4 Data storage means 5 Free area information acquisition unit 6 User Information Acquisition Department 7 Index value calculator 8 Index information setting section

Claims (3)

[Claims] 1. An information processing apparatus comprising a data storage unit for storing data of a database file designated by a user as newly updated information in a database file while securing an area controlled by an index key. A free area information acquisition unit that acquires information including the index key value of the final index control area set by the data storage unit and the size of the free area left after data storage, and performs index control specified by the user The user information acquisition unit that acquires the size of the area, the number of areas for which index control is set, and the displacement of the index key value that is set for the area for index control, and the information acquired by this user information acquisition unit And an index value calculation unit that calculates an index key value of an area for performing index control, and the user information acquisition unit and the index value calculation unit. Information on the basis of an information processing apparatus characterized by comprising a index information setting unit that sets the index information in the free space of the new database file. 2. The free space information acquisition unit calculates a size of a free space left in the new database file, and the calculated value and the index of the final index control region acquired from the data storage unit. The information processing apparatus according to claim 1, further comprising means for notifying the index value calculation unit of a key value. 3. The index value calculation unit has a storage area for registering the displacement of the index key value acquired by the user information acquisition unit, and stores the final index control area notified from the free area information acquisition unit. The information processing apparatus according to claim 1, further comprising means for adding a difference between the index key values registered in the storage area to the index key value to calculate an index key value of an area for index control.