JP2008234260A - Assumed operation condition analysis program, assumed operation condition analysis device and assumed operation condition analysis method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically extract an assumed operation condition of a program needed to normally perform processing which is frequently executed in actual work by use of an access result of data. <P>SOLUTION: A performance route extraction means 12 generates performance route information containing a performance route showing a route of update processing of a data group and an appearance number of the performance route, and a processing route extraction means 14 extracts a processing route from program definition information, and generates processing route information showing reading processing and writing processing to the data group and an execution condition of each processing route. A route association means 15 associates the performance route information with the processing route information, and an essential processing route determination means 16 determines a processing route associated with a performance route having the appearance number of a threshold or more as an essential processing route. An assumed operation condition extraction means 17 takes a group of execution conditions of the essential processing route as an assumed operation condition, and outputs information showing the assumed operation condition 19. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to an assumed operating condition analysis program for analyzing an assumed operating condition of a computer system, an assumed operating condition analysis apparatus, and an assumed operating condition analysis method, and more particularly to an assumed operating condition analysis for analyzing an assumed operating condition of a program executed in a computer system. The present invention relates to a program, an assumed operating condition analysis apparatus, and an assumed operating condition analysis method.

  The computer system is developed assuming conditions for operating the system (hereinafter, the conditions assumed by the computer system are referred to as assumed operating conditions). As the assumed operating conditions, there are various conditions such as conditions related to hardware and conditions related to software (program, OS, etc.). In a situation where the assumed operation condition is not satisfied, the computer system becomes an unexpected situation, and thus an abnormal operation may occur. Therefore, it is necessary to grasp the assumed operating conditions and maintain the conditions so as to be satisfied during the operation and maintenance of the computer system.

  However, in computer systems that have been aged since development, there are often situations in which the assumed operating conditions are unclear due to loss of documents during development, lack of additional development documents, and absence of system experts. In a situation where the assumed operation condition is unknown, there is a risk that a modification contrary to the assumed operation condition may be performed by maintenance work or operation work. This can have an adverse effect on the computer system.

  Therefore, there is a need for a method of analyzing the assumed operating conditions of the computer system based on data that can be acquired from the current computer system, as well as existing documents that describe the assumed operating conditions.

2. Description of the Related Art Conventionally, among the above-described assumed operation conditions, the following methods are known as analysis methods for the assumed operation conditions of a program.
Focusing on the expected operating conditions of the program, focusing on data flow and input / output based on re-engineering technology, parsing the program, analyzing the control flow, data flow, influence range, etc., job flow (For example, refer to Patent Document 1).
JP 2003-67186 A

  However, since the technique described in Patent Document 1 does not use the actual data acquired at the time of actual operation of the computer system, when there are a plurality of processing paths composed of a plurality of continuous processes, the processing is performed. It cannot be determined whether or not the route is used in actual business. For this reason, it is necessary to comprehensively consider the assumed operating conditions for all the processing paths, and it is necessary to consider processing paths that are not executed at all in actual work, resulting in wasted labor. .

  In addition, when there are a plurality of processing paths, the execution frequency of each processing path in the actual job cannot be determined from the program analysis. For this reason, a process that is frequently executed in an actual job and a process that is hardly executed in the actual job must be considered in the same way, and the examination work may become inefficient.

  In addition, the database access processing executed by the computer system according to the program is a database accessor program (a function program for performing processing on a specified database. Reference, update, addition, deletion, etc. depending on arguments when called from other programs) If the process type is specified and the specified process is executed on the database, the process type cannot be specified by program analysis. A series of processing paths up to the end cannot be specified. In addition, when the program to be executed depends on external factors such as human operation, it is not known which program will be executed depending on the program analysis. I can't get a route. In such cases, even if program analysis is used, it is impossible to extract the assumed operating condition of the computer system program because the processing path is unknown.

  In addition, in order to acquire the processing path, the computer system program is modified so that data indicating the processing status is sequentially output as necessary in order to observe the operation of the computer system from the outside, and it is operated in actual work. It is also possible to observe the output data. However, modification of a program for observation is not only labor intensive, but this modification may cause new adverse effects on the computer system.

  The present invention has been made in view of these points, and uses a data access result, which is an execution result of a computer system that can be collected from outside the computer system, to perform a process that is frequently executed in actual work. An object of the present invention is to provide an assumed operation condition analysis program, an assumed operation condition analysis apparatus, and an assumed operation condition analysis method that automatically extract an assumed operation condition of a program required for normal operation.

  In the present invention, in order to solve the above-mentioned problem, an assumed operation condition analysis program as shown in FIG. 1 is provided. The assumed operating condition analysis program according to the present invention uses a data access result, which is an execution result of a computer system that can be collected from the outside of the computer system, to normally perform a process that is frequently executed in an actual job. It automatically extracts the expected operating conditions of the required program. The computer 10 that executes the assumed operation condition analysis program includes an update information storage unit 11, a performance route extraction unit 12, a program definition information storage unit 13, a processing route extraction unit 14, a route association unit 15, and a main processing route determination unit 16. And an assumed operating condition extracting means 17. The update information storage unit 11 associates and stores update information including the data set name of the data set updated by the program executed in the computer system and the update time when the data set is updated. The actual route extracting unit 12 extracts the actual route that is the relationship between two data sets that are continuously updated from the update information stored in the update information storage unit 11, and the data set that is the start point and the end point of each actual route. And actual route information indicating the number of appearance of the actual route is generated. The program definition information storage unit 13 stores program definition information that defines a processing procedure of a program executed in the computer system to be analyzed. The processing path extraction unit 14 extracts a processing path from the program definition information stored in the program definition information storage unit 13, reads and writes the data set executed on each processing path, and the execution conditions of the processing path Processing path information indicating that is generated. The route correlating means 15 is based on the actual route information generated by the actual route extracting means 12 and the processing route information generated by the processing route extracting means 14, and the data set as the starting point and the data set as the target of the reading process. Are matched, and the data path as the end point and the data set as the target of the writing process are associated with the actual result path and the processing path. The main processing route determination unit 16 determines a processing route in which the number of appearances of the actual route associated with the processing route by the route association unit 15 is equal to or greater than a predetermined threshold among the processing routes as a main processing route. The assumed operation condition extraction unit 17 extracts the execution condition of the processing path determined as the main process path by the main process route determination unit 16, and sets the extracted execution condition as the assumed operation condition 19. Output information.

  According to the computer 10 that executes such an assumed operation condition analysis program, the actual route information including the actual route indicating the data set update processing route and the number of appearances of the actual route is obtained by the actual route extraction unit 12. Generated. Next, the processing path extraction unit 14 extracts the processing path from the program definition information, and generates processing path information indicating a read process and a write process for the data set, and an execution condition for each processing path. Then, the route association means 15 associates the actual route information with the processing route information. Thereafter, the main processing path determination unit 16 determines that the processing path associated with the actual path whose number of appearances is equal to or greater than a predetermined threshold is the main processing path. Then, the set of execution conditions for the processing path determined as the main processing path is set as the assumed operation condition by the assumed operation condition extraction unit 17, and information indicating the assumed operation condition 19 is output.

  In the present invention, the actual operation of the computer system is analyzed from the data access result that is the execution result of the computer system, the program processing path extracted by the program analysis, and the actual path restored from the data access result of the computer system To determine the main processing path that is the processing path that is actually used frequently among the processing paths on the program that realizes the business functions of the computer system, and further determines the execution conditions of the main processing path. It was decided to extract the assumed operating conditions of the computer system program. As a result, it is possible to automatically extract an assumed operation condition that is important for the performance of the business. Therefore, a system administrator or the like can efficiently prevent an adverse effect on a main business by performing the operation so as to satisfy the extracted assumed operation condition during the operation and maintenance of the computer system.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. First, an outline of the present invention will be described, and then specific contents of the embodiment will be described.
FIG. 1 is a diagram showing an outline of the present embodiment. The computer 10 shown in FIG. 1 uses a database system and a business including the database system based on update information of tables included in a database output from the database management system and program definition information that defines a program that uses data managed by the database management system. For the normal operation of the system, an assumed operating condition of the program that should be satisfied even when the program is modified during system operation or maintenance work is generated. The computer 10 includes an update information storage unit 11, an actual route extraction unit 12, a program definition information storage unit 13, a processing route extraction unit 14, a route association unit 15, a main processing route determination unit 16, and an assumed operation condition extraction unit 17. Have.

  The update information storage unit 11 stores table update information 21a, 22a, and 23a output from the database management systems 21, 22, and 23. The update information 21a, 22a, 23a includes update processing of a plurality of data sets stored in the database management systems 21, 22, 23 when the business system 20 including the database management systems 21, 22, 23 is actually operated. Are associated with the data set name of the data set updated by the data update process including the update time when the data set was updated. Here, the data set is, for example, one table in a relational database.

  The actual result route extracting unit 12 extracts the actual result route that is the relationship between two data sets that are continuously updated from the update information stored in the update information storage unit 11. Next, the actual route extraction unit 12 generates actual route information indicating a data set that is a start point and an end point of each actual route and the number of appearances of the actual route. Here, the column of the data set is considered to represent the actual route.

  The program definition information storage means 13 stores program definition information 25a, 26a, 27a that defines the processing procedure of the programs 25, 26, 27 executed in the business system 20 to be analyzed. The program definition information 25a, 26a, 27a is, for example, source information, machine-readable code such as object code, or design information such as a flowchart.

  The processing path extraction unit 14 analyzes the program definition information 25a, 26a, 27a stored in the program definition information storage unit 13, and performs the program processing defined by the program definition information 25a, 26a, 27a for each processing path. Decompose. Then, the processing path extraction unit 14 generates processing path information indicating an execution condition for each decomposed processing path, a data set to be read, and a data set to be written.

  The route association means 15 associates the actual route with the processing route based on the actual route information and the processing route information. Specifically, the route association unit 15 compares the data set name read in the actual route and the data set name read in the processing route, and the data set name written in the actual route and the data written in the processing route. Compare set names. Then, the route association unit 15 associates the result route and the processing route in which both the read target data set name and the set of the write target data set name match. In this way, the route correlating unit 15 is based on the actual route information generated by the actual route extracting unit 12 and the processing route information generated by the processing route extracting unit 14, and the data set as the starting point and the target of the reading process And the result path and the processing path in which the data set as the end point and the data set as the target of the writing process match are associated with each other.

  Based on the number of appearances calculated by the actual route extraction unit 12, the main processing route determination unit 16 processes the processing route associated with the actual route having a high appearance frequency during actual operation of the business system 20 among the processing routes. Are determined to be main processing paths which are main processing paths. In this way, the main processing route determination unit 16 selects a processing route in which the number of appearance of the actual route associated with the processing route by the route association unit 15 is equal to or greater than the predetermined threshold among the processing routes. Is determined. Thereby, it is possible to extract a processing path having a high appearance frequency in an actual business.

  The assumed operation condition extraction unit 17 extracts the execution condition of the main process path determined by the main process path determination unit 16 as the assumed operation condition 19. Then, the assumed operation condition extraction unit 17 outputs information indicating the extracted assumed operation condition 19.

  According to such a computer 10, the actual route information including the actual route indicating the route of the data set update processing and the number of appearances of the actual route is generated by the actual route extraction means 12. Next, the processing path extraction unit 14 extracts the processing path from the program definition information, and generates processing path information indicating a read process and a write process for the data set, and an execution condition for each processing path. Then, the route association means 15 associates the actual route information with the processing route information. Thereafter, the main processing path determination unit 16 determines that the processing path associated with the actual path whose number of appearances is equal to or greater than a predetermined threshold is the main processing path. Then, the set of execution conditions for the processing path determined as the main processing path is set as the assumed operation condition by the assumed operation condition extraction unit 17, and information indicating the assumed operation condition 19 is output.

  As a result, it is possible to automatically extract an assumed operation condition that is important for the performance of the business. Therefore, a system administrator or the like can efficiently prevent an adverse effect on a main business by performing the operation so as to satisfy the extracted assumed operation condition during the operation and maintenance of the computer system. In this way, the system administrator or the like is one of the criteria that must be satisfied for the normal operation of the business system 20 during the operation or maintenance work of the computer system. By adopting and modifying the program, it is possible to improve the efficiency of the operation and maintenance work of the computer system.

Hereinafter, the present embodiment will be described in detail with reference to the drawings.
FIG. 2 is a diagram showing a system configuration of the present embodiment. The assumed operation condition analysis system of this embodiment analyzes the update information of the table output by the database management system and the program definition information that defines the program executed by the business server, and the assumed operation condition of the program (hereinafter, simply referred to as the program operation information). "Assumed operating condition") is automatically extracted.

  The assumed operation condition analysis system according to the present embodiment includes the assumed operation condition analysis apparatus 100, business servers 200a and 200b, database servers 300a, 300b, and 300c, and a network 60. The assumed operating condition analysis apparatus 100, the business servers 200a and 200b, and the database servers 300a, 300b, and 300c are connected to the network 60 and can communicate with each other.

  In the business servers 200a and 200b, application programs are executed. For example, the business server 200a executes an inventory management program, and the business server 200b executes an order management program. Application programs executed by the business servers 200a and 200b access the database servers 300a, 300b, and 300c through the network 60 as necessary, and use data managed by the database servers 300a, 300b, and 300c.

  In each of the database servers 300a, 300b, and 300c, a database management system is executed. The database management system manages data used by application programs executed on the business servers 200a and 200b. The database management system manages data in a table format, and performs data search and update processing in response to requests from application programs. Here, when data update processing is executed, the database management system outputs update information to a log file. The log file is managed by each database server 300a, 300b, 300c.

  The assumed operating condition analysis apparatus 100 acquires log files through the network 60 from the database servers 300a, 300b, and 300c. Then, the assumed operating condition analysis apparatus 100 automatically extracts main assumed operating conditions by analyzing the update information described in the acquired log file.

  In the present embodiment, the assumed operation condition analysis device 100 is provided as a device for realizing the assumed operation condition generation function. However, the assumed operation condition analysis device 100 has any of the functions of the database servers 300a, 300b, and 300c. It can also be realized on a server. It is also possible to realize the function of the assumed operating condition analysis apparatus 100 on any one of the business servers 200a and 200b.

  Next, the hardware configuration of the assumed operating condition analysis apparatus 100, the business servers 200a and 200b, and the database servers 300a, 300b, and 300c will be described. However, since the assumed operating condition analysis apparatus 100, the business servers 200a and 200b, and the database servers 300a, 300b, and 300c can be realized by the same hardware configuration, the assumed operating condition analysis apparatus 100 will be described below as a representative.

  FIG. 3 is a diagram illustrating a hardware configuration of the assumed operation condition analysis apparatus. The assumed operation condition analysis apparatus 100 is controlled by a CPU (Central Processing Unit) 101 as a whole. A random access memory (RAM) 102, a hard disk drive (HDD) 103, a graphic processing device 104, an input interface 105, and a communication interface 106 are connected to the CPU 101 via a bus 107.

  The RAM 102 temporarily stores at least part of an OS program and application programs to be executed by the CPU 101. The RAM 102 stores various data necessary for processing by the CPU 101. The HDD 103 stores an OS program and application programs.

  A monitor 50 is connected to the graphic processing device 104. The graphic processing device 104 displays an image on the screen of the monitor 50 in accordance with a command from the CPU 101. A keyboard 41 and a mouse 42 are connected to the input interface 105. The input interface 105 transmits signals sent from the keyboard 41 and the mouse 42 to the CPU 101 via the bus 107. The communication interface 106 is connected to the network 60.

With the hardware configuration as described above, the processing functions of the present embodiment can be realized.
Next, the field configuration of the tables stored in the database servers 300a, 300b, and 300c of this embodiment will be described.

FIG. 4 is a diagram showing fields included in the table. The field configuration table 311 is a table showing fields included in the table of the present embodiment.
An item 311a indicating a table name in the field configuration table 311 indicates names (DB1 to DB7) of tables (see FIG. 8) stored in the database servers 300a, 300b, and 300c in the business system according to the present embodiment. An item 311b indicating a field name in the field configuration table 311 indicates the name of a field constituting the table. The table of the present embodiment is composed of fields as shown in the figure.

Next, the module configuration of the assumed operating condition analysis apparatus 100 will be described.
FIG. 5 is a block diagram illustrating functions of the assumed operating condition analysis apparatus. The assumed operation condition analysis apparatus 100 includes an update information storage unit 110, a performance route information storage unit 120, a program definition information storage unit 130, a processing route information storage unit 140, and an assumed operation condition storage unit. Further, the assumed operation condition analysis apparatus 100 includes an update information acquisition unit 161, a result route extraction unit 162, a program definition information acquisition unit 171, a processing route extraction unit 172, a route association unit 183, a main processing route determination unit 184, and main processing. A path connection unit 185, an assumed operation condition extraction unit 186, and an assumed operation condition output unit 187 are included.

  The update information acquisition unit 161 and the program definition information acquisition unit 171 can communicate with the business servers 200 and 200b and the database servers 300a, 300b, and 300c via the network 60. The actual result route extraction unit 162, the processing route extraction unit 172, the main processing route determination unit 184, the main processing route connection unit 185, and the assumed operation condition extraction unit 186 can receive input from the user through the keyboard 41 and the mouse 42. . Further, the assumed operation condition output unit 187 can output information related to the assumed operation condition such as assumed operation condition display information for displaying the processing result on the screen of the monitor 50.

  The update information storage unit 110 stores update information output from the database management system. The update information is created every time one table is updated. Specifically, the table update process is one of record addition, update, and deletion. One or more tables are updated by one data update process by the application program. The update information includes identification information that uniquely identifies the data update process, the table name of the updated table, the update time, and the field name. Here, the identification information of the data update process is, for example, a transaction ID or an ID explicitly given by the program. The field name is a name of a takeover field (see FIG. 4) that constitutes the database and is taken over by the data update process.

Here, “handover of field” means that a value is transferred from one field to another field between fields constituting different tables.
The actual route information storage unit 120 stores the actual route generated by the actual route extraction unit 162 and the number of appearances of the actual route. The actual result path is defined as the table update order in the data update process executed in the business system. For example, a combination of two tables that are continuously updated and that is composed of tables “table A”, “table B”, and “table C” means an actual result path. This is because, in a computer system used in business, it is considered that the data update order most closely reflects the flow of business. In the actual route information storage unit 120, the number of appearances of the actual route is associated with the actual route and stored as actual route information.

  The program definition information storage unit 130 stores program definition information that is acquired by the program definition information acquisition unit 171 and defines program processing executed by the business server. As described above, the program definition information is, for example, source code, object code, or a flowchart.

  The processing route information generated by the processing route extraction unit 172 is stored in the processing route information storage unit 140. The processing path information indicates the execution conditions, the table to be read, and the table to be written for each of the decomposed processing paths by disassembling the contents of the program processing defined by the program definition information into one or more processing paths. The processing path sequentially indicates a series of processes executed from the start to the end of the business system program, and will be described in detail later with reference to FIG.

  In the processing path information storage unit 140, the processing path execution condition, the table to be read, and the table to be written are associated with the processing path and stored as processing path information. It is assumed that the program according to the present embodiment includes a table reading process and a writing process, and the table writing process is always executed at the end of the program process. When there are a plurality of write processes in a series of processes, the above assumption can be satisfied by assuming that a plurality of processes are being executed.

  The assumed operation condition storage unit 150 stores the assumed operation condition extracted by the assumed operation condition extraction unit 186. The assumed operation condition is composed of execution conditions of main processing paths during actual business operation.

  The update information acquisition unit 161 periodically accesses the database servers 300a, 300b, and 300c at predetermined time intervals, and acquires log files managed by the database servers 300a, 300b, and 300c, respectively. Then, the update information storage unit 110 determines whether the acquired log file has update information newly added since the previous acquisition. The presence or absence of new update information is determined by comparing the previous log file acquisition time with the update time in the update information. When there is new update information, the update information acquisition unit 161 extracts the update information from the log file and adds it to the update information storage unit 110.

  When the result route extraction unit 162 receives the result route extraction instruction by the input from the user, the result route extraction unit 162 analyzes the update information stored in the update information storage unit 110, and the relationship between the two data sets that are continuously updated. A certain performance route is extracted. Specifically, the actual route extraction unit 162 updates the table names of the two tables continuously updated by the data update process for each data update process from the update information stored in the update information storage unit 110. A track record arranged in the order of early time is extracted. Next, the actual route extraction unit 162 calculates the number of appearances of the same actual route. Then, the actual route extraction unit 162 creates actual route information that associates the actual route with the number of appearances of the actual route.

  The program definition information acquisition unit 171 is stored in the business server to be executed, and is acquired by the program definition information acquisition unit 171 via the network 60. The program definition information is not limited to this, and the program definition information is obtained by reading information stored in a computer-readable storage device such as a magnetic recording device, an optical disc, a magneto-optical recording medium, or a semiconductor memory. It may be configured to input from the unit 171.

  The processing path extraction unit 172 analyzes the program definition information stored in the program definition information storage unit 130, and decomposes the program processing defined by the program definition information for each processing path. Then, the processing path extraction unit 172 creates processing path information indicating the execution condition for each decomposed processing path, the read process and the write process for the table executed in each process path, and the field name to be taken over.

  Based on the actual route information extracted by the actual route extraction unit 162 and the processing route information extracted by the processing route extraction unit 172, the route association unit 183 matches the table that is the starting point and the table that is the target of the reading process. In addition, the result path and the processing path in which the table as the end point and the table as the target of the writing process match are associated with each other. Specifically, the path association unit 183 compares the table name read in the actual path and the table name read in the processing path, and compares the table name written in the actual path and the table name written in the processing path. To do. Then, the path association unit 183 associates the result path and the processing path in which both the table name to be read and the set of the table name to be written match.

  The data content acquisition unit 198 acquires the content of data included in the tables stored in the database servers 300a, 300b, and 300c via the network 60. Specifically, the contents of the table are acquired.

The takeover item specifying unit 199 specifies a field to be taken over in the table that is the start point and end point of the actual result path from the contents of the table acquired by the data content acquisition unit 198.
Then, the route association unit 183 has a case where a plurality of processing routes exist as candidates for association with respect to one actual route, so that the actual route information and the processing route information cannot be associated with only the table name. In addition to the table name match, the actual route information and the processing route information are obtained by matching the field name to be taken over specified by the takeover item specifying unit 199 and the table name specified by the processing route extracting unit 172. Associate. By this association, the execution condition of the processing path is linked to the number of appearances of the actual path.

  Based on the number of appearances calculated by the performance route extraction unit 162, the main processing route determination unit 184 selects a processing route associated with a performance route having a high appearance frequency during actual operation of the business system from the processing routes. The main processing path is determined as the main processing path. Thereby, it is possible to extract a processing path having a high appearance frequency in an actual business.

  Note that the main processing path determination unit 184 uses the number of appearances of the actual paths associated with the processing path as the estimated frequency of the processing path, and sets a processing path whose estimated frequency is equal to or higher than a preset threshold value in the job. Considering that the processing path has a high execution frequency, the main processing path is determined.

  Here, in the present embodiment, the execution frequency of the processing path is used as the estimated frequency. This is due to the following reason. In this embodiment, in which the assumed operating conditions are extracted only from information that is normally observed from the outside without changing the internal program processing, the actual execution frequency of the processing path cannot be obtained. The number of occurrences is used. However, the performance route and the processing route do not necessarily correspond one-on-one. For this reason, when a plurality of processing paths correspond to one actual path, it is impossible to accurately distribute the number of appearances of the actual paths to the plurality of processing paths. By determining the frequency of occurrence.

  As described above, in the present embodiment, strict accuracy is not guaranteed without modifying the inside of the business system, but the execution frequency of the processing path can be estimated with a certain probability.

  The threshold value may be, for example, a fixed integer value representing the number of appearances, or may be a value calculated by a predetermined calculation formula such as an average value of the number of appearances of all the actual paths. In addition, a processing route in which the number of appearances of the corresponding actual route is in a certain ratio from the top of the cumulative value of the number of appearances may be determined as the main processing route without using the threshold value.

  The main processing path connecting unit 185 connects the main processing paths determined by the main processing path determining unit 184 based on the actual path information. Then, the main processing path connection unit 185 creates linked main processing path information indicating the connected main processing paths.

  The assumed operation condition extraction unit 186 extracts the execution condition of the main process path determined by the main process path determination unit 184 as an assumed operation condition for each program. Then, the assumed operation condition extraction unit 186 stores the extracted assumed operation condition for each program in the assumed operation condition storage unit 150. Based on the assumed operating conditions for each program, the assumed operating conditions for each program can be easily grasped.

  Further, the assumed operation condition extraction unit 186 obtains the execution condition of the connected main process path indicated by the connected main process path information from the execution condition of the main process path determined by the main process path determination unit 184, and the assumed connection operation condition. Extract as Then, the assumed operation condition extraction unit 186 stores the extracted assumed connection operation condition in the assumed operation condition storage unit 150. With this assumed connection operation condition, it is possible to easily grasp the assumed operation condition at the time of execution of a series of operations including a plurality of continuous processes.

  The assumed operation condition output unit 187 outputs the assumed operation condition for each program stored in the assumed operation condition storage unit 150 and the assumed operation condition information indicating the assumed connection operation condition. Thereby, it is possible to display, analyze, and store the assumed operation condition outside the assumed operation condition analyzer 100.

  Further, the assumed operation condition output unit 187 outputs assumed operation condition display information for displaying a figure showing the assumed operation condition for each program stored in the assumed operation condition storage unit 150 and the assumed connection operation condition. Thereby, for example, a diagram showing the assumed operating condition can be displayed on the monitor 50 connected to the assumed operating condition analyzing apparatus 100.

  In the present embodiment, the update information acquisition unit 161 periodically accesses the database servers 300a, 300b, and 300c. However, there is an instruction from the user to analyze the assumed operating conditions or to extract the actual route. At this time, the database servers 300a, 300b, and 300c may be accessed.

The update information storage unit 110 has an update information table 111 that represents a list of update information.
FIG. 6 is a diagram illustrating a data structure example of the update information table. In the update information table 111, update information is stored as a table for each update process of one table. The update information table 111 includes an item 111a indicating a process ID, an item 111b indicating a table name, an item 111c indicating a field name of a takeover field, and an item 111d indicating an update time. Information arranged in the horizontal direction of each field is associated with each other to form update information.

  In the item 111a, an identification number for uniquely identifying the data update process is set. As the processing ID, for example, a transaction ID can be used. In this case, the database management system executed by the database servers 300a, 300b, and 300c may cooperate to give a unique transaction ID for each data update process and include the transaction ID in the update information. Alternatively, the application program executed on the business servers 200a and 200b may set a unique identification number for each data update process, and the database management system may include this identification number in the update information.

  In the item 111b, zero or more table names of tables updated by the data update process indicated by the process ID set in the item 111a are set. In the item 111c, the field name of the takeover field taken over by the data update process is set. In the item 111d, the time when the table having the table name set in the item 111b is updated by the data update process indicated by the process ID set in the item 111a is set.

The update information stored in the update information table 110a is registered by the update information acquisition unit 161.
The track record information storage unit 120 has a track record table 121 representing a list of track record information.

  FIG. 7 is a diagram illustrating an example of the data structure of the result route table. In the actual route table 121, actual route information is stored in a table for each actual route. The actual path table 121 includes an item 121a indicating the actual path number (No), an item 121b indicating the table name of the table serving as the starting point of the process, an item 121c indicating the table name of the table serving as the end point of the process, and the appearance of the actual path An item 121d indicating the number and an item 121e indicating the takeover field name are provided. Information arranged in the horizontal direction of each field is associated with each other to constitute the actual route information.

  In the item 121a, an actual route number representing the actual route is set. In the item 121b, a table name as a starting point of processing is set. In the item 121c, a table name that is the end point of the process is set. In the item 121d, an integer value representing the number of appearances of each track record is set as the frequency. That is, the number of times that the data update process along the performance route has been executed is set. In the item 121e, the field name (FIG. 4) of the takeover field taken over in the actual result route is set.

The actual route information stored in the actual route table 121 is registered by the actual route extraction unit 162.
Next, the actual route map displayed on the monitor 50 by the actual route extraction unit 162 will be described.

  FIG. 8 is a diagram illustrating a display example of a track record diagram. The actual route diagram display screen 52 is a screen displayed on the monitor 50 by the output from the actual route extraction unit 162. The actual route diagram display screen 52 displays one actual route diagram representing all the actual routes.

  The actual route diagram display screen 52 describes nodes 321a to 321f indicating all tables (DB1 to DB7) on which update processing is executed in the business system. In the actual route diagram display screen 52, an arrow line indicating the order relationship of the table update processing is described between the nodes indicating the table. For example, an arrow line from the node 321b to the node 321d means that there is an actual result path for executing the update process of the node 321d following the update process of the node 321b.

When a plurality of arrow lines are output from one node, this means that any one of the arrow destination processes is executed after the arrow source process.
For example, the arrow lines from the node 321a to the node 321b and the node 321c indicate the update process of the table (DB2) indicated by the node 321b, the update process of the table (DB2) indicated by the node 321b, and the table ( It means that any one of the update processing of DB3) is executed.

In this way, the sequential relationship of the processing in the actual route is expressed as one diagram by a series of arrow lines connecting the nodes.
Next, an example of the structure of a program executed on the business server according to this embodiment will be described.

FIG. 9 is a diagram illustrating an example of the structure of a program.
As shown in the figure, flowcharts 131a to 131e (PG1 to PG5) of programs for executing the database update processing of the present embodiment are started from execution of a SELECT (search) statement of SQL (Structured Query Language). The structure ends after execution of an INSERT (insert) statement, an UPDATE (update) statement, or a DELETE (delete) statement.

  In addition, the INSERT statement, the UPDATE statement, and the DELETE statement, which are processes in which data is written to the table by one execution of the program, are processed only once and only one of them is processed. . Program definition information that defines this program is acquired by the program definition information acquisition unit 171 and stored in the program definition information storage unit 130.

Next, the extraction result of the processing path of the program executed in the database management system 300a, 300b, 300c of this embodiment will be described.
FIG. 10 is a diagram illustrating a data structure example of the processing path table.

  When the processing path information is extracted from the program definition information by the processing path extraction unit 172, the processing path information is tabulated for each processing path and stored in the processing path table 141 and stored in the processing path information storage unit 140. Remembered.

  The processing path table 141 includes an item 141a indicating a processing path number (No), an item 141b indicating a program for realizing the processing path, and an item 141c indicating a table name of a table to be read first in the processing path. , An item 141d indicating an instruction to be executed in the table, an item 141e indicating a field name read from the table, an item 141f indicating a table name to be written at the end of the processing path, and an instruction to be executed in the table An item 141g indicating a field name to be written in the table, an item 141i indicating a field name inherited by the processing path, and an item 141j indicating an execution condition of the processing path. Information arranged in the horizontal direction of each field is associated with each other to form processing path information.

  In the item 141a, a processing path number representing a processing path is set. In the item 141b, the program name from which the processing path is extracted is set. In the item 141c, the name of the table on which the reading process is performed is set. In the item 141d, an instruction to be executed in the reading process is set. For example, an SQL SELECT instruction is set. In the item 141e, a field name (FIG. 4) read in the reading process is set.

  In the item 141f, a table name of a table to be written is set. In the item 141g, an instruction to be executed in the writing process is set. For example, one of an SQL INSERT instruction, an UPDATE instruction, and a DELETE instruction is set. In the item 141h, a field name (FIG. 4) to be written in the writing process is set. In the item 141i, the field name (FIG. 4) of the takeover field to be taken over in the reading process and the writing process is set. In the item 141j, an execution condition for normally processing the processing path is set.

The processing route information stored in the processing route table 141 is registered by the processing route extraction unit 172.
Next, details of processing executed in the system having the above-described configuration and data structure will be described. First, a process for analyzing update information and extracting a performance path will be described.

FIG. 11 is a flowchart showing the procedure of the performance route extraction process. In the following, the process illustrated in FIG. 10 will be described in order of step number.
[Step S <b> 11] Upon receiving an instruction to generate a result route, the result route extraction unit 162 arranges all the update information stored in the update information storage unit 110 based on the process ID.

  [Step S12] The actual result route extraction unit 162 arranges a plurality of pieces of update information having the same process ID in order of earlier update time. Then, the track record extraction unit 162 creates a table sequence in which table names are arranged in order of update time for each process ID.

  [Step S13] The actual result route extraction unit 162 totals all the table columns created in Step S12. That is, the number of identical table columns is calculated. The value calculated here is the number of appearances of each table column.

  [Step S14] The actual result path extraction unit 162 extracts a combination of two tables that are continuously updated (hereinafter referred to as a table set) from all the table columns created in Step S13. Then, the number of appearances of the extracted table set is totaled from the number of appearances of the table row totaled in step S13. That is, the number of identical table sets that are continuously updated is calculated. The value calculated here is the number of appearances of the actual route represented by each table set. Then, the actual route extraction unit 162 stores the total result in the actual route information storage unit 120.

  Specifically, for example, a table column updated in the order of “table A → table B → table C” and a table column updated in the order of “table A → table B → table D” are created in step S12. In this case, the table sets extracted in step S14 are “table A → table B”, “table B → table C”, and “table B → table D”. This table set is extracted as a track record.

  Further, for example, when the number of occurrences of the table row calculated in step S13 is 100 for “table A → table B → table C” and 200 for “table A → table B → table D”, in step S14 The numbers of appearances of the result paths calculated are 300 for “table A → table B”, 100 for “table B → table C”, and 200 for “table B → table D”. This is the number of appearance of the actual route.

  In this way, the actual route extraction unit 162 creates a table sequence for each data update process using the update information stored in the update information storage unit 110. Next, the track record extraction unit 162 totals all the created table columns. Next, the actual route extraction unit 162 extracts the actual route from all the created table columns. Then, the actual route extraction unit 162 aggregates the extracted actual routes and identifies each actual route and the number of appearances thereof.

Next, processing for decomposing program definition information and extracting processing paths will be described.
12 and 13 are flowcharts showing the procedure of the processing path extraction process. Hereinafter, the processing illustrated in FIGS. 12 and 13 will be described in order of step number.

  [Step S21] The processing path extraction unit 172 analyzes the syntax tree structure of the program processing executed in the business system from the program definition information stored in the program definition information storage unit 130.

[Step S <b> 22] The processing path extraction unit 172 acquires command statements executed by program processing in order from the top of the analyzed syntax tree.
[Step S23] If the command statement acquired from the syntax tree indicates the end of the program processing, the processing path extraction unit 172 advances the processing to step S26. On the other hand, if the command sentence acquired from the syntax tree does not indicate the end of the program process, the process proceeds to step S24.

  [Step S24] If the command sentence acquired from the syntax tree inherits the variable, the processing path extraction unit 172 advances the processing to step S25. On the other hand, if the command sentence acquired from the syntax tree does not inherit the variable, the process proceeds to step S28 (FIG. 13). Examples of variables that are inherited include those based on stored data values such as tables, input data values by an operator, and output data values of other processes.

[Step S25] The processing path extraction unit 172 holds the contents of the inherited variables.
[Step S <b> 26] The processing path extraction unit 172 outputs processing path information indicating the held processing path. The output processing path information is stored in the processing path information storage unit 140.

  [Step S27] If there is a branch that has not yet been selected, the processing path extraction unit 172 advances the processing to step S22. On the other hand, if there is no branch that has not been selected, the process is terminated.

  [Step S28] If the command sentence acquired from the syntax tree indicates a process of reading from the table, the processing path extraction unit 172 advances the process to step S31. On the other hand, if the command sentence acquired from the syntax tree does not indicate a process of reading from the table, the process proceeds to step S29.

  [Step S29] If the command sentence acquired from the syntax tree indicates a process of writing to the table, the processing path extraction unit 172 advances the process to step S31. On the other hand, if the imperative sentence acquired from the syntax tree does not indicate a process of writing in the table, the process proceeds to step S30.

  [Step S30] If the instruction sentence acquired from the syntax tree is a conditional branch, the processing path extraction unit 172 advances the processing to step S31. On the other hand, if the instruction sentence acquired from the syntax tree is not a conditional branch, the process proceeds to step S22 (FIG. 12).

  [Step S31] The processing path extraction unit 172 reads the contents of the statement list of the process that has been passed through (the table that has been read and written, the field name that has been read and written, and the inherited field name), or the statement statement list that has passed through the conditional branch. Is stored as part of the processing path information. Thereafter, the processing path extraction unit 172 advances the processing to step S22 (FIG. 12).

The processing path extraction unit 172 executes the above processing for all programs.
In this way, the processing path extraction unit 172 is executed in accordance with the execution condition for each processing path and each processing path from the statement of the syntax tree indicated in the program definition information stored in the program definition information storage unit 130. Processing path information indicating a field name to be inherited and a read process and a write process for the table to be created.

Next, a process for associating a performance route with a processing route will be described.
14, FIG. 15, and FIG. 16 are flowcharts showing the procedure of the route association processing. Hereinafter, the processes illustrated in FIGS. 14, 15, and 16 will be described in order of step number.

  [Step S <b> 41] The path association unit 183 sequentially selects the processing paths extracted by the processing path extraction unit 172 based on the processing path information stored in the processing path information storage unit 140.

  [Step S42] If the processing of all the extracted processing paths has been completed, the path association unit 183 advances the process to step S49 (FIG. 16). On the other hand, if all the extracted processing paths have not been processed, the process proceeds to step S43.

  [Step S43] If the selected processing path includes a table (input table) in which read processing is performed and a table (output table) in which write processing is performed (step S43), the path association unit 183 performs processing. Proceed to S44. On the other hand, if there is no input table and output table in the selected processing path, the process proceeds to step S41.

[Step S44] The route association unit 183 sequentially selects the processing route input table.
[Step S45] The route association unit 183 compares the set of the input table and output table of the processing route with the set of the start table and the end table of the actual route, and if there is a match, the process proceeds to step S46. Proceed. On the other hand, if there is no match with the combination of the starting table and the ending table of the actual route as compared with the combination of the input table and output table of the processing route, the process proceeds to step S47.

[Step S46] The route association unit 183 associates the processing route and the actual route that match the set of tables.
[Step S47] Since there is no set of tables corresponding to the actual route, the route association unit 183 sets “no corresponding actual route” to the processing route without associating the actual route.

  [Step S48] If the process based on the selection of all the input tables has been completed, the path association unit 183 advances the process to Step S41. On the other hand, if the process based on the selection of all the extracted input tables has not been completed, the process proceeds to step S44.

[Step S49] The route association unit 183 sequentially selects processing routes associated with the actual route.
[Step S50] If there is a plurality of input tables in the processing route and a plurality of actual routes are associated with the processing route, the route association unit 183 advances the processing to step S51. On the other hand, if only one performance route is associated with the processing route, the process proceeds to step S52.

  Here, as an example of a processing path having a plurality of input tables, there is PG1 (program 131a in FIG. 9, PG1_2 and PG1_3 in the processing path table 141 in FIG. 10). In PG1, depending on the conditional branching, there is a case where data is read from DB1 and DB2 and data is written to DB3 (PG1_2) or DB4 (PG1_4). In such a case, since two input tables exist in one processing route, there are cases where two performance routes are associated with each other.

  [Step S51] When a plurality of actual paths are associated with one processing path as described above, the path association unit 183 combines the plurality of actual paths into one actual path.

  [Step S52] If all the associated processing paths have been selected, the path association unit 183 advances the process to step S53 (FIG. 16). On the other hand, if there is any associated processing path that is not selected, the process proceeds to step S49.

[Step S <b> 53] The route association unit 183 sequentially selects the actual route associated with the processing route.
[Step S54] If there is a pair of the same input table and output table in different processing routes and a plurality of processing routes are associated with the actual route, the route association unit 183 advances the processing to step S55. On the other hand, if only one processing path is associated with the actual path, the process proceeds to step S56.

  [Step S55] When a plurality of processing paths are associated with one actual path as described above, the path association unit 183 determines that the actual path and the handover field included in the processing path match each other. It is specified as a processing route associated with the route.

  As described above, the route association unit 183 may associate the actual route information and the processing route information with only the table name because a plurality of processing routes exist as candidates for association with one actual route. In the case where it is not possible, in addition to the matching of the table name, the actual route information and the processing are performed by matching the field name to be taken over specified by the takeover item specifying unit 199 and the table name specified by the processing route extracting unit 172. Correlate with route information.

Here, a process in which the takeover item specifying unit 199 specifies a field that has been taken over in the actual result path will be described.
The takeover item specifying unit 199 specifies a field to be taken over in the table that is the start point and end point of the actual result path from the contents of the table acquired by the data content acquisition unit 198. At this time, the succeeding item specifying unit 199 compares the data stored in the fields of the two tables, and transcribes the fields having the most matching values from one table to the other table. I think that it was done.

  Further, based on the update log of the table, it is considered that the field is inherited from the update order on the actual result path to the update order from the previous update order. As a result, the takeover item specifying unit 199 specifies the field as the takeover field of the actual result route.

Note that the takeover field between the processing path input table and the output table is extracted by program analysis.
The route association unit 183 associates the inheritance field of the actual route thus identified with the takeover field of the processing route.

  [Step S56] If all the associated track records have been selected, the path association unit 183 advances the process to step S57. On the other hand, if there is a route that has not been selected among the associated performance routes, the process proceeds to step S54.

[Step S57] The route association unit 183 associates the associated processing route and the actual route based on the above processing results.
In this way, the route association unit 183 associates the processing route and the actual route from the processing route input table and output table, the actual route start point table and end point table, and the processing route and actual route takeover field.

Next, processing for determining whether or not the processing path is the main processing path will be described.
FIG. 17 is a flowchart illustrating a procedure of main processing path determination processing. In the following, the process illustrated in FIG. 17 will be described in order of step number.

[Step S <b> 71] The main processing route determination unit 184 sequentially selects processing routes associated with the actual route by the route association unit 183.
[Step S72] If the processing of all the associated processing routes has been completed, the main processing route determination unit 184 advances the processing to step S74. On the other hand, if the processing of all the associated processing paths has not been completed, the process proceeds to step S73.

[Step S <b> 73] The main processing path determination unit 184 calculates the estimation frequency of the processing path from the number of appearances of the associated actual path.
Here, in the present embodiment, the estimated frequency of the processing route is set as the estimated frequency of the number of appearances of the associated actual route. Further, when there are a plurality of actual routes associated with the processing route, the lowest value of the appearance numbers of the actual routes is set as the estimated frequency of the processing route.

  [Step S74] The main processing path determination unit 184 determines whether each processing path is a main processing path, which is a main processing path, based on the estimated frequency of the processing path. Then, the determination result is output as main processing path determination information 191 (FIGS. 20 and 21) to the main processing path connecting unit 185 and the assumed operation condition extracting unit 186.

  Here, as a method of evaluating the processing path estimation frequency for determining whether or not the processing path is the main processing path, a processing path whose estimation frequency is equal to or higher than a preset threshold is determined as the main processing path. To do. The threshold value may be, for example, a fixed integer value representing the number of appearances, or an average value of the number of appearances of all the actual paths. In addition, a processing route in which the number of appearances of the corresponding actual route is in a certain ratio from the top of the cumulative value of the number of appearances may be determined as the main processing route without using the threshold value.

  In this way, the main processing route determination unit 184 associates with the actual route having a high appearance frequency during the actual operation of the business system, among the processing routes, based on the number of appearances calculated by the actual route extraction unit 162. The determined processing path is determined as a main processing path which is a main processing path.

Next, processing for connecting processing paths determined to be processing paths as main processing paths will be described.
FIG. 18 is a flowchart illustrating a procedure of main processing path connection processing. In the following, the process illustrated in FIG. 18 will be described in order of step number.

[Step S81] The main processing path connection unit 185 sequentially selects the main processing paths determined by the main processing path determination unit 184.
[Step S <b> 82] The main processing path connection unit 185 ends the process if all the main processing paths have been processed. On the other hand, if all the main processing paths have not been processed, the process proceeds to step S83.

  [Step S <b> 83] The main processing path connection unit 185 acquires the actual path associated with the main processing path. Here, when a plurality of actual routes correspond to one main processing route, the actual routes combined in step S51 of the route association processing are acquired.

  [Step S <b> 84] The main processing path connecting unit 185 acquires a main processing path in which input / output of the table is continuous with the selected main processing path based on the continuation of the acquired actual paths. Here, the main processing path linking unit 185 selects the main processing path corresponding to the actual path using the starting point table of the actual path corresponding to the selected main processing path as the end point table, or the actual path corresponding to the selected main processing path. One main processing route corresponding to the actual route having the end point table as the starting point table is acquired. Note that, here, tables that have already been used for connection are excluded from the starting point table and the ending point table of the actual route corresponding to the main processing route to be acquired.

  [Step S85] The main processing path connection unit 185 connects the acquired main processing path to the selected main processing path. Then, the main processing path connection unit 185 creates linked main processing path information indicating the connected main processing paths.

In this way, the main processing path connecting unit 185 connects the main processing paths determined by the main processing path determining unit 184 based on the actual path information.
Next, a process for extracting an assumed operation condition will be described.

FIG. 19 is a flowchart illustrating the procedure of the assumed operation condition extraction process. In the following, the process illustrated in FIG. 19 will be described in order of step number.
[Step S91] The assumed operation condition extraction unit 186 assumes the execution condition (item 141j) of the processing path determined as the main processing path by the main processing path determination unit 184 from the processing path table 141 (FIG. 10). Extract as operating conditions. Then, the assumed operation condition extraction unit 186 stores the assumed program operation condition information indicating the extracted assumed operation condition for each program in the assumed operation condition table for each program 151 stored in the assumed operation condition storage unit 150.

  [Step S92] The assumed operation condition extraction unit 186 extracts, from the process route table 141, the logical product of the execution conditions of the process paths connected by the main process route connection unit 185 as the assumed connection operation condition. Then, the assumed operation condition extraction unit 186 stores the assumed connection operation condition information indicating the extracted assumed connection operation condition in the assumed connection operation condition table 152 stored in the assumed operation condition storage unit 150.

  In this way, the assumed operation condition extraction unit 186 extracts the execution condition of the main processing path determined by the main processing path determination unit 184 as the assumed operation condition for each program, and uses the extracted assumed operation condition for each program as the assumed operation. The condition is stored in the condition storage unit 150. Further, the assumed operation condition extraction unit 186 obtains the execution condition of the connected main process path indicated by the connected main process path information from the execution condition of the main process path determined by the main process path determination unit 184, and the assumed connection operation condition. And the extracted assumed connection operation condition is stored in the assumed operation condition storage unit 150.

Next, main processing path determination information will be described.
20 and 21 are diagrams illustrating examples of the data structure of main processing path determination information. The main processing path determination information 191 is output from the main processing path determination unit 184 and input to the main processing path connection unit 185 and the assumed operation condition extraction unit 186. Here, the main processing path determination information 191 is expressed in a table format for convenience. Further, since items 191a to 191j of the main processing path determination information 191 are the same as items 141a to 141j of the processing path table 141 (FIG. 10), description thereof is omitted here.

  The main processing route determination information 191 includes, in addition to the above-described fields, an item 191k indicating the actual route associated with the processing route, an item 191m further specifying the actual route associated with the processing route, and the estimated frequency of the processing route. And an item 191p indicating the result of main processing path determination are provided. Information arranged in the horizontal direction of each field is associated with each other to form processing path information.

  In the item 191k, the actual route name associated with the processing route is set. In the item 191m, as a result of rearranging what is not one-to-one correspondence by the route association unit 183 among the actual routes associated with the processing route, the associated actual route name is set. In the item 191n, the estimated frequency of the processing path calculated by the main processing path determination unit 184 is set. In the item 191p, a determination result by the main processing path determination unit 191p of the processing path is set.

  Note that “none” of the item 191m set in the area 191s indicates that there is no actual result path corresponding to the program number “PG5_2”. In addition, “−” set in the item 191m of the area 191r indicates that the correspondence relationship of the table performance path 1 indicated by the item 191k to be associated with the program number “PG2_1” is the program. It is specified as No “PG1_1” and indicates that there is no track record corresponding to “PG2_1”.

The main processing path determination information 191 is output by the main processing path determination unit 184 to the main processing path connection unit 185 and the assumed operation condition extraction unit 186.
Next, the assumed operation condition stored in the assumed operation condition storage unit 150 by the assumed operation condition extraction unit 186 will be described.

  FIG. 22 is a diagram illustrating an example of the data structure of the assumed operating condition table for each program. The program-specific assumed operation condition table 151 stores the program-specific assumed operation conditions in a table for each processing path. The assumed operating condition table 151 by program includes an item 151a indicating the number (No) of the processing path, an item 151b indicating a program including the processing path, and an item indicating the table name of the table on which input processing is performed in the processing path. 151c, an item 151d indicating the table name of the table for which output processing is performed in the processing path, an item 151e indicating the execution condition of the processing path, and an item 151f indicating the determination result of the main processing path determination of the processing path are provided. ing. Information arranged in the horizontal direction of each field is associated with each other, and constitutes an assumed operation condition for each program.

  In the item 151a, the number of the processing path analyzed from the program definition information is set. In the item 151b, the program name from which the processing path is extracted is set. In the item 151c, a table name of a table on which input processing is performed in the processing path is set. In the program processing of this embodiment, the number of input tables is not necessarily one for one processing path.

  In the item 151d, a table name of a table in which output processing which is the last processing in the processing path is performed is set. In the program processing of the present embodiment, there is always one output table for each processing path. In the item 151e, an execution condition for the processing path is set. In the item 151f, a determination result of main processing path determination of the processing path is set.

The assumed operation condition for each program stored in the assumed operation condition table for each program 151 is registered by the assumed operation condition extraction unit 186.
As a result, a system administrator or the like can easily grasp the main processing path for each program and the assumed operating conditions for each program that are the operating conditions of the main path.

  FIG. 23 is a diagram illustrating an example of the data structure of the concatenated assumed operation condition table. The assumed connection operation condition table 152 stores the assumed connection operation conditions for each main connection processing path. In the concatenated assumed operation condition table 152, an item 152a indicating the number (No) of the main connection processing path, an item 152b indicating the processing path constituting the main connection processing path, and an item indicating the execution condition of the main connection processing path. 152c is provided. Information arranged in the horizontal direction of each field is associated with each other to constitute a concatenated operation condition.

  In the item 151a, the number of the connected main processing path connected by the main processing path connecting unit 185 is set. In the item 152b, the number of the processing path constituting the connected main processing path is set. In the item 152c, the execution condition of the linked main processing path is set.

The assumed connection operation condition stored in the assumed connection operation condition table 152 is registered by the assumed operation condition extraction unit 186.
As a result, the system administrator or the like can grasp an assumed operation condition that needs to be satisfied in order to normally execute a series of main processes.

Next, an assumed operation condition diagram displayed by the assumed operation condition output unit 187 will be described.
FIG. 24 is a diagram illustrating a display example of an assumed operation condition diagram. Assumed Operating Condition FIG. 53 is a screen displayed on the monitor 50 by the output from the assumed operating condition output unit 187. The assumed operation condition diagram 53 displays one diagram representing all the connected main processing paths.

  In the assumed operation condition diagram 53, nodes 321a to 321f indicating all tables appearing in the actual result route are described. And these nodes 321a-321f are connected by the arrow line which shows the process path | route matched with the performance path | route. Further, in the assumed operation condition diagram 53, main processing paths 142a to 142d are shown. The main processing paths 142a to 142d are displayed by program names, and the arrow lines indicating the corresponding processing paths are emphasized boldly to form a connected main processing path. Also, in the assumed operation condition diagram 53, as the assumed operation condition, the execution condition of the connected main process path is illustrated so as to be associated with the main process path by the program name.

Thus, the system administrator can easily recognize the main processing path, the connected main processing path, and the assumed connection operation condition.
By using such an assumed operating condition analysis apparatus 100, the actual operation of the computer system is analyzed from the data access result that is the execution result of the computer system, the program processing path extracted by the program analysis, and the computer system By comparing the actual route restored from the data access result, the main processing route that is the processing route that is actually used frequently is identified among the processing routes on the program that realizes the business function of the computer system. Furthermore, it is possible to extract the execution condition of the main processing path and extract the assumed operation condition of the computer system program.

  As a result, it is possible to automatically extract the assumed operating conditions that are important for the performance of the work, and by using the assumed operating conditions of the computer system program, they were extracted during the operation and maintenance work of the computer system. By working so as to satisfy the assumed operating conditions, it is possible to efficiently prevent the occurrence of adverse effects on main business due to the work of the computer system.

(Modification of this embodiment)
Next, a modification of the present embodiment will be described.
In the modification of the present embodiment, part of the route association processing is different compared to the above-described embodiment. Therefore, only the configuration different from the above-described embodiment will be described here, and the same reference numeral is given to the same configuration as the present embodiment, and the description thereof is omitted.

  In the modification of the present embodiment, when a plurality of processing routes correspond to one actual route in the route association processing, the correspondence relationship is not automatically specified by the takeover field, and information on the plurality of corresponding processing routes is displayed. Display and accept input for specifying the correspondence.

In the modification of the present embodiment, the actual route information storage unit 120 has an actual route table 122 that represents a list of actual route information.
FIG. 25 is a diagram illustrating an example of a data structure of a track record route table according to a modification of the present embodiment. In the actual route table 122, actual route information is stored in a table for each actual route. Since the field configuration of the actual result route table 122 of the modified example is the same as that of the actual result route table 121 (FIG. 7) of the present embodiment, description thereof is omitted here.

  In the actual result route table 122, an item 122e indicating a takeover field name is provided in the same manner as the actual result route table 122 of the present embodiment. However, as in the item 122e of the actual route No. “1”, the number of appearances is added without distinguishing the actual route in the takeover field, and the takeover field name is written together as “NO or TELM”.

In the item 121e, the field name (FIG. 4) of the takeover field taken over in the actual result route is set.
The actual route information stored in the actual route table 121 is registered by the actual route extraction unit 162.

Next, the route association processing according to this modification will be described.
FIG. 26 is the rear part of the flowchart showing the procedure of the route association processing according to the modification of the present embodiment. In the following, the process illustrated in FIG. 26 will be described in order of step number. Note that the route association processing of the present modification is the same as the flowchart showing the route association processing of the present embodiment because the front and middle portions are the same as the flowchart of the route association processing of the present embodiment. Descriptions of these figures (FIGS. 14 and 15) are omitted here.

[Step S <b> 201] The route association unit 183 sequentially selects the actual route associated with the processing route.
[Step S202] The route association unit 183 advances the processing to step S203 if there are pairs of the same input table and output table in different processing routes and a plurality of processing routes are associated with the actual route. On the other hand, if only one processing path is associated with the actual path, the process proceeds to step S204.

  [Step S203] When a plurality of processing paths are associated with one actual path as described above, the path association unit 183 displays such actual paths and processing paths, and displays a system administrator or the like. The input which specifies the correspondence of these track record paths and processing paths is accepted.

  At this time, the route association unit 183 causes the monitor 50 to display “actual route” and “a plurality of processing routes corresponding to the actual route”. Further, for example, the route association unit 183 displays the total result of the takeover field inherited in the actual route as “NO or TELM” in the item 122e of the actual route No “1” in FIG. Information for a specific judgment may be displayed.

  [Step S204] If all the associated track records have been selected, the path association unit 183 advances the process to step S205. On the other hand, if there is an unselected one of the associated track records, the process proceeds to step S202.

[Step S205] The route association unit 183 associates the associated processing route with the actual route based on the above processing results.
In this way, the path association unit 183 cannot associate one processing path with the actual path from the processing path input table and output table, and the actual path start point table and end point table. The fact and the corresponding route are displayed, and an input for specifying the correspondence is accepted. As a result, when the correspondence is complex and there are a plurality of processing routes for the actual route, the fact is presented to the administrator, etc., and the input specifying the correspondence by the administrator etc. is received, Even when there are a plurality of program processes that perform the same or similar processes, it is possible to flexibly cope with the extraction of the assumed operation conditions.

  Therefore, even if the correspondence relationship between the actual route and the processing route is complex, the assumed operation condition of the computer system program is used to satisfy this assumed operation condition during the operation and maintenance of the computer system. It is possible to work, and it is possible to reduce the occurrence of adverse effects on main business due to work of the computer system.

  As described above, the assumed operation condition analysis program, the assumed operation condition analysis apparatus, and the assumed operation condition analysis method of the present invention have been described based on the illustrated embodiment, but the present invention is not limited to this, and the configuration of each part Can be replaced with any structure having a similar function. Moreover, other arbitrary structures and processes may be added to the present invention. Further, the present invention may be a combination of any two or more configurations (features) of the above-described embodiments.

  The above processing functions can be realized by a computer. In that case, a program describing processing contents of functions that the assumed operating condition analysis apparatus 100 should have is provided. By executing the program on a computer, the above processing functions are realized on the computer. The program describing the processing contents can be recorded on a computer-readable recording medium. Examples of the computer-readable recording medium include a magnetic recording device, an optical disk, a magneto-optical recording medium, and a semiconductor memory. Examples of the magnetic recording device include a hard disk device (HDD), a flexible disk (FD), and a magnetic tape (MT). Examples of the optical disc include a DVD (Digital Versatile Disc), a DVD-RAM, a CD-ROM (Compact Disc Read Only Memory), and a CD-R (Recordable) / RW (ReWritable). Examples of the magneto-optical recording medium include an MO (Magneto-Optical disk).

  When distributing the program, for example, portable recording media such as a DVD and a CD-ROM on which the program is recorded are sold. It is also possible to store the program in a storage device of a server computer and transfer the program from the server computer to another computer via a network.

  A computer that executes the assumed operating condition analysis program stores, for example, a program recorded on a portable recording medium or a program transferred from a server computer in its own storage device. Then, the computer reads the program from its own storage device and executes processing according to the program. The computer can also read the program directly from the portable recording medium and execute processing according to the program. Further, each time the program is transferred from the server computer, the computer can sequentially execute processing according to the received program.

The main technical features of the embodiment described above are as follows.
(Supplementary note 1) In an assumed operating condition analysis program for analyzing an assumed operating condition of a program executed in a computer system,
Computer
Update information storage means for storing update information including a data set name and an update time of a data set updated by a program executed in the computer system;
Program definition information storage means for storing program definition information defining a processing procedure of a program executed in the computer system;
From the update information stored in the update information storage means, an actual path that is a relationship between two data sets that are continuously updated is extracted, and the data set that is the start point and end point of each actual path and the actual path Track record extraction means for generating track record information indicating the number of occurrences of
A processing path that extracts a processing path from the program definition information stored in the program definition information storage means, and indicates a reading process and a writing process for the data set executed in each processing path, and an execution condition of the processing path Processing path extraction means for generating information,
Based on the actual route information generated by the actual route extraction unit and the processing route information generated by the processing route extraction unit, the data set as a starting point coincides with the data set as a target of the reading process. And a route association means for associating the actual route with the processing route, wherein the data set as the end point and the data set to be written are matched.
Main processing path determination means for determining, as the main processing path, the processing path in which the number of appearances of the actual path correlated with the processing path by the path correlating means is a predetermined threshold or more among the processing paths;
The execution condition of the processing path determined as the main processing path by the main processing path determination unit is extracted, the set of the extracted execution conditions is set as the assumed operation condition, and information indicating the assumed operation condition is output. Assumed operating condition extraction means,
Assumed operating condition analysis program characterized by functioning as

  (Supplementary Note 2) The assumed operation condition extraction unit classifies the plurality of processing paths determined as the main processing paths into a set of processing paths to which the corresponding actual paths can be connected, and according to the classification result. The assumed operation condition analysis program according to appendix 1, wherein the execution condition is classified and output as information indicating the assumed operation condition.

(Supplementary note 3)
Data content acquisition means for acquiring the content of data included in the data set;
From the data content acquired by the data content acquisition means, a takeover item specifying means for specifying the data item to be taken over in the data set as the start point and the end point of the actual result route,
Function as
The processing path extraction unit specifies the data item of data to be inherited between the reading process and the writing process, and further includes the specified data item to generate the processing path information.
In addition to matching the data set, the route association unit matches the data item specified by the takeover item specifying unit and the data item included in the processing route information by the processing route extraction unit. As a condition, the actual result route and the processing route are associated with each other.
The assumed operating condition analysis program according to supplementary note 1, characterized by:

(Supplementary Note 4) Assumed operation condition output means for displaying assumed operation condition display information for displaying a figure showing the assumed operation condition in which the entire actual route is highlighted and the main processing route is highlighted. means,
Assumed operating condition analysis program according to appendix 1, characterized in that

(Supplementary Note 5) In an assumed operating condition analysis apparatus for analyzing an assumed operating condition of a program executed in a computer system,
Update information storage means for storing update information including a data set name and an update time of a data set updated by a program executed in the computer system;
Program definition information storage means for storing program definition information defining a processing procedure of a program executed in the computer system;
From the update information stored in the update information storage means, an actual path that is a relationship between two data sets that are continuously updated is extracted, and the data set that is the start point and end point of each actual path and the actual path An actual route extraction means for generating actual route information indicating the number of occurrences of
A processing path that extracts a processing path from the program definition information stored in the program definition information storage means, and indicates a reading process and a writing process for the data set executed in each processing path, and an execution condition of the processing path Processing path extraction means for generating information;
Based on the actual route information generated by the actual route extraction unit and the processing route information generated by the processing route extraction unit, the data set as a starting point coincides with the data set as a target of the reading process. And a route correlating means for associating the actual route with the processing route in which the data set as an end point and the data set as a target of the writing process match.
Main processing path determination means for determining, as a main processing path, the processing path in which the number of appearances of the actual path correlated with the processing path by the path correlating means is a predetermined threshold or more among the processing paths;
The execution condition of the processing path determined as the main processing path by the main processing path determination unit is extracted, the set of the extracted execution conditions is set as the assumed operation condition, and information indicating the assumed operation condition is output. Assumed operating condition extraction means;
An assumed operating condition analysis device characterized by comprising:

(Supplementary Note 6) In a method for analyzing an assumed operating condition by a computer for analyzing an assumed operating condition of a computer system program,
The actual route extraction means is continuously updated from update information update information including the data set name and update time of the data set updated by the program executed by the computer system stored in the update information storage means 2 The actual route that is the relationship between the two data sets is extracted, and the actual route information indicating the data set that is the start point and the end point of each actual route and the number of appearances of the actual route is generated. Processing definition is extracted from the program definition information program definition information defining the processing procedure of the program executed in the computer system stored in the program definition information storage means, and the reading process for the data set executed in each processing path; Generate processing path information indicating the write processing and the execution condition of the processing path,
The route association means is based on the actual route information generated by the actual route extraction means and the processing route information generated by the processing route extraction means, and the data set as the starting point and the target of the reading process A data set that matches and the data set that is the end point and the data set that is a target of the writing process are associated with the actual result path and the processing path;
The main processing path determination unit determines, as the main processing path, the processing path in which the number of appearances of the actual path correlated with the processing path by the path association unit is equal to or greater than a predetermined threshold among the processing paths. ,
The assumed operation condition extraction unit extracts the execution condition of the processing path determined as the main process path by the main process route determination unit, and sets the extracted execution condition as the assumed operation condition, and the assumed operation Output information indicating the condition,
An assumed operating condition analysis method characterized by the above.

It is a figure which shows the outline | summary of this Embodiment. It is a figure which shows the system configuration | structure of this Embodiment. It is a figure which shows the hardware constitutions of an assumption operating condition analysis apparatus. It is a figure which shows the field which a table comprises. It is a block diagram which shows the function of an assumption operating condition analyzer. It is a figure which shows the example of a data structure of an update information table. It is a figure which shows the example of a data structure of a track record route table. It is a figure which shows the example of a display of a track record route figure. It is a figure which shows the example of a structure of a program. It is a figure which shows the example of a data structure of a processing path table. It is a flowchart which shows the procedure of a track record extraction process. It is a flowchart (first half) which shows the procedure of a process path | route extraction process. It is a flowchart (latter half) which shows the procedure of a process path | route extraction process. It is a flowchart (front part) which shows the procedure of a path | route matching process. It is a flowchart (central part) which shows the procedure of a path | route corresponding | compatible process. It is a flowchart (rear part) which shows the procedure of a path | route matching process. It is a flowchart which shows the procedure of a main process path | route determination process. It is a flowchart which shows the procedure of the main process path | route connection process. It is a flowchart which shows the procedure of assumption operation condition extraction processing. It is a figure which shows the data structure example (first half) of main process path | route determination information. It is a figure which shows the data structure example (latter half) of main process path | route determination information. It is a figure which shows the example of a data structure of the assumption operation condition table classified by program. It is a figure which shows the example of a data structure of a connection assumption operation condition table. It is a figure which shows the example of a display of an assumption operating condition figure. It is a figure which shows the example of a data structure of the track record table of the modification of this Embodiment. It is a flowchart (rear part) which shows the procedure of the path | route corresponding | compatible process of the modification of this Embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Computer 11 Update information storage means 12 Actual route extraction means 13 Program definition information storage means 14 Processing path extraction means 15 Path correspondence means 16 Main processing path determination means 17 Assumed operation condition extraction means 19 Assumed operation conditions 21, 22, 23 Database Management system 21a, 22a, 23a Update information 25, 26, 27 Program 25a, 26a, 27a Program definition information

Claims (5)

In an assumed operating condition analysis program for analyzing an assumed operating condition of a program executed in a computer system,
Computer
Update information storage means for storing update information including a data set name and an update time of a data set updated by a program executed in the computer system;
Program definition information storage means for storing program definition information defining a processing procedure of a program executed in the computer system;
From the update information stored in the update information storage means, an actual path that is a relationship between two data sets that are continuously updated is extracted, and the data set that is the start point and end point of each actual path and the actual path Track record extraction means for generating track record information indicating the number of occurrences of
A processing path that extracts a processing path from the program definition information stored in the program definition information storage means, and indicates a reading process and a writing process for the data set executed in each processing path, and an execution condition of the processing path Processing path extraction means for generating information,
Based on the actual route information generated by the actual route extraction unit and the processing route information generated by the processing route extraction unit, the data set as a starting point coincides with the data set as a target of the reading process. And a route association means for associating the actual route with the processing route, wherein the data set as the end point and the data set to be written are matched.
Main processing path determination means for determining, as the main processing path, the processing path in which the number of appearances of the actual path correlated with the processing path by the path correlating means is a predetermined threshold or more among the processing paths;
The execution condition of the processing path determined as the main processing path by the main processing path determination unit is extracted, the set of the extracted execution conditions is set as the assumed operation condition, and information indicating the assumed operation condition is output. Assumed operating condition extraction means,
Assumed operating condition analysis program characterized by functioning as   The assumed operation condition extraction unit classifies the plurality of processing paths determined to be the main processing path into a set of processing paths to which the corresponding actual path can be connected, and executes the execution condition according to a classification result. 2. The assumed operation condition analysis program according to claim 1, wherein the information is output as information indicating the assumed operation condition. Said computer further
Data content acquisition means for acquiring the content of data included in the data set;
From the data content acquired by the data content acquisition means, a takeover item specifying means for specifying the data item to be taken over in the data set as the start point and the end point of the actual result route,
Function as
The processing path extraction unit specifies the data item of data to be inherited between the reading process and the writing process, and further includes the specified data item to generate the processing path information.
In addition to matching the data set, the route association unit matches the data item specified by the takeover item specifying unit and the data item included in the processing route information by the processing route extraction unit. As a condition, the actual result route and the processing route are associated with each other.
The assumed operating condition analysis program according to claim 1. In an assumed operation condition analyzer for analyzing an assumed operation condition of a program executed in a computer system,
Update information storage means for storing update information including a data set name and an update time of a data set updated by a program executed in the computer system;
Program definition information storage means for storing program definition information defining a processing procedure of a program executed in the computer system;
From the update information stored in the update information storage means, an actual path that is a relationship between two data sets that are continuously updated is extracted, and the data set that is the start point and end point of each actual path and the actual path Track record extraction means for generating track record information indicating the number of occurrences of
A processing path that extracts a processing path from the program definition information stored in the program definition information storage means, and indicates a reading process and a writing process for the data set executed in each processing path, and an execution condition of the processing path Processing path extraction means for generating information;
Based on the actual route information generated by the actual route extraction unit and the processing route information generated by the processing route extraction unit, the data set as a starting point coincides with the data set as a target of the reading process. And a route association means for associating the actual route with the processing route, wherein the data set as the end point and the data set as a target of the writing process match.
Main processing path determination means for determining, as a main processing path, the processing path in which the number of appearances of the actual path correlated with the processing path by the path correlating means is a predetermined threshold or more among the processing paths;
The execution condition of the processing path determined as the main processing path by the main processing path determination unit is extracted, the set of the extracted execution conditions is set as the assumed operation condition, and information indicating the assumed operation condition is output. Assumed operating condition extraction means;
An assumed operating condition analyzing apparatus characterized by comprising: In a method for analyzing an assumed operating condition by a computer for analyzing an assumed operating condition of a program of a computer system,
The actual route extraction means is continuously updated from update information update information including the data set name and update time of the data set updated by the program executed by the computer system stored in the update information storage means 2 The actual route that is the relationship between the two data sets is extracted, and the actual route information indicating the data set that is the start point and the end point of each actual route and the number of appearances of the actual route is generated. Processing definition is extracted from the program definition information program definition information defining the processing procedure of the program executed in the computer system stored in the program definition information storage means, and the reading process for the data set executed in each processing path; Generate processing path information indicating the write processing and the execution condition of the processing path,
The route association means is based on the actual route information generated by the actual route extraction means and the processing route information generated by the processing route extraction means, and the data set as the starting point and the target of the reading process A data set that matches and the data set that is the end point and the data set that is a target of the writing process are associated with the actual result path and the processing path;
The main processing path determination unit determines, as the main processing path, the processing path in which the number of appearances of the actual path correlated with the processing path by the path association unit is equal to or greater than a predetermined threshold among the processing paths. ,
The assumed operation condition extraction unit extracts the execution condition of the processing path determined as the main process path by the main process route determination unit, and sets the extracted execution condition as the assumed operation condition, and the assumed operation Output information indicating the condition,
An assumed operating condition analysis method characterized by the above.

Images