JP2014071548A - Information processor, information processing method and computer program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To suitably prevent an erroneous operation due to an operation mistake when a user is able to operate both a production environment server and a development environment server.SOLUTION: An information processor manages which server a user has logged-in to. When accepting a predetermined operation command to a production environment server while the user has logged in to both a development environment server and the production environment server, the information processor allows the user to confirm the content of the operation command before executing processing based on the operation command. Afterwards, when accepting an instruction of the execution of the operation from the user, the information processor executes the processing following the operation command. Thus, it is possible to increase a possibility of finding out the issue mistake of the operation command by the user.

Description

  The present invention relates to a technology for supporting maintenance / operation work of a server.

  Conventionally, when operating an in-house system at a company, etc., an environment for performing operation verification (development environment) and an environment for actually operating the system (production environment) have been established, and development of application programs used in those systems Etc. are performed in a development environment configured in the same way as the production environment, and after confirming that there is no problem as a result of the operation verification, it is widely performed to change the application program in the production environment.

  It is also common to change the master environment used in the in-house system after confirming in the development environment whether there is a problem with the system by changing the master data. is there.

  For example, in Patent Document 1, a change operation is performed in order to prevent an operation person in charge of the system from making an operation error in the production environment and to prevent the operation person in charge from performing an unexpected operation. Before doing this, in the development environment, first perform the same work as the change work, acquire the operation log, and warn when an operation different from the pattern indicated by the operation log is performed, Techniques for preventing operational mistakes by operators are disclosed.

JP 2011-170739

  However, for example, in the case of minor data correction of the master data, operation confirmation in the development environment is not necessarily performed, and the master data in the production environment is changed.

  When the system operator performs business in this way, the operator performs the work different from the master data change work in the development environment, and logs in to the production environment to perform the master data change process. Sometimes done. In many cases, the application configuration and database structure of the development environment server are often set to the same settings as in the production environment. A human error has occurred.

  In view of the above-described problems, the present invention is a system maintenance / operation person who logs in both the development environment and the production environment and performs server maintenance / operation work, and mistakes the server to be operated. The purpose is to alleviate operation mistakes caused by this.

  In order to achieve the above object, an information processing apparatus according to the present invention is an information processing apparatus that transmits an operation command to a plurality of system servers including a production environment server and a development environment server, and is a client device used by a user A first accepting unit that accepts a login request to the system server, a login unit that performs a login process of the user in accordance with a connection request accepted by the first accepting unit, and the login process allows the user to A first setting means for setting the production environment server as a confirmation required system server that requires user confirmation to transmit an operation command when logging in to a plurality of system servers including the environment server; An operation command for the system server is sent from the client device used by A second determination unit that determines whether the operation command received by the second reception unit is an operation command for the system server that requires confirmation, and the first determination unit, A third receiving means for receiving, from the client device used by the user, a confirmation input as to whether or not to transmit the operation command to the system server after it is determined whether the operation command is for the system server requiring confirmation; Transmitting means for transmitting a command to a designated system server, and when the first determining means determines whether the command is an operation command for the system server to be confirmed, the transmitting means After receiving the confirmation input for sending the operation command to the confirmation required system server by the receiving means of 3, the operation command is specified It transmits to a system server.

  In order to achieve the above object, an information processing method of the present invention is an information processing method performed by an information processing apparatus that transmits operation commands to a plurality of system servers including a production environment server and a development environment server, A first accepting step for accepting a log-in request from the client device used by the user to the system server, a log-in step for performing the log-in process of the user in accordance with the connection request accepted in the first accepting step, and the log-in process. When the user enters a state of logging in to a plurality of system servers including the production environment server, the production environment server is set as a confirmation required system server that requires user confirmation to transmit an operation command. From the setting process and the client device used by the user, the system support A second accepting step for accepting an operation command for the server, a first determining step for judging whether the operation command accepted in the second accepting step is an operation command for the system server requiring confirmation, and the first accepting step A third receiving step of receiving a confirmation input as to whether or not to transmit the operation command to the system server from the client device used by the user after it is determined in the determination step that the operation command is for the system server requiring confirmation; And a transmission step of transmitting the operation command to the designated system server, wherein the transmission step is determined in the first determination step as to whether or not the operation command is for the system server requiring confirmation. After accepting the confirmation input for transmitting the operation command to the confirmation required system server in the third acceptance step, And transmitting the the manipulation command to the specified system server.

  In order to achieve the above object, a computer program according to the present invention provides an information processing apparatus that transmits an operation command to a plurality of system servers including a production environment server and a development environment server from a client apparatus used by a user to a system server. A first accepting unit that accepts a log-in request to the user, a log-in unit that performs a log-in process for the user in accordance with a connection request accepted by the first accepting unit, and the log-in process allows the user to configure the production environment server. A first setting means for setting the production environment server as a confirmation-required system server that requires user confirmation to transmit an operation command when logging in to a plurality of system servers, and the user uses Operation commands for the system server from the client device A second receiving means for receiving, a first determining means for determining whether or not the operation command received by the second receiving means is an operation command for the confirmation-required system server, and the first determining means; A third receiving means for receiving, from the client device used by the user, a confirmation input as to whether or not to transmit the operation command to the system server after determining whether the operation command is for the confirmation system server; Is transmitted to the designated system server. When the first determination unit determines whether the operation command is for the system server requiring confirmation, the third determination unit After accepting the confirmation input to send the operation command to the confirmation required system server by the accepting means, specify the operation command. And transmits to the system server that is.

  According to the present invention, even if a person in charge of system maintenance / operation logs in both the development environment and the production environment and performs server maintenance / operation work, the server to be operated is mistaken. It is possible to reduce the operation error that occurs.

It is a figure which shows an example of the system configuration | structure of the information processing system of this invention. It is a figure which shows an example of the hardware constitutions of the information processing apparatus applicable to each apparatus shown in FIG. It is a figure which shows an example of a function structure of each apparatus shown in FIG. It is a figure which shows an example of a connection request process. It is a figure which shows an example of the detailed process of a connection information confirmation process. It is a figure which shows an example of the detailed process of a connection approval process. It is a figure which shows an example of the detailed process of a connection process. It is a figure which shows an example of an operation command execution process. It is a figure which shows an example of a structure of a login screen. It is a figure which shows an example of a structure of an operation command input screen. It is a figure which shows an example of a structure of an operation command confirmation screen. It is a figure which shows an example of a data structure of a confirmation required operation command list. It is a figure which shows an example of a data structure of a system server information management table. It is a figure which shows an example of a data structure of a connection information management table.

  Hereinafter, an example of an embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 is a diagram illustrating an example of a system configuration of an information processing system according to the present invention. As shown in FIG. 1, the information processing system of the present invention comprises a connection management server 101, a client device 102, a production environment server 103, a development environment server 104, and a network 105 (from now on, the production environment server 103). The development environment server 104 is collectively referred to as “system server”).

  The connection management server 101 has terminal emulator software (server) installed therein, and the system server (the production environment server 103 and the development environment server 104) transmitted from the client device 102 according to the control of the terminal emulator software (server). A server device having a function of relaying an operation command to a system server. Also, which user is logged in to which server is managed.

  The client device 102 is a terminal device in which terminal emulator software (client) is installed. According to control by the terminal emulator software (client), user authentication information and a connection destination system server (production environment server 103, development environment server) 104) and a terminal device that receives input of various operation commands and transmits them to the connection management server 101. Used by an operator who maintains and operates the system server and an approver who approves / denies the login of the operator to the system server.

  The production environment server 103 is a server device that provides various services used in in-house operations, for example, a database server, a business application server, or the like. In accordance with the operation command transmitted from the connection management server 101, processing such as various setting changes is executed.

  The development environment server 104 is a server device that provides the same environment as the production environment server 103, which is a server device that provides various services used in in-house operations, for system development, system testing, and the like. In accordance with the operation command transmitted from the connection management server 101, processing such as various setting changes is executed.

  The network 105 is a network for connecting the above-described apparatuses so that they can communicate with each other. The connection form may be wired or wireless.

  The above is an example of the system configuration of the information processing system of the present invention.

  Next, an example of a hardware configuration of an information processing apparatus applicable to the connection management server 101, the client apparatus 102, the production environment server 103, and the development environment server 104 in FIG. 1 will be described with reference to FIG.

  In FIG. 2, reference numeral 201 denotes a CPU that comprehensively controls each device and controller connected to the system bus 204. The ROM 203 or the external memory 211 has a BIOS (Basic Input / Output System) or an operating system program (hereinafter referred to as OS), a connection management server 101, a client device 102, a production environment server 103, a development program, etc. Various programs to be described later necessary for realizing the functions executed by the environment server 104 are stored.

  A RAM 202 functions as a main memory, work area, and the like for the CPU 201. The CPU 201 implements various operations to be described later by loading a program or the like necessary for executing the processing from the ROM 203 or the external memory 211 to the RAM 202 and executing the loaded program.

  An input controller 205 controls input from an input device 209 such as a keyboard and a pointing device. A video controller 206 controls display on a display device such as the display device 210.

  A memory controller 207 is connected to the hard disk (HD), flexible disk (FD), or PCMCIA card slot for storing a boot program, various applications, font data, user files, editing files, various data, etc. via an adapter. The access to the external memory 211 such as a compact flash (registered trademark) memory is controlled.

  A communication I / F (interface) controller 208 connects and communicates with an external device via a network (for example, the network 105 shown in FIG. 1), and executes communication control processing in the network. For example, communication using TCP / IP is possible.

  Note that the CPU 201 enables display on the display device 210 by executing outline font rasterization processing on a display information area in the RAM 202, for example. Further, the CPU 201 enables a user instruction with a mouse cursor (not shown) on the display device 210.

  The processing of each step shown in the flowcharts to be described later for realizing the present invention is executed by a computer-readable program that is recorded in the external memory 211. Then, it is executed by the CPU 201 by being loaded into the RAM 202 as necessary. Furthermore, a definition file and various information tables used when executing the program are also stored in the external memory 211, and a detailed description thereof will be described later.

  The above is an example of the hardware configuration of the information processing apparatus applicable to the connection management server 101, the client apparatus 102, the production environment server 103, and the development environment server 104 in FIG.

  Next, an example of the functional configuration of the connection management server 101, the client device 102, the production environment server 103, and the development environment server 104 of FIG. 1 will be described with reference to FIG.

  As illustrated in FIG. 3, the connection management server 101 includes an authentication unit 301, a connection destination server designation reception unit 302, a connection approval necessity / unnecessity determination unit 303, a connection approval information reception unit 304, a connection information management unit 305, and an operation command reception unit. 306, an operation command confirmation necessity / unnecessity determination unit 307, an operation command transmission unit 308, and the like.

  The client device 102 includes an authentication information input reception unit 311, a connection destination server designation input reception unit 312, an operation command input reception unit 313, an operation command confirmation input reception unit 314, a connection approval information input reception unit 315, and the like. Yes.

  The production environment server 103 and the development environment server 104 are configured to include an operation execution instruction reception unit 321 and an operation execution unit 322, respectively.

  The authentication unit 301 of the connection management server 101 receives the authentication information (for example, user name and password) received by the authentication information input reception unit 311 of the client device 102 from the client device 102, and the authentication information and the authentication information (not shown). It is a functional unit that authenticates a user who is using the client apparatus 102 using user information stored in the user information table.

  The connection destination server designation receiving unit 302 of the connection management server 101 is a functional unit that receives the connection destination server designation information received by the connection destination server designation input receiving unit 312 of the client device 102 from the client device 102.

  The connection approval necessity / unnecessity determination unit 303 of the connection management server 101 is connected to a system server in which the user authenticated by the authentication unit 301 has received designation by the connection destination server designation acceptance unit 302. It is a functional unit that determines whether or not user approval is required.

  The connection approval information accepting unit 304 of the connection management server 101 is connected to a server of a user that is determined by the connection approval necessity / unnecessity determination unit 303 to be approved by another user in order to connect to the system server. This is a functional unit that receives approval information (approval or denial) from the client device 102 used by another user.

  The connection information management unit 305 of the connection management server 101 is a functional unit that stores and manages which user is connected to which system server (logged in) using the connection information management table 1400 shown in FIG.

  The operation command reception unit 306 of the connection management server 101 is a functional unit that receives from the client device 102 the operation command received by the operation command input reception unit 313 of the client device 102.

  The operation command confirmation necessity / unnecessity determination unit 307 of the connection management server 101 determines whether confirmation by the user is required before transmitting the operation command received by the operation command reception unit 306 to the designated system server. It is a functional part to do.

  The operation command transmission unit 308 of the connection management server 101 is a functional unit that transmits the operation command received from the client apparatus 102 by the operation command reception unit 306 to the designated system server.

  The authentication information input accepting unit 311 of the client device 102 is a functional unit that accepts input of authentication information (for example, a user name and password) used in user authentication performed when a system server operation is performed. The connection destination server designation input reception unit 312 of the client device 102 is a functional unit that receives designation of a system server that is a target of operation by the user.

  The operation command input receiving unit 313 of the client device 102 is a functional unit that receives an input of an operation command such as SQL for operating the system server, for example, for changing a database managed by the system server. .

  The operation command confirmation input receiving unit 314 of the client device 102 needs to be confirmed by the user before the operation command confirmation necessity / unnecessity determination unit 307 of the connection management server 101 transmits the operation command to the designated system server. It is a functional unit that receives input of confirmation input (transmission execution, transmission cancellation, etc.) for the operation command determined to be.

  The connection approval information input reception unit 315 of the client device 102 is the connection approval necessity / unnecessity determination unit 303 of the connection management server 101 and needs to be approved by another user such as an upper manager in order to connect to the system server. The determined user is an accepting unit that accepts approval or denial (approval information) of connection to the system server.

  The operation execution instruction receiving unit 321 of the production environment server 103 and the development environment server 104 is a functional unit that receives operation commands transmitted from the connection management server 101 as various operation execution instructions. The operation execution unit 322 is a functional unit that executes processing according to the operation command received by the operation execution instruction reception unit 321.

  The above is an example of the functional configuration of the connection management server 101, the client device 102, the production environment server 103, and the development environment server 104.

  Next, an example of the connection request process will be described with reference to FIG. This processing is performed by the CPU 201 of the connection management server 101 and the client device 102.

  First, the CPU 201 of the client apparatus 102 displays a login screen 900 shown in FIG. 9 (step S401), and receives input of authentication information used for user authentication and designation of a connection destination server via the login screen 900 (step S402). Step S403).

  Here, an example of the configuration of the login screen 900 displayed on the display device 210 of the client device 102 in step S401 of FIG. 4 will be described with reference to FIG.

  In the figure, a user ID input receiving unit 901 is a receiving unit that receives an input of a user name used as authentication information. The password input receiving unit 902 is a receiving unit that receives an input of a password used as authentication information. The connection destination server designation receiving unit 903 is a reception unit that receives designation of a system server as a connection destination. In the connection destination server designation receiving unit 903, a system server registered in the system server information management table shown in FIG.

  The connection button 904 is used to input a transmission execution instruction for transmitting a connection request for the production environment server 103 or the development environment server 104 designated by the connection destination server designation receiving unit 903 to the connection management server 101 to the CPU 201 of the client apparatus 102. Button used. A cancel button 905 is a button used to end the processing via this screen without making a connection request to the system server for the connection management server 101.

  The above is an example of the configuration of the login screen 900.

  Next, the data configuration of the system server information management table 1300 stored in the external memory 211 of the connection management server 101 will be described with reference to FIG. As shown in FIG. 13, the system server information management table 1300 includes data items such as a server identifier 1301, a server name 1302, and an environment type 1303.

  The server identifier 1301 is a data item in which identification information for uniquely identifying a server registered in the system server information management table 1300 is registered. The server name 1302 is a data item in which the server name is registered. Using this server name, it is possible to specify a communication partner and perform communication.

  The environment type 1303 is a data item in which information for specifying whether the system server is the production environment server 103 or the development environment server 104 is registered.

  The above is an example of the data configuration of the system server information management table 1300.

  Returning to the description of FIG. When the CPU 201 of the client device 102 receives the authentication information and the designation of the connection destination server and then accepts the press of the connection button 904 on the login screen 900, the CPU 201 sends a connection request to the designated system server to the connection management server 101. Transmit (step S404). This connection request includes authentication information and system server specific information (for example, a server identifier) designated as a connection destination.

  When the CPU 201 of the connection management server 101 receives the connection request to the system server transmitted from the client device 102 (step S405), authentication of the user who uses the client device 102 is performed using the authentication information included in the connection request. Processing is performed (step S406). If it is determined that authentication could not be performed normally (NO in “Authentication OK?” In step S406), the process proceeds to step S407, and an authentication error notification is transmitted to the client apparatus 102 that transmitted the connection request. To do.

  When receiving the authentication error notification transmitted from the connection management server 101 (step S408), the CPU 201 of the client apparatus 102 displays a warning to notify the user that an authentication error has occurred. Thereafter, when a retry instruction for re-establishing a connection request in a form in which the authentication information and the connection destination server are reset is received by an operation instruction from the user (YES in step S409), the process proceeds to step S402. On the other hand, if a retry instruction has not been received (that is, if an end instruction has been received: NO in step S409), the processing shown in FIG.

  If it is determined in step S406 that the user authentication has been performed normally (YES), the CPU 201 of the connection management server 101 advances the process to step S410, and the authenticated user has accepted the connection request. In order to connect to the system server, an approval necessity / unnecessity determination process for determining whether or not third-party approval is required is performed. Details of this processing will be described with reference to FIG.

  Here, the details of the approval necessity / unnecessity determination processing in step S410 of FIG. 4 will be described with reference to FIG. This processing is performed by the CPU 201 of the connection management server 101.

  The CPU 201 of the connection management server 101 acquires the connection information of the user authenticated in step S406 in FIG. 4 from the connection information management table 1400 shown in FIG. 14 (step S501).

  Here, an example of the data configuration of the connection information management table 1400 will be described with reference to FIG. The connection information management table 1400 is a data table for managing which users are connected (logged in) to the respective system servers.

  As shown in FIG. 14, the connection information management table 1400 has a data structure such as an ID 1401, a server identifier 1402, a server name 1403, a server name 1404, a login user name 1405, a confirmation flag 1406, and the like.

  The ID 1401 is a data item in which identification information for uniquely identifying each connection information registered in the connection information management table 1400 is registered.

  The server identifier 1402 is a data item in which the server identifier of the server to which the user is logged in is registered. The server name 1403 is a data item in which the server name is registered, and the environment identifier is a data item in which the environment identifier of the server is registered. These pieces of information are acquired from the system server information management table 1300 and registered.

  The login user 1405 is a data item in which user identification information (user ID and user name) of a user who has logged in to the system server specified by the server identifier registered in the server identifier 1402 is registered.

  In the confirmation flag 1406, information indicating whether or not a user confirmation is required before the operation command received from the client apparatus 102 by the connection management server 101 is transferred to the system server (production environment server 103) is registered. It is a data item. For example, when “ON” is set in this data item, confirmation is required, and when “OFF” is set, the CPU 201 of the connection management server 101 determines that confirmation is not required. .

  The above is an example of the data configuration of the connection information management table 1400.

  Returning to the description of FIG. After acquiring the connection information of the authenticated user in step S501, the connection management server 101 determines whether or not the system server (connection destination) that has received this connection request is the production environment server 103 (step S502). ). If it is determined YES in this determination process, the process proceeds to step S503, and it is determined whether or not the user is already connected to another system server.

  If it is determined YES in the determination process of step S503, the CPU 201 of the connection management server 101 advances the process to step S504 and determines that approval is required for connection to the system server. On the other hand, if it is determined NO in the determination process of step S503, the CPU 201 of the connection management server 101 proceeds with the process to step S505 and determines that no approval is required.

  If it is determined NO in the determination process in step S502, the connection management server 101 advances the process to step S506 to determine whether the user is currently connected to the production environment server 103 (logged in).

  If the determination process in step S506 determines YES, the CPU 201 of the connection management server 101 advances the process to step S507, and determines that approval is required for connection to the system server. On the other hand, if it is determined NO in the determination process in step S506, the CPU 201 of the connection management server 101 advances the process to step S508 and determines that no approval is required.

  The above is the detailed description of the approval necessity / unnecessity determination processing. In the present invention, when a user connects to the production environment server 103 and logs in to another system server (production environment server 103, development environment server 104), the system server to be operated is erroneously specified. In order to prevent an erroneous operation on the production environment server 103 caused by this, an approval process by another user is performed so that the user cannot easily log in to the production environment server.

  In addition, if the user logs in to the production environment server 103 and logs in to another system server (the production environment server 103 or the development environment server 104), there is a risk that the same error as described above may occur. In this case as well, the approval process is performed so that the user cannot easily log in to the production environment server.

  Returning to the description of FIG. After the approval necessity / unnecessity determination processing in step S410 is completed, the CPU 201 of the connection management server 101 determines that the user needs to be approved in order to log in to the system server designated as the connection destination, or the approval is made. It is determined whether it is determined that it is unnecessary (step S411). If it is determined in this determination process that approval is required (YES), the process proceeds to step S412 to perform a connection approval process. Details of this processing will be described with reference to FIG. On the other hand, if it is determined in the determination process in step S411 that no approval is required (NO), the process proceeds to step S417, and a connection process is performed. Details of this processing will be described with reference to FIG.

  Here, with reference to FIG. 6, the details of the connection approval process in step S412 of FIG. 4 will be described. This process is performed by the CPU 201 of the connection management server 101 and the CPU 201 of the client apparatus 102. In this connection approval process, a process in which a user who has made a connection request to a system server accepts an instruction to approve / deny login to the system server from a user other than the user (for example, a user's superior). I do.

  First, the CPU 201 of the connection management server 101 uses a user information table (not shown) to identify a user who makes a login approval to the system server of a user who has made a connection request to the system server (step S601). Then, an approval processing request is transmitted to the client device 102 used by the approver. For example, a method such as sending an approval processing request e-mail to the approver's e-mail address may be used.

  The CPU 201 of the client device 102 used by the approver receives an approval processing request from the connection management server 101 (step S603) and then inputs an operation instruction using the input device 209 by the approver to the user's system server. An input of log-in approval or denial information is accepted (step S604). Then, the input approval or denial information is transmitted to the connection management server 101 (step S605). Then, the CPU 201 of the connection management server 101 acquires the approval / denial information transmitted from the client device 102 (step S606).

  The above is the detailed description of the connection approval process. In this approval process, if YES is determined in the determination process in step S411 in FIG. 4, the authentication information of the approver and the approval / rejection information are displayed on the display device 210 of the client apparatus 102 that has made the connection request. A screen for inputting denial may be displayed, and the authentication information of the approver and the approval / denial information may be received via the screen.

  Returning to the description of FIG. The CPU 201 of the connection management server 101 determines whether the connection (login) of the user to the system server has been approved after the connection approval process in step S412 is completed (step S413).

  If it is determined in step S413 that the connection has not been approved (NO), the CPU 201 of the connection management server 101 advances the process to step S414, and notifies the connection error notification that the connection has not been approved. The connection request is transmitted to the client apparatus 102 that has transmitted the connection request.

  When receiving the connection error notification transmitted from the connection management server 101 (step S415), the CPU 201 of the client device 102 displays a warning on the display device 210. After that, when a retry instruction for re-establishing a connection request is received in response to an operation instruction from the user (YES in step S416), the process proceeds to step S402. On the other hand, if a retry instruction has not been received (that is, if an end instruction has been received: NO in step S416), the processing shown in FIG.

  If it is determined in the determination process in step S413 that the connection has been approved (YES), the CPU 201 of the connection management server 101 advances the process to step S417 to perform the connection process.

  Here, with reference to FIG. 7, the details of the connection processing in step S417 of FIG. 4 will be described. This process is performed by the CPU 201 of the connection management server 101 and the CPU 201 of the system server.

  First, the CPU 201 of the connection management server 101 acquires identification information of the connection destination system server included in the connection request received from the client apparatus 102 in step S405 of FIG. 4 (step S701), and specifies the connection destination system server. (Step S702). Thereafter, a connection request is transmitted to the identified connection destination system server (step S703).

  When the CPU 201 of the system server (the production environment server 103 or the development environment server 104) receives the connection request transmitted from the connection management server 101 (step S704), an operation command is transmitted between the connection management server 101 and the system server. A connection process for enabling transmission / reception is performed (step S705), and the result of the connection process is transmitted to the connection management server 101 (step S706). Then, the CPU 201 of the connection management server 101 receives the connection processing result transmitted from the system server (step S707).

  Note that the CPU 201 of the connection management server 101 determines that the connection process has failed if the connection request is not received from the system server for a certain period of time after the connection request is transmitted in step S703. Become.

  The above is the detailed description of the connection process.

  Returning to the description of FIG. After the connection process in step S417 is completed, the CPU 201 of the connection management server 101 determines whether the connection with the system server that has received the connection request is successful (step S418). If it is determined in this determination process that the connection has failed (NO), a connection notification error is transmitted to the client apparatus 102 that has made the connection request (step S419).

  When receiving the connection error notification transmitted from the connection management server 101 (step S415), the CPU 201 of the client device 102 displays a warning on the display device 210. Thereafter, when a retry instruction is accepted by an operation instruction from the user (YES in step S416), the process proceeds to step S402. On the other hand, when the retry instruction has not been received (that is, when the end instruction has been received: NO in step S416), the processing shown in FIG.

  If it is determined in step S417 that the connection process is successful (YES), the CPU 201 of the connection management server 101 advances the process to step S420 to newly register connection information in the connection information management table 1400. To do. In this connection information, information on the system server designated as the connection destination and information on the user specified by the authentication process are registered.

  Thereafter, the CPU 201 of the connection management server 101 determines whether or not an approval process has been performed when the user is connected to the system server (step S421). If it is determined in this determination process that the approval process has been performed, the CPU 201 of the connection management server 101 advances the process to step S422, and includes the connection information related to the user registered in the connection information management table 1400. Then, the confirmation flag 1406 for the connection information to the production environment server 103 is set to ON.

  The CPU 201 of the connection management server 101 determines YES in step S 421 when the user is connected (logged in) to a plurality of system servers including the production environment server 103. The CPU 201 of the connection management server 101 sets the connection information confirmation flag 1406 of the user to the production environment server 103 to ON so that the operation command execution process (FIG. 8) described later can access the production environment server 103. When an operation command is received from the client device 102, it is not immediately transferred to the production environment server 103, but once the user confirms whether the operation command has been correctly input. As a result, it is possible to suitably prevent an erroneous operation due to an erroneous selection of the system server (operation screen selection error) as the operation command transmission destination.

  If the CPU 201 of the connection management server 101 determines NO in step S421, or after the processing of step S422 ends, the CPU 201 transmits a connection success notification to the client device 102 that has made the connection request (step S423). When receiving the connection success notification from the connection management server 101 (step S424), the CPU 201 of the client apparatus 102 continues to execute the operation command execution process shown in FIG.

  The above is an example of the connection request process.

  Next, an example of the operation command execution process will be described with reference to FIG. This process is performed by the CPU 201 of the connection management server 101, the client apparatus 102, and the CPU 201 of the system server (the production environment server 103 and the development environment server 104).

  After the process of step S424 in FIG. 4 is completed, the CPU 201 of the client apparatus 102 displays the operation command input screen 1000 shown in FIG. 10 on the display apparatus 210, which is used to transmit various operation commands to the newly connected system server. It is displayed (step S801). When connected to a plurality of system servers, an operation command input screen 900 is displayed for each system server. That is, a plurality of operation command input screens are displayed.

  Here, an example of the configuration of the operation command input screen 1000 displayed on the display apparatus 210 of the client apparatus 102 in step S801 of FIG. 8 will be described with reference to FIG. The operation command input screen 1000 is a screen for inputting various operation commands for the database managed by the system server.

  As shown in FIG. 10, the operation command input screen 1000 includes a database designation unit 1001, an operation command input unit 1002, an execution button 1003, a clear button 1004, an execution result display unit 1005, an end button 1006, and the like. .

  The database specifying unit 1001 is a specifying unit for specifying a database to be operated. The operation command input unit 1002 is an input unit that receives an input of an operation command for the database specified by the database specifying unit 1001.

  The execution button 1003 is a button used for transmitting a process execution request based on the operation command input to the operation command input unit 1002 to the system server via the connection management server 101. When receiving an instruction to press the execution button, the CPU 201 of the client apparatus 102 transmits the input operation command to the connection management server 101. The clear button 1004 is a button used to delete an operation command input to the operation command input unit 1002.

  The execution result display unit 1005 is a display unit that displays a result of processing performed by the system server in accordance with the operation command input to the operation command input unit 1002. For example, when processing based on a database search operation command is performed by the system server, a list of data hit as a result of the search processing is displayed. Further, when processing based on an operation command for updating a record in the database is performed, information on the record after the update is displayed. When the process based on the delete command is performed, information indicating whether or not the delete process is successful is displayed.

  An end button 1006 is a button used to end the display of the operation command input screen. When receiving an instruction to press the end button 1006, the CPU 201 of the client apparatus 102 transmits an operation command for instructing disconnection from the system server to the connection management server 101. The above is an example of the configuration of the operation command input screen 1000.

  Returning to the description of FIG. After the operation command input screen 1000 is displayed in step S801, input of an operation command is accepted via the operation command input screen 1000 (step S802).

  If it is determined that an execution instruction input by receiving a press instruction to the execution button 1003 on the operation command input screen 1000 after receiving an operation command input (YES in step S803), the operation command input unit 1002 The operation command input to is transmitted to the connection management server 101 (step S804). At this time, a server identifier indicating which system server is the operation instruction is also transmitted. When an instruction to press the end button 1006 on the operation command input screen 1000 is received, the CPU 201 of the client apparatus 102 transmits an instruction to disconnect from the connected system server to the connection management server 101.

  When the CPU 201 of the connection management server 101 receives the operation command transmitted from the client device 102 (step S805), the user using the client device 102 registered in the connection information management table 1400, the operation command It is confirmed whether or not the connection information confirmation flag 1406 for managing the connection with the transmission destination system server is set to ON (step S806).

  If it is determined in step S806 that the confirmation flag is ON (YES), the CPU 201 of the connection management server 101 advances the process to step S807, and the operation command received in step S805 is shown in FIG. It is determined whether the operation command is registered in the required operation command list 1200 shown. In the operation command list to be confirmed 1200, operation commands that allow the user to reconfirm whether transfer is possible before transferring the operation command to the system server are registered. For example, registration is performed based on an operation instruction from a system administrator or the like. For example, an operation command for changing (updating, deleting, adding, etc.) the contents (data or table) of the database is registered in the confirmation operation command list 1200 required.

  If it is determined in step S807 that the operation command received in step S805 is included in the confirmation-necessary operation command list 1200 (YES), the CPU 201 of the connection management server 101 proceeds to step S808. If it is determined that it is not included in the operation command list (NO), the process proceeds to step S814.

  In step S808, the CPU 201 of the connection management server 101 transmits an operation command confirmation request to the client apparatus 102 that has transmitted the operation command. When the CPU 201 of the client apparatus 102 receives the operation command confirmation request transmitted from the connection management server 101 (step S809), the operation command confirmation screen 1100 shown in FIG. 11 is displayed on the display device 210, and the operation command is displayed on the screen. Is displayed (step S810).

  Here, an example of the configuration of the operation command confirmation screen 1100 displayed on the display device of the client device 102 will be described with reference to FIG. As shown in FIG. 11, the operation command confirmation screen 1100 includes a connection destination server display unit 1101, a connection destination server environment type display unit 1102, an operation target database display unit 1103, an operation command display unit 1104, a content confirmation check box 1105, and a Yes button. 1106, a No button 1107, and the like.

  The connection destination server display unit 1101 is a display unit that displays a system server that is a transmission destination of an operation command. The connection destination server environment type display unit 1102 is a display unit that displays the environment type (production environment server 103 / development environment server 104) of the system server that is the transmission destination of the operation command. The operation target database display unit 1103 is a display unit that displays a database to be operated by an operation command.

  The operation command display unit 1104 is a display unit that displays an operation command transmitted from the client apparatus 102 to the connection management server 101.

  A confirmation check box 1105 is a check box for receiving an instruction that the user has confirmed the contents of the display item. The Yes button 1106 is a button used to transmit an instruction to transfer the operation command displayed on this screen to the designated system server to the connection management server 101. The Yes button 1106 can be pressed only when all the confirmation check boxes 1105 are checked.

  A No button 1107 is a button used to input an operation command discard instruction to the connection management server 101. When this button is pressed, the CPU 201 of the client apparatus 102 transmits an instruction to discard the operation command displayed on the operation command confirmation screen 1100 to the connection management server 101.

  The above is an example of the configuration of the operation command confirmation screen 1100.

  Returning to the description of FIG. If it is determined that the operation command transfer instruction input by pressing the Yes button 1106 in the operation command confirmation screen 1100 is pressed after displaying the operation command confirmation screen 1100 in step S810 (YES in step S811), the client device The CPU 201 proceeds to step S812, and transmits an operation command transfer instruction to the connection management server 101. When the CPU 201 of the connection management server 101 receives an operation command transfer instruction from the client device 102 (step S813), the process proceeds to step S814.

  On the other hand, when it is determined that an operation command discard instruction input by pressing the No button 1107 has been received (NO in step S811), the CPU 201 of the client apparatus 102 performs an operation command discard instruction in a step (not shown). Is transmitted to the connection management server 101, and the process proceeds to step S802. The CPU 201 of the connection management server 101 that has received the operation command discard instruction from the client device 102 discards the designated operation command without transferring it to the system server.

  If NO is determined in the determination process of step S806, NO is determined in step S807, or after the process of step S813 is completed, the CPU 201 of the connection management server 101 advances the process to step S814, and the operation command received from the client apparatus 102 in step S805 Is sent to the specified system server.

  When receiving the operation command transmitted from the connection management server 101 (step S815), the CPU 201 of the system server executes processing according to the received operation command (step S816) and transmits the processing result to the connection management server 101. (Step S817). The CPU 201 of the connection management server 101 receives the processing result transmitted from the system server (step S818).

  After the process of step S818 is completed, the CPU 201 of the connection management server 101 determines whether the process executed by the system server is a disconnection process (step S819). If the determination process determines YES, the disconnection process is performed. The connection information managing the connection disconnected by the processing is specified, and the connection information is deleted from the connection information management table 1400 (step S819).

  If NO is determined in step S818 or after the process of step S819 is completed, the CPU 201 of the connection management server 101 advances the process to step S820, and transmits the processing result acquired from the system server to the client apparatus 102. The CPU 201 of the client apparatus 102 receives the processing result transmitted from the connection management server 101 (step S822).

  After the process of step S822 is completed, the CPU 201 of the client apparatus 102 determines whether or not to continue the operation command execution process (step S823). When the end button 1006 of the operation command input screen 1000 is pressed and the processing result of the operation command for the disconnection instruction with the system server transmitted to the connection management server 101 is received in step S822, the CPU 201 of the client apparatus 102 Is determined as YES in this determination step. If it is determined YES in this determination process, the process illustrated in FIG. On the other hand, if it is determined as NO, the CPU 201 of the client apparatus 102 advances the process to step S802 and repeatedly executes the subsequent processes.

  The above is the description of the operation command execution process.

  As described above, in the present invention, when the same user can operate both the production environment server 103 and the development environment server 104, before sending a specific operation command to the production environment server 103, Ask for user confirmation. Thereby, it is possible to increase the possibility of finding an operation command input error by the user.

  As a result, it is possible to suitably prevent the server from being erroneously operated due to an error in the designation of the system server that is the transmission destination of the operation command.

  Further, in the present invention, even when the user operates a plurality of client devices 102 to operate different system servers, the connection management server 101 connects any user to any system server. Is manageable. Therefore, for example, in order to operate a plurality of system servers, a user operates a plurality of different client devices 102, and the client devices 102 share the display device 210 and the input device 209. Even when the operation is performed in an operation environment in which an operation error is likely to occur, it is possible to suitably prevent an erroneous operation of the server due to a user operation error.

  Although the embodiment has been described in detail above, the present invention can take an embodiment as a method, a program, a recording medium, or the like.

  The program according to the present invention is a program that allows a computer to execute (read) each processing method, and the recording medium according to the present invention stores a program that allows the computer to execute each processing method. The program in the present invention may be a program for each processing method of each device.

  As described above, a recording medium that records a program that implements the functions of the above-described embodiments is supplied to a system or apparatus, and a computer (or CPU or MPU) of the system or apparatus stores the program stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by performing reading.

  In this case, the program itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program constitutes the present invention.

  As a recording medium for supplying the program, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, silicon A disk or the like can be used.

  Further, by executing the program read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) operating on the computer based on an instruction of the program is actually It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the processing and the processing is included.

  Furthermore, after the program read from the recording medium is written in a memory provided in a function expansion board inserted into the computer or a function expansion unit connected to the computer, the function expansion board or It goes without saying that the CPU or the like provided in the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading a recording medium storing a program for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

  Furthermore, by downloading and reading a program for achieving the present invention from a server, database, etc. on a network by a communication program, the system or apparatus can enjoy the effects of the present invention.

  In addition, all the structures which combined each embodiment mentioned above and its modification are also included in this invention.

101 Connection Management Server 102 Client Device 103 Production Environment Server 104 Development Environment Server 105 Network 201 CPU
202 RAM
203 ROM
204 System Bus 205 Input Controller 206 Video Controller 207 Memory Controller 208 Communication Interface (I / F) Controller 209 Input Device 210 Display Device 211 External Memory

Claims (6)

An information processing apparatus that transmits operation commands to a plurality of system servers including a production environment server and a development environment server,
First accepting means for accepting a login request to the system server from a client device used by a user;
Login means for performing login processing of the user in accordance with the connection request received by the first receiving means;
When the login process causes the user to log in to a plurality of system servers including the production environment server, the production environment server is set as a confirmation system server requiring confirmation for transmitting an operation command. First setting means to:
Second receiving means for receiving an operation command for the system server from a client device used by the user;
First determination means for determining whether the operation command received by the second reception means is an operation command for a system server requiring confirmation;
After the first determination means determines whether the operation command is for the system server requiring confirmation, a confirmation input indicating whether to transmit the operation command to the system server is received from the client device used by the user. 3 acceptance means;
Transmitting means for transmitting the operation command to a designated system server;
With
The transmission means confirms that the third receiving means transmits an operation command to the confirmation required system server when the first determination means determines whether the operation command is for the confirmation required system server. After receiving an input, the information processing apparatus transmits the operation command to a designated system server. Second setting means for setting an operation command that requires transmission confirmation by the user as a confirmation-needed operation command before transmission to the confirmation-required system server;
A second determination unit that determines whether the operation command for the confirmation-required system server includes the confirmation-operation command set by the second setting unit;
The third accepting unit further determines whether or not to transmit the operation command to the system server when the second determining unit determines that the operation command requiring confirmation is included in the operation command for the system server requiring confirmation. The information processing apparatus according to claim 1, wherein a confirmation input is received from the client device based on the number of user usage. The information processing apparatus according to claim 2, wherein the confirmation required operation command is an operation command for changing contents of a database. Third determination means for determining whether the user is to be logged in to a plurality of system servers including the production environment server by performing login processing in response to the connection request received by the first reception means. When,
When it is determined by the third determination means that the user is to be logged in to a plurality of system servers including the production environment server, the login process of the user is performed for an authorized user different from the user. A request means for requesting approval, and
4. The information processing according to claim 1, wherein the login unit performs login processing of the user after the approved user has approved login of the user to the system server. 5. apparatus. An information processing method performed by an information processing apparatus that transmits operation commands to a plurality of system servers including a production environment server and a development environment server,
A first accepting step for accepting a login request to the system server from a client device used by the user;
In accordance with the connection request received in the first reception step, a login step for performing login processing of the user;
When the login process causes the user to log in to a plurality of system servers including the production environment server, the production environment server is set as a confirmation system server requiring confirmation for transmitting an operation command. A first setting step,
A second receiving step of receiving an operation command for the system server from a client device used by the user;
A first determination step of determining whether the operation command received in the second reception step is an operation command for the system server to be confirmed;
In the first determination step, after it is determined whether the operation command is for the confirmation-required system server, a confirmation input as to whether to transmit the operation command to the system server is received from the client device used by the user. 3 acceptance processes,
A transmission step of transmitting the operation command to a designated system server;
With
In the transmission step, when it is determined in the first determination step whether the operation command is for the confirmation-required system server, the confirmation for transmitting the operation command to the confirmation-required system server in the third reception step An information processing method characterized by transmitting the operation command to a designated system server after receiving an input. An information processing apparatus that transmits operation commands to a plurality of system servers including a production environment server and a development environment server.
First accepting means for accepting a login request to the system server from a client device used by a user;
Login means for performing login processing of the user in accordance with the connection request received by the first receiving means;
When the login process causes the user to log in to a plurality of system servers including the production environment server, the production environment server is set as a confirmation system server requiring confirmation for transmitting an operation command. First setting means to:
Second receiving means for receiving an operation command for the system server from a client device used by the user;
First determination means for determining whether the operation command received by the second reception means is an operation command for a system server requiring confirmation;
After the first determination means determines whether the operation command is for the system server requiring confirmation, a confirmation input indicating whether to transmit the operation command to the system server is received from the client device used by the user. 3 acceptance means;
Function as a transmission means for transmitting the operation command to a designated system server;
The transmission means confirms that the third receiving means transmits an operation command to the confirmation required system server when the first determination means determines whether the operation command is for the confirmation required system server. A computer program characterized by transmitting an operation command to a designated system server after receiving an input.

Images