JP2004334768A - Data base management system, data base management method, and data base management program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data base management system and a data base management method capable of increasing recordable disk capacity by deleting unnecessary DBs and enhancing use efficiency of the system. <P>SOLUTION: The data base management system manages a plurality of data bases based on use states of the data bases and has a management means for managing use state information indicating the use states of information stored in the data bases, a determining means for determining whether or not managers of the data bases are notified of existence review requests based on the use state information managed by the management means and a notification means for notifying the managers of the data bases of written review requests based on a determination result by the determining means. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a database management system and a database management method, and in particular, to a database management system for managing a database based on use status information indicating the use and update status of information stored in a plurality of databases (DB). And a database management method.
[0002]
Further, the present invention relates to a program for causing a computer to perform the processing in such a database management method.
[0003]
[Prior art]
2. Description of the Related Art Conventionally, in order to manage a plurality of DBs storing a large amount of information in a company, there has been an application system for performing application registration for using a DB for each DB manager and collectively managing the DBs. In such an application system, application information registered in advance using a uniform application format in a company is managed as a master document in a DB. Such an application format includes items such as a department, contact information of a manager, a DB name to be managed, and contents of the DB. Based on the master document, various DBs in the company are searched, and necessary information is acquired and used for business.
[0004]
Further, as a conventional technique, there is described a DB monitoring system that collects the usage status of a database, measures the usage rate of the DB and a predicted date of capacity shortage, and enables screen inquiry (for example, see Patent Document 1). .
[0005]
[Patent Document 1]
JP-A-8-235034
[Problems to be solved by the invention]
However, there is no means for easily grasping the usage status such as the number of times the DB has been used, and unnecessary DBs that have not been updated for a long time or have a small number of accesses among a plurality of DBs in which a large amount of information is managed. Since a new DB is provided and managed in a state where a large DB exists, there is a problem that the disk capacity for recording information becomes insufficient.
[0007]
Further, in a system in which a huge amount of information is managed as described above, unnecessary DBs that are not used increase, and the use efficiency of a system that performs processing by referring to the DB such as a search process is reduced. There was a point.
[0008]
Therefore, an object of the present invention is to provide a database management system and a database management method capable of increasing a recordable disk capacity by deleting unnecessary DBs and improving system use efficiency.
[0009]
[Means for Solving the Problems]
In order to solve the above-mentioned problem, the present invention provides a database management system that manages a database based on the usage status of the database, wherein the usage status indicates the usage status of the database. A use status information management unit that manages information; a management master information management unit that manages the management master information of the database; and a manager of the database based on the use status information and the management master information. Access information management means for managing access information having survival study necessity information as to whether or not notification of a survival study request is necessary; and, in response to a request of a system administrator of the database management system, A display unit for displaying the necessity of continuation study.
[0010]
Such a database management system manages usage information indicating the usage status of the database, manages the management master information of the database, and gives a database administrator the management of the database based on the usage status information and the management master information. By managing access information having survival study necessity information as to whether notification of the survival study request is necessary or not, and displaying the survival study necessity information according to the request of the system administrator of the database management system, The system administrator can accurately grasp the database that needs to be examined, such as deleting the database. Therefore, the system administrator notifies the database administrator of the request for database continuation study, and deletes the database based on the response of the notification result, increasing the recordable disk capacity and improving the system utilization efficiency Can be done.
[0011]
From the viewpoint of deleting unnecessary databases based on the results of the examination by the database administrator, the present invention provides a method for requesting the system administrator based on the display result by the display means, as described in claim 2. In response, the notification means for notifying the database administrator of the request for continuation study, and when it is determined that there is no response from the administrator within a predetermined period to the notification result by the notification means, the system administrator It may be configured to have a deletion means for deleting the database in response to a request.
[0012]
In such a usage status information management system, a request for continuation study is notified to the administrator of the database according to a request of the system administrator from the display result, and there is no response from the administrator to the notification result within a predetermined period. When it is determined that the database is deleted according to the request of the system administrator, it is possible to determine whether or not the database can be deleted from the result of the examination by the administrator and delete the database.
[0013]
From the viewpoint of appropriately judging the DB to be deleted, according to the present invention, as set forth in claim 3, the management master information management means performs the processing based on the information on the attribute of the database in the database creation application information. Alternatively, a configuration may be adopted in which a criterion for determining whether or not to notify a manager of the database of a request for continuation of the database is set.
[0014]
In such a usage status information management system, an unnecessary database can be accurately determined by setting a reference value based on application information on an attribute of a database applied by a database administrator.
[0015]
From the viewpoint of making it possible to change the criterion for deleting a database, according to the present invention, as set forth in claim 4, the management master information managing means sets a reference value to the number of accesses to the database within a predetermined period. And requesting at least one of an update period until updating the information of the database, a predetermined storage capacity of the database, and a storage expiration date of the database to a manager of the database to request the continuation of the database. A configuration may be used as a criterion for determining whether to notify.
[0016]
In such a usage status information management system, any one of the number of accesses, the update period, and the storage capacity is used as a criterion for determining whether or not to notify the database administrator of a request to consider the existence of the database. The versatility of the deletion criterion can be improved.
[0017]
Further, in order to solve the above problems, the present invention can be a program for causing a computer to perform the process in the database management method, and a recording medium storing the program.
[0018]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[0019]
FIG. 1 is a configuration diagram of a DB management system according to an embodiment of the present invention. In FIG. 1, a DB management system 10 includes a DB management server 20, DB holding servers 60 a to 60 x holding DBs 50 a to 50 x, and DB creation application information, and terminals 30 a to 50 that use various DBs 50 a to 50 x. 30x. Note that a DB management center (not shown), DB holding servers 60a to 60x, and terminals 30a to 30x are connected via the network 1.
[0020]
1, the DB management server 20 includes a DB management master DB 250, a usage status information DB 251 and a DB access information DB 252.
[0021]
The DB management server 20 is a server computer, and the following components are controlled by a CPU (Central Processing Unit). The CPU performs processing in the DB management system 10 according to a program stored in the memory unit. The DB management server 20 mainly includes an installer 208 for installing a program for realizing processing in the DB management system 10 according to an embodiment of the present invention, a communication control processing unit 203 for controlling data communication, An input / output control processing unit 209 for controlling data input / output, a display processing unit 210 for controlling display of information in the system, and DB management master information created based on various DB creation application information; DB creation application information registration processing unit 200 that controls the process of registering in DB, DB usage status collection unit 201 that collects the DB usage status and stores it in usage status information DB 251, DB management master information in DB management master, Based on the usage status information in the usage status information DB 251, DB access information is created and stored in the DB access information DB 252. B access information creating section 202, DB access information list creating section 204 for creating a DB access information list, notification processing section 206 for notifying a DB administrator of DB continuation study, and DB for deleting various DBs And a deletion processing unit 207.
[0022]
The communication control processing unit 203 is a processing unit that controls transmission and reception of data via a network, and includes a communication unit for connecting to a network.
[0023]
The input / output control processing unit 209 controls input units such as a mouse and a keyboard, and output units such as a monitor and a printer, and controls input / output of data.
[0024]
The installer 208 reads the program from a recording medium on which a program for realizing processing in the DB management system according to the embodiment of the present invention is recorded, and stores the read program in, for example, an auxiliary storage device. To install. Then, when the database management process is started, the CPU starts the process according to the program installed in the auxiliary storage device. The recording medium may be a computer-readable medium such as a CD-ROM as a medium for storing the program.
[0025]
The display processing unit 210 has a display unit such as a display, and controls a screen display of information in the present system. For example, when an input for displaying the DB access information list is performed from the input unit by the system administrator, the display processing unit 210 determines the DB access information list based on the DB access information stored in the DB access information DB 252. The DB access information list created by the creating unit 204 is displayed on the display unit. Note that the terminal may have the display processing unit 210 to display information of the system on the display unit of the terminal.
[0026]
The DB creation application information registration processing unit 200 creates DB management information based on the DB creation application information from the terminal, and stores it in the DB management master DB 250.
[0027]
The DB usage status collection unit 201 receives a DB name, a DB size, an access count, and a document read count held by the DB holding server from the DB holding servers 60a to 60x connected to the network every day at a predetermined time. , The usage status information of the DB such as the number of writes is collected and stored in the usage status information DB 251.
[0028]
The DB access information creating unit 202 issues a notification of the DB name in the DB management master DB 250, the mail address of the manager, the attribute, the DB usage frequency, and the continuation study notification to the DB manager at a predetermined time every day. And the number of accesses, the number of accesses, and the number of accesses to collect the information on the number of accesses, the date of information update, and the size of the DB in the usage status information DB 251 and whether to issue a notification to the DB administrator of the existence of the information. Based on the date, the DB size, and the DB storage expiration date, the DB that does not satisfy the above criterion creates the examination request notification flag, and creates the DB access information without the flag for the DB that satisfies the above criterion. , In the DB access information DB 252.
[0029]
When the notification processing unit 206 acquires the request for transmission of the survival study request mail from the DB management server, the notification processing unit 206 notifies the administrator of the DB of a survival study request email with a link to a screen as shown in FIG. 9 or the like. . Further, the notification processing unit 206 provides the DB access information creation unit 202 with the notification date of the continuation study, the date of receiving the study result, the study result, and the like. In this way, it is possible to manage the DB access information that reflects the survival study notification date, the study result reception date, the study result, and the like in the DB access information.
[0030]
The DB deletion processing unit 207 determines whether or not there is no response from the DB administrator within a predetermined period after the notification processing unit 206 has transmitted the survival study request mail to each DB administrator, and the review received from the DB administrator. When the result is discontinued, the DB managed by the DB administrator is deleted. The DB deletion processing unit 207 may provide the result of deleting the DB to the notification processing unit 206, and the notification processing unit 206 may notify each DB administrator of the deletion result by e-mail or the like. Further, the DB deletion processing unit 207 may delete the DB access information and the DB management master information of the deleted DB from the DB access information DB management 252 and the DB management master DB 250, respectively.
[0031]
The DB management master DB 250 is composed of, for example, a rewritable storage device such as a hard disk device, and stores a DB management master information table 255 as shown in FIG. The DB management master information is information created by the DB creation application information registration processing unit 200 from the DB creation application information. The DB management master information table 255 includes a DB name, a management section name, a manager's name and an e-mail address of the manager, an attribute, a DB use frequency, and a criterion for determining whether to notify the DB manager of the continuation study. And so on.
[0032]
The usage status information DB 251 is composed of, for example, a rewritable storage device such as a hard disk device, and stores the DB usage status information table 256 shown in FIG. 4 for each DB for each date. The use status information table 256 includes a DB name, a DB holding server name, a date, an access count, a read document count, a write document count, an access user name, a DB size, and the like.
[0033]
The DB access information DB 252 is composed of, for example, a rewritable storage device such as a hard disk device, and accumulates DB access information created as shown in FIG. 5 based on DB management information and usage status information.
[0034]
Next, a table stored in the DB access information DB 252 will be described. FIG. 5 is a diagram showing a table 257 stored in the DB access information DB 252. The DB access information table 257 stores the DB name, the department name, the name of the manager, the mail address of the manager, the attribute, the frequency of use of the DB, and whether or not to notify the DB manager of the continuation study obtained from the DB management master DB 250. Number of accesses, update period, DB size, DB storage expiration date and DB update period, which is obtained from the usage status information DB 251 and determines whether or not to issue a continuation study notification to the administrator Based on the frequency of access to the DB, the date of the last information update, the DB size (byte) at the time of creating the DB access information, and the above-mentioned criteria and the usage information corresponding to them, in accordance with the unit of Of whether or not a criterion for determining whether or not to issue a continuation review notification, a continuation review notification flag, and a continuation review request provided by the notification processing unit 206. An examination request date item indicating the date and time when the mail was sent, an examination result reception date item indicating the date when the examination result was received from the DB administrator, and an examination result item indicating the content of the continued or discontinued examination result are stored. ing. The DB access information creation unit 202 stores the determination result of “○” when the usage status satisfies the survival criterion, and “X” when the usage status does not meet the criterion, and the survival study notification flag in the DB access information table 257 of the DB access information DB 252. Store.
[0035]
For example, in the DB access information table 257, for the DB name item "Intellectual Property News DB (DB1)", the section item "Legal Affairs Headquarters", the DB administrator name and the administrator mail address items "Taro Tatto, aaa" ＠Aaaa ”, attribute item“ forum ”, DB usage frequency item“ as needed ”, number of accesses in survival condition item“ 100 / month ”, update period“ once a month ”, DB size“ 3G or less ”, DB storage The expiration date “2007/01/01”, the month before access “97”, the month before February “107”, the month before March “143”, the information update date item “2002/09/18”, DB size item "2,100,297,728" and "X" one month ago, "O" two months ago, "O" three months ago, "O" update period, "DB""○", DB storage period " And ", the surviving consider notification flag" ○ ", study request Date item" 10/01 ", study results received date the item" 10/04 ", study results and the item" continuation "is stored.
[0036]
The information stored in the access frequency item and the DB continuation use determination result item is not limited to one month to three months ago, and is a reference access to determine whether or not to notify the manager of the continuation study. Whether the number of accesses in a short period of time, such as half a year or one year, such as half a year or one year, or one day, meets the criteria for judging whether or not to notify the administrator of the existence of a survivorship. The determination result may be stored.
[0037]
Note that the terminals 30a to 30x have the same configuration as the installer 208, the communication control processing unit 203, the input / output control processing unit 209, and the display control unit 210 of the DB management server 20, and thus the description is omitted.
[0038]
Next, a DB application information registration process in the present system will be described with reference to FIG. FIG. 2 shows an example of a DB creation application screen transmitted to the terminals 30a to 30x of the DB applicant. First, the DB creation application screen 300 is obtained from the terminals 30a to 30x of the DB applicant who wants to create a DB. The DB creation application screen 300 is a screen provided by the DB creation application information registration processing unit 200 in the DB management server 20 when a display request for the DB creation application screen 300 is acquired from the terminals 30a to 30x to the DB management server 20. . The DB creation application screen 300 is for returning to the display area 301 showing a display for inputting application contents, an application button 312 for transmitting the input application information, and a screen for requesting display of the DB creation application screen 300. Button 313. The display area 301 includes an input area 302 for inputting a DB name, an input area 303 for inputting a department, an input area 304 for selectively inputting attributes of a DB from "forum", "company rules", and the like, and management of the DB. An input area 305 for inputting the name of the person in charge, an input area 306 for inputting an e-mail address of the notification destination of the person in charge of DB management, and a DB usage frequency of “as needed”, “once a month”, , Etc., an input area 308 for selectively inputting the number of accesses, which is a condition for maintaining the DB, from “100 / month”, “50 / month”, “1000 / month”, etc., and an update period. An input area 309 for selecting and inputting from “as needed”, “once a week”, “once a month”, and the like, and the DB size indicating the storage capacity of the DB as “1 G or less”, “2 G or less”, “3 G or less” And the input area 310 for selecting and inputting from the And the input area 311 is displayed to the force.
[0039]
For example, the DB applicant enters a DB name “Intellectual Property News DB”, a section “Legal Affairs Headquarters”, a DB attribute “Forum”, a manager name “Patent Taro”, and a mail address of the manager in the input area of the display area. “Aaa @ aaaa”, DB usage frequency “as needed”, access number of survival condition “100 / month”, update period “once a month”, DB size “3G or less”, DB storage expiration date “2007/1/1” Is input and the application button 312 is selected, the DB management server 20 receives the DB creation application information registration request. The DB creation application information registration processing unit 200 of the DB management server stores the application information in the DB management master DB 250 based on the DB creation application information registration request received from the terminal. At this time, the DB survival condition in the DB application information is set as a reference value for determining whether or not to issue a survival consideration notification to the administrator, and stored in the DB management master DB 250.
[0040]
Next, the survival study request email will be described. A link to a survival study screen as shown in FIG. 9 is attached to the survival study request email transmitted to the DB administrator. The survival examination screen 320 includes a display area 321 on which information on the survival examination notice and the name of the DB to be examined for survival are displayed, a DB access information browse button 322, and a continuation button 323 selected when the DB is to be persisted. A non-continuation button 324 is selected when the DB is not to be kept. The DB access information browse button 322 is selected when the DB administrator requests browsing of the DB access information of the DB to be notified. When the browse DB access information button 322 is selected, the DB management server 20 provides the DB access information of the notified DB to the DB administrator terminal. Thereby, the DB administrator can browse the DB access information of the DB to be notified, and can accurately determine whether or not to continue the DB to be notified. The continuation button 323 is selected when the DB administrator determines that the DB to be notified should be kept. When the continuation button 323 is selected, the content is transmitted to the notification processing unit 206 in the DB management server 20 via the network 1. The non-continuation button 324 is selected when it is desired to delete the notification target DB. When the non-continuation button 324 is selected, the content is transmitted to the notification processing unit 206 in the DB management server 20 via the network.
[0041]
Next, the DB access information list display processing will be described. FIG. 6 is a diagram showing a flowchart in the DB access information list display processing. 6, first, in the process of step S10, the DB access information creation unit 202 of the DB management server 20 sends the DB name, the department name, the name of the manager, the mail address of the manager, and the attribute from the DB management master DB 250. , A survival criterion item indicating the number of accesses, a renewal period, a DB size, a DB storage expiration date, and a DB use frequency, which serve as a criterion for notifying a DB review request, and a usage status information DB 251 for each DB. In this case, items indicating the number of accesses to each DB, the last update date, and the current DB size, which are totaled in units that match the criteria for determining whether or not to issue a notification of surviving to the administrator, are acquired. In the process of step S11, the DB access information creation unit 202 compares the criterion for judging whether or not to issue a notification of the continuation review to each manager with the frequency of use, the date of last information update, and the DB size information. It is determined whether or not a criterion for determining whether to issue an examination notice is satisfied.
[0042]
If the criterion for judging whether or not to issue a survival study notification to the administrator is satisfied in the processing of step S11, DB access information without a survival study notification flag is created in step S13 and stored in the DB access information DB 252. . In the process of step S11, if the criteria for determining whether or not to issue a survival consideration notification to the administrator is not satisfied, the DB access information with the survival consideration notification flag is stored in the DB access information DB 252 in step S12. In addition, for example, when the number of accesses “100 / month” is set as a criterion for determining whether or not to send a notification of survival to the administrator, the actual number of accesses calculated on a monthly basis Compare. In addition, when the update period “once a month” is set as a criterion for determining whether or not to notify the administrator of the continuation examination, if the update period “once a month” is set, This is used as a criterion for determining whether or not to issue a notification of surviving examination to the administrator. When the DB size “3G or less” is set, the DB size at the time of creating the DB access information is used as a criterion for judging whether or not to issue a notification of the continuation study to the administrator. If the DB storage date has been set, the DB storage date is compared with the DB access information creation date. In the process of step S14, the DB access information list creation unit 204 of the DB management server 20 acquires a list display request. In the process of step S15, the DB access information list creation unit 204 of the DB management server 20 creates a DB access information list that can identify the DB access information with the flag and the DB access information without the flag, and the display processing unit Displays the DB access information list on the display. Step S14 may be the first step, and steps S10 to S13 may be performed thereafter.
[0043]
Next, the DB deletion process will be described. FIG. 7 is a diagram showing a flowchart in the DB deletion process. 7, first, in the processing of step S20, the DB deletion processing unit 207 refers to the DB access information DB 252. In the processing of step S21, the DB deletion processing unit 207 determines whether or not the examination result has been received from the DB administrator within a predetermined period for the transmission of the survival examination request mail. If it is determined in step S21 that the examination result has been received from the DB administrator within the predetermined period, the DB deletion processing unit 207 determines in step S22 whether the contents of the examination result are continued. If it is determined in step S21 that there is no response from the DB administrator within a predetermined period, and if it is determined in step S23 that the content of the examination result is not continuous, the DB is deleted in step S23. The processing unit 207 deletes a predetermined DB. After the predetermined DB is deleted in the process of step S23, the notification processing unit 206 may notify the DB administrator of the result of deleting the predetermined DB. Further, the DB deletion processing unit 207 may delete the DB access information and the DB management master information of the deleted DB from the DB access information DB 252 and the DB management master DB 250, respectively.
[0044]
According to the present invention, the use status information management process can determine whether or not to notify a DB administrator of a survival study request based on the use status information, and delete a predetermined DB when there is no response to the notification. By performing the above processing, unnecessary DBs can be deleted, a recordable disk capacity can be increased, and DB use efficiency can be improved.
[0045]
Note that the DB access information DB 252 in the second embodiment of the present system includes a table 258 shown in FIG. 8, and the DB creation application information registration processing unit 200 performs management based on the attributes of the DB of the DB creation application information. May be automatically set as a criterion for determining whether or not to issue a notification of the continuation study.
[0046]
The table 258 shown in FIG. 8 stores information for the application registration processing unit to set the criteria for maintaining the DB based on the attributes of the DB of the application information from the terminals 30a to 30x. The table 258 includes an item indicating an attribute of a DB, an item indicating the number of accesses as a reference value for the attribute, an item indicating an update period, and an item indicating a DB size. For example, the table 258 stores, for the attribute item “forum”, the number of accesses in the survival criterion item “100”, the update period “once a month”, and the DB size “3G or less”. The number of accesses in the survival criterion item “50”, the update period “once a year”, the DB size “1 G or less” and the like are stored for the “company-wide rules”.
[0047]
Therefore, the DB creation application information registration processing unit can set a reference value for maintaining the DB based on the table 258 and the attributes of the DB in the application information from the terminals 30a to 30x.
[0048]
In such a usage status information management system, it is necessary to set a reference value based on the application information on the attributes of the DB applied by the DB administrator, and thereby to appropriately transmit the survival study notification. Can be determined.
[0049]
Next, the contents of the DB access information list displayed on the DB management server 20 by the input of the administrator of the DB management server 20 will be described. FIG. 10 is a diagram showing a DB access information list screen displayed on the DB management server. As shown in FIG. 10, the DB access information list screen 220 is created by the DB access information list creation unit 204 of the DB management server 20 based on the DB access information, and displayed on the screen by the display processing unit 210. 3 shows an access information list. On the DB access information list screen 220, a display area 221 showing the DB access information list, a button 222 for displaying the next screen, and a button 223 for returning to the previous screen are displayed. The items displayed in the display area 221 are the same as the items in the table stored in the DB access information DB 252, and a description thereof will be omitted. The DB access information with the existence examination notification flag is shaded on the line, and is displayed in a manner distinguishable from the DB access information without the flag.
[0050]
Here, as the identifiable display mode, shading is used for the row of the DB access information with a flag. However, the identifiable display mode is not limited to this. The color of the character may be changed.
[0051]
As an example of the present system, an example of a DB management system in a company has been described, but the embodiment of the present system is not limited to this. For example, implementation of the present system in a company that provides use of a DB to a plurality of companies is also an embodiment.
[0052]
【The invention's effect】
As described above, according to the present invention, it is determined whether or not to notify the DB manager of the survival study request from the usage status information indicating the DB usage status, and the DB manager is notified of the survival study request. In addition, since each DB is deleted by urging the administrator to consider the deletion of the DB, the capacity of a recordable disk can be increased and the use efficiency of the system can be improved.
[Brief description of the drawings]
FIG. 1 is a configuration diagram of a DB management system according to an embodiment of the present invention.
FIG. 2 is a diagram showing a creation application screen displayed on a DB creation applicant terminal.
FIG. 3 is a diagram showing a table stored in a DB management master DB.
FIG. 4 is a diagram showing information stored in a usage status information DB.
FIG. 5 is a diagram showing a table stored in a DB access information DB.
FIG. 6 is a diagram showing a flowchart in a DB access information list display process.
FIG. 7 is a diagram showing a flowchart in a DB deletion process.
FIG. 8 is a diagram showing a table to be referred to when automatically setting a criterion for determining whether or not to issue a notification of a continuation study to an administrator based on an attribute;
FIG. 9 is a diagram showing the contents of a mail of a survival examination notice.
FIG. 10 is a diagram showing a DB access information list screen displayed on the DB management server.
[Explanation of symbols]
1 Network 10 DB Management System 20 DB Management Servers 30a-30x Terminals 50a-50x DB
60a-60x DB holding server 200 DB creation application information registration processing unit 201 DB usage status collection unit 202 DB access information creation unit 203 Communication control processing unit 204 DB access information list creation unit 206 Notification processing unit 207 DB deletion processing unit 208 Installer 209 Input / output control processing unit 210 Display processing unit 250 DB management master DB
251 Usage status information DB
252 DB access information DB

Claims (5)

A database management system that manages the database based on the usage status of the database,
Usage status information management means for managing usage status information indicating the usage status of the database,
Management master information management means for managing the management master information of the database,
Access information that manages access information having survival study necessity information as to whether or not a notification of a request for survival study of the database is necessary for the administrator of the database based on the use status information and the management master information. Management means;
Display means for displaying the information on the necessity of continuation of the access information in response to a request from a system administrator of the database management system. Notifying means for notifying the database administrator of a survival study request in response to a request of the system administrator based on a display result by the display means,
When it is determined that there is no response from the administrator within a predetermined period with respect to the notification result by the notification unit, a deletion unit that deletes the database in response to a request from the system administrator is provided. The database management system according to claim 1. The management master information management means sets a criterion for determining whether or not to notify a manager of the database of a request to consider the continuation of the database, based on information on attributes in the database creation application information. The database management system according to claim 1. The management master information management means includes: a reference value, a number of accesses to the database within a predetermined period, an update period until information of the database is updated, a predetermined storage capacity of the database, and a storage time limit of the database. The database management system according to any one of claims 1 to 3, wherein at least one of a date and a date is used as a criterion for determining whether or not to notify a manager of the database of a request to investigate the existence of the database. . A program for causing a computer to perform a process in a database management system that manages the database based on the usage state of the database,
A usage status information management procedure for managing usage status information indicating the usage status of the database,
A management master information management procedure for managing the management master information of the database,
Access information that manages access information having survival study necessity information as to whether or not a notification of a request for survival study of the database is necessary for the administrator of the database based on the use status information and the management master information. Management procedures,
A display procedure for displaying the survival study necessity information of the access information in response to a request from a system administrator of the database management system.

Images