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

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

公开(公告)号：US08713186B2

公开(公告)日：2014-04-29

申请号：US12047278

申请日：2008-03-12

申请人： Lakshminarayanan Chidambaran ,  Srinath Krishnaswamy ,  Krishna Mohan Itikarlapalli ,  Kevin Neel ,  Sreekumar K. Seshadri ,  Jonathan Giloni ,  Scot McKinley ,  Ravi Thammaiah

发明人： Lakshminarayanan Chidambaran ,  Srinath Krishnaswamy ,  Krishna Mohan Itikarlapalli ,  Kevin Neel ,  Sreekumar K. Seshadri ,  Jonathan Giloni ,  Scot McKinley ,  Ravi Thammaiah

IPC分类号： G06F15/16

CPC分类号： H04L67/14 ,  H04L67/28 ,  H04L67/2809

摘要： A server side connection pool provides pooling of server connections. Thus, client side processes do not create groups of dedicated resources. Clients are provided the capability to communicate to a server side connection broker process to GET a pooled server connection comprising connection state plus a thread of execution for doing some work, whereby requesting the work can bypass the connection broker process and go directly to the assigned pooled connection. Once the client issues a RELEASE to release the pooled connection back to the pool, a completely different client process on potentially a different client middle tier machine can reuse the same pooled connection. The server-side connection pool can be logically partitioned into sub-pools that correspond to connection classes that typically correspond to respective applications. A client process can request a pooled connection having a particular state, where a stored procedure can be executed to generate such state.

摘要翻译： 服务器端连接池提供服务器连接池。 因此，客户端进程不创建专用资源组。 提供客户端与服务器端连接代理进程通信的能力，以获取包含连接状态加执行线程的池服务器连接，以执行某些工作，从而请求工作可以绕过连接代理进程并直接转到已分配的合并 连接。 一旦客户端发布RELEASE以将池连接释放回池，则潜在的不同客户端中间层计算机上的完全不同的客户端进程可以重新使用相同的池化连接。 服务器端连接池可以在逻辑上划分为与通常对应于各个应用程序的连接类相对应的子池。 客户端进程可以请求具有特定状态的池化连接，其中可以执行存储过程以产生这样的状态。

公开(公告)号：US20080228923A1

公开(公告)日：2008-09-18

申请号：US12047278

申请日：2008-03-12

申请人： Lakshminarayanan Chidambaran ,  Srinath Krishnaswamy ,  Krishna Mohan Itikarlapalli ,  Kevin Neel ,  Sreekumar K. Seshadri ,  Jonathan Giloni ,  Scot McKinley ,  Ravi Thammaiah

发明人： Lakshminarayanan Chidambaran ,  Srinath Krishnaswamy ,  Krishna Mohan Itikarlapalli ,  Kevin Neel ,  Sreekumar K. Seshadri ,  Jonathan Giloni ,  Scot McKinley ,  Ravi Thammaiah

IPC分类号： G06F15/16

CPC分类号： H04L67/14 ,  H04L67/28 ,  H04L67/2809

摘要： A server side connection pool provides pooling of server connections. Thus, client side processes do not create groups of dedicated resources. Clients are provided the capability to communicate to a server side connection broker process to GET a pooled server connection comprising connection state plus a thread of execution for doing some work, whereby requesting the work can bypass the connection broker process and go directly to the assigned pooled connection. Once the client issues a RELEASE to release the pooled connection back to the pool, a completely different client process on potentially a different client middle tier machine can reuse the same pooled connection. The server-side connection pool can be logically partitioned into sub-pools that correspond to connection classes that typically correspond to respective applications. A client process can request a pooled connection having a particular state, where a stored procedure can be executed to generate such state.

摘要翻译： 服务器端连接池提供服务器连接池。 因此，客户端进程不创建专用资源组。 提供客户端与服务器端连接代理进程通信的能力，以获取包含连接状态加执行线程的池服务器连接，以执行某些工作，从而请求工作可以绕过连接代理进程并直接转到已分配的合并 连接。 一旦客户端发布RELEASE以将池连接释放回池，则潜在的不同客户端中间层计算机上的完全不同的客户端进程可以重新使用相同的池化连接。 服务器端连接池可以在逻辑上划分为与通常对应于各个应用程序的连接类相对应的子池。 客户端进程可以请求具有特定状态的池化连接，其中可以执行存储过程以产生这样的状态。