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.
- C. Binnig, D. Kossman, E. Lo, M. T. Özsu. QAGen: generating query-aware test databases. ACM SIGMOD international conference on Management of data 2007 Google ScholarDigital Library
- M. Emmi, R. Majumdar, K. Sen. Dynamic test input generation for database applications. International symposium on Software testing and analysis 2007. Google ScholarDigital Library
- L. Galanis and etc. Oracle Database Replay. ACM SIGMOD international conference on Management of data 2008. 1159--1170. Google ScholarDigital Library
- HP LoadRunner. http://www.hp.com.Google Scholar
- SQL Server Profiler, RDBMS Documentation, http://msdn.microsoft.com.Google Scholar
- K. Yagoub, P. Belknap, B. Dageville, K. Dias, S. Joshi, and H. Yu. Oracle's SQL Performance Analyzer. IEEE Data Engineering Bulletin. March 2008 Vol. 31 No. 1Google Scholar
Index Terms
- Real application testing with database replay
Recommendations
Oracle Database Replay
This demonstration presents Oracle Database Replay, a novel approach to testing changes to the relational database management system component of an information system (software upgrades, hardware changes etc). Database Replay makes it possible to ...
Oracle database replay
SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of dataThis paper presents Oracle Database Replay, a novel approach to testing changes to the relational database management system component of an information system (software upgrades, hardware changes etc). Database Replay makes it possible to subject a ...
Best practices of testing database manipulation code
AbstractSoftware testing enables development teams to maintain the quality of a software system while it evolves. The database manipulation code requires special attention in this context. However, it is often neglected and suffers from ...
Highlights- A study on the coverage of database access code in the tests of open-source projects.
Comments