Database Operation Attribution via Process Log Embedding
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for analyzing application programs using SQL traces struggle to accurately attribute data operations to specific development teams, especially when development work is shared on a screen or button basis, making it difficult to determine which team is responsible for each operation.
Innovation Solution
A non-transitory computer-readable recording medium storing an analysis program that generates a compiled program with embedded commands for storing process logs, allowing for the specification of operation commands related to a database based on identification information of objects, and outputs a correspondence table indicating the type of operation for each access destination, enabling detailed analysis and attribution of data operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If SQL traces are used to analyze application programs, then data operation analysis is enabled, but accurate attribution to specific development teams becomes difficult when work is shared on screen or button basis
Solution Approach 1:
The patent segments the analysis process into distinct components: SQL trace collection, process log extraction, and correspondence table generation. By dividing the monolithic analysis system into modular segments that handle specific tasks (screen identification, button identification, SQL operation classification), the system achieves precise attribution to development teams while maintaining manageable complexity through clear separation of concerns.
Solution Approach 2:
The patent introduces process logs as an intermediary element that bridges SQL traces and development team attribution. These logs capture screen and button identification information, acting as a mediator that connects the raw SQL operations with the contextual information needed for accurate team attribution, thereby improving measurement precision without directly increasing system complexity.
2Loss of information
If detailed process logs are embedded in compiled programs, then accurate operation command specification is achieved, but program size and processing overhead increase
Solution Approach 1:
The patent extracts process log information from the compiled program execution flow and stores it separately in process logs. Instead of embedding detailed logging code throughout the application source, the system captures essential operation information (screen ID, button ID, SQL commands) in external process logs, thereby maintaining program size efficiency while achieving complete operation information recording for accurate attribution.
Solution Approach 2:
The patent implements partial logging by recording only the essential information needed for attribution (screen identification, button identification, SQL operation type) rather than logging all program execution details. This selective partial logging approach provides sufficient information for development team attribution while minimizing the quantity of logged data and associated storage overhead.
Data Source
AI summary
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.