公开(公告)号：US08380665B2

公开(公告)日：2013-02-19

申请号：US13076313

申请日：2011-03-30

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/00

CPC分类号： G06F11/3688

摘要： 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. Instead, a real application workload may be used as or substantially as it is captured.

摘要翻译： 提供了具有事务一致的应用程序工作负载重放功能的应用程序工作负载捕获和重放系统。 更具体地，该特征包括用于捕获和记录提交到生产web应用系统的真实应用工作负载的捕获相组件，并且包括用于以事务一致的方式针对测试web应用系统重放所捕获的应用工作负载的重放阶段组件。 该功能提供了关于在重放工作负载时引起的数据库事务的顺序的保证，使得数据库事务的重放阶段顺序与捕获工作负载时发生的那些事务的顺序之间存在一致性。 这些一致性保证有助于在测试Web应用系统中使用捕获的实际应用程序工作负载忠实地再现在生产Web应用系统中观察到的数据库更改。 重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。 相反，真正的应用程序工作负载可以被使用或基本上被捕获。

公开(公告)号：US08380664B2

公开(公告)日：2013-02-19

申请号：US13034526

申请日：2011-02-24

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/00

CPC分类号： G06F17/30557

摘要： 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.

摘要翻译： 数据库系统提供事务性一致的应用程序工作负载重播。 在数据库系统中，提供事务性地一致地重放应用工作负载的方法包括以下步骤：在重放阶段，其中在捕获阶段期间先前提交给应用服务器系统的多个应用请求正在被重播， 数据库服务器，针对数据库执行数据库命令的数据库请求。 数据库请求指定标识多个应用请求的特定应用请求的应用请求标识符。 特定的应用程序请求导致数据库命令在捕获阶段之前执行。 响应于接收到数据库请求，基于数据库请求中的应用请求标识确定是否延迟数据库命令的执行至少直到特定的重放阶段数据库事务被提交。

公开(公告)号：US08326816B2

公开(公告)日：2012-12-04

申请号：US12775322

申请日：2010-05-06

申请人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/303

摘要： A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.

摘要翻译： 提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。 捕获过程捕获生产系统执行的数据库命令的工作负载。 捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。 捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。 处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。 测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。

公开(公告)号：US20110276550A1

公开(公告)日：2011-11-10

申请号：US12775322

申请日：2010-05-06

申请人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/303

摘要： A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.

摘要翻译： 提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。 捕获过程捕获生产系统执行的数据库命令的工作负载。 捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。 捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。 处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。 测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。

公开(公告)号：US08438144B2

公开(公告)日：2013-05-07

申请号：US12870736

申请日：2010-08-27

申请人： Romain Colle ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Giloni ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain Colle ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Giloni ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/303

摘要： A method, apparatus, and computer-readable medium is provided for replaying captured workload data in a database environment with connection pools. A replay system includes a dispatcher that manages a connection pool. In one aspect, the dispatcher selects available connections for sending database commands that are ready to be executed against a database, but prevents from being sent, or holds, commands that are not ready to be executed against the database. Commands may be stored at the dispatcher until the database advances to a state that allows the commands to be executed. In another aspect, the dispatcher may use an available connection to send a command to a database instance even though the command is not ready to be executed, as long as at least a threshold number or percentage of connections remains available.

摘要翻译： 提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。 重播系统包括管理连接池的调度器。 在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。 命令可以存储在调度器中，直到数据库进入允许执行命令的状态。 在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。

公开(公告)号：US20120221519A1

公开(公告)日：2012-08-30

申请号：US13076313

申请日：2011-03-30

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/30

CPC分类号： G06F11/3688

摘要： 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. Instead, a real application workload may be used as or substantially as it is captured.

摘要翻译： 提供了具有事务一致的应用程序工作负载重放功能的应用程序工作负载捕获和重放系统。 更具体地，该特征包括用于捕获和记录提交到生产web应用系统的真实应用工作负载的捕获相组件，并且包括用于以事务一致的方式针对测试web应用系统重放所捕获的应用工作负载的重放阶段组件。 该功能提供了关于在重放工作负载时引起的数据库事务的顺序的保证，使得数据库事务的重放阶段顺序与捕获工作负载时发生的那些事务的顺序之间存在一致性。 这些一致性保证有助于在测试Web应用系统中使用捕获的实际应用程序工作负载忠实地再现在生产Web应用系统中观察到的数据库更改。 重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。 相反，真正的应用程序工作负载可以被使用或基本上被捕获。

公开(公告)号：US20120221513A1

公开(公告)日：2012-08-30

申请号：US13034526

申请日：2011-02-24

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/30557

摘要： 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.

摘要翻译： 数据库系统提供事务性一致的应用程序工作负载重播。 在数据库系统中，提供事务性地一致地重放应用工作负载的方法包括以下步骤：在重放阶段，其中在捕获阶段期间先前提交给应用服务器系统的多个应用请求正在被重放， 数据库服务器，针对数据库执行数据库命令的数据库请求。 数据库请求指定标识多个应用请求的特定应用请求的应用请求标识符。 特定的应用程序请求导致数据库命令在捕获阶段之前执行。 响应于接收到数据库请求，基于数据库请求中的应用请求标识确定是否延迟数据库命令的执行至少直到特定的重放阶段数据库事务被提交。

公开(公告)号：US20120054245A1

公开(公告)日：2012-03-01

申请号：US12870736

申请日：2010-08-27

申请人： Romain COLLE ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Giloni ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain COLLE ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Giloni ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/303

摘要： A method, apparatus, and computer-readable medium is provided for replaying captured workload data in a database environment with connection pools. A replay system includes a dispatcher that manages a connection pool. In one aspect, the dispatcher selects available connections for sending database commands that are ready to be executed against a database, but prevents from being sent, or holds, commands that are not ready to be executed against the database. Commands may be stored at the dispatcher until the database advances to a state that allows the commands to be executed. In another aspect, the dispatcher may use an available connection to send a command to a database instance even though the command is not ready to be executed, as long as at least a threshold number or percentage of connections remains available.

摘要翻译： 提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。 重播系统包括管理连接池的调度器。 在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。 命令可以存储在调度器中，直到数据库进入允许执行命令的状态。 在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。