Recording medium recording analysis program, analysis method, and analysis apparatus

An analysis method comprising:

• embedding a command for generating a process log that monitors a behavior of a source program into a compiled program generated by compiling the source program, the source program including a display command instructing to display one or more objects, each being a screen or a button, such that a program in which the command is embedded is generated;
• executing the program to generate the process log that serves as monitoring data;
• storing the process log that serves as the monitoring data in a monitoring database;
• reading out the process log from the monitoring database;
• determine whether SQL (Structured Query Language) data is present in the monitoring data;
• when it is determined that the SQL data is present in the monitoring data, analyzing a syntax of the SQL data such that a data operation command and identification information of the one or more objects are specified based on the process log, the identification information of the one or more objects including one or more of screen names and button names each serving as an access source;
• analyzing the data operation command to specify one or more access destinations that includes table names and accessed by the one or more objects, respectively;
• determining a type of the data operation command specified in the analyzing the syntax of the SQL data;
• associating the identification information of the one or more objects to the one or more access destinations including the table names such that a correspondence table is generated in which information indicating the type of the data operation command is represented in each of the one or more access destinations;
• and
• outputting, for each of the one or more objects each being the screen or the button, the correspondence table generated at the associating.

An analysis apparatus comprising:

• a memory that stores an analysis program;
• and
• a processor coupled to the memory and the processor configured to perform a process based on the analysis program, wherein the process includes:
• embedding a command for generating a process log that monitors a behavior of a source program into a compiled program generated by compiling the source program, the source program including a display command instructing to display one or more objects, each being a screen or a button, such that a program in which the command is embedded is generated;
• executing the program to generate the process log that serves as monitoring data;
• storing the process log that serves as the monitoring data in a monitoring database;
• reading out the process log from the monitoring database;
• determine whether SQL (Structured Query Language) data is present in the monitoring data;
• when it is determined that the SQL data is present in the monitoring data, analyzing a syntax of the SQL data such that a data operation command and identification information of the one or more objects are specified based on the process log, the identification information of the one or more objects including one or more of screen names and button names each serving as an access source;
• analyzing the data operation command to specify one or more access destinations that includes table names and accessed by the one or more objects, respectively;
• determining a type of the data operation command specified in the analyzing the syntax of the SQL data;
• associating the identification information of the one or more objects to the one or more access destinations including the table names such that a correspondence table is generated in which information indicating the type of the data operation command is represented in each of the one or more access destinations;
• and
• outputting, for each of the one or more objects each being the screen or the button, the correspondence table generated at the associating.