JPH07121411A - Data base storage area allocation device - Google Patents

Abstract

PURPOSE:To provide a data base storage area allocation device which optimizes a data base area and which can easily manage the data base area. CONSTITUTION:A data area use situation monitor part 10 inquires of DBMS 20 the use situation of the data base area, and informs a data base area allocation part 30 of the inquired result. When a notice result from the data area use situation monitor part 10 is that the data base area is used by exceeding a previously set threshold, the data base area allocation part 30 transmits information for allocating a storage area corresponding to a previously set data unit stored in a set value storage part 40 to DBMS 20. DBMS 20 allocates data to the data base area based on received information.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database storage area allocation device capable of expanding a database area when the free area of the database area is insufficient.

[0002]

2. Description of the Related Art Conventionally, in order to efficiently use a plurality of relational database management systems (RDBMS) and a plurality of database areas within a limited disk resource, the initial value of the database area of each RDBMS is used. Set it to the minimum and operate it only for databases that have run out of space.
I am trying to add an area.

As a means for performing such processing, "OR
ACLE database administrator guide VERSION 6.0, Oracle Corporation, issued May 1, 1990 "(Original source: ORACLE
Database Administrator's Guide Version 6.0 = Oracle Database Administrators Guide Version 6.0, original author: Oracle Corporation
(= Oracle Corporation) is known. Oracle described in this document
In the case of (registered trademark of Oracle Corporation above), create a tablespace in the database, create a database file in this tablespace, and perform operations such as table creation / deletion / search. Has become. Also, if you create many tables and the database file space is insufficient, you can increase the database file size with the ALTER TABLESPACE ADD FILE statement.

The above-mentioned lack of database area causes
When a user tries to register data in a relational database (RDB) by SQL (Structured Query Language), it can be known by an error message issued by the RDB. Further, addition of a database area generally requires the right of the administrator of the target database.

Therefore, when a user tries to register predetermined data in the RDB by SQL and finds out that the database area is insufficient by an error message,
I asked the database administrator to increase the database area.

[0006] Also, when Informix-Online or Sybase is used, it is the same as the above-mentioned Oracle.

[0007] JP-A-59-16366 discloses a method for improving the operability of inquiry by SQL.
The one described in No. 1 is known. The invention of this publication uses a query syntax (eg, insert query syntax or update query syntax) required for a query by SQL such as insert or update,
In a schematic language expressed as one or more elements, including example elements or implicit operand descriptions, appearing in the rows and columns of the example table containing the source or target table and in any optional conditional boxes Describe and display as a query. Then, when the user sets a value for the displayed query in the graphical language, the query information in the graphical language in which the value is set is translated into a query in the linear language. That is, in general, an inquiry by SQL must use a complicated syntax that describes a specific command, but in the invention of this publication, a message corresponding to the command is displayed in an inquiry format. The user should set the value in response to this inquiry. Therefore, S
Even if the QL syntax is not known in detail, the SQL syntax that is actually required is generated. Therefore, when a database administrator who understands SQL uses the technique of the above publication to add a database area, , SQL, it is possible to improve the operability of the inquiry.

[0008]

As described above, in the prior art, there were the following problems in using the database.

(1) It cannot be known that the free area of the database area is insufficient until the shortage of the database area actually occurs. Therefore, unless the data is registered in the database, the lack of the database area cannot be known, and the data registration in the database cannot be performed quickly. (2) It is necessary to request the database administrator to add the database area. For this reason, the work of the user who is trying to register the data and the database administrator becomes complicated, resulting in poor work efficiency.

As described above, conventionally, when using the database, the work efficiency of registering data in the database area and adding the database area was poor.

It is an object of the present invention to provide a database storage area allocating device capable of optimizing a database area and easily managing the database area.

[0012]

According to the present invention, when a free space in a storage area for storing a database is insufficient, a database storage area allocating device for allocating a new storage area monitors the usage status of the storage area. When the monitoring means (10 in FIG. 1) and the monitoring result of the monitoring means indicate that the free area of the storage area is smaller than the area corresponding to the preset threshold value, the storage area of the preset data unit Allocation means (30 in FIG. 1) for executing the allocation operation of

[0013]

According to the present invention, the monitoring means monitors the use status of the storage area allocated for storing the database, and the allocation means presets the monitoring result of the monitoring means and the free area of the storage area. If it is determined that the area is smaller than the area corresponding to the threshold value, a storage area allocation operation of a preset data unit is executed. Therefore, in this invention,
When the free area of the storage area becomes smaller than the area corresponding to the threshold value, a new storage area is automatically allocated, so that the database area can be optimized.

[0014]

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

FIG. 1 shows the principle of a database storage area allocation device according to the present invention. In FIG. 1, the data area usage monitoring unit 10 monitors the usage status of a storage area allocated to a storage unit such as a disk (not shown), that is, a database area for storing a database, and the monitoring result is sent to the database area allocation unit 30. Notice. In the database area allocation unit 30, the database is allocated based on the monitoring result from the data area use status monitoring unit 10 and the parameters (which will be described later) related to the expansion of the database area stored in the set value storage unit 40. The area change information is output to the DBMS 20.

This database area change information is such that the remaining capacity of the current database area, that is, the free area is smaller than the area corresponding to the preset threshold value, and the database area that has been allocated up to now has the preset maximum value. If it is smaller than the corresponding area, it is issued as information to add a database area of a preset data unit.

Then, the DBMS 20 adds a new database area to the storage means based on the database area change information.

FIG. 2 is a functional block diagram showing an embodiment of the database storage area allocation device according to the present invention. This functional block diagram is basically the same as the configuration of the principle diagram shown in FIG. In the configuration of this functional block diagram, the data area usage monitoring unit 10
Is configured to monitor the usage status of the database area by inquiring the usage status of the database area with respect to the DBMS 20 based on the data set in the setting value storage unit 40. In this example,
Relational database as DBMS 20
Management system (RDBMS) is applied. Therefore, in the following description, the DBMS 20 is the RDBM.
It means S.

The set value storage unit 40 stores parameter data relating to the expansion of the database area. That is, at least the threshold value of the remaining capacity of the database area (that is, the capacity of the free area) that serves as a criterion for whether or not to add the database area (hereinafter referred to as threshold data), 1
The unit of additional capacity that can be added for each time (hereinafter referred to as additional capacity unit data) and the maximum value (hereinafter referred to as maximum value data) of the database area pre-allocated by the database administrator are stored.

The data area usage status monitoring unit 10 generates an SQL for inquiring the usage status of the database area according to the threshold value data stored in the set value storage unit 40, issues it to the DBMS 20, and issues it to the DBMS 20. DBM
Based on the inquiry result from S20, the monitoring result of the usage status of the database area is sent to the database area allocation unit 3
Notify 0.

The database area allocation unit 30 stores the database area based on the monitoring result from the data area usage status monitoring unit 10 and the maximum value data and the additional capacity unit data stored in the set value storage unit 40. It is determined whether addition is necessary, and if it is necessary, SQL for adding the database area is generated and issued to the DBMS 20. Since the database area allocation unit 30 knows the capacity of the allocated database area,
“Capacity of database area based on maximum value data” −
When the "currently allocated database area capacity" is calculated and the "remaining capacity" resulting from this calculation is greater than or equal to the "capacity based on the additional capacity unit data" above, it is possible to add a database area. to decide.

FIG. 3 shows the logical structure of the database area. In this logical structure, the database area is composed of table areas, and the table area is composed of tables. The allocation of the database area 100 means that the table area is allocated. Therefore, the relation of database area = all table areas is established. In this example, tablespace 110,
120 is allocated, and the tables 111, 112, and 113 are registered in the table area 110, while the table area 12
A table 121 is registered in 0. In the database area 100 in this state, the table area 110 is initially allocated, but since the free area of the table area 100 is insufficient, the table area 120 is allocated next. The addition of the table area is performed for each area corresponding to the above-mentioned additional capacity unit data. Therefore, each of the above table areas 110, 12
The area 0 corresponds to the additional capacity unit data.

The database area 10 shown in FIG.
At 0, the range indicated by reference numeral 130 represents a used area, the range indicated by reference numeral 140 represents an unused area, and the range indicated by reference numeral 150 represents an area corresponding to the above-mentioned threshold data. Further, in the example shown in FIG. 3, the range indicated by reference numeral 160 represents the maximum area of the database area corresponding to the maximum value data described above.
Further, a value obtained by subtracting the database area 100 from the maximum area 160, that is, a range indicated by reference numeral 170 represents an area (addable area) to which a database area, that is, a table area can be further allocated in the current allocation state of the database area. ing.

Next, the database area allocation processing of this embodiment will be described with reference to FIGS. 4 and 5. FIG. 4 is a flowchart showing the monitoring processing operation of the database area by the data area usage monitoring unit 10, and FIG.
6 is a flowchart showing a database area allocation processing operation by the database area allocation unit 30.

First, in FIG. 4, the data area use status monitoring unit 10 sets the threshold value data (Kbytes) read from the set value storage unit 40 to L, and the capacity (Kbytes) per table row set in advance. Where R is R, the required number of rows n is obtained by calculating n = L / R (step 201). Next, the SQL for registering preset heading row (first row in the rows constituting the table) data in the database (this is S
QL (1)) and generate the SQL (1) in DBM.
It is issued to S20 (step 202).

RDBMS receiving the above SQL (1)
From FIG. 20, the result of whether or not the above-mentioned heading line has been registered, that is, whether or not there is an error is displayed as the data area use status monitoring unit
The data area usage monitoring unit 10 determines whether the returned result is an error (step 20).
3).

Here, if there is no error, it is judged whether or not the expression of n> 0 is satisfied (step 204), and if this expression is satisfied, a preset value to be registered after the above-mentioned heading line is set. SQL for registering the one line of the data thus created (referred to as SQL (2)) in the database is generated, and the SQL (2) is issued to the DBMS 20 (step 205). Next, n = n-1 is set (step 20).
6) Then, the process returns to step 203.

At step 204, if the expression of n> 0 is not satisfied, the return value = OK (step 20).
7). If there is an error in step 203, the return value = NG is set (step 208).

Here, the return value = OK means that
This means that the remaining capacity of the database area is at least the capacity corresponding to the threshold value data and it is necessary to add the database area. On the other hand, the return value = NG means that the database area needs to be added because the remaining capacity of the database area is smaller than the capacity corresponding to the threshold data.

The capacity data per one row of the preset table, the heading row data, and the data for one row may be held in the data area usage monitoring section 10 or the set value storage section 40. May be stored in.

In this embodiment, the processing procedure shown in FIG. 4 is regularly executed by the data area usage monitoring unit 10. That is, the DBMS 20
Is periodically inquired about the usage status of the database area.

Next, in FIG. 5, the database area allocation unit 30 obtains a return value from the data area usage monitoring unit 10 (step 301) and checks whether this return value is "NG" or "OK". (Step 302).

In step 302, the return value is N
In case of G, maximum area of database area (maximum capacity)
Then, it is checked whether the value obtained by subtracting (the capacity of) the database area allocated up to now is equal to or larger than the capacity corresponding to the additional capacity unit data and the area can be added (step 303).

If an area can be added, SQL for allocating a new database area (that is, table area) to the storage means (not shown) (this is SQL (3))
Is generated) and is issued to the DBMS 20 (step 304). On the other hand, when the area cannot be added, a warning message is output (step 305). This message is displayed by a display unit (not shown).

Then, the RD that has received the above SQL (3)
In the BMS 20, the table area is assigned to the storage means (not shown).

That is, when the process of step 304 is performed, as shown in FIG. 6, the maximum value of the database area corresponding to the maximum value data is MAX1 (corresponding to the maximum area 160 of the database area of FIG. 3). When
Database area 610 (database area 10 in FIG. 3)
(Corresponding to 0) is already allocated, and an unused area 620 (corresponding to the unused area 140 in FIG. 3) of that area is the area 630 corresponding to the threshold data (corresponding to the area 150 corresponding to the threshold in FIG. 3). When the number is smaller, the table area 640 (hatched portion in the drawing) is newly added. That is,
Expandable area E1 (expandable area 17 in FIG. 3) obtained by subtracting database area 610 from maximum area MAX1.
(Corresponding to 0) is larger than the area (corresponding to, for example, the table area 120 in FIG. 3) corresponding to the additional procedure unit data, the table area 640 corresponding to the additional procedure unit data is added. As a result, the database area already allocated from the maximum area MAX1 (that is, the area 61
It is assumed that the expandable area E2 obtained by subtracting (the area obtained by adding 0 and the area 640) is smaller than the area corresponding to the additional procedure unit data.

When the database area needs to be added next time and the processing procedure shown in FIG. 5 is executed, the expandable area is the expandable area E2, so that a new table area 640 is added. There is no free area, and as a result, step 305
That is, the warning message is output.

Conventionally, in FIG. 6, even before the table area 640 is added, it is not possible to know that the free area of the database area is insufficient as already described. It was Then, from this state, when the data of the unused area 620 or more is to be registered in the database, the shortage of the database area is first known.

Here, the above-mentioned SQL (1), SQL (2) and SQL when using the above-mentioned Oracle
A specific example of the format of (3) will be described below. Note that this is merely an example, and the present invention is not limited to this.

Concrete example of SQL (1) create table <table name> (col0 long, col1 longraw, co
l2 char ,, ..., col9 char) where create table means to create a table (table) that is a basic structure to hold data,
<table name> represents the name of the table, and in col0 long, co
l0 is the column name, long is the data type name, col1 lon
In graw, col1 represents a column name, longraw represents a data type, col2 char represents col2 a column name, char represents a data type, col9 char represents col9 a column name, and char represents a data type. In the whole SQL (1), the first column is named col0, the type is long, the second column is named col1, the type is longraw, and so on.
This means creating a table named e>.

Concrete example of SQL (2) insert into <table name> value ('a', 'b', ..., 'aa') Here, insert into means to add a new row to the specified table. Meaning, <table name> represents the name of the table, 'a', 'b',…, 'aa' represents the value corresponding to the position (column) of the column name specified in the create table statement above, For example, 'a'
Is the value corresponding to the column named col0, and'aa 'is col9
The value corresponding to the column of the name of. Then, in the entire SQL (2), the rows having the values'a ',' b ', ...
This means adding to the table named me>.

Concrete example of SQL (3) alter tablespace add file or create tablespace Here, alter tablespace add file means that an area usable as a tablespace is added, and create t
ablespace means to create a tablespace.

In this embodiment, the DBMS2
When the SQL used when making an inquiry to 0 is the above-mentioned Oracle, the data area usage monitoring unit 10 selects [select * from sys.dba segments] or [s
elect * from sys.dba-free-space]
The view (that is, the table) may be searched by issuing it to the MS 20, and the search result may be analyzed to monitor the usage status of the database area. The two SQLs illustrated here are both sys.dba-segments o
It means to search all columns in the data dictionary called r sys.dba-free-space. The data dictionary is basic information in the system for the RDBMS itself and the user, and is held in the form of a table.

As described above, according to this embodiment, when the unused area of the allocated database area is smaller than the area corresponding to the preset threshold value, the table area of the preset additional unit is allocated. Therefore, the general user can perform the work without being aware of the unused area of the database area. That is, a general user does not need to request the database administrator to add an area after he / she knows that the database area is insufficient, as in the conventional case. Therefore, working efficiency can be improved. In addition, the database administrator can also improve work efficiency because the above-mentioned request from a general user is eliminated.

In the above-described embodiment, the DBMS 20 uses R
Although the case of the DBMS has been described, the present invention is directed to an object-oriented database management system (OODBM) that handles an object-oriented database (OODB), for example.
It can also be applied to other database management systems such as S).

[0046]

As described in detail above, according to the present invention, the monitoring means monitors the usage status of the storage area allocated for storing the database, and the allocation means determines the monitoring result of the monitoring means. However, if the free space of the storage area is smaller than the area corresponding to the preset threshold value, the storage area allocation operation of the preset data unit is executed. When becomes smaller than the threshold value, a new storage area is automatically allocated, and thus the storage area can be optimized.

Further, from the above, a new database area is allocated before the free area of the database area becomes smaller than the area corresponding to the threshold value, so that the operation of registering data in the database can be performed with high efficiency. be able to.

Further, as compared with the conventional method, it is not necessary to request the database administrator to add the area after the shortage of the database area is known, so that the database area can be easily managed.

[Brief description of drawings]

FIG. 1 is a principle diagram showing the basic principle of the present invention.

FIG. 2 is a functional block diagram showing an embodiment of a database area allocation device according to the present invention.

FIG. 3 is a diagram for explaining a logical structure of a database area in this embodiment.

FIG. 4 is a flowchart showing a database area monitoring processing operation by a data area usage state monitoring unit in the present embodiment.

FIG. 5 is a flowchart showing a database area allocation processing operation by a database area allocation unit in the present embodiment.

FIG. 6 is a diagram for explaining a database area allocation process.

[Explanation of symbols]

10 ... Data area usage monitoring unit, 20 ... DBMS, 3
0 ... Database area allocation unit, 40 ... Set value storage unit.

Claims (1)

[Claims] 1. A database storage area allocating device for allocating a new storage area when a free area of a storage area for storing a database is insufficient, and monitoring means for monitoring the usage status of the storage area; When the monitoring result indicates that the free space of the storage area is smaller than the area corresponding to the preset threshold value, the storage device further comprises allocation means for executing a storage area allocation operation of a preset data unit. Characteristic database storage area allocation device.