Oracle database replay

ABSTRACT

This 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 test system to a real production system workload, which helps identify all potential problems before implementing the planned changes on the production system. 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. Therefore, the test results using database replay can provide very high assurance in determining the impact of changes to a production system before applying these changes. This paper presents the architecture of Database Replay as well as experimental results that demonstrate its usefulness as testing methodology.

REFERENCES

• 1: Carsten Binnig , Donald Kossmann , Eric Lo , M. Tamer Özsu, QAGen: generating query-aware test databases, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, June 11-14, 2007, Beijing, China [doi>10.1145/1247480.1247520]
• 2: Jong-Deok Choi , Harini Srinivasan, Deterministic replay of Java multithreaded applications, Proceedings of the SIGMETRICS symposium on Parallel and distributed tools, p.48-59, August 03-04, 1998, Welches, Oregon, United States [doi>10.1145/281035.281041]
• 3: DTM Data Generator. http://www.sqledit.com/dg/
• 4: K. Dias, M. Ramacher, U. Shaft, V. Venkataramani, G. Wood. Automatic Performance Diagnosis and Tuning in Oracle. CIDR 2005
• 5: Michael Emmi , Rupak Majumdar , Koushik Sen, Dynamic test input generation for database applications, Proceedings of the 2007 international symposium on Software testing and analysis, July 09-12, 2007, London, United Kingdom [doi>10.1145/1273463.1273484]
• 6: C. Fernandez, J. Leslie. Predicting and Preventing Performance Bottlenecks in Oracle 10g. Technical Brief, http://www.quest.com.
• 7: A. Georges , M. Christiaens , M. Ronsse , K. De Bosschere, JaRec: a portable record/replay environment for multi-threaded Java applications, Software—Practice & Experience, v.34 n.6, p.523-547, May 2004 [doi>10.1002/spe.579]
• 8: HP LoadRunner. http://www.hp.com.
• 9: IBM DB2 Test Database Generator. http://www-306.ibm.com/software/data/db2imstools/db2tools/db2tdbg/
• 10: Nikolai Joukov , Timothy Wong , Erez Zadok, Accurate and efficient replaying of file system traces, Proceedings of the 4th conference on USENIX Conference on File and Storage Technologies, p.25-25, December 13-16, 2005, San Francisco, CA
• 11: T. J. LeBlanc , J. M. Mellor-Crummey, Debugging Parallel Programs with Instant Replay, IEEE Transactions on Computers, v.36 n.4, p.471-482, April 1987 [doi>10.1109/TC.1987.1676929]
• 12: Oracle 11g Documentation. http://www.oracle.com/pls/db111/db111.homepage.
• 13: Meikel Poess , John M. Stephens, Jr., Generating thousand benchmark queries in seconds, Proceedings of the Thirtieth international conference on Very large data bases, p.1045-1053, August 31-September 03, 2004, Toronto, Canada
• 14: SQL Server Profiler, RDBMS Documentation, http://msdn.microsoft.com.
• 15: Donald R. Slutz, Massive Stochastic Testing of SQL, Proceedings of the 24rd International Conference on Very Large Data Bases, p.618-622, August 24-27, 1998
• 16: Jim Gray , Prakash Sundaresan , Susanne Englert , Ken Baclawski , Peter J. Weinberger, Quickly generating billion-record synthetic databases, Proceedings of the 1994 ACM SIGMOD international conference on Management of data, p.243-252, May 24-27, 1994, Minneapolis, Minnesota, United States
• 17: Sara Sprenkle , Emily Gibson , Sreedevi Sampath , Lori Pollock, Automated replay and failure detection for web applications, Proceedings of the 20th IEEE/ACM international Conference on Automated software engineering, November 07-11, 2005, Long Beach, CA, USA [doi>10.1145/1101908.1101947]
• 18: TPC-C, http://www.tpc.org.
• 19: John M. Stephens , Meikel Poess, MUDD: a multi-dimensional data generator, Proceedings of the 4th international workshop on Software and performance, January 14-16, 2004, Redwood Shores, California
• 20: VMWare Workstation 6 Record and Replay. http://www.vmware.com.
• 21: 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. 1

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.m Miscellaneous

General Terms:
Management, Measurement, Performance, Verification

Keywords:
capture, database, record, replay, testing