Transactional Workload Replay for Web Application Testing

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing testing systems for web applications fail to reliably reproduce real application workloads due to non-deterministic factors, leading to inconsistent database changes and inaccurate defect reproduction, making it difficult to diagnose and troubleshoot issues that occur under high volume or concurrent workloads.

Innovation Solution

An application workload capture and replay system that ensures transactional consistency by capturing and replaying real application workloads with guaranteed order of database transactions, using application request identifiers and database log sequence numbers to maintain the original transactional behavior, thus faithfully reproducing production environment behavior in a test environment.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If real application workload is captured and replayed against a replica web application, then the approach can reproduce production environment behavior for analysis and diagnosis, but non-deterministic factors cause the order of database changes to diverge from production, making reliable reproduction difficult

Engineering Contradiction:
Improvereliability of defect reproductionVSAvoidcomplexity of controlling non-deterministic factors
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent creates a synthetic application workload that copies the essential characteristics and patterns of the real production workload. Instead of directly replaying the original workload which contains non-deterministic elements, a synthesized version is constructed that preserves the critical behavioral patterns while eliminating unpredictable variations, enabling reliable defect reproduction.

Inventive Principle:
Principle #26Copying

Solution Approach 2:

The patent extracts and isolates the deterministic, pattern-based components of the application workload from the non-deterministic elements. By separating the essential workload characteristics (such as transaction sequences, data access patterns, and concurrency patterns) from unpredictable factors (such as timing variations and system state dependencies), the system can replay workloads in a controlled manner that reliably reproduces defects.

Inventive Principle:
Principle #2Taking out (Extraction)

2Reliability

If synthetic application workload is created to approximate real workload volume and concurrency, then defect reproduction may be achieved, but the process is time-consuming, expensive, and error-prone requiring human user design

Engineering Contradiction:
Improveaccuracy of defect reproductionVSAvoidtime required for workload design and creation
Core Design Contradiction:
ReliabilityVSLoss of time

Solution Approach 1:

The system performs self-service by automatically analyzing production workload data and generating synthetic workloads without requiring manual human intervention. The workload synthesis process is automated, using algorithms to capture production patterns and generate test workloads that accurately reproduce defects while eliminating the time-consuming manual design process.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary analysis of production workload characteristics before defect reproduction is needed. By pre-processing production data to extract patterns and generate synthetic workload templates in advance, the system prepares ready-to-use test workloads that can be quickly deployed for defect reproduction without time-consuming manual design at the moment of need.

Inventive Principle:
Principle #10Preliminary action

3Ease of operation

If captured workload is replayed without controlling transaction order, then non-deterministic factors cause errors that did not occur in production to appear in test environment, potentially masking the actual defect

Engineering Contradiction:
Improvesimplicity of workload replay processVSAvoidaccuracy of defect reproduction
Core Design Contradiction:
Ease of operationVSReliability

Solution Approach 1:

The patent implements dynamic control of transaction ordering during workload replay. The system adapts the replay process by dynamically adjusting the execution order of transactions based on production patterns, ensuring that the synthesized workload maintains the same logical sequencing as production while accommodating necessary variations for reliable defect reproduction.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS8380665B2Application workload capture and replay system
Publication Date: 2013.02.19 ORACLE INT CORP
  • US8380665B2 patent drawing
  • US8380665B2 patent drawing
  • US8380665B2 patent drawing

AI summary

An application workload capture and replay system with a transactionally consistent application workload replay feature is provided. More particularly, the feature includes capture-phase components for capturing and recording a real application workload submitted to a production web application system and includes replay-phase components for replaying the captured application workload against a test web application system in a transactionally consistent manner. The feature provides guarantees about the order of database transactions that are caused when the workload is replayed such that there is a consistency between the replay-phase order of the database transactions and the order of those transactions that occurred when the workload was captured. These consistency guarantees facilitate a faithful reproduction of database changes observed in the production web application system in the test web application system using a captured real application workload. Significantly, this faithful reproduction may be accomplished without having to create a synthetic application workload that approximates or emulates the transactional behavior of the real application workload. Instead, a real application workload may be used as or substantially as it is captured.