Dynamic Transaction Logging Policy Based on Response Time

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing transaction process logging systems face inefficiencies in managing log data volume, leading to increased system load and delayed transactions, as they either record excessive data for short response times or insufficient data for long response times, making it difficult to analyze service quality effectively.

Innovation Solution

A system that dynamically adjusts log data volume based on response time, using a logging policy table to determine which data to record more or less, with a transaction process monitoring unit and logging control unit to implement this policy, allowing for varying log data amounts based on required service level agreement specifications.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of information

If logging is performed for all transaction processes regardless of response time, then sufficient information is recorded for analyzing service quality, but system load increases and transaction processing is delayed

Engineering Contradiction:
Improveservice quality informationVSAvoidtransaction processing speed
Core Design Contradiction:
Loss of informationVSProductivity

Solution Approach 1:

The system dynamically adjusts logging granularity based on transaction response time. When response time exceeds a threshold, detailed logging is activated; otherwise, minimal or no logging is performed. This dynamic adaptation resolves the contradiction by making logging intensity variable rather than fixed, ensuring sufficient information capture only when necessary.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The logging system changes the parameter of log data volume based on transaction characteristics. By monitoring response time as a key parameter, the system adjusts the amount of log data recorded - capturing detailed information for slow transactions while using minimal logging for fast transactions, thus balancing information quality with processing efficiency.

Inventive Principle:
Principle #35Parameter changes

2Measurement precision

If logging data amount is increased to capture sufficient service quality information, then analysis capability is improved, but system load increases causing delayed transactions

Engineering Contradiction:
Improveservice quality measurementVSAvoidtransaction response time
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The system implements dynamic logging where the measurement precision of service quality is adjusted based on transaction response time. For transactions already exceeding response time thresholds, detailed logging provides precise analysis capability. For normal transactions, minimal logging reduces time loss, achieving efficient service quality monitoring without uniformly increasing logging for all transactions.

Inventive Principle:
Principle #15Dynamics

3Loss of information

If logging is performed for every transaction process, then complete log data is available for problem analysis, but output processes concentrate on storage device causing delays

Engineering Contradiction:
Improvetransaction log informationVSAvoidlog output speed
Core Design Contradiction:
Loss of informationVSSpeed

Solution Approach 1:

The system applies partial logging action by selectively recording only necessary log information based on transaction response time. Instead of logging all transactions completely, it performs partial logging for normal transactions and complete logging only for problematic transactions, reducing the overall output burden on storage devices while maintaining adequate information for problem analysis.

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS8001094B2System, method, program, and system implementation method for transaction process logging
Publication Date: 2011.08.16 SAP SE
  • US8001094B2 patent drawing
  • US8001094B2 patent drawing
  • US8001094B2 patent drawing

AI summary

A system is provided to log a transaction process performed based on a service level agreement concerning the response time of the transaction process. The system includes a logging policy table, a transaction process monitoring unit, and a storage device. The logging policy table records one or more logging policies defined to log a transaction process with a varying amount of log data based on a required response time specified in the service level agreement. The transaction process monitoring unit automatically monitors the response time of the transaction process. The storage device records a transaction process log. The system further includes a logging control unit. The logging control unit uses response time of a transaction process monitored by the transaction process monitoring unit to select one of the logging policies stored in the logging policy table. According to the selected logging policy, the logging control unit allows the storage device to record a log of the transaction process.