JPH06231015A - Data base system area expanding device - Google Patents

Abstract

PURPOSE:To provide a data base system area expanding device by which the setting and usage. etc., of the area of an external memory device, can be executed smoothly. CONSTITUTION:An area expansion place (directory, etc.) when the shortage of an area occurs is designated by a designating means 2 such as a mouse or display device, etc., and a designated area expansion place is stored in a storage means 9. When the shortage of the area occurs, the fact is referred to an area setting means 12, and an expansion area of prescribed size is set at the place. Also, the size of the expansion area is designated in addition to the area expansion place, and when the shortage of the area occurs, the expansion area of designated size is set at the designated area expansion place. Furthermore, priority is designated in addition to the area expansion place and size of it, and when the shortage of the area occurs, the size of the remaining area of the designated expansion place is inspected by designated priority, and it is set at a place where the expansion area of designated size can be set.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system area expansion device, and more particularly, to a database system area for executing area expansion accurately and automatically when an area for storing data runs short. Regarding expansion device.

[0002]

2. Description of the Related Art In a database system, the expansion of an area for storing data is usually executed when the shortage occurs (for example, Japanese Patent Laid-Open No. 3-240844, Oracle Japan Co., Ltd.). "ORACLE Database Administrator's Guide Version 6.0" (May 1992)
Mon) Issued by the company Area management 16-13). In the database system, the unit of the area required for each record is large. Therefore, if the area is set unnecessarily, the area of the external storage device may be pressed. Also, the amount of data handled by the database system varies from system to system. Therefore, it is difficult to set an optimum area in advance, and therefore, the processing format is adopted in which the area expansion processing is performed when the area shortage occurs as described above. Conventionally, this area expansion has been carried out manually by a database administrator or automatically by the system (for example, for the manual work, the above-mentioned “ORACLE Database Administrator Guide Version 6.0”, and for the automatic processing, the above-mentioned special feature is used. Kaihei 3-2408
44, etc.).

[0003]

Needless to say, the technique described in Japanese Patent Laid-Open No. 3-240844 is superior to the technique described in "ORACE database administrator's guide" in that it does not take time and effort. Absent. However, in the technique described in this publication, no consideration is given to where to set a new area. Therefore,
For example, if you try to set a new area, there will be an error because there is no space in the current directory at that time, or the area will be expanded, but it will be impossible to set the area on other systems. In some cases, there was a problem with setting and using the area. An object of the present invention is to solve the above-mentioned drawbacks of the prior art and to provide a database system area expansion device in which area setting, use, etc. are smoothly executed.

[0004]

In order to achieve the above object, in the invention of claim 1, there is provided a designating means for designating an area expansion location when an area shortage occurs, and a storage means for storing the designated area expansion location. , When the area shortage occurs, refer to the storage means,
Area setting means for setting an expansion area of a predetermined size at the specified area expansion location. Further, in the invention of claim 2, a designation means for designating the area expansion place and the size of the expansion area when the area shortage occurs, a storage means for storing the specified area expansion place and the size of the expansion area, and the area When a shortage occurs, the storage unit is referred to, and an area setting unit that sets an expansion area of the specified size at the specified area expansion location is provided. Further, according to the invention of claim 3, a designation means for designating the area expansion place, the priority and the size of the expansion area when the area shortage occurs, and the specified area expansion place, the priority and the size of the expansion area are stored. And a storage unit that, when an area shortage occurs, refers to the storage unit and compares the size of the remaining area at each of the specified area expansion locations with the size of the specified expansion area in accordance with the specified priority. A selection means for selecting an area expansion place where the expansion area of the specified size can be set, and an area setting means for setting the expansion area of the specified size at the selected area expansion place .

[0005]

In the invention of claim 1, when the area expansion location at the time of area shortage is specified by using the specifying means, for example, the keyboard, the mouse, the display device, etc., the specified area expansion location is changed. It is stored in the storage means. This area expansion location is
When an area shortage occurs, the area setting means refers to it and an expansion area of a predetermined size is set at the designated area expansion location. Therefore, by specifying a directory prepared for the database system, a directory with sufficient free space, or a directory that can be balanced with other systems, as the area expansion location in advance. Area automatic expansion is executed smoothly and in a manner that does not hinder the area usage of other systems. Further, in the invention of claim 2, the same designation means designates the area expansion location and the size of the expansion area when the area shortage occurs, and when the area shortage occurs, the area extension location is designated to the specified area extension location. A size expansion area is set. Therefore, by previously specifying the size and expansion location in the same manner as described above, the area automatic expansion is executed in a manner similar to the above and in a smoother manner than that. Further, in the invention of claim 3, by the same designating means, the area expansion place, the priority order and the size of the expansion area when the area shortage occurs are designated, and when the area shortage occurs, the designation is performed in accordance with the designated priority order. The size of the remaining area of the expanded location is checked,
The extended area of that size is set at a location where the extended area of the read size can be set. Therefore, by designating the size, the expansion location, and the priority in advance, the priority, that is, the user or the database system administrator, can most smoothly interfere with the use of the area of other systems. Area expansion location selection and automatic expansion are executed in the order in which they think they will not.

[0006]

The details of the present invention will be described below with reference to the illustrated embodiments. FIG. 1 shows the configuration of the embodiment apparatus. In the figure, 1 is a display device, which is realized by a CRT, LCD or the like. An input device 2 is realized by a keyboard, a mouse, and the like. 3-1
3-3 is a magnetic disk storage device, of which the magnetic disk storage device 3-1 has database management files 4-
A database management area 5 for storing 1 (DB management file 1), 4-2 (DB management file 2), ...
-1, and each user file 6-1 (user file 1), user file 6-2 (user file 2),
A user area 5-2 for storing ..., ... Is provided, and each log file 7-1 is provided in the magnetic disk storage device 3-2.
A log area 5-3 for storing (log file 1), log file 7-2 (log file 2), ..., Is provided. The magnetic disk storage device 3-3 will be used as a place for setting an extended area in the description below.
8 is a database management unit,
It executes data retrieval, data input, data update, and other various processes required by the database system.

An extension information storage unit 9 stores information about area extension. In the present embodiment, the information about the area expansion includes the location (directory etc.) where the extension area is set when the area shortage is detected, its priority, the size of the file as the extension area, and the extension location. A combination of three data, that is, a flag indicating whether or not it has already been used, is treated as one case, and data for each case is input by the user or the database system administrator using the display device 1 and the input device 2. . An area shortage monitoring unit 10 monitors the usage status of each data storage area of each file, and when the free space becomes less than a predetermined amount, for example, 10% of the total, notifies the extension location selection unit 11 of that fact. To do. In response to this notification, the extension location selection unit 11 refers to the extension information storage unit 9 and determines the size of the remaining area of each of the designated area extension locations and the size of the designated extension area in accordance with the designated priority. Compare with. As a result, the area expansion place where the specified expansion area can be set is selected, and the area expansion unit 12 is notified of this. The area expansion unit 12 responds to this notification and, for example, “CREAT
By using a predetermined command such as "E", the extended location selection unit 1
1 is an extension area at a location selected, for example, extension file 13
To set. Information such as the position and size of the set extension area is notified to the database management unit 8, and the database management unit 8 adds this extension area, for example, the extension file 13 to its own management file, and inputs data to this file. It executes various processes such as updating and searching.

FIG. 2 shows an example of a screen display for inputting information regarding area expansion. This screen is displayed, for example, by selecting an item such as "extended information input" on the menu screen of the database system. Initially, only the input area for inputting the information regarding the area expansion having the first priority is shown. Enter the directory with the highest priority for area expansion and the size of the expansion file. To enter information about the next priority area expansion, move the cursor and specify "Next". As a result, the input area with the second priority is displayed on the screen. As in the case of the first priority, the information about the area expansion of the second priority is input. This input is repeated, and when all information has been input, the cursor is moved to instruct "end". This completes the input processing of information related to area expansion. The input information is stored in the extended information storage unit 9 by the database management unit 8. An example of this information stored in the extended information storage unit 9 is shown in FIG. It should be noted that the display of the third priority and below is omitted. The size of the extension file is megabytes.

An example of the area expansion processing is shown in FIG. First, while there is a sufficient space in each data storage area of each file, the processing of steps S1 to S3 is repeated. That is, during this period, the area shortage monitoring unit 10 to the expansion location selecting unit 11
Is not notified of the area shortage. Therefore, step S3
The answer is “No”, and the processing of steps S1 and S2, that is, data processing corresponding to command input such as user search, input, and update is sequentially performed. The word of step will be omitted hereinafter. Data update, additional input, etc. are performed as the data processing of S2, and the area is used thereby, so that any of the files (4-1, 4-2, ...,
6-1, 6-2, ..., 7-1, 7-2 ,. The answer of S3 is "Yes"
Then, the process proceeds to S4. Here, the extension location selection unit 11 refers to the extension information storage unit 9. Here, it is assumed that the extended information storage unit 9 stores information as shown in FIG. The used flag has already been set to "1" for the information regarding the area expansion having the first priority. An extension file cannot be set in the area extension location indicated by this information. Therefore, the extension location selecting unit 11 reads out information about the area extension having the second priority with the used flag being “0”. Then, the area expansion location designated by this information, that is, the size of the remaining area of the directory "/ home2 /" is acquired from the system. Here, the directory "/ home2 /" is the magnetic disk storage device 3-3.
And the remaining area is 50 megabytes or more.
The answer to S5 is "Yes", and this directory "/ h
“Ome2 /” is selected by the extension location selection unit 11 as a location to newly extend the area.

The name of the selected directory "/ ho
The “me2 /” is notified to the area expansion unit 12. In response to this, the area expansion unit 12 uses a command such as "CREATE" to set a new expansion file, for example 13, in this magnetic disk storage device 3-3 (S6). Information about the set extension file 13 and the like is notified from the area extension unit 12 to the database management unit 8. The database management unit 8 stores this information and stores it in any one of the files (4-
1, 4-2, ..., 6-1, 6-2, ..., 7-1, 7-
(2, ..., And so on), the extension file 13 and the like are used as a data storage area. The information indicating the set area varies depending on the environment of the system in which the database system is constructed. Here, it is represented by a directory and a file name. Depending on how the area is acquired and managed, it may be represented by a track number, a volume name, or the like. Next, in S4, even if the used flag is taken out from the extended information storage unit 9 as the used flag being "0", the remaining capacity of the directory designated by the information is designated by the information. In some cases, the size of the area is less than the size of the area (S5 “No”). In this case S
7, the used flag of the extension location is set to "1", and the process proceeds to S8 to check whether there is an extension location of the used flag "0". If the system is not improperly operated, this extension location usually exists. Return to S7,
The extension information storage unit 9 is referred to read the next extension location candidate. If, for some reason, all the expansion locations stored in the expansion information storage unit 9 are used flags “1”, the fact is displayed on the display device 1 to notify the user or system administrator, The process ends (S9).

Even if the remaining capacity is insufficient when checked, the areas, directories, files, etc. used by other systems are then released and deleted, etc. There may be an environment where the area increases. In the case of such a system, for example, the used flag shown in FIG. 3 and the like may not be provided and the processing shown in FIG. 5 may be performed. The process shown in FIG. 5 is a modification of part of the process shown in FIG. 4, and no flag is used. That is, every time the area is expanded, it is called in order from the one with the highest priority, and it is checked whether "a file of the specified size can be created there" (S5). Only this point is different from the processing of FIG. Since this is redundant, only this point will be described, and the description of the parts having the same contents as those in FIG. That is, in the processing example of FIG. 5, when the area becomes insufficient (S3 “Yes”), the variable n is first set to the initial value “1” (S11). This variable n is used to indicate the priority order.
Then, the extension location having the priority designated by the variable n, that is, the extension location having the first priority is read, and it is examined whether or not a file of the designated size can be created therein. If it can be created, a file that is an extended area is created in the same way as the processing of FIG. 4 (S6). If it cannot be created, the variable n
Is incremented (S13), and it is checked whether the incremented value exceeds the maximum priority value max (S14). If not, there are still candidates for expansion locations. Returning to step S12, the inspection of step S5 is performed on the nth expansion place. The answer is "No" in S14.
In the case of, there is no candidate for extension location anymore. Similar to the previous example, the process proceeds to S9, an error is notified, and the process ends.

The embodiment described with reference to FIGS. 1 to 5 corresponds to an embodiment of the invention of claim 3. In this embodiment, the extension location data stored in the extension information storage unit 9 is set to 1
When the number is set to one and the extended location selecting unit 11 is deleted and the processing of FIG. 6 is performed instead of that of FIG. 4, an embodiment of the invention of claim 2 is obtained. The process of FIG. 6 is a simplification of the process of FIG. 4, and is considered to be easy to understand. The description is omitted. Similarly, in the embodiment shown in FIGS. 1 to 5, the extension information storage unit 9 stores only one piece of extension location data, the extension location selecting unit 11 is deleted, and instead of FIG. When processing is performed, an embodiment of the invention of claim 1 is achieved. Note that the predetermined size in S32 of FIG. 7 is an extension size that is considered preferable for the database system. The processing of this embodiment is also a simplification of the processing of FIG. It is considered easy to understand. The description is omitted. Finally, the correspondence between the structure of the embodiment and the structure of the claims will be described. Display device 1 and input device 2
Is the designation means, the extended information storage unit 9 is the storage means, and S3 in FIG.
The area expansion unit 12 performing the processing of S1 and S6 is the area setting means of claim 1, and the area expansion unit 12 performing the processing of S21 and S6 of FIG. The area expanding section 12 in which the section 11 is a selecting means and performs the processing of S5 and S6 of FIG. 4 or S12 and S6 of FIG.
Corresponds to the area setting means of claim 3.

[0013]

As described above, according to the first aspect of the present invention, the area expansion location when the area shortage occurs is specified in advance and stored in the storage means, and when the area shortage occurs, the storage means is referred to. Then, an expansion area having a predetermined size is set at the designated area expansion location. Therefore, by designating a directory prepared for the database system, a directory in which free space is sufficiently set, or a directory that can be balanced with other systems, as the area expansion location in advance, Area automatic expansion can be executed smoothly and in a manner that does not hinder the area usage of other systems. Further, in the invention of claim 2, when the area shortage occurs, the area extension place and the size of the extension area are previously designated and stored in the storage means, and when the area shortage occurs, the storage means is referred to and the designation is made. The expanded area of the specified size is set in the specified area expansion location. Therefore, by previously specifying the size and expansion location in the same manner as described above, the area automatic expansion is executed in a manner similar to the above and in a smoother manner than that. According to the third aspect of the invention, the area expansion location, the priority order, and the size of the expansion area are designated in advance when the area shortage occurs and stored in the storage means. When the area shortage occurs, the storage means is referred to. Then, the size of the remaining area at each of the specified area expansion locations and the size of the specified expansion area are compared according to the specified priority, and the expansion area of the specified size can be set. An area expansion place is selected, and an expansion area of the specified size is set at that place. Therefore, by designating the size, the expansion location, and the priority in advance, the priority, that is, the user or the database system administrator, can most smoothly interfere with the use of the area of other systems. Area expansion location selection and automatic expansion are executed in the order in which they think they will not.

[Brief description of drawings]

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

FIG. 2 is a diagram showing an example of a screen display when an area expansion place is designated.

FIG. 3 is a diagram showing an example of information about area expansion.

FIG. 4 is a flowchart showing a processing procedure of an embodiment of the invention of claim 3;

FIG. 5 is a flowchart showing a modification of the processing procedure of the embodiment of the invention of claim 3;

FIG. 6 is a flowchart showing a processing procedure of an embodiment of the invention of claim 2;

FIG. 7 is a flowchart showing a processing procedure of an embodiment of the invention of claim 1;

[Explanation of symbols]

 2 designation means 9 storage means 11 selection means 12 area setting means

Claims (3)

[Claims] 1. A designation means for designating an area extension location when an area shortage occurs, a storage means for storing the designated area extension location, and a designation means for referring to the storage means when the area shortage occurs. A database system area expansion device, comprising: area setting means for setting an expansion area having a predetermined size at an area expansion location. 2. Designating means for designating an area expansion place and a size of the expansion area when the area shortage occurs, storage means for storing the specified area extension place and the size of the expansion area, and when the area shortage occurs. A database system area expansion device, comprising: area setting means for setting an expansion area of the specified size at the specified area expansion location with reference to the storage means. 3. Designating means for designating an area expansion location, priority and size of expansion area when area shortage occurs, and storage means for storing the designated area expansion location, priority and size of expansion area. When an area shortage occurs, the storage means is referred to, the size of the remaining area at each of the specified area expansion locations and the size of the specified expansion area are compared in accordance with the specified priority, and the specified area is specified. A selection means for selecting an area expansion location capable of setting an expansion area of a specified size; and an area setting means for setting the expansion area of the specified size at the selected area expansion location. Characteristic database system area expansion device.