公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：US08732126B2

公开(公告)日：2014-05-20

申请号：US13207763

申请日：2011-08-11

申请人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang

发明人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang

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

CPC分类号： G06F17/30286

摘要： A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.

摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

公开(公告)号：US20140006358A1

公开(公告)日：2014-01-02

申请号：US13538278

申请日：2012-06-29

申请人： Yujun Wang ,  Leonidas Galanis ,  Konstantinos Morfonios ,  Karl Dias ,  John Mark Beresniewicz

发明人： Yujun Wang ,  Leonidas Galanis ,  Konstantinos Morfonios ,  Karl Dias ,  John Mark Beresniewicz

IPC分类号： G06F17/30

CPC分类号： G06F17/30289

摘要： A method for replaying a simulation workload is provided. The simulation workload identifies a plurality of workload parts. Each workload part is at least a portion of a respective captured workload. In an embodiment, a first workload part is a portion of a first workload executed relative to a first capture database server and a second workload part is a portion of a second workload executed relative to a second capture database server. A portion of the first workload part and a portion of the second workload part may be replayed concurrently.

摘要翻译： 提供了一种重放模拟工作负载的方法。 模拟工作负载识别多个工作负载部分。 每个工作负载部分至少是相应捕获的工作负载的一部分。 在一个实施例中，第一工作负载部分是相对于第一捕获数据库服务器执行的第一工作负载的一部分，并且第二工作负荷部分是相对于第二捕获数据库服务器执行的第二工作负载的一部分。 可以同时重放第一工作负荷部分的一部分和第二工作负荷部分的一部分。