Apparatus and method for enabling database batch updates without modifying generated code
    1.
    发明授权
    Apparatus and method for enabling database batch updates without modifying generated code 失效
    用于启用数据库批量更新而不修改生成代码的装置和方法

    公开(公告)号:US07225205B2

    公开(公告)日:2007-05-29

    申请号:US10777735

    申请日:2004-02-12

    IPC分类号: G06F17/30

    CPC分类号: G06F9/466 G06F17/30306

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

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

    Modifying connection records
    2.
    发明授权
    Modifying connection records 失效
    修改连接记录

    公开(公告)号:US07962782B2

    公开(公告)日:2011-06-14

    申请号:US12123948

    申请日:2008-05-20

    IPC分类号: G06F11/00

    CPC分类号: G06F11/1482 G06F11/1443

    摘要: Systems and methods to modify a set of connection records are described. A determination is made that an application failed to access a first database via a connection record, where the connection record includes data to access the first database. A determination is made that a second database is accessible, where the second database is a failover database to the first database. A set of connection records associated with the first database is modified to enable access to the second database.

    摘要翻译: 描述了修改一组连接记录的系统和方法。 确定应用程序未能通过连接记录访问第一数据库,其中连接记录包括访问第一数据库的数据。 确定可访问第二数据库,其中第二数据库是到第一数据库的故障转移数据库。 修改与第一数据库相关联的一组连接记录以允许访问第二数据库。

    CUSTOMIZED ROLL BACK STRATEGY FOR DATABASES IN MIXED WORKLOAD ENVIRONMENTS
    3.
    发明申请
    CUSTOMIZED ROLL BACK STRATEGY FOR DATABASES IN MIXED WORKLOAD ENVIRONMENTS 审中-公开
    用于混合工作环境中数据库的自定义滚动返回策略

    公开(公告)号:US20090106326A1

    公开(公告)日:2009-04-23

    申请号:US11876953

    申请日:2007-10-23

    IPC分类号: G06F17/30

    CPC分类号: G06F16/2343

    摘要: Roll back strategies for database deadlock resolution are customized by identifying a first transaction to a database, identifying a second transaction to the database and detecting a deadlock between the first and second transactions with respect to the database. The deadlock is resolved based upon a predetermined roll back strategy associated with at least one of the first or second transactions to identify a select one of the first and second transactions for roll back and a request is conveyed to roll back the selected one of the first and second transactions, wherein the preferred transaction is allowed to continue processing.

    摘要翻译: 数据库死锁解决方案的回滚策略是通过识别到数据库的第一个事务,识别到数据库的第二个事务和检测第一个和第二个事务之间相对于数据库的死锁来自定义的。 基于与第一或第二交易中的至少一个交易相关联的预定回滚策略来解决死锁,以识别用于回滚的第一和第二交易中的选择一个,并且请求被传送以回滚所选择的第一和第二交易中的所选择的一个 和第二交易,其中优选交易被允许继续处理。

    Registering a resource that delegates commit voting
    5.
    发明授权
    Registering a resource that delegates commit voting 失效
    注册委托投票的资源

    公开(公告)号:US07818429B2

    公开(公告)日:2010-10-19

    申请号:US12317544

    申请日:2008-12-23

    IPC分类号: G06F15/173

    CPC分类号: G06F9/466 G06F17/30377

    摘要: A computer system and storage 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.

    摘要翻译: 一种计算机系统和存储介质,在一个实施例中,如果资源希望将提交投票委托给另一资源,则在一个实施例中接收资源的分配请求并将该资源注册为无投票参与者。 然后,注册的资源被禁止参与封闭的事务上下文,而是在事务完成时被通知。 如果资源不希望委托提交投票,则该资源作为投票参与者登记。 以这种方式,当在交易中使用多个资源时,可以注册资源并且接收事务完成的通知而不是在提交决定上登记并投票。 单个资源对多个其他资源负责的事务的结果是事务完成避免了两阶段提交协议以及由此导致的性能下降。

    Registering a resource that delegates commit voting
    6.
    发明申请
    Registering a resource that delegates commit voting 失效
    注册委托投票的资源

    公开(公告)号:US20090113441A1

    公开(公告)日:2009-04-30

    申请号:US12317544

    申请日:2008-12-23

    IPC分类号: G06F9/50

    CPC分类号: G06F9/466 G06F17/30377

    摘要: A computer system and storage 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.

    摘要翻译: 一种计算机系统和存储介质,在一个实施例中,如果资源希望将提交投票委托给另一资源,则在一个实施例中接收资源的分配请求并将该资源注册为无投票参与者。 然后,注册的资源被禁止参与封闭的事务上下文,而是在事务完成时被通知。 如果资源不希望委托提交投票,则该资源作为投票参与者登记。 以这种方式,当在交易中使用多个资源时,可以注册资源并且接收事务完成的通知而不是在提交决定上登记并投票。 单个资源对多个其他资源负责的事务的结果是事务完成避免了两阶段提交协议以及由此导致的性能下降。

    MODIFYING CONNECTION RECORDS
    7.
    发明申请
    MODIFYING CONNECTION RECORDS 失效
    修改连接记录

    公开(公告)号:US20090292953A1

    公开(公告)日:2009-11-26

    申请号:US12123948

    申请日:2008-05-20

    IPC分类号: G06F11/00

    CPC分类号: G06F11/1482 G06F11/1443

    摘要: Systems and methods to modify a set of connection records are described. A determination is made that an application failed to access a first database via a connection record, where the connection record includes data to access the first database. A determination is made that a second database is accessible, where the second database is a failover database to the first database. A set of connection records associated with the first database is modified to enable access to the second database.

    摘要翻译: 描述了修改一组连接记录的系统和方法。 确定应用程序未能通过连接记录访问第一数据库,其中连接记录包括访问第一数据库的数据。 确定可访问第二数据库,其中第二数据库是到第一数据库的故障转移数据库。 修改与第一数据库相关联的一组连接记录以允许访问第二数据库。

    Registering a resource that delegates commit voting
    8.
    发明授权
    Registering a resource that delegates commit voting 有权
    注册委托投票的资源

    公开(公告)号:US07483987B2

    公开(公告)日:2009-01-27

    申请号:US11000436

    申请日:2004-11-30

    IPC分类号: G06F15/173

    CPC分类号: G06F9/466 G06F17/30377

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

    摘要翻译: 一种方法,装置,系统和信号承载介质,在一个实施例中,如果资源希望将提交投票委托给另一资源,则接收资源的分配请求并将资源注册为无投票参与者。 然后,注册的资源被禁止参与封闭的事务上下文,而是在事务完成时被通知。 如果资源不希望委托提交投票,则该资源作为投票参与者登记。 以这种方式,当在交易中使用多个资源时,可以注册资源并且接收事务完成的通知而不是在提交决定上登记并投票。 单个资源对多个其他资源负责的事务的结果是事务完成避免了两阶段提交协议以及由此导致的性能下降。