会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Ownership reassignment in a shared-nothing database system
    • 无共享数据库系统中的所有权重新分配
    • US07139772B2
    • 2006-11-21
    • US10665062
    • 2003-09-17
    • Roger J. BamfordSashikanth ChandrasekaranAngelo Pruscino
    • Roger J. BamfordSashikanth ChandrasekaranAngelo Pruscino
    • G06F17/30
    • G06F17/3038G06F17/30575Y10S707/99943
    • Various techniques are described for improving the performance of a shared-nothing database system in which at least two of the nodes that are running the shared-nothing database system have shared access to a disk. Specifically, techniques are provided for changing the ownership of data in a shared-nothing database without changing the location of the data on persistent storage. Because the persistent storage location for the data is not changed during a transfer of ownership of the data, ownership can be transferred more freely and with less of a performance penalty than would otherwise be incurred by a physical relocation of the data. Various techniques are also described for providing fast run-time reassignment of ownership. Because the reassignment can be performed during run-time, the shared-nothing system does not have to be taken offline to perform the reassignment. Further, the techniques describe how the reassignment can be performed with relatively fine granularity, avoiding the need to perform bulk reassignment of large amounts of data across all nodes merely to reassign ownership of a few data items on one of the nodes.
    • 描述了用于改善无共享数据库系统的性能的各种技术,其中运行无共享数据库系统的至少两个节点具有对盘的共享访问。 具体来说,提供了用于在不改变永久存储器上的数据的位置的情况下改变无共享数据库中的数据的所有权的技术。 由于数据的持有存储位置在数据的所有权转移期间没有改变,因此所有权可以更自由地传送,而不会因数据的物理重定位而导致的性能损失更少。 还描述了用于提供所有权的快速运行时重新分配的各种技术。 因为可以在运行时执行重新分配,所以无需共享系统就不必脱机执行重新分配。 此外,这些技术描述了如何以相对精细的粒度来执行重新分配,避免了需要在所有节点上执行大量数据的批量重新分配,仅仅重新分配其中一个节点上的几个数据项的所有权。
    • 5. 发明授权
    • One-phase commit in a shared-nothing database system
    • 无共享数据库系统中的一阶段提交
    • US06845384B2
    • 2005-01-18
    • US10718875
    • 2003-11-21
    • Roger J. BamfordSashikanth ChandrasekaranAngelo Pruscino
    • Roger J. BamfordSashikanth ChandrasekaranAngelo Pruscino
    • G06F9/50G06F17/30
    • G06F17/30575G06F17/30377Y10S707/99956
    • Techniques are provided for handling distributed transactions in shared-nothing database systems where one or more of the nodes have access to a shared persistent storage. Rather than coordinate the distributed transaction using a two-phase commit protocol, the coordinator of the distributed transaction uses a one-phase commit protocol with those participants that have access to the transaction status information maintained by the coordinator. The transaction status information may reside, for example, in the redo log of the coordinator. In the case that the coordinator fails, those participants can determine the state of the distributed transaction based on information stored on the shared disk. In addition, the coordinator is able to determine whether it is possible to commit the distributed transaction based on information that is stored on the shared disk by the participants, without those participants entering a formal “prepared” state.
    • 提供了用于在无共享数据库系统中处理分布式事务的技术,其中一个或多个节点可以访问共享永久存储。 分布式事务的协调器不是使用两阶段提交协议来协调分布式事务,而是与那些能够访问协调器维护的事务状态信息的参与者使用一阶段提交协议。 事务状态信息可以驻留在例如协调器的重做日志中。 在协调器失败的情况下,这些参与者可以基于存储在共享磁盘上的信息来确定分布式事务的状态。 此外,协调器能够根据参与者在共享磁盘上存储的信息来确定是否可以提交分布式事务,而不需要参与者进入正式的“准备”状态。