JP2005115841A - Database management method and system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database management method capable of smoothly grasping the situation of a database; and to provide a system suitable for implementing the method. <P>SOLUTION: This system (100) includes: a database (10) having predetermined storage capacity for storing data; and a management device (20) for managing the database. The database has: a first storage part (11) provided with predetermined storage capacity; and a second storage part (12) for keeping threshold information showing a threshold value of the storage amount in the first storage part and contact information showing a contact address to which the management result of the database should be notified. The management device has: a monitoring part (21) for monitoring whether the storage amount of the first storage part reaches the threshold value of the threshold information or not; and a notifying part (22) for notifying, when it is detected by the monitoring result of the monitoring part that the storage amount of the first storage part reaches the storage threshold value, that effect as the management result to the contact address of the contact information. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a method and system for managing the operating status of a database.

In general, when there is a possibility of insufficient capacity in a running database, the storage process is performed by expanding the data storage area. However, if the resource limit is violated, the database operation is unconditional. It is known to stop. In order to avoid such a situation in advance, for example, a system as described in Patent Document 1 that monitors the free space of a database has been proposed.
JP 2001-175513 A

  However, in the method of monitoring the free space of the database, it is necessary to appropriately determine whether or not the capacity is insufficient from the free space that is the monitoring result. It is necessary to confirm.

  The present invention has been made in view of the above problems, and an object of the present invention is to provide a database management method capable of smoothly grasping the state of a database and a system suitable for implementing the method.

  A database management method according to the present invention is a method for managing a database having a predetermined storage capacity, and indicates threshold information indicating a storage amount allowed for the database and a contact to which a management result of the database is to be notified. When the contact information is set, monitoring whether or not the storage amount of the database reaches the value of the threshold information, and when it is detected by the monitoring that the storage amount of the database reaches the value of the threshold information , To that effect is notified to the contact information of the contact information as a management result.

  A system suitable for carrying out the management method according to the present invention is a system including a database having a predetermined storage capacity and a management device for managing the database, wherein the database provides the predetermined storage capacity. And a second storage unit that holds threshold information indicating a storage amount allowed for the database and contact information indicating a contact to be notified of the management result of the database. The management device monitors whether or not the storage amount of the first storage unit reaches the value of the threshold information, and the storage amount of the first storage unit based on the monitoring result of the monitoring unit When it is detected that the value of the threshold information has been reached, a notification unit that notifies the contact information of the contact information as a management result.

  A program according to the present invention is a program for causing a computer that manages a database having a predetermined storage capacity for storing data to execute the management method, and the recording medium according to the present invention records the program. It is a recording medium.

  According to the database management method of the present invention, since a threshold is set for the storage amount of the first storage unit and the storage amount is monitored using the threshold, the first storage unit can fall short of capacity. Sex can be detected reliably. In addition, when the storage amount exceeds the threshold value, the fact is notified to the preset contact information, so the administrator can quickly detect the shortage of the database capacity. Thereby, it is possible to avoid troubles in business due to the stop of the database.

[Example]
Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a block diagram showing the configuration of an embodiment of a database management system according to the present invention. As shown in FIG. 1, a system 100 according to an embodiment includes a storage device 10 that performs a database function for storing data including resources in a predetermined format, and a storage device according to a program for managing the storage device. 10, an input / output device 30 such as a keyboard and a display connected to the management device, and a terminal device 40 used by an administrator of the system 100.

  The storage device 10 of this embodiment is a relational database that stores objects as data to be handled in a two-dimensional table format. As shown in FIG. 1, the storage device 10 is a database main body having a predetermined storage capacity. Storage unit 11, a management program used by the management apparatus 20, a second storage unit 12 that holds threshold information and contact information described later, and a third storage area that serves as a spare storage area for the first storage unit 11. Storage unit 13. Each of these storage units 11 to 13 indicates a storage area designated in the storage device 10.

  The threshold information held in the second storage unit 12 indicates a storage amount allowed for the first storage unit 11 as a threshold, and based on this threshold, the capacity of the first storage unit 11 during operation is stored. Determine potential shortage. In setting the threshold value, for example, the threshold value is set to 800 MB when the first storage unit 11 has a storage capacity of 1 GB, or the threshold value is set to 39.5 MB for a storage capacity of 50 MB. However, it is desirable to set the threshold according to the data amount of the object handled by the first storage unit 11 so as to cope with a situation where the storage amount temporarily exceeds the threshold.

  Similarly, the contact information held in the second storage unit 12 is contact information to be notified of the management result of the storage device 10. In this embodiment, as the contact information, the e-mail address of the terminal device 40 browsed by the system administrator is used. However, the present invention is not limited to this. Also good.

  The management device 20 is a computer that operates in accordance with the management program stored in the second storage unit 12. As shown in FIG. 1, the management device 20 detects an object for each table or index stored in the storage device 10. A monitoring unit 21 that monitors whether or not the accumulated data amount of the object that has been reached reaches the threshold value of the threshold information, and a notification unit that notifies the management result to the e-mail address of the contact information according to the monitoring result of the monitoring unit 21 22. Note that the monitoring unit 21 and the notification unit 22 are functional components realized by a CPU (not shown) in the management device 20 in accordance with the management program.

  The operation of the system 100 according to the embodiment will be described with reference to the flowchart shown in FIG. First, the monitoring unit 21 of the management device 20 starts a management program held in the storage device 10, acquires threshold information and contact information from the administrator via the input / output device 30, for example, and stores the second storage information. Store in the unit 12 (step S1).

  The monitoring unit 21 scans the first storage unit 11 with data including resources, and periodically checks the current storage amount (step S2). Then, by referring to the threshold information of the second storage unit 12, it is monitored whether or not the storage amount of the first storage unit 11 reaches the threshold (step S3). Monitoring is continued while the threshold is not reached (step S3: No). Further, during the monitoring, when it is detected that the storage amount of the first storage unit 11 has reached the threshold value (step S3: Yes), the monitoring unit 21 activates the notification unit 22 and is the same as the conventional one. With this technique, the data for exceeding the threshold is stored in the third storage unit 13 (step S4).

  After the activation, the notifying unit 22 notifies the terminal device 40 that the storage amount of the first storage unit 11 has exceeded the threshold value as a management result, and the excess data amount stored in the third storage unit 13 And create an e-mail indicating the management result. Then, the created electronic mail is transmitted to the address stored in the second storage unit 12 (step S5). Thereby, e-mail as shown in FIG. 3 is delivered to the terminal device 40, for example. Although the description contents of the management result can be set as appropriate, as shown in the example in the figure, the system administrator presents the storage capacity, threshold value, and excess storage amount of the first storage unit 11 so that the system administrator can Can quickly grasp the situation.

  As described above, according to the system 100 of the embodiment, a threshold is set for the first storage unit 11 that is the database main body, and the monitoring unit 21 monitors the storage amount based on this threshold. Can be accurately determined. In addition, when the storage amount of the first storage unit 11 exceeds the threshold value, the fact is automatically notified to the terminal device 40 of the system administrator, so that the administrator may have insufficient capacity. This makes it possible to quickly grasp the database, thereby preventing the database from being stopped. Furthermore, in the above embodiment, the storage status is monitored in units of objects, so that even if the amount of storage to be monitored is small, they can be reliably detected.

  In the above embodiment, the storage device 10 has been described as a relational database. However, the scope of the present invention is not limited to this example. For example, a hierarchical database that handles data in a tree structure or a network is used. The present invention can also be applied to a network database associated with data.

It is a block diagram which shows the structure of the database management system which concerns on this invention. It is a flowchart for demonstrating the operation | movement procedure of an Example. It is explanatory drawing for demonstrating an example of the management result of an Example.

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 Database management system 10 Memory | storage devices 11-13 The 1st-3rd memory | storage part 20 Management apparatus 21 Monitoring part 22 Notification part 30 Input / output device 40 Terminal device for administrators

Claims (8)

A method of managing a database having a predetermined storage capacity,
Set threshold information indicating the amount of storage allowed for the database and contact information indicating a contact to be notified of the management result of the database,
Monitoring whether the storage amount of the database reaches the value of the threshold information;
When the monitoring detects that the storage amount of the database has reached the value of the threshold information, the management information is notified as a management result to the contact information of the contact information.   The database management method according to claim 1, wherein the database is a relational database, and the storage status of the database is detected in units of objects, and the threshold information is monitored based on the detection result.   The database management method according to claim 1, wherein the contact information is a predetermined e-mail address, and an e-mail describing the management result is transmitted to the address. A system including a database having a predetermined storage capacity and a management device for managing the database,
The database is
A first storage unit given the predetermined storage capacity;
A second storage unit that holds threshold information indicating a storage amount allowed for the database and contact information indicating a contact to be notified of a management result of the database;
The management device
A monitoring unit that monitors whether the storage amount of the first storage unit reaches the value of the threshold information;
A notification unit for notifying the contact information of the contact information as a management result when detecting that the storage amount of the first storage unit has reached the value of the threshold information based on the monitoring result of the monitoring unit; A database management system comprising:   5. The database according to claim 4, wherein the database is a relational database, and the monitoring unit detects the storage status of the database in units of objects, and monitors the threshold information based on a result of the detection. Database management system. The second storage unit holds a predetermined email address as the contact information,
The database management system according to claim 4, wherein the notification unit transmits an e-mail describing the management result to the address. A program for operating a computer that manages a database having a predetermined storage capacity,
Setting threshold information indicating the amount of storage allowed for the database and contact information indicating a contact to be notified of the management result of the database;
Monitoring whether the amount of storage in the database reaches the value of the threshold information;
When the monitoring detects that the storage amount of the database has reached the value of the threshold information, the computer is caused to execute a step of notifying the contact information of the contact information as a management result. A database management program. A recording medium recording a program for operating a computer that manages a database having a predetermined storage capacity,
Setting threshold information indicating the amount of storage allowed for the database and contact information indicating a contact to be notified of the management result of the database;
Monitoring whether the amount of storage in the database reaches the value of the threshold information;
When the monitoring detects that the storage amount of the database has reached the value of the threshold information, a program for causing the computer to execute a step of notifying the contact information of the contact information as a management result is recorded. A recording medium characterized by that.

Images