JP4810113B2 - Database tuning apparatus, database tuning method, and program - Google Patents

Description

  The present invention relates to a database access tuning technique, and more particularly to a tuning technique for monitoring database access in service units and tuning database access based on the monitoring result.

  Conventionally, in a database system, database access is monitored, and database access is tuned based on the monitoring result.

  Conventional technologies of this type include, for example, a relational database, an execution unit that enables data access using SQL (Structured Query Language), a monitoring unit that monitors the operation status of the relational database, and a monitoring result by the monitoring unit. Controls the statistical information section to store as statistical information, the source code of the program using SQL, the compiler that converts the source code into an executable program, the script that includes the index that defines the relational database, and the operation of the relational database Evaluation to evaluate the statistical information stored in the statistical information section using the evaluation database, and rewrite at least one of the source code, script and parameters for improvement based on the evaluation result The one with the part Are (e.g., see Patent Document 1).

  In addition, as a monitoring technology for database access, the time until an inquiry is received from the client to the database server, the processing time at the database server, the disk I / O time, and the time until the result arrives from the database server to the client is monitored for each SQL statement. The technique to do is also known conventionally (for example, refer patent document 2).

In addition, a technique for calculating a processing time for each service is known, although it is not a monitoring and tuning technique for a database (see, for example, Patent Document 3).
JP 2002-366402 A JP 2004-5085 A JP-A-6-243097

  As described above, since the conventional techniques described in Patent Documents 1 and 2 perform monitoring and tuning in SQL statement units (database access units), it takes time to narrow down tuning points. In addition, there is a problem that the tuning work may adversely affect many services.

  For example, if there is an SQL statement that is used only in a service that does not require high-speed processing, it is not necessary to tune (change) the SQL statement even if processing of the SQL statement takes time. However, when monitoring is performed in units of SQL statements, the administrator or the like manually investigates what services are available as services that use the SQL statements, and those services require high-speed processing. If it is not checked whether the service is a service that is being performed, it is not possible to determine whether or not tuning is necessary for the above-mentioned SQL statement.

  Contrary to the above example, if there is an SQL statement that is used only in a service that requires high-speed processing, if it takes time to process the SQL statement, immediately change the SQL statement. It becomes necessary to tune. However, in this case as well, it is difficult for a manager or the like to manually perform tuning work because it is necessary to determine whether tuning is necessary.

  Also, for example, if there is an SQL statement that is used by both the service x for which high-speed processing is requested and the service y for which high-speed processing is not requested, it will take time to process the SQL statement. If so, it is necessary to tune the SQL statement. However, in this case as well, it is difficult for a manager or the like to determine whether or not tuning is necessary manually, so that quick tuning work is difficult. Further, at the time of tuning the SQL statement, high speed processing is required even if it is unavoidable to have some adverse effect on the service x for which high speed processing is required (for example, the service x cannot be used). There is also a problem that there is a possibility of adversely affecting the service y that is not present.

(Object of invention)
Accordingly, an object of the present invention is to enable monitoring and tuning for database access in units of services.

The first database tuning apparatus according to the present invention is:
A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the component control is associated with the component name of the component and the service name. When a change SQL statement is stored in the information storage unit, database access is performed according to the change SQL statement, and the statistical information storage unit is specified by a session ID with the user terminal and the service name. The modified SQL statement, its processing time, and the component name are added as statistical information, and if the modified SQL statement is not stored, the database is accessed according to the SQL statement in the component and the statistical information storage unit , The session ID and the service Characterized by comprising the SQL statement as the statistical information specified and a database access unit for adding the processing time and the component name by.

The second database tuning apparatus according to the present invention is:
A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the SQL statement included in the component, the component name of the component, the user A database access request including a session ID for identifying a session with a terminal and a service name in the processing request is output, and statistical information including session information including the session ID and the service name is stored in the statistical information storage unit A component execution control unit to store;
When a database access request is output from the component execution control unit, if a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit, according to the change SQL statement In addition to performing database access, the statistical information whose session information matches the session ID and service name in the database access request in the statistical information stored in the statistical information storage unit is changed to the changed SQL statement and its processing If the time and the component name included in the database access request are added, and the change SQL statement corresponding to the SQL statement included in the database access request is not stored in the component control information storage unit, Follow the SQL statement In addition to performing base access, the statistical information in which the session information matches the session ID and the service name in the database access request in the statistical information stored in the statistical information storage unit is included in the SQL statement and the processing time. And a database access control unit for adding a component name included in the database access request.

The third database tuning apparatus according to the present invention is:
Component control information in which component information including a component name for identifying a component is stored in association with service information including a service name, which is component information of each of a plurality of components constituting the service identified by the service name. A storage unit;
Monitoring / adding the changed SQL statement to the corresponding component information in the component information stored in the component control information storage unit according to the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change A tuning control unit;
A statistical information storage unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed with reference to the component control information storage unit, and an SQL statement included in the component is executed. A database access request including a component name of the component, a session ID for specifying a session with the user terminal, and a service name in the processing request, and includes session information including the session ID and the service name. A component execution control unit for storing statistical information in the statistical information storage unit,
When a database access request is output from the component execution control unit, a change SQL statement is included in the component information specified by the database access request among the component information stored in the component control information storage unit If the database information is accessed according to the changed SQL statement, the statistical information in the statistical information stored in the statistical information storage unit matches the session ID and service name in the database access request. The change SQL statement, its processing time, and the name of the component in the database access request are added, and if the change SQL statement is not included, the database is accessed according to the SQL statement included in the database access request. When Among the statistical information stored in the statistical information storage unit, the SQL statement, its processing time, and the database access request are added to the statistical information whose session information matches the session ID and service name in the database access request. And a database access control unit for adding a component name therein.

The fourth database tuning apparatus according to the present invention is:
A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name is stored in the statistical information storage unit For each component in which the SQL statement is changed for each component constituting the service specified by the service name, the corresponding changed SQL statement stored in the component control information storage unit is executed. A database access request that includes a component name of the component, a session ID that identifies a session with the user terminal, and a service name in the processing request, and for the SQL statement that has not been changed, the SQL statement , Component of the component Name, and component execution control unit that performs processing for outputting a database access request including the service name in the session ID and the processing request,
When a database access request is output from the component execution control unit, the database is accessed according to the SQL statement or the modified SQL statement included in the database access request, and the statistical information stored in the statistical information storage unit A database access control unit for adding the SQL statement or the change SQL statement, its processing time, and the component name in the database access request to statistical information whose session information matches the session ID and service name in the database access request It is characterized by comprising.

The fifth database tuning apparatus according to the present invention is:
Component control information in which component information including a component name for identifying a component is stored in association with service information including a service name, which is component information of each of a plurality of components constituting the service identified by the service name. A storage unit;
Monitoring / adding the changed SQL statement to the corresponding component information in the component information stored in the component control information storage unit according to the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change A tuning control unit;
A statistical information storage unit;
When a processing request including a service name is input from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name is stored in the statistical information storage unit When each component constituting the service specified by the service name is executed with reference to the component control information storage unit, and the component information corresponding to the component includes a change SQL statement Outputs a database access request including the change SQL statement, the component name of the component, the session ID, and the service name in the processing request, and if the change SQL statement is not included in the component information, the component SQL statement included in the above-mentioned component Cement component name, and component execution control unit for outputting a database access request including the service name in the session ID and the processing request,
When a database access request is output from the component execution control unit, the database is accessed according to the SQL statement or the modified SQL statement included in the database access request, and the statistical information stored in the statistical information storage unit A database in which the SQL statement or the change SQL statement, its processing time, and the component name in the database access request are added to statistical information whose session information matches the session ID and service name in the database access request And an access control unit.

A sixth database tuning apparatus according to the present invention is:
A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the SQL statement included in the component, the component name of the component, the user A database access request including a session ID for identifying a session with a terminal and a service name in the processing request is output, and statistical information including session information including the session ID and the service name is stored in the statistical information storage unit A component execution control unit to store;
When a database access request is output from the component execution control unit, if a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit, according to the change SQL statement A database access control unit that performs database access and performs a database access according to the SQL statement when a change SQL statement corresponding to the SQL statement included in the database access request is not stored in the component control information storage unit; And comprising
In addition, the component executed by the component execution control unit is stored in the statistical information storage unit when a change SQL statement for the SQL statement included in the component is stored in the component control information storage unit. Among the statistical information, the modified SQL statement, its processing time, and the component name of its own component are added to the statistical information whose session information matches the session ID and service name in the database access request, and included in the own component If a change SQL statement for the SQL statement being stored is not stored in the component control information storage unit, the session information in the statistical information stored in the statistical information storage unit is the session for which the database access request is being made Statistics that match the ID and service name The distribution is characterized by having a structure of adding the SQL statement, the component name of the processing time and the own components.

A seventh database tuning apparatus according to the present invention is the third or fifth database tuning apparatus,
Each service information stored in the component control information storage unit includes a service threshold value indicating an allowable processing time of a service specified by the service information,
Services in which the monitoring / tuning control unit corresponds to the processing time based on the statistical information stored in the statistical information storage unit and the service threshold value for each service stored in the component control information storage unit It has the structure which detects generation | occurrence | production of the service exceeding a threshold value.

An eighth database tuning apparatus according to the present invention is the seventh database tuning apparatus,
When the monitoring / tuning control unit detects the occurrence of a service whose processing time exceeds a corresponding service threshold, the monitoring / tuning control unit includes an event processing unit that notifies an external device of the occurrence of the service

A first database tuning method according to the present invention includes:
When the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change is input, the monitoring / tuning control unit associates the change SQL with the service name and the component name in the component control information storage unit. Store statements,
When a processing request including a service name is input from the user terminal, the database access unit executes each component constituting the service specified by the service name, and corresponds to the component name of the component and the service name In addition, when a change SQL statement is stored in the component control information storage unit, database access is performed according to the change SQL statement, and a session ID with the user terminal and the user terminal are stored in the statistical information storage unit. The changed SQL statement, its processing time and the component name are added as statistical information specified by the service name. When the changed SQL statement is not stored, the database is accessed according to the SQL statement in the component, and The statistical information storage unit Deployment ID and the SQL statement as the statistical information specified by the service name, and wherein adding the processing time and the component name.

The second database tuning method according to the present invention includes:
When the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change is input, the monitoring / tuning control unit associates the change SQL with the service name and the component name in the component control information storage unit. Store statements,
When a processing request including a service name is input from a user terminal, the component execution control unit executes each component constituting the service specified by the service name, and includes an SQL statement included in the component, Outputs a database access request including a component name, a session ID for specifying a session with the user terminal, and a service name in the processing request, and statistical information including session information including the session ID and the service name. Store in the statistical information storage,
When the database access control unit outputs a database access request from the component execution control unit, a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit. The database is accessed according to the changed SQL statement, and the statistical information in the statistical information stored in the statistical information storage unit matches the session ID and service name in the database access request. A change SQL statement, its processing time, and a component name included in the database access request are added, and a change SQL statement corresponding to the SQL statement included in the database access request is stored in the component control information storage unit Not If the database information is accessed according to the SQL statement, and the statistical information stored in the statistical information storage unit, the session information matches the session ID and service name in the database access request, The SQL statement, its processing time, and the component name included in the database access request are added.

A third database tuning method according to the present invention includes:
When the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change is input, the monitoring / tuning control unit associates the change SQL with the service name and the component name in the component control information storage unit. Store statements,
When the component execution control unit receives a processing request including a service name from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name In addition to performing processing to be stored in the information storage unit, each component constituting the service specified by the service name is executed, and components whose SQL statements have been changed are stored in the component control information storage unit For a component for which a database access request including a corresponding change SQL statement, a component name of the component, a session ID for specifying a session with the user terminal, and a service name in the processing request is output, and the SQL statement is not changed Is the SQL statement, Component name component, performs a process of outputting a database access request including the service name in the session ID and the processing request,
When the database access control unit outputs a database access request from the component execution control unit, the database access control unit accesses the database according to the SQL statement or the modified SQL statement included in the database access request and stores it in the statistical information storage unit Among the statistical information, the SQL statement or the modified SQL statement, the processing time and the component name in the database access request are added to the statistical information whose session information matches the session ID and service name in the database access request. It is characterized by adding.

The first program according to the present invention is:
A computer including a component control information storage unit and a statistical information storage unit
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit Tuning control unit,
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the component control is associated with the component name of the component and the service name. When a change SQL statement is stored in the information storage unit, database access is performed according to the change SQL statement, and the statistical information storage unit is specified by a session ID with the user terminal and the service name. The modified SQL statement, its processing time, and the component name are added as statistical information, and if the modified SQL statement is not stored, the database is accessed according to the SQL statement in the component and the statistical information storage unit , The session ID and the service The SQL statement as statistical information specified by, to function as a database access unit for adding the processing time and the component name.

The second program according to the present invention is:
A computer including a component control information storage unit and a statistical information storage unit
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit Tuning control unit,
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the SQL statement included in the component, the component name of the component, the user A database access request including a session ID for identifying a session with a terminal and a service name in the processing request is output, and statistical information including session information including the session ID and the service name is stored in the statistical information storage unit Component execution control unit to store,
When a database access request is output from the component execution control unit, if a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit, according to the change SQL statement In addition to performing database access, the statistical information whose session information matches the session ID and service name in the database access request in the statistical information stored in the statistical information storage unit is changed to the changed SQL statement and its processing If the time and the component name included in the database access request are added, and the change SQL statement corresponding to the SQL statement included in the database access request is not stored in the component control information storage unit, Follow the SQL statement In addition to performing base access, the statistical information in which the session information matches the session ID and the service name in the database access request in the statistical information stored in the statistical information storage unit is included in the SQL statement and the processing time. And a database access control unit for adding a component name included in the database access request.

The third program according to the present invention is:
A computer including a component control information storage unit and a statistical information storage unit
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit Tuning control unit,
When a processing request including a service name is input from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name is stored in the statistical information storage unit For each component in which the SQL statement is changed for each component constituting the service specified by the service name, the corresponding changed SQL statement stored in the component control information storage unit is executed. A database access request that includes a component name of the component, a session ID that identifies a session with the user terminal, and a service name in the processing request, and for the SQL statement that has not been changed, the SQL statement , Component of the component Name, the component execution control unit that performs processing for outputting a database access request including the session ID and the service name in the processing request,
When a database access request is output from the component execution control unit, the database is accessed according to the SQL statement or the modified SQL statement included in the database access request, and the statistical information stored in the statistical information storage unit A database access control unit for adding the SQL statement or the change SQL statement, its processing time, and the component name in the database access request to statistical information whose session information matches the session ID and service name in the database access request To function as.

[Action]
As shown in FIG. 1, when a processing request including a service name is input from a user terminal, the database access unit 1 sequentially executes the components A, B, and C constituting the service specified by the service name. If a changed SQL statement is stored in the component control information storage unit 3 in association with the component name of the component being executed (for example, component A) and the service name, the database is accessed according to the changed SQL statement. At the same time, as the statistical information specified by the session ID specifying the session with the user terminal and the service name, the modified SQL sentence, the processing time thereof, and the component name of the component A are added to the statistical information in the statistical information storage unit 4. . On the other hand, when the changed SQL statement is not stored, the database is accessed according to the SQL statement “SQL-1” in the component A, and specified in the statistical information storage unit 4 by the session ID and the service name. SQL statement “SQL-1”, its processing time, and the component name of component A are added as statistical information.

  As described above, the statistical information storage unit 4 stores statistical information including the processing time of the SQL statement in each component constituting the service in units of services, so that tuning points can be easily narrowed down. Become. For example, when there is an SQL statement that takes processing time in statistical information of a certain service, it is only necessary to check whether the certain service is a service for which high-speed processing is requested. It is possible to easily determine whether or not tuning is necessary.

  An administrator or the like needs to tune (change) an SQL statement in a certain component (for example, component B) used in a certain service α based on the statistical information stored in the statistical information storage unit 4. If it is determined, the SQL statement change instruction including the service name of the service α, the component name of the component B, and the changed SQL statement (changed SQL statement) is input. As a result, the monitoring / tuning control unit 2 stores the changed SQL statement in the component control information storage unit 3 in association with the service name of the service α and the component name of the component B. Thus, when the component B is used in the service α, the corresponding change SQL statement in the component control information storage unit 3 is used instead of the SQL statement “SQL-2” in the component B. That is, tuning can be performed on a service basis.

  Since the present invention can monitor database access on a service basis, it is possible to easily narrow down tuning locations, and furthermore, tuning can be performed on a service basis, so that the influence of tuning work is increased. Can be minimized.

  The reason why the database access can be monitored on a service basis is that when a processing request including a service name is input from the user terminal, a session ID that identifies a session with the user terminal and the session information including the service name Each time a component that constitutes a service with the service name is executed, an SQL statement or a changed SQL statement of the component, a processing time, and a component name are stored in the statistical information storage unit. This is because it has a database access means for adding to the statistical information.

  The reason that tuning can be performed on a service-by-service basis is that when an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, the service name and component are stored in the component control information storage unit. A monitoring / tuning control unit that stores the changed SQL statement in association with a name, and stores the changed SQL statement in association with the component name of the component and the service name of the requested service when the component is executed This is because it includes database access means for performing database access according to the changed SQL statement.

  Next, embodiments of the present invention will be described in detail with reference to the drawings.

[First Embodiment]
Referring to FIG. 2, the first embodiment of the database tuning apparatus according to the present invention includes a component execution control unit 11, a database (DB) access control unit 12, a relational database management system (RDBMS; Relational Database Management System). ) 13, a monitoring / tuning control unit 14, an event processing unit 15, a component information registration unit 16, a component control information storage unit 17, a statistical information storage unit 18, a relational database (RDB) 19, and a display unit 20.

  In the component control information storage unit 17, for each service provided by the system, information related to the components constituting the service is registered. FIG. 3 shows an example of the contents of the component control information storage unit 17. Referring to FIG. 3, in the component control information storage unit 17, service information 31 and component information 32 to 34 relating to three components constituting the service specified by the service information 31 are registered.

  The service information 31 includes a service name α, a service threshold Thα, and a change flag “1”. The service threshold indicates an allowable processing time (allowable time from when a service processing request is received until the processing is completed) when a service specified by the service name α is requested. The change flag displays whether or not there is a component including a change SQL statement in the component information of the lower hierarchy. In the present embodiment, the change flag is set to “1” when there is a change SQL statement, and the change flag is set to “0” when there is no change SQL statement.

  The component information 32, 33, and 34 include component names a, b, and c, and component threshold values Tha, Thb, and Thc, respectively. Further, the component information 33 includes a change SQL sentence “SQL-2 ′”. The component threshold value indicates the allowable processing time of the SQL sentence related to the component. The change SQL statement indicates an SQL statement used instead of the SQL statement in the component.

  The component information registration unit 16 has a function of storing information 31 to 34 as shown in FIG. 3 in the component control information storage unit 17 in accordance with an instruction from the administrator.

  When a processing request including a service name is input from a user terminal (not shown), the component execution control unit 11 refers to the component control information storage unit 17 and configures each component constituting the service specified by the service name The database access request including the SQL statement included in the component, the component name of the component, the session ID identifying the session with the user terminal, and the service name in the processing request is sent to the database access control unit 12 And a function of storing statistical information including session information including the session ID and the service name in the statistical information storage unit 18.

  The database access control unit 12 has the following functions.

When a database access request is output from the component execution control unit 11, the component information specified by the database access request in the component information stored in the component control information storage unit 17 includes a change SQL statement. A function to check whether or not.
When a change SQL statement is included, database access is performed according to the change SQL statement, and the session information in the statistical information stored in the statistical information storage unit 18 is the session ID requesting the database access and A function of adding a change SQL statement, its processing time, and the name of a component in a database access request to statistical information that matches the service name.
If the change SQL statement is not included, the database is accessed according to the SQL statement included in the database access request, and the session information in the statistical information stored in the statistical information storage unit 18 is A function of adding the SQL statement, its processing time, and the component name in the database access request to the statistical information matching the session ID and service name in the database access request.

  In the statistical information storage unit 18, statistical information including processing time and the like is registered for each series of service processing executed according to the processing request input from the user terminal. FIG. 4 shows an example of the contents of the statistical information storage unit 18. Referring to FIG. 4, session information 41 and three component information 42 are registered in the statistical information storage unit 18.

  The session information 41 is information for identifying a service process executed in accordance with a process request input from a user terminal. The session ID 41 identifies a session with the user terminal, a requested service name, a service The processing time required for processing is included. The session information 41 is registered by the component execution control unit 11.

  The component information 42 to 44 is information related to the component used when executing the service processing indicated by the session information 41 of the higher hierarchy, and includes the component name, the SQL statement, and the processing time. These pieces of information are registered by the database access control unit 12.

  The monitoring / tuning control unit 14 has the following functions.

When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input by an administrator or the like, it is stored in the component control information storage unit 17 using the database access control unit 12 A function to add a change SQL statement to the corresponding component information. For example, when an SQL statement change instruction including a service name α, a component name b, and a change SQL statement SQL-2 ′ is input, the change SQL statement SQL-2 ′ is added to the component information 33 as shown in FIG. To do.
-Based on the statistical information stored in the statistical information storage unit 18 and the service threshold value for each service stored in the component control information storage unit 17, a service whose processing time exceeds the corresponding service threshold value is generated. A function of displaying statistical information related to the service on the display unit 20 when it is determined that the service has been performed.
A function of obtaining the processing time required for database access for each service, the ratio to the whole, and the like on the display unit 20 based on the statistical information accumulated in the statistical information storage unit 18 in accordance with an instruction from the administrator .
-For the service specified by the administrator, the statistical information before the SQL statement change (for example, the latest of the statistical information before the SQL statement change) and the statistical information after the SQL statement change (for example, the statistics after the SQL statement change) A function of retrieving the latest information) from the statistical information storage unit 18 and displaying both on the display unit 20. At that time, a function for obtaining a difference between the processing times of the two and displaying the difference together.

  When the monitoring / tuning control unit 14 determines that a service having a processing time exceeding the service threshold has occurred, the event processing unit 15 is connected to an external device (for example, a mobile phone carried by a maintenance staff or an administrator, A function of notifying a pager or the like).

  The component execution control unit 11, the database access control unit 12, the relational database management system 13, the monitoring / tuning control unit 14, the event processing unit 15, and the component information registration unit 16 can be realized by a computer. For example, the following is performed. A disk on which a program for causing a computer to function as a component execution control unit 11, a database access control unit 12, a relational database management system 13, a monitoring / tuning control unit 14, an event processing unit 15, and a component information registration unit 16 is recorded, a semiconductor A memory and other recording media are prepared, and the computer is caused to read the program. The computer controls its own operation according to the read program, so that the component execution control unit 11, the database access control unit 12, the relational database management system 13, the monitoring / tuning control unit 14, and the event processing unit 15 are executed on the computer. , The component information registration unit 16 is realized.

[Description of Operation of First Embodiment]
Next, the operation of the present embodiment will be described in detail.

  When using a service, the user transmits a processing request including the service name of the service to be used from the user terminal to the component execution control unit 11.

  When the component execution control unit 11 receives a processing request including a service name, as illustrated in the flowchart of FIG. 5, session information including the service name and a session ID that identifies a session with the requesting user terminal. Is registered in the statistical information storage unit 18 (step S51). Now, for example, if the processing request includes the service name α and the session ID is “ID1”, the session information 41 as shown in FIG. 4 is stored in the statistical information storage unit 18. However, at this time, the processing time Tα is not included.

  Next, the component execution control unit 11 searches the component control information storage unit 17 using the service name α being requested as a key, and searches for corresponding service information (step S52). Now, assuming that the content of the component control information storage unit 17 is as shown in FIG. 3, the component execution control unit 11 searches for the service information 31.

  Thereafter, the component execution control unit 11 pays attention to the first component information among the components 32 to 34 existing in the lower hierarchy of the service information 31 searched in step S52 (steps S53 and S54). In this example, since the component information 32 exists as the first component information (YES in step S55), the component execution control unit 11 determines the component A identified by the component name a included in the component information 32. And a database access request including the SQL statement “SQL-1” included in the component A, the component a, the session ID “ID1”, and the service name α is sent to the database access control unit 12. Issue (Steps S56, S57).

  When receiving the database access request from the component execution control unit 11, the database access control unit 12 uses the service name α and the component name a included therein as a key, as shown in the flowchart of FIG. The corresponding component information is searched from the storage unit 17 (step S61). When the content of the component control information storage unit 17 is as shown in FIG. 3, the component information 32 having the component name a and existing in the lower hierarchy of the service information 31 including the service name α is searched.

  Thereafter, the database access control unit 12 determines whether or not a changed SQL sentence is included in the retrieved component information 32 (step S62). In this example, since the component 32 does not include the change SQL statement (NO in step S62), the database access control unit 12 follows the SQL statement “SQL-1” included in the database access request. When an execution request is made to the relational database management system 13 and an execution result is acquired, it is returned to the component execution control unit 11 (step S63). Thereafter, the database access control unit 12 retrieves the session information 41 from the statistical information storage unit 18 using the session ID “ID1” and the service name “α” as keys, and the component name “a” and the SQL sentence “ Component information 42 including “SQL-1” and its processing time Ta is added (step S65).

  On the other hand, when the execution result is returned from the database access control unit 12, the component execution control unit 11 pays attention to the next component information 33 (steps S58 and S54 in FIG. 5). Thereafter, the component B specified by the component name b in the component information 33 is executed, and the SQL sentence “SQL-2”, the component name b, the session ID “ID1”, and the service name α included in the component B are executed. Is issued to the database access control unit 12 (step S57).

  When the database access control unit 12 accepts the database access request, the database access control unit 12 searches the component control information storage unit 17 for the corresponding component information using the service name α and the component name b included therein as keys (FIG. 6). Step S61). In the case of this example, the component information 33 including the component name b existing in the lower hierarchy of the service information 31 including the service name α is searched.

  Since the retrieved component information 33 includes the changed SQL statement “SQL-2 ′” (step S62 is YES), the database access control unit 12 follows the changed SQL statement “SQL-2 ′”. When an execution request is made to the relational database management system 13 and an execution result is acquired, it is returned to the component execution control unit 11 (step S64). Thereafter, the database access control unit 12 retrieves the session information 41 from the statistical information storage unit 18 using the session ID “ID1” and the service name “α” as keys, and in the lower hierarchy, the component name b and the change SQL statement Component information 43 including “SQL-2 ′” and the processing time Tb is added (step S65).

  On the other hand, when the execution result is returned from the database access control unit 12, the component execution control unit 11 executes the component C specified by the third component information 34 (steps S58, S54, and S56 in FIG. 5). Then, a database access request including the SQL statement “SQL-3”, the component name c, the session ID “ID1”, and the service name α included therein is issued to the database access control unit 12 (step S57). ).

  Thereby, the database access control unit 12 performs the same processing as when the first database access request is received, returns the execution result to the component execution control unit 11, and displays the component information in the lower hierarchy of the session information 41. Component information 44 including the name c, the SQL sentence “SQL-3”, and the processing time Tc is added (NO in steps S61 and S62 in FIG. 6, S63 and S65).

  On the other hand, when the execution result is returned from the database access control unit 12, the component execution control unit 11 performs the process of step S59 because there is no unfocused component information (NO in step S55 in FIG. 5). In step S59, first, the difference between the reception time of the processing request from the user terminal and the current time is obtained to obtain the processing time (assuming that it is Tα) required for the service processing, and then the obtained processing time. A processing time notification including Tα, the service name α included in the processing request, and a session ID “ID1” for specifying a session with the user terminal is sent to the database access control unit 12.

  When the processing time notification is sent from the component execution control unit 11, the database access control unit 12 corresponds from the statistical information storage unit 18 using the service name α and session ID “ID1” included therein as keys. The session information 41 is searched, and the processing time Tα is added to the session information 41 as shown in FIG. 4 (steps S71 and S72 in FIG. 7). Thereafter, the database access control unit 12 notifies the monitoring / tuning control unit 14 of the service name α and the session ID “ID1” (step S73).

  As a result, the monitoring / tuning control unit 14 searches the statistical information storage unit 18 using the service name α and the session ID “ID1” as keys, and searches for the corresponding session information 41, as shown in the flowchart of FIG. (Step S81). Thereafter, the monitoring / tuning control unit 14 determines whether or not the processing time Tα included in the session information 41 exceeds the service threshold Thα for the service with the service name α (step S82). Note that the service threshold value Thα is included in the service information 31 specified by the service name α in the service information stored in the component control information storage unit 17, so the service name α is used as a key for the component It can be obtained by searching the control information storage unit 17. Further, when the service threshold value Thα is obtained, the component threshold values Tha, Thb, Thc included in the components 32 to 34 existing in the lower hierarchy of the service information 31 are also obtained.

  When the processing time Tα does not exceed the service threshold Thα (step S82 is NO), the monitoring / tuning control unit 14 ends the processing.

  On the other hand, when the processing time Tα exceeds the service threshold Thα (YES in step S82), the processing time Ta included in the component information 42 to 44 in the lower hierarchy of the session information 41 is included. A case where Tb and Tc exceed the corresponding component threshold values Tha, Thb and Thc is searched (step S83). Next, the monitoring / tuning control unit 14 displays statistical information including the session information 41 searched in step S81 and the component information 42 to 44 existing in the lower hierarchy on the display unit 20 (step S84). At this time, the display form of the component information found in step S83 is set to a specific display form different from the display form of other component information (for example, the display color of the found component information is set to red, and the display of other components is displayed). Make the color black). Finally, the event processing unit 15 is notified that a service whose processing time has exceeded the service threshold has occurred (step S85), and the process ends. When the event processing unit 15 receives the notification, the event processing unit 15 notifies the mobile phone or pager carried by the maintenance staff or the administrator.

  When the statistical information of the service whose processing time has exceeded the service threshold is displayed on the display unit 20, the administrator creates a modified SQL statement that is a tuning of the SQL statement in the component information whose display form is red. Now, for example, as shown in FIG. 9, the display unit 20 displays statistical information about the service with the service name α, which includes session information 41 and component information 42 to 44, and the display color of the component information 43 is If it is red, the administrator creates a modified SQL statement “SQL-2 ″” obtained by tuning the SQL statement “SQL-2 ′” included in the component information 43.

  Thereafter, the administrator outputs an SQL statement change instruction including the created change SQL statement “SQL-2 ″”, the service name α, and the component name b to the monitoring / tuning control unit 14. Accordingly, the monitoring / tuning control unit 14 is stored in the component control information storage unit 17 specified by the service name α and the component name b in the SQL statement change instruction using the database access control unit 12. The changed SQL sentence “SQL-2 ′” in the existing component information 33 is replaced with “SQL-2 ″”. In this example, since the component information 33 includes the changed SQL sentence “SQL-2 ′”, a process for replacing it with the changed SQL sentence “SQL-2 ″” is performed. If the change SQL statement “SQL-2 ′” is not included in 33, a process of adding the change SQL statement “SQL-2 ″” to the component information 33 is performed.

  The SQL statement change instruction described above includes the service name α and the component name b in addition to the change SQL statement “SQL-2 ″”, but the change SQL statement “SQL-2 ″” and the component When the SQL statement change instruction including the name b and not the service name α is input, the monitoring / tuning control unit 14 includes all the component names b registered in the component control information storage unit 17. The change SQL sentence “SQL-2 ′” is added or replaced with the component information of

[Effect of the first embodiment]
Since this embodiment can monitor database access in units of services, it is possible to easily narrow down tuning locations, and further tuning can be performed in units of services, so that tuning work can be performed. The effect of this can be minimized.

  The reason why the database access can be monitored on a service basis is that when a processing request including a service name is input from the user terminal, a session ID that identifies a session with the user terminal and the session information including the service name Each time the component constituting the service with the service name is executed, the SQL statement or changed SQL statement of the component, the processing time, and the component This is because it includes database access means (comprising the component execution control unit 11 and the database access control unit 12) for adding the name to the statistical information.

  Further, according to the present embodiment, it is possible to easily detect the occurrence of a service whose processing time has exceeded the corresponding service threshold. The reason is that the processing time exceeded the applicable service threshold based on the statistical information stored in the statistical information storage unit 18 and the service threshold for each service stored in the component control information storage unit 17. This is because a monitoring / tuning control unit 14 that detects the occurrence of a service is provided.

  In addition, according to the present embodiment, when a service that exceeds the service threshold corresponding to the processing time occurs, it is possible to quickly respond. The reason is that it includes an event processing unit 15 that notifies an administrator of an external device such as a mobile phone or a pager when a service whose processing time exceeds a corresponding service threshold value occurs.

[Configuration of Second Embodiment]
Next, a second embodiment of the present invention will be described. In this embodiment, the component execution control unit 11 executes the process shown in the flowchart of FIG. 10 instead of the process shown in the flowchart of FIG. 5, and the database access control unit 12 causes the process shown in the flowchart of FIG. Instead, it is realized by executing the processing shown in the flowchart of FIG. In FIGS. 10 and 11, steps that perform the same processing as in FIGS. 5 and 6 are assigned the same numbers.

[Description of Operation of Second Embodiment]
Referring to FIG. 10, when a processing request including a service name (for example, service name α) is sent from the user terminal, the component execution control unit 11 performs steps S51 to S56 described in the first embodiment. Perform the process. Thereafter, instead of step S57, the processes of steps S101 to S103 are performed.

  In step S101, it is determined whether the component SQL noticed in step S54 includes a change SQL sentence.

  For example, if attention is paid to the component information 32 shown in FIG. 3 in step S54, the determination result in step S101 is NO, so that the component execution control unit 11 includes the service name α included in the processing request, A session ID (for example, ID1) that identifies a session with the requesting user terminal, a component name a included in the component information 32, and an SQL statement “SQL-1” included in the component A being executed Is issued to the database access control unit 12 (step S102).

  When the database access control unit 12 receives a database access request including the SQL sentence “SQL-1” from the component execution control unit 11, it is included in the database access request as shown in the flowchart of FIG. In accordance with the SQL statement “SQL-1”, an execution request is made to the relational database management system 13, and when an execution result is acquired, it is returned to the component execution control unit 11 (step S111). Thereafter, the database access control unit 12 performs the process of step S65 described in the first embodiment.

  On the other hand, when the execution result is returned from the database access control unit 12, the component execution control unit 11 pays attention to the next component information 33 and executes the corresponding component B (steps S58, S54, and S56 in FIG. 10). . Thereafter, the component execution control unit 11 includes the service name α and the session ID “ID1” because the changed SQL sentence “SQL-2 ′” is included in the component information 33 of interest (YES in step S101). Then, a database access request including the component name b included in the component information 33 and the changed SQL sentence “SQL-2 ′” is issued to the database access control unit 12 (step S103).

  When a database access request including the changed SQL statement “SQL-2 ′” is sent from the component execution control unit 11, the database access control unit 12 is included in the database access request as shown in the flowchart of FIG. 11. The execution request is made to the relational database management system 13 according to the changed SQL statement “SQL-2 ′”, and when the execution result is acquired, it is returned to the component execution control unit 11 (step S111). Thereafter, the database access control unit 12 performs the process of step S65 described in the first embodiment.

[Effects of Second Embodiment]
According to the present embodiment, in addition to the effects of the first embodiment, it is possible to obtain an effect that the number of search processes performed by the database access control unit 12 can be reduced. The reason for this is that in the first embodiment, the database access control unit 12 searches the component control information storage unit 17 to determine whether there is a change SQL statement, and follows the SQL statement based on the determination result. In the present embodiment, the component execution control unit 11 determines that there is a change SQL statement, although it is determined whether the execution request is made or whether the execution request according to the change SQL statement is executed (steps S61 to S64). In this case, a database access request including a change SQL statement is issued to the database access control unit 12, and if there is no database access request, the database access request including the SQL statement in the component being executed is sent to the database access control unit 12. This is because it is issued (steps S101 to S103).

[Configuration of Third Embodiment]
Next, a third embodiment of the database tuning apparatus according to the present invention will be described. FIG. 12 is a block diagram showing a configuration example of the database tuning apparatus according to the present embodiment. Differences between the database tuning apparatus of the present embodiment and the database tuning apparatus of the first embodiment shown in FIG. The points are that the components A to C include statistical information registration units 111A to 111C for performing statistical information registration processing, the component execution control unit 11a instead of the component execution control unit 11, and the database A database access control unit 12 a is provided instead of the access control unit 12.

[Operation of Third Embodiment]
Referring to the flowchart of FIG. 13, when a processing request including a service name (for example, service name α) is input from the user terminal, the component execution control unit 11a performs step S51 described in the first embodiment. The process of -S56 is performed and the 1st component of the components which comprise the service of the said service name (alpha) is performed. Now, for example, if the component A shown in FIG. 12 (component name is a) is executed, the component execution control unit 11a determines the session name (ID1 and ID1) that identifies the service name α and the session with the user terminal. A database access request including the SQL statement “SQL-1” in component A and the component name a is issued to the database access control unit 12 (step S57).

  Thereby, the database access control part 12a performs the process shown in the flowchart of FIG. 14, and returns an execution result to the component execution control part 11a. The difference between the flowchart of FIG. 14 and the flowchart of FIG. 6 showing the processing example of the database access control unit 12 is that step S65 is deleted.

  When the execution result is returned from the database access control unit 12a, the statistical information registration unit 111A of the component A being executed on the component execution control unit 11a performs the process of step S131 shown in the flowchart of FIG. In step S131, the statistical information registration unit 111A first checks whether or not a change SQL sentence is included in the component information 32 related to the self component name a registered in the component control information storage unit 17. If the changed SQL statement is not included, the component information 42 including the SQL statement “SQL-1” in the own component A, the component name a of the own component A, and the processing time Ta thereof is displayed as the session information. 41 is added to the lower hierarchy. On the other hand, when the change SQL sentence is included in the component information 32, the component information 42 including the change SQL sentence, the component name a of the self component A, and the processing time Ta is set in the session information 41. Add to the lower hierarchy. The above is the process performed in step S131.

  Thereafter, the component execution control unit 11a pays attention to the next component information (steps S58 and S54), and performs the same process as described above. When there is no unfocused component information (NO in step S55), the process is terminated.

  According to the present embodiment, in addition to the effect of the first embodiment, an effect that the load on the database access control unit 12a can be reduced can be obtained. This is because the statistical information registration units 111A to 111C are provided in the components A to C, respectively.

  The present invention can be used in the field of application development and system operation using a database.

It is a figure for demonstrating the effect | action of this invention. It is a block diagram which shows the structural example of 1st Embodiment of the database tuning apparatus concerning this invention. It is a figure which shows the example of the content of the component control information storage part. It is a figure which shows the example of the content of the statistical information storage part. 4 is a flowchart illustrating a processing example of a component execution control unit 11. It is a flowchart which shows the process example of the database access control part 12 when a database access request | requirement is input. It is a flowchart which shows the process example of the database access control part 12 when a process time notification is input. 4 is a flowchart showing a processing example of a monitoring / tuning control unit 14. It is a figure which shows an example of the statistical information displayed on the display part. It is a flowchart which shows the process example which the component execution control part 11 performs in the 2nd Embodiment of this invention. It is a flowchart which shows the process example which the database access control part 12 performs in the 2nd Embodiment of this invention. It is a block diagram which shows the structural example of 3rd Embodiment of the database tuning apparatus concerning this invention. It is a flowchart which shows the process example of the component execution control part 11a. It is a flowchart which shows the process example of the database access control part 12a.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Database access means 2 ... Monitoring / tuning control part 3 ... Component control information storage part 4 ... Statistical information storage part 11, 11a ... Component execution control part 12, 12a ... Database access control part 13 ... Relational database management system (RDBMS)
14 ... Monitoring / tuning control unit 15 ... Event processing unit 16 ... Component information registration unit 17 ... Component control information storage unit 18 ... Statistical information storage unit 19 ... Relational database (RDB)
20: Display units A to C: Component

Claims (14)

A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the component control is associated with the component name of the component and the service name. When a change SQL statement is stored in the information storage unit, database access is performed according to the change SQL statement, and the statistical information storage unit is specified by a session ID with the user terminal and the service name. The modified SQL statement, its processing time, and the component name are added as statistical information, and if the modified SQL statement is not stored, the database is accessed according to the SQL statement in the component and the statistical information storage unit , The session ID and the service Database tuning apparatus characterized by comprising the SQL statement as the statistical information specified and a database access unit for adding the processing time and the component name by. A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the SQL statement included in the component, the component name of the component, the user A database access request including a session ID for identifying a session with a terminal and a service name in the processing request is output, and statistical information including session information including the session ID and the service name is stored in the statistical information storage unit A component execution control unit to store;
When a database access request is output from the component execution control unit, if a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit, according to the change SQL statement In addition to performing database access, the statistical information whose session information matches the session ID and service name in the database access request in the statistical information stored in the statistical information storage unit is changed to the changed SQL statement and its processing If the time and the component name included in the database access request are added, and the change SQL statement corresponding to the SQL statement included in the database access request is not stored in the component control information storage unit, Follow the SQL statement In addition to performing base access, the statistical information in which the session information matches the session ID and the service name in the database access request in the statistical information stored in the statistical information storage unit is included in the SQL statement and the processing time. And a database access control unit for adding a component name included in the database access request. Component control information in which component information including a component name for identifying a component is stored in association with service information including a service name, which is component information of each of a plurality of components constituting the service identified by the service name. A storage unit;
Monitoring / adding the changed SQL statement to the corresponding component information in the component information stored in the component control information storage unit according to the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change A tuning control unit;
A statistical information storage unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed with reference to the component control information storage unit, and an SQL statement included in the component is executed. A database access request including a component name of the component, a session ID for specifying a session with the user terminal, and a service name in the processing request, and includes session information including the session ID and the service name. A component execution control unit for storing statistical information in the statistical information storage unit,
When a database access request is output from the component execution control unit, a change SQL statement is included in the component information specified by the database access request among the component information stored in the component control information storage unit If the database information is accessed according to the changed SQL statement, the statistical information in the statistical information stored in the statistical information storage unit matches the session ID and service name in the database access request. The change SQL statement, its processing time, and the name of the component in the database access request are added, and if the change SQL statement is not included, the database is accessed according to the SQL statement included in the database access request. When Among the statistical information stored in the statistical information storage unit, the SQL statement, its processing time, and the database access request are added to the statistical information whose session information matches the session ID and service name in the database access request. And a database access control unit for adding a component name therein. A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name is stored in the statistical information storage unit For each component in which the SQL statement is changed for each component constituting the service specified by the service name, the corresponding changed SQL statement stored in the component control information storage unit is executed. A database access request that includes a component name of the component, a session ID that identifies a session with the user terminal, and a service name in the processing request, and for the SQL statement that has not been changed, the SQL statement , Component of the component Name, and component execution control unit that performs processing for outputting a database access request including the service name in the session ID and the processing request,
When a database access request is output from the component execution control unit, the database is accessed according to the SQL statement or the modified SQL statement included in the database access request, and the statistical information stored in the statistical information storage unit A database access control unit for adding the SQL statement or the change SQL statement, its processing time, and the component name in the database access request to statistical information whose session information matches the session ID and service name in the database access request And a database tuning apparatus. Component control information in which component information including a component name for identifying a component is stored in association with service information including a service name, which is component information of each of a plurality of components constituting the service identified by the service name. A storage unit;
Monitoring / adding the changed SQL statement to the corresponding component information in the component information stored in the component control information storage unit according to the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change A tuning control unit;
A statistical information storage unit;
When a processing request including a service name is input from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name is stored in the statistical information storage unit When each component constituting the service specified by the service name is executed with reference to the component control information storage unit, and the component information corresponding to the component includes a change SQL statement Outputs a database access request including the change SQL statement, the component name of the component, the session ID, and the service name in the processing request, and if the change SQL statement is not included in the component information, the component SQL statement included in the above-mentioned component Cement component name, and component execution control unit for outputting a database access request including the service name in the session ID and the processing request,
When a database access request is output from the component execution control unit, the database is accessed according to the SQL statement or the modified SQL statement included in the database access request, and the statistical information stored in the statistical information storage unit A database in which the SQL statement or the change SQL statement, its processing time, and the component name in the database access request are added to statistical information whose session information matches the session ID and service name in the database access request A database tuning apparatus comprising an access control unit. A component control information storage unit;
A statistical information storage unit;
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit A tuning control unit;
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the SQL statement included in the component, the component name of the component, the user A database access request including a session ID for identifying a session with a terminal and a service name in the processing request is output, and statistical information including session information including the session ID and the service name is stored in the statistical information storage unit A component execution control unit to store;
When a database access request is output from the component execution control unit, if a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit, according to the change SQL statement A database access control unit that performs database access and performs a database access according to the SQL statement when a change SQL statement corresponding to the SQL statement included in the database access request is not stored in the component control information storage unit; And comprising
The component executed by the component execution control unit is stored in the statistical information storage unit when the change SQL statement for the SQL statement included in the component is stored in the component control information storage unit Among the statistical information, the session information is added to the statistical information that matches the session ID and service name in the database access request, and the modified SQL statement, its processing time, and the component name of the own component are added. When a change SQL statement for the existing SQL statement is not stored in the component control information storage unit, the session information in the statistical information stored in the statistical information storage unit is the session ID in the database access request and In the statistics that match the service name, Serial SQL statements, the database tuning apparatus characterized by having a structure of adding the component names of the processing time and the own components. In the database tuning device according to claim 3 or 5,
Each service information stored in the component control information storage unit includes a service threshold value indicating an allowable processing time of a service specified by the service information,
Services in which the monitoring / tuning control unit corresponds to the processing time based on the statistical information stored in the statistical information storage unit and the service threshold value for each service stored in the component control information storage unit A database tuning apparatus having a configuration for detecting occurrence of a service exceeding a threshold. The database tuning device according to claim 7, wherein
When the monitoring / tuning control unit detects the occurrence of a service whose processing time exceeds a corresponding service threshold, the database tuning device includes an event processing unit that notifies an external device of the occurrence. When the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change is input, the monitoring / tuning control unit associates the change SQL with the service name and the component name in the component control information storage unit. Store statements,
When a processing request including a service name is input from the user terminal, the database access unit executes each component constituting the service specified by the service name, and corresponds to the component name of the component and the service name In addition, when a change SQL statement is stored in the component control information storage unit, database access is performed according to the change SQL statement, and a session ID with the user terminal and the user terminal are stored in the statistical information storage unit. The changed SQL statement, its processing time and the component name are added as statistical information specified by the service name. When the changed SQL statement is not stored, the database is accessed according to the SQL statement in the component, and The statistical information storage unit Deployment ID and the SQL statement as the statistical information specified by the service name, the database tuning method characterized by adding the processing time and the component name. When the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change is input, the monitoring / tuning control unit associates the change SQL with the service name and the component name in the component control information storage unit. Store statements,
When a processing request including a service name is input from a user terminal, the component execution control unit executes each component constituting the service specified by the service name, and includes an SQL statement included in the component, Outputs a database access request including a component name, a session ID for specifying a session with the user terminal, and a service name in the processing request, and statistical information including session information including the session ID and the service name. Store in the statistical information storage,
When the database access control unit outputs a database access request from the component execution control unit, a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit. The database is accessed according to the changed SQL statement, and the statistical information in the statistical information stored in the statistical information storage unit matches the session ID and service name in the database access request. A change SQL statement, its processing time, and a component name included in the database access request are added, and a change SQL statement corresponding to the SQL statement included in the database access request is stored in the component control information storage unit Not If the database information is accessed according to the SQL statement, and the statistical information stored in the statistical information storage unit, the session information matches the session ID and service name in the database access request, A database tuning method comprising: adding the SQL statement, its processing time, and a component name included in the database access request. When the SQL statement change instruction including the service name, the component name, and the changed SQL statement after the change is input, the monitoring / tuning control unit associates the change SQL with the service name and the component name in the component control information storage unit. Store statements,
When the component execution control unit receives a processing request including a service name from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name In addition to performing processing to be stored in the information storage unit, each component constituting the service specified by the service name is executed, and components whose SQL statements have been changed are stored in the component control information storage unit For a component for which a database access request including a corresponding change SQL statement, a component name of the component, a session ID for specifying a session with the user terminal, and a service name in the processing request is output, and the SQL statement is not changed Is the SQL statement, Component name component, performs a process of outputting a database access request including the service name in the session ID and the processing request,
When the database access control unit outputs a database access request from the component execution control unit, the database access control unit accesses the database according to the SQL statement or the modified SQL statement included in the database access request and stores it in the statistical information storage unit Among the statistical information, the SQL statement or the modified SQL statement, the processing time and the component name in the database access request are added to the statistical information whose session information matches the session ID and service name in the database access request. A database tuning method characterized by adding. A computer including a component control information storage unit and a statistical information storage unit
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit Tuning control unit,
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the component control is associated with the component name of the component and the service name. When a change SQL statement is stored in the information storage unit, database access is performed according to the change SQL statement, and the statistical information storage unit is specified by a session ID with the user terminal and the service name. The modified SQL statement, its processing time, and the component name are added as statistical information, and if the modified SQL statement is not stored, the database is accessed according to the SQL statement in the component and the statistical information storage unit , The session ID and the service The SQL statement, program for functioning as a database access unit for adding the processing time and the component name as the statistical information specified by. A computer including a component control information storage unit and a statistical information storage unit
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit Tuning control unit,
When a processing request including a service name is input from a user terminal, each component constituting the service specified by the service name is executed, and the SQL statement included in the component, the component name of the component, the user A database access request including a session ID for identifying a session with a terminal and a service name in the processing request is output, and statistical information including session information including the session ID and the service name is stored in the statistical information storage unit Component execution control unit to store,
When a database access request is output from the component execution control unit, if a change SQL statement for the SQL statement included in the database access request is stored in the component control information storage unit, according to the change SQL statement In addition to performing database access, the statistical information whose session information matches the session ID and service name in the database access request in the statistical information stored in the statistical information storage unit is changed to the changed SQL statement and its processing If the time and the component name included in the database access request are added, and the change SQL statement corresponding to the SQL statement included in the database access request is not stored in the component control information storage unit, Follow the SQL statement In addition to performing base access, the statistical information in which the session information matches the session ID and the service name in the database access request in the statistical information stored in the statistical information storage unit is included in the SQL statement and the processing time. And a program for causing a database access control unit to add a component name included in the database access request. A computer including a component control information storage unit and a statistical information storage unit
When an SQL statement change instruction including a service name, a component name, and a changed SQL statement after change is input, monitoring / stores the changed SQL statement in association with the service name and the component name in the component control information storage unit Tuning control unit,
When a processing request including a service name is input from a user terminal, statistical information including session information including a session ID for identifying a session with the user terminal and the service name is stored in the statistical information storage unit For each component in which the SQL statement is changed for each component constituting the service specified by the service name, the corresponding changed SQL statement stored in the component control information storage unit is executed. A database access request that includes a component name of the component, a session ID that identifies a session with the user terminal, and a service name in the processing request, and for the SQL statement that has not been changed, the SQL statement , Component of the component Name, the component execution control unit that performs processing for outputting a database access request including the session ID and the service name in the processing request,
When a database access request is output from the component execution control unit, the database is accessed according to the SQL statement or the modified SQL statement included in the database access request, and the statistical information stored in the statistical information storage unit A database access control unit for adding the SQL statement or the change SQL statement, its processing time, and the component name in the database access request to statistical information whose session information matches the session ID and service name in the database access request Program to function as.

Images