Real application testing with database replay

Authors:
Yujun Wang;Supiti Buranawatanachoke;Romain Colle;Karl Dias;Leonidas Galanis;Stratos Papadomanolakis;Uri Shaft
Affiliations:
Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA;Oracle USA, Redwood City, CA
Venue:
Proceedings of the Second International Workshop on Testing Database Systems
Year:
2009

Citing 3
Cited 0

QAGen: generating query-aware test databases

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
Dynamic test input generation for database applications

Proceedings of the 2007 international symposium on Software testing and analysis
Oracle database replay

Proceedings of the 2008 ACM SIGMOD international conference on Management of data

Quantified Score

Hi-index	0.01

Visualization

Abstract

Oracle Database Replay provides a new way to test changes to a database system by reproducing the real user workload in a test environment. It helps to identify potential problems after software or hardware upgrades, patches, or changes to database parameters, schema or data. Any interesting workload period of a production database system can be captured with minimal overhead. The captured workload can be used to drive a test system while maintaining the concurrency and load characteristics of the real production workload. The replay does not depend on any other software including the application itself. It reliably reproduces the captured workload to support early diagnosis and troubleshooting. In this paper we discuss the analysis of replay results and introduce a new compare-period report, which assists with a detailed performance comparison of the capture and its replays with respect to changes. We demonstrate its usefulness in a case study involving an upgrade for a Siebel financial application, where Database Replay identifies performance problems after the upgrade and helps correcting them.