# US 10,310,958 B2 · Recording medium recording analysis program, analysis method, and analysis apparatus > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 10,310,958 B2 - Document ID: US10310958B2 - Status: Granted - Kind: B2 - Application number: 15/697,650 - Filed: 2017-09-07 - Published: 2018-03-22 - Granted: 2019-06-04 - Earliest claimed: 2016-09-16 - Assignees: Fujitsu Limited - Applicants: Fujitsu Limited - Inventors: Daisuke Hiyama; Sayaka Shimada; Hideya Ikeda - Web page: https://patentgrep.com/patent/US10310958B2 ## CPC - G06F 11/3476: {Data logging (G06F11/14, G06F11/2205 take precedence)} - G06F 11/3495: {for systems} - G06F 11/3698: Environments for analysis, debugging or testing of software - G06F 16/33: Querying - H04N 1/00408: {Display of information to the user, e.g. menus} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - H04N: PICTORIAL COMMUNICATION, e.g. TELEVISION ## Abstract A non-transitory computer-readable recording medium recording an analysis program for causing a computer to execute a process includes: generating a program by embedding a command for storing a process log in a storage into a compiled program generated by compiling a source program including a display command instructing to display a object; specifying an operation command related to a database in association with identification information of the object based on the process log stored in the storage by the display command in execution of the program; analyzing the operation command to specify an access destination; and outputting, for every access destination, a correspondence including information indicating a type of the operation command in association with the identification information of the predetermined object. ## Claims ### Claim 1 A non-transitory computer-readable recording medium recording an analysis program for causing a computer to execute a process comprising: embedding a command for generating a process log that monitors a behavior of a source program in a storage 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; determining 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. ### Claim 2 (depends on 1) The non-transitory computer-readable recording medium according to claim 1, wherein the data operation command is specified based on a log that specifies the one or more objects at the analyzing the syntax of the SQL data. ### Claim 3 (depends on 1) The non-transitory computer-readable recording medium according to claim 1, wherein the information indicating the type of the data operation command is one of a character for specifying creation, a character for specifying reference, a character for specifying update, and a character for specifying deletion, or a combination of at least two of the character for specifying creation, the character for specifying the reference, the character specifying the update, and the character specifying the deletion. ### Claim 4 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. ### Claim 5 (depends on 4) The analysis method according to claim 4, wherein the data operation command is specified based on a log that specifies the one or more objects at the analyzing the syntax of the SQL data. ### Claim 6 (depends on 4) The analysis method according to claim 4, wherein the information indicating the type of the data operation command is one of a character for specifying creation, a character for specifying reference, a character for specifying update, and a character for specifying deletion, or a combination of at least two of the character for specifying creation, the character for specifying the reference, the character specifying the update, and the character specifying the deletion. ### Claim 7 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. ### Claim 8 (depends on 7) The analysis apparatus according to claim 7, wherein the data operation command is specified based on a log that specifies the one or more objects. ### Claim 9 (depends on 7) The analysis apparatus according to claim 7, wherein the information indicating the type of the data operation command is one of a character for specifying creation, a character for specifying reference, a character for specifying update, and a character for specifying deletion, or a combination of at least two of the character for specifying creation, the character for specifying the reference, the character specifying the update, and the character specifying the deletion.