Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems
    1.
    发明申请
    Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems 审中-公开
    维护由集群数据库系统的外部事务管理器管理的分布式事务的全局状态

    公开(公告)号:US20080243865A1

    公开(公告)日:2008-10-02

    申请号:US11729473

    申请日:2007-03-28

    IPC分类号: G06F17/30

    CPC分类号: G06F16/27

    摘要: In accordance with an embodiment of the present invention, a transaction tracking mechanism is provided by a database server cluster to keep track of a global state of a distributed transaction. The global state of the distributed transaction comprises one or more statuses that are associated with one or more transaction branches that are part of the distributed transaction. The global state may be associated with a global lock. Through using the global state in association with the global lock, problems such as partial commits, data inconsistency, access contentions and deadlocks may be avoided when the database server cluster processes the distributed transaction.

    摘要翻译: 根据本发明的实施例,由数据库服务器集群提供事务跟踪机制以跟踪分布式事务的全局状态。 分布式事务的全局状态包括与作为分布式事务的一部分的一个或多个事务分支相关联的一个或多个状态。 全局状态可能与全局锁相关联。 通过使用与全局锁相关联的全局状态,当数据库服务器集群处理分布式事务时,可能会避免诸如部分提交,数据不一致,访问争用和死锁等问题。

    Transparent support for distributed transactions in a clustered disk-sharing database environment
    2.
    发明授权
    Transparent support for distributed transactions in a clustered disk-sharing database environment 有权
    在群集式磁盘共享数据库环境中透明支持分布式事务

    公开(公告)号:US08818934B2

    公开(公告)日:2014-08-26

    申请号:US12048161

    申请日:2008-03-13

    申请人: Yong Hu Bipul Sinha

    发明人: Yong Hu Bipul Sinha

    IPC分类号: G06F17/30

    CPC分类号: G06F9/466

    摘要: A method, system and computer program product for transparent support for distributed transactions in a clustered disk-sharing database environment is disclosed. In one approach, a method, a system and a computer program product are disclosed that disassociate a transaction with a session at a first resource manger, send a request to a second resource manager for the transaction that requires access to stored transaction information from prior requests for the transaction, determine whether the second resource manager has access to transaction information for the transaction stored using the session that has been disassociated with the transaction, obtain an identity of the first resource manager in data shared by the first and the second resource managers, and request access to the transaction information at the first resource manager.

    摘要翻译: 公开了一种用于对集群磁盘共享数据库环境中的分布式事务进行透明支持的方法,系统和计算机程序产品。 在一种方法中,公开了一种方法,系统和计算机程序产品,其将事务与第一资源管理器处的会话分离,向需要从先前请求访问存储的交易信息的事务的第二资源管理器发送请求 对于所述事务,确定所述第二资源管理器是否能够使用已经与所述事务解除关联的会话存储的所述事务的事务信息访问,获得由所述第一和第二资源管理器共享的数据中的所述第一资源管理器的身份, 并请求访问第一个资源管理器处的交易信息。

    TRANSPARENT SUPPORT FOR DISTRIBUTED TRANSACTIONS IN A CLUSTERED DISK-SHARING DATABASE ENVIRONMENT
    3.
    发明申请
    TRANSPARENT SUPPORT FOR DISTRIBUTED TRANSACTIONS IN A CLUSTERED DISK-SHARING DATABASE ENVIRONMENT 有权
    集群式共享数据库环境中分布式交易的透明支持

    公开(公告)号:US20090235255A1

    公开(公告)日:2009-09-17

    申请号:US12048161

    申请日:2008-03-13

    申请人: Yong HU Bipul Sinha

    发明人: Yong HU Bipul Sinha

    IPC分类号: G06F9/44

    CPC分类号: G06F9/466

    摘要: A method, system and computer program product for transparent support for distributed transactions in a clustered disk-sharing database environment is disclosed. In one approach, a method, a system and a computer program product are disclosed that disassociate a transaction with a session at a first resource manger, send a request to a second resource manager for the transaction that requires access to stored transaction information from prior requests for the transaction, determine whether the second resource manager has access to transaction information for the transaction stored using the session that has been disassociated with the transaction, obtain an identity of the first resource manager in data shared by the first and the second resource managers, and request access to the transaction information at the first resource manager.

    摘要翻译: 公开了一种用于对集群磁盘共享数据库环境中的分布式事务进行透明支持的方法,系统和计算机程序产品。 在一种方法中,公开了一种方法,系统和计算机程序产品,其将事务与第一资源管理器处的会话分离,向需要从先前请求访问存储的交易信息的事务的第二资源管理器发送请求 对于所述事务,确定所述第二资源管理器是否能够使用已经与所述事务解除关联的会话存储的所述事务的事务信息访问,获得由所述第一和第二资源管理器共享的数据中的所述第一资源管理器的身份, 并请求访问第一个资源管理器处的交易信息。

    Carbon black reactor
    4.
    发明授权

    公开(公告)号:US09718963B2

    公开(公告)日:2017-08-01

    申请号:US13642951

    申请日:2011-04-19

    IPC分类号: C09C1/50

    CPC分类号: C09C1/50

    摘要: The present invention discloses a reactor (100) for manufacturing carbon black, said reactor (100) comprising flow guide means (110) provided between a fuel burner (106) and an air inlet (108) for altering the flow path of combustion air entering at the air inlet (108) to result in a better mixing between the fuel and the combustion air, thereby, producing higher temperature hot combustion gases which are subsequently received in a reaction chamber (104) where they react with a carbonaceous feedstock to produce carbon black. The reactor (100) of the present invention increases the carbon black production by 5-20%. Further, the positioning of the flow guide means (110) stabilizes the flame from the fuel burner (106) to maintain it along the reactor axis, thus, increasing the life of the refractory lining (114).

    Method and mechanism for determining life intervals for a key in an index
    5.
    发明授权
    Method and mechanism for determining life intervals for a key in an index 有权
    确定索引中键的生命周期的方法和机制

    公开(公告)号:US09400812B2

    公开(公告)日:2016-07-26

    申请号:US13209224

    申请日:2011-08-12

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    CPC分类号: G06F17/30309

    摘要: Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.

    摘要翻译: 公开了一种在给予键时确定一个或多个生命周期的机制,系统,界面和过程。 另外,可以在一系列键内为每个键确定一个或多个生命周期。 这种类型的过程对于审计目的是有用的,或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。 这有助于算法,机制和过程来实现过去版本的查询。

    Apparatus to selectively remove the effects of transactions in online database and enable logical recovery
    6.
    发明授权
    Apparatus to selectively remove the effects of transactions in online database and enable logical recovery 有权
    用于选择性地消除在线数据库中事务的影响并启用逻辑恢复的装置

    公开(公告)号:US07873605B2

    公开(公告)日:2011-01-18

    申请号:US11699689

    申请日:2007-01-29

    IPC分类号: G06F7/00 G06F17/00

    CPC分类号: G06F17/30377

    摘要: A method and apparatus for selective removal of user data changes is provided. In one embodiment, the methodology is implemented by a logical recovery mechanism. Upon receiving a request to selectively remove user data changes stored in a database, the mechanism creates an empty set of transactions to be populated for selective removal, identifies one or more transactions and places them in the causal set of transactions. The mechanism further identifies other transactions that logically depend on any transaction already in the causal set of transactions. Finally, either while the causal set of transactions is being identified or after the identification is completed, the mechanism also determines user data changes made by the causal set of transactions. One or more compensating transactions may be generated by the logical recovery mechanism, which when executed, reverse the user data changes.

    摘要翻译: 提供了用于选择性地去除用户数据变化的方法和装置。 在一个实施例中,该方法由逻辑恢复机制来实现。 在接收到选择性地删除存储在数据库中的用户数据改变的请求时,该机制创建要填充的空的一组事务以进行选择性删除,识别一个或多个事务并将它们放置在因果集合中。 该机制进一步识别逻辑上依赖于因果交易集合中的任何交易的其他交易。 最后,既然确定了交易的因果集合,或者在识别完成之后,该机制还确定了因果集交易所做的用户数据更改。 一个或多个补偿事务可以由逻辑恢复机制产生,逻辑恢复机制在执行时反转用户数据改变。

    ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION
    7.
    发明申请
    ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION 有权
    用于确定DML操作影响的自适应滤波器索引

    公开(公告)号:US20100036803A1

    公开(公告)日:2010-02-11

    申请号:US12326822

    申请日:2008-12-02

    IPC分类号: G06F7/06 G06F17/30

    CPC分类号: G06F17/3051

    摘要: Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created based on predicates contained in the registered queries. The filter conditions may include exclusive predicates and join predicates. Join predicates that join a table T1 with a table T2 may be instantiated by replacing references to table T2 with values extracted from table T2. Various techniques are described for recognizing situations in which a query can be included in, or excluded from, the set of likely-changed queries, without fully evaluating the filter conditions that correspond to the queries.

    摘要翻译: 公开了用于创建和使用过滤器索引的技术,以便识别其结果集可能由于对表的改变而改变的注册查询。 过滤器索引条目基于过滤器条件。 过滤条件是根据注册查询中包含的谓词创建的。 过滤条件可能包括排除谓词和连接谓词。 可以通过用从表T2提取的值替换对表T2的引用来实例化加入具有表T2的表T1的连接谓词。 描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况,而不完全评估与查询相对应的过滤条件。

    Method and apparatus for accessing data as it existed at a previous point in time
    8.
    发明授权
    Method and apparatus for accessing data as it existed at a previous point in time 有权
    用于访问在先前时间点存在的数据的方法和装置

    公开(公告)号:US06983286B1

    公开(公告)日:2006-01-03

    申请号:US10325211

    申请日:2002-12-18

    IPC分类号: G06F17/30

    摘要: Techniques are provided for sharing of flashback cursors by adding a time domain property to flashback cursors. This time domain property defines the range of flashback times for which the flashback cursor is valid. According to one embodiment, this “validity range” is closed at the lower bound and open at the upper bound. A subsequent flashback query can share an existing flashback cursor if the flashback time of the subsequent flashback query falls within the validity range of the existing flashback cursor. In one embodiment, the validity range of a flashback cursor is established based on times associated with indexes used to process the flashback query for which the flashback cursor was made. Consequently, an existing flashback cursor is less likely to be used by a subsequent flashback query when it would be inefficient to do so.

    摘要翻译: 提供了通过向闪回光标添加时域属性来共享闪回光标的技术。 此时域属性定义闪回光标有效的闪回时间范围。 根据一个实施例,该“有效范围”在下限处封闭并在上限处打开。 如果后续闪回查询的闪回时间落在现有闪回游标的有效范围内,后续闪回查询可以共享现有闪回游标。 在一个实施例中,闪回光标的有效范围基于与用于处理闪回光标的闪回查询的索引相关联的时间来建立。 因此,当这样做的效率低下时,现有的闪回游标不太可能被随后的闪回查询使用。

    Method and mechanism for determining life intervals for a key in an index
    9.
    发明申请
    Method and mechanism for determining life intervals for a key in an index 有权
    确定索引中键的生命周期的方法和机制

    公开(公告)号:US20050120064A1

    公开(公告)日:2005-06-02

    申请号:US10933828

    申请日:2004-09-03

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30309

    摘要: Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.

    摘要翻译: 公开了一种在给予键时确定一个或多个生命周期的机制,系统,界面和过程。 另外,可以在一系列键内为每个键确定一个或多个生命周期。 这种类型的过程对于审计目的是有用的,或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。 这有助于算法,机制和过程来实现过去版本的查询。