专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08438144B2 Transactionally consistent database replay in an environment with connection pooling 有权
标题翻译：在具有连接池的环境中事务一致的数据库重播
公开(公告)号：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.
摘要翻译：提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。重播系统包括管理连接池的调度器。在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。命令可以存储在调度器中，直到数据库进入允许执行命令的状态。在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。

2. 发明申请

US20120054245A1 TRANSACTIONALLY CONSISTENT DATABASE REPLAY IN AN ENVIRONMENT WITH CONNECTION POOLING 有权
标题翻译：在连接池的环境中进行一致的数据库重复
公开(公告)号：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.
摘要翻译：提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。重播系统包括管理连接池的调度器。在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。命令可以存储在调度器中，直到数据库进入允许执行命令的状态。在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。

3. 发明授权

US08326816B2 Fine grain synchronization for database replay 有权
标题翻译：数据库重播的细粒度同步
公开(公告)号：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.
摘要翻译：提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。捕获过程捕获生产系统执行的数据库命令的工作负载。捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。

4. 发明申请

US20110276550A1 FINE GRAIN SYNCHRONIZATION FOR DATABASE REPLAY 有权
标题翻译：用于数据库复制的精细粒度同步
公开(公告)号：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.
摘要翻译：提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。捕获过程捕获生产系统执行的数据库命令的工作负载。捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。

5. 发明授权

US08732126B2 Filtering workload for database replay 有权
标题翻译：过滤数据库重播的工作负载
公开(公告)号：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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

6. 发明申请

US20140006358A1 CREATION AND REPLAY OF A SIMULATION WORKLOAD USING CAPTURED WORKLOADS 有权
标题翻译：使用捕获的工作负载的模拟工作的创建和重置
公开(公告)号：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.
摘要翻译：提供了一种重放模拟工作负载的方法。模拟工作负载识别多个工作负载部分。每个工作负载部分至少是相应捕获的工作负载的一部分。在一个实施例中，第一工作负载部分是相对于第一捕获数据库服务器执行的第一工作负载的一部分，并且第二工作负荷部分是相对于第二捕获数据库服务器执行的第二工作负载的一部分。可以同时重放第一工作负荷部分的一部分和第二工作负荷部分的一部分。

7. 发明授权

US07890457B2 Transactionally consistent database workload replay 有权
标题翻译：事务一致的数据库工作负载重播
公开(公告)号：US07890457B2
公开(公告)日：2011-02-15
申请号：US11800238
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30377
摘要： 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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

8. 发明授权

US08024299B2 Client-driven functionally equivalent database replay 有权
标题翻译：客户端驱动的功能等效数据库重播
公开(公告)号：US08024299B2
公开(公告)日：2011-09-20
申请号：US11800224
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F7/22 , G06F17/40
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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

9. 发明授权

US07984015B2 Database workload capture and replay architecture 有权
标题翻译：数据库工作负载捕获和重播架构
公开(公告)号：US07984015B2
公开(公告)日：2011-07-19
申请号：US11800122
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang , Richard Sarwal , Leng Tan , Graham Wood , Benoit Dageville , Chao Liang , Sanjay Kaluskar
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang , Richard Sarwal , Leng Tan , Graham Wood , Benoit Dageville , Chao Liang , Sanjay Kaluskar
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30377
摘要： 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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

10. 发明申请

US20080097961A1 Capturing database workload while preserving original transactional and concurrency characteristics for replay 有权
标题翻译：捕获数据库工作负载，同时保留用于重放的原始事务和并发特性
公开(公告)号：US20080097961A1
公开(公告)日：2008-04-24
申请号：US11800239
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F17/30
CPC分类号： G06F11/3414 , G06F11/3419 , G06F11/3495 , G06F11/3688 , G06F2201/805 , G06F2201/87
摘要： 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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式