JP2009157445A - Database development management system and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database development management system or the like for improving efficiency of database development. <P>SOLUTION: A template DB 22 of a development management server 10 stores template data of each database, an access control list DB 23 stores user list data having an access right to the databases, and a development process DB 21 stores data related to a development process of each database. A development progress management part 11 performs connection to a schedule management server 30 when a date of a conference in the development process of the database is input, performs reservation processing of a conference room based on the input date, and sets a schedule of the conference to schedule data of each person in charge of the database. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a database development management system for supporting database development work.

Conventionally, in the development of a database, a plurality of types of templates have been used to improve work efficiency. These templates were distributed and managed on multiple servers.
In addition, a list of users (access control list) that is permitted to develop / update database templates is set for each database and managed in paper.
For example, there is a system that manages information on element development / product development processes in a database in a unified manner for design support (Patent Document 1).
JP 2007-72580 A

In the system as described above, it is impossible to determine which server has the latest version of the template, and it is necessary to access a plurality of servers to search for the latest version of the template.
In addition, since the access control list is managed on paper, the work efficiency is poor.
In addition, it has been desired to realize a mechanism for proceeding with database development work more efficiently.

  The present invention has been made in view of the above problems, and an object thereof is to provide a database development management system and the like that improve the efficiency of database development.

In order to achieve the above object, a database development management system according to the first aspect of the present invention provides:
Means for storing template data of each database;
Means for storing for each database user list data having authority to access the database;
Means for storing data relating to the development process of each database;
When a meeting date in the database development process is input, reservation processing for the conference room is performed based on the date, and reservation means for setting a meeting schedule in the schedule data of each person in charge of the database;
It is characterized by providing.

  The reservation means may further comprise means for transmitting a notification mail regarding the conference to each person in charge of the database.

  The reservation unit may refer to schedule data of each person in charge in the database and search for a free time common to persons in charge of a predetermined ratio or more among all persons in charge to determine a reservation time for the conference room. .

A program according to the second aspect of the present invention is:
Computer
Means for storing template data of each database;
Means for storing, for each database, list data of users having authority to access the database;
Means for storing data relating to the development process of each database;
Reservation means for performing conference room reservation processing based on the date when the date of the conference in the database development process is input, and setting the conference schedule in the schedule data of each person in charge of the database,
It is made to function as.

  According to the present invention, the efficiency of database development can be further improved.

Hereinafter, a database development management system according to an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 illustrates a system configuration of a database development management system according to an embodiment of the present invention. As shown in the figure, this database development management system 1 includes a development management server 10, a schedule management server 30, and a terminal device 50, which are connected to each other by a network N such as a LAN.

  The development management server 10 is for managing database development work, and includes a control unit including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like, and a hard disk device. Etc., and a communication unit comprising an operation program to be executed by the control unit and various data necessary for processing, etc., and a communication device such as a NIC (Network Interface Card), a router, or a modem And a computer comprising: The control unit logically realizes the development progress management unit 11, the template management unit 12, the access control list management unit 13, and the like by reading and executing an operation program or the like stored in advance in the storage unit. The storage unit also includes a development process DB (database) 21, a template DB 22, an access control list DB 23, and the like.

  The development progress management unit 11 performs various processes for managing the progress of database development. Specifically, when a registration request for a new development process is received from the terminal device 50, the development progress management unit 11 transmits a predetermined input screen and generates development process information based on the input data from the terminal device 50. And registered in the development process DB 21. The development process information includes, for example, data such as the name of the database to be developed, the person in charge, the version, etc., and the scheduled date and results of each development process (design review, audit, completion report, test plan, test result report, release judgment, etc.) Contains day data.

In addition, when an input request related to a development process such as a progress situation is received from the terminal device 50, the development progress management unit 11 receives input of information specifying a database to be processed, and develops development process information of the corresponding database as a development process. Read from DB21. Then, a development process input screen that displays the read development process information and receives an input such as a progress status is generated and transmitted to the terminal device 50, and data input such as the actual date of the development process is received and stored in the development process DB 21. To do.
In addition, when a progress status browsing request is received from the terminal device 50, the development progress management unit 11 receives input of information specifying a database to be browsed, reads development process information of the corresponding database from the development process DB 21, A development process display screen for displaying the read development process information is generated and transmitted to the terminal device 50.
When the development process input screen and the development process display screen are generated, the development progress management unit 11 refers to the scheduled date of each development process, and a red mark is displayed for a development process that has not been performed even if the scheduled date has passed ( Warning display). Also, blue marks are displayed for development processes that have already been implemented on or before the scheduled date.
An example of the development process display screen is shown in FIG.

  Further, when the conference date in the development process is input by the terminal device 50 at the time of registration of the development process or when the development process information is subsequently input, the development progress management unit 11 connects to the schedule management server 30 to Make room reservations and set attendee schedules. Specifically, the person-in-charge information (group member information) set in advance for the database in which the meeting date in the development process is input is read from the development process DB 21, and the schedule information after the input meeting date is read for each person in charge. Is searched from the schedule DB 41 of the schedule management server 30 to search for a free time common to the persons in charge of a predetermined ratio or more (for example, 70%) of all persons in charge. For the detected vacant time, the facility schedule information is referred to from the facility schedule DB 42 of the schedule management server 30. If the conference room is available, reservations are set for both the schedule information of each person in charge and the schedule information of the conference room. To do. If the conference room is not available, the person-in-charge schedule is further searched to find a time when both the person-in-charge schedule and the conference room are available. Then, a notification mail for notifying the date and place of the meeting and the like is generated and transmitted to the mail address of each person in charge.

  In addition, it is possible to make settings such as adding, changing, and deleting attendees of the conference as necessary. In this case, in response to a request from the terminal device 30, the development progress management unit 11 transmits a conference attendee setting screen, accepts input such as addition, change, and deletion of attendees, and each input content indicates Set the above schedule for attendees.

The template management unit 12 performs various processes for managing templates used for database development.
Specifically, when a template registration request is received from the terminal device 50, the template management unit 12 transmits a predetermined input screen, generates template information based on the input data, and registers it in the template DB 22. The template information includes, for example, data such as a template database name, file name, stored server name, version, development status, and release date. At this time, the latest version of the template file is also attached and stored in the template DB 22 in association with the template information.
Further, when a template information update request is received from the terminal device 50, the template management unit 12 receives input of information (for example, a template file name) for specifying the template information to be updated, and the corresponding template information An edit screen for accepting a change input is transmitted and the template information in the template DB 22 is updated with the input content.

  Further, when a template information display request is received from the terminal device 50, the template management unit 12 receives input of information for specifying the template information to be displayed, reads out the corresponding template information from the template DB 22, and lists them. Send the screen. An example of a template information list screen is shown in FIG.

The access control list management unit 13 performs various processes for managing access control list information indicating a person in charge having access authority such as design / change of a database for each database.
Specifically, when a registration application request for access control list is received from the terminal device 50, the access control list management unit 13, for example, a template name, a version, an authorized user name, an authorized period, an authorized reason, etc. A predetermined registration application screen for inputting is transmitted to accept the input, and access control list information including input data and data such as application status / registration status is registered in the access control list DB 23. In addition, the access control list management unit 13 transmits an approval request mail to an approver set in advance or input by the terminal device 50, and when a predetermined approval process is performed by the approver, the access control list The application status of the access control list information in the DB 23 is changed from “Applying” to “Approved”.

  When the access control list display request is received from the terminal device 50, the access control list management unit 13 reads the specified access control list information from the access control list DB 23 and transmits a screen for displaying the information. When the access control list is displayed, the access control list management unit 13 displays a red mark (warning display) for the person in charge who has passed the authorization period. Further, a blue mark may be displayed for a person in charge who has not passed the authorization period.

In the display of the access control list information, in addition to the normal list display, it is also possible to extract and display items that have been granted authority or those that have expired the authority grant period. An example of the display screen of access control list information is shown in FIG.
Further, the access control list management unit 13 manages the history of the access control list information for a predetermined number of times and displays them in response to a request from the terminal device 50.

  The schedule management server 30 is for managing a user's schedule and a use schedule of equipment such as a conference room, and is composed of a control unit composed of a CPU, a ROM, a RAM, etc., a hard disk device, etc. It is comprised from the computer provided with the memory | storage part which memorize | stores the operation program for performing, various data required for a process, etc., and the communication part comprised from communication apparatuses, such as NIC, a router, and a modem. The control unit logically implements the schedule management unit 31 by reading and executing an operation program or the like stored in advance in the storage unit.

  In response to a request from the development management server 10, the schedule management unit 31 reads schedule information from the schedule DB 41, reads equipment schedule information from the equipment schedule DB 42, reservation settings for schedule information, reservation settings for equipment schedule information, and the like. Each process is performed. The storage unit also includes a schedule DB 41 in which schedule information of each user is stored, an equipment schedule DB 42 in which equipment schedule information of equipment such as a conference room is stored.

  The terminal device 50 is a terminal device used by a person in charge of database development work, and includes a control unit including a CPU, a ROM, a RAM, a storage unit including a hard disk device, a display unit including a liquid crystal display, and the like. And a personal computer including an input unit including a keyboard and a mouse, and a communication control unit including a NIC, a router, a modem, and the like. The control unit of the terminal device 50 connects to the development management server 10 by executing a program or the like stored in the storage unit, and inputs / displays information related to the progress of database development, and registers / updates information related to the template. Various processes such as display, registration, update, and display of information related to the access control list are performed.

Next, conference room reservation processing, which is one of the features of the database development management system 1 according to the embodiment of the present invention, will be described with reference to the flowchart of FIG.
For example, it is assumed that the person in charge transmits an input request regarding a development process to the development management server 10 using the terminal device 50 and inputs a meeting date “November 15” in the development process of a certain database A.

  In response to the input of the conference date, the development progress management unit 11 of the development management server 10 reads the information of the person in charge of the database A from the storage unit, and schedule information after “November 15” for each person in charge. With reference to the schedule DB 41 of the schedule management server 30, a search is made for a common free time in which more than a predetermined ratio (for example, 70%) of all persons in charge can attend (step S <b> 11). Here, for example, it is assumed that “15:00 to 17:00” of “November 15” is detected as a common idle time.

  Next, the development progress management unit 11 refers to the equipment schedule information from the equipment schedule DB 42 of the schedule management server 30 for the time zone “15:00 to 17:00” of the detected “November 15”, and the reservation is made. A conference room that does not enter is searched (step S12). Here, for example, it is assumed that “conference room B” is detected.

Next, the development progress management unit 11 determines whether an empty conference room has been detected (step S13). In this example, since “conference room B” is detected (step S13: YES), the development progress management unit 11 “15:00” of “November 15” of the schedule information of the person in charge of the database A in the schedule DB 41. The schedule is set in the time zone of “17:00 to 17:00” (step S14) and reserved for use in the time zone of “15:00 to 17:00” of “November 15” of the equipment schedule information of the conference room B in the equipment schedule DB 42 Is set (step S15).
Next, the development progress management unit 11 transmits a notification mail for notifying the date and time of the meeting and the location to each person in charge of the database A (step S16).

  In step S13, when a vacant conference room is not detected (step S13: NO), the development progress management unit 11 returns to step S11, and “15” of “November 15” detected earlier. In a time later than “hours to 17:00”, a search is made for a time that is free for all persons in charge of a predetermined ratio or more, and the above-described processing is continued.

  As described above, according to the present invention, the template used for database development is centrally managed by the development management server 10, so the efficiency of database development using the template can be improved. In addition, centrally managing the access control list with the development management server 10 makes it easy for the person in charge to refer to the access control list and update the authorization period, thereby improving the database development work efficiency. . In addition, the development management server 10 manages the progress of database development, and automatically schedules the person in charge and reserves the conference room when the meeting date of the development process is input, thereby improving the efficiency of database development. It can be improved further.

The present invention can be variously modified and applied.
For example, the development management server 10 may register the development process information and document (link) of each database in the development process DB 21 so that each review can be smoothly performed according to the registered schedule.

Further, in the conference room reservation process, the user can arbitrarily set a ratio value for searching for a free time common to persons in charge of a predetermined ratio or more among all persons in charge. Further, the set value is not limited to the ratio value, and other values such as the number of people may be used.
Further, after the schedule of the person in charge is set, the development management server 10 may be able to change / delete the set schedule information in response to a request from the terminal device 50. .
In addition, after the reservation setting of the conference room, the development management server 10 may be able to change the reservation content or delete the reservation in response to a request from the terminal device 50.

Further, the development management server 10 may check the progress status of each database, and if there is a delayed process (displayed in red), an email may be transmitted to the person in charge.
The functions of the development management server 10 and the schedule management server 30 may be realized by a single computer.

The system of the present invention can be realized using a normal computer system, not a dedicated system. For example, by storing a program for executing the above-described operation in a computer-readable recording medium (FD, CD-ROM, DVD, etc.) and distributing the program, and installing the program in the computer, the development management server 10, You may comprise the schedule management server 30 grade | etc.,. Alternatively, it may be stored in a disk device of a server device on a network such as the Internet and downloaded to a computer, for example.
In addition, when the OS realizes the above functions by sharing the OS or jointly with the OS and the application, etc., only the part other than the OS may be stored and distributed in the medium, or may be downloaded to the computer. Good.

It is a figure which shows the structure of the database development management system which concerns on embodiment of this invention. It is a figure which shows an example of a development process display screen. It is a figure which shows an example of the list screen of template information. It is a figure which shows an example of the display screen of access control list information. It is a flowchart for demonstrating a conference room reservation process.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Database development management system 10 Development management server 30 Schedule management server 50 Terminal device 11 Development progress management part 12 Template management part 13 Access control list management part 21 Development process DB
22 Template DB
23 Access control list DB
31 Schedule Management Department 41 Schedule DB
42 Equipment Schedule DB

Claims (4)

Means for storing template data of each database;
Means for storing for each database user list data having authority to access the database;
Means for storing data relating to the development process of each database;
When a meeting date in the database development process is input, reservation processing for the conference room is performed based on the date, and reservation means for setting a meeting schedule in the schedule data of each person in charge of the database;
A database development management system comprising: The reservation means further comprises means for transmitting a notification mail regarding the conference to each person in charge of the database.
The database development management system according to claim 1. The reservation means refers to the schedule data of each person in charge of the database, searches for free time common to persons in charge of a predetermined ratio or more of all persons in charge, and determines the reservation time of the conference room.
The database development management system according to claim 1 or 2. Computer
Means for storing template data of each database;
Means for storing, for each database, list data of users having authority to access the database;
Means for storing data relating to the development process of each database;
Reservation means for performing conference room reservation processing based on the date when the date of the conference in the database development process is input, and setting the conference schedule in the schedule data of each person in charge of the database,
Program to function as.

Images