公开(公告)号：US20060294088A1

公开(公告)日：2006-12-28

申请号：US11167504

申请日：2005-06-27

Applicant: John Stecher ,  Soloman Barghouthi ,  Matt Hogstrom ,  Yang Lei ,  Andrew Spyker ,  Robert Wisniewski

Inventor： John Stecher ,  Soloman Barghouthi ,  Matt Hogstrom ,  Yang Lei ,  Andrew Spyker ,  Robert Wisniewski

IPC: G06F17/30

CPC classification number: G06F16/24539

Abstract: The present invention provides a method, system, and computer program product for caching dynamically generated queries such as SQL (Structured Query Language) statements. A method in accordance with an embodiment of the present invention comprises: providing a partial update query for updating at least one column in a table stored in a database; generating a key using a number representative of an update status of each column in the table; and determining if a prepared statement corresponding to the partial update query is located in a prepared statement cache using the key.

Abstract translation: 本发明提供了用于缓存动态生成的查询（诸如SQL（结构化查询语言）语句）的方法，系统和计算机程序产品。 根据本发明的实施例的方法包括：提供用于更新存储在数据库中的表中的至少一列的部分更新查询; 使用代表表中每列的更新状态的数字生成密钥; 以及使用所述密钥确定与所述部分更新查询相对应的准备语句是否位于准备好的语句高速缓存中。

公开(公告)号：US20060117095A1

公开(公告)日：2006-06-01

申请号：US11000436

申请日：2004-11-30

Applicant: Soloman Barghouthi ,  Ian Robinson ,  Andrew Schofield ,  Kevin Sutter

Inventor： Soloman Barghouthi ,  Ian Robinson ,  Andrew Schofield ,  Kevin Sutter

IPC: G06F15/16

CPC classification number: G06F9/466 ,  G06F17/30377

Abstract: A method, apparatus, system, and signal-bearing medium that, in an embodiment, receive an allocation request for a resource and registers the resource as a non-voting participant if the resource desires to delegate commit voting to another resource. The registered resource is then prohibited from participating in an enclosing transactional context and instead is informed when the transaction completes. The resource is enlisted as a voting participant if the resource does not desire to delegate commit voting. In this way, when multiple resources are used in a transaction, a resource may be registered and receive notifications of transaction completion instead of being enlisted and voting on commit decisions. The result of a transaction in which a single resource takes responsibility for a number of other resources is that transaction completion avoids the two-phase commit protocol and the resulting performance degradation.

公开(公告)号：US20070022133A1

公开(公告)日：2007-01-25

申请号：US11186600

申请日：2005-07-21

Applicant: Soloman Barghouthi

Inventor： Soloman Barghouthi

IPC: G06F7/00

CPC classification number: G06F16/21

Abstract: A client or client representative of a database maintains a configurable table of database messages and associated values, at least some of which include references to commands to be executed upon the occurrence of the message being issued from the database. One or more of these command sets respond to a lack of resource message by causing the system to automatically increase the allocated resources of the database to allow the request to be processed, preferably transparently to the client. After increasing the resource allocation, the request is then automatically retried.

Abstract translation: 数据库的客户端或客户代表维护数据库消息和关联值的可配置表，其中至少一些包括对从数据库发出的消息发生时要执行的命令的引用。 这些命令集中的一个或多个通过使系统自动增加数据库的分配的资源来允许对客户端进行透明处理的请求，从而对缺少资源消息进行响应。 增加资源分配后，请求自动重试。

公开(公告)号：US20050183057A1

公开(公告)日：2005-08-18

申请号：US10777735

申请日：2004-02-12

Applicant: Soloman Barghouthi ,  Teresa Kan ,  Yang Lei

Inventor： Soloman Barghouthi ,  Teresa Kan ,  Yang Lei

IPC: G06F9/44 ,  G06F9/46 ,  G06F17/30

CPC classification number: G06F9/466 ,  G06F17/30306

Abstract: An apparatus and method enable batch processing of database updates without modifying generated code, i.e., without redeployment of the application server or application. A batch mechanism intercepts calls from the generated code, compiles updates into batches, and processes the updates to the database in batches. In this manner the batch mechanism takes advantage of the batch processing capabilities of the database without modifying the generated code.

Abstract translation: 一种装置和方法能够批量处理数据库更新而不修改生成的代码，即不重新部署应用程序服务器或应用程序。 批处理机制拦截来自生成的代码的调用，将更新编译成批次，并批量处理数据库的更新。 以这种方式，批处理机制利用数据库的批处理能力，而不修改生成的代码。