Oracle database replay

  • Authors:

  • Leonidas Galanis;Supiti Buranawatanachoke;Romain Colle;Benoît Dageville;Karl Dias;Jonathan Klein;Stratos Papadomanolakis;Leng Leng Tan;Venkateshwaran Venkataramani;Yujun Wang;Graham Wood

  • Affiliations:

  • Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA;Facebook, Palo Alto, CA, USA;Oracle USA, Redwood City, CA, USA;Oracle USA, Redwood City, CA, USA

  • Venue:
  • Proceedings of the 2008 ACM SIGMOD international conference on Management of data
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

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.