Rodney K Graham

US Patent:

8380664, Feb 19, 2013

Filed:

Feb 24, 2011

Appl. No.:

13/034526

Inventors:

Efstratios Papadomanolakis - San Francisco CA, US
Zhongtang Cai - Redwood Shores CA, US
Romain Colle - San Francisco CA, US
Benoit Dageville - Truckee CA, US
Karl Dias - Foster City CA, US
Leonidas Galanis - San Jose CA, US
Rodney Graham - San Francisco CA, US
Bo Gong - Foster City CA, US
Qinghui H. Altmar - Cupertino CA, US
Jae Young Yoon - San Mateo CA, US
Mehmet Fidanboylu - Palo Alto CA, US
Tom Hsu - Foster City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/00

US Classification:

707615, 707610, 707640, 707661, 707809, 709201, 709248

Abstract:

A database system providing transactionally consistent replay of application workloads. In a database system, a method providing transactionally consistent replay of application workloads comprises the steps of: during a replay phase in which a plurality of application requests that were previously submitted to an application server system during a capture phase are being replayed, receiving, at a database server, a database request to execute a database command against a database. The database request specifies an application request identifier that identifies a particular application request of the plurality of application requests. The particular application request caused the database command to be executed previously during the capture phase. In response to receiving the database request, determining, based on the application request identifier in the database request, whether to delay execution of the database command at least until a particular replay-phase database transaction has been committed.

US Patent:

8380665, Feb 19, 2013

Filed:

Mar 30, 2011

Appl. No.:

13/076313

Inventors:

Efstratios Papadomanolakis - San Francisco CA, US
Zhongtang Cai - Redwood Shores CA, US
Romain Colle - San Francisco CA, US
Benoit Dageville - Truckee CA, US
Karl Dias - Foster City CA, US
Leonidas Galanis - San Jose CA, US
Rodney Graham - San Francisco CA, US
Bo Gong - Foster City CA, US
Qinghui H. Altmar - Cupertino CA, US
Jae Young Yoon - San Mateo CA, US
Mehmet Fidanboylu - Palo Alto CA, US
Tom Hsu - Foster City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/00

US Classification:

707615, 707610, 707640, 707661, 707809, 709201, 709248

Abstract:

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.