公开(公告)号：WO2005013157A2

公开(公告)日：2005-02-10

申请号：PCT/US2004/024555

申请日：2004-07-28

Applicant: ORACLE INTERNATIONAL CORPORATION ,  BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

Inventor： BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F9/5083 ,  Y10S707/972 ,  Y10S707/99944

Abstract: 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 dynamically, based on factors such as which node would be the most efficient owner relative to the performance of a particular operation. Once determined, the ownership of the data may be changed permanently to the new owner, or temporarily for the duration of the particular operation.

Abstract translation: 描述了用于改善无共享数据库系统的性能的各种技术，其中运行无共享数据库系统的至少两个节点具有对盘的共享访问。 具体地说，提供了基于诸如哪个节点相对于特定操作的性能来说最有效的所有者的因素来动态地改变无共享数据库中的数据的所有权的技术。 一旦确定，数据的所有权可以永久地更改为新的所有者，或者在特定操作期间临时更改。

公开(公告)号：WO2005013155A1

公开(公告)日：2005-02-10

申请号：PCT/US2004/024451

申请日：2004-07-28

Applicant: ORACLE INTERNATIONAL CORPORATION ,  BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

Inventor： BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F9/5083 ,  Y10S707/972 ,  Y10S707/99944

Abstract: Techniques are provided for handling distributed transaction in shared-nothing database system 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 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.

Abstract translation: 提供了用于在无共享数据库系统中处理分布式事务的技术，其中一个或多个节点可以访问共享持久存储。 分布式事务的协调器不是使用两阶段提交协议来协调分布式事务，而是与那些能够访问协调器维护的事务状态信息的参与者使用一阶段提交协议。 事务状态信息可以驻留在例如协调器的重做日志中。 在协调器失败的情况下，这些参与者可以基于存储在共享磁盘上的信息来确定分布式事务的状态。 此外，协调器能够根据参与者在共享磁盘上存储的信息来确定是否可以提交分布式事务，而不需要参与者进入正式的“准备”状态。

公开(公告)号：WO2002099658A2

公开(公告)日：2002-12-12

申请号：PCT/US2002/014710

申请日：2002-05-08

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： CHANDRASEKARAN, Sashikanth ,  BROWER, David ,  BAMFORD, Roger

IPC: G06F13/00

CPC classification number: G06F9/52 ,  Y10S707/99938

Abstract: A method and apparatus are provided for improving the performance associated with transferring a data item and obtaining a lock in a multi-node system by interpreting the block transfer message as a lock grant message. Typically when a Holder of a data item transfers a data item (e.g. block) to a Requestor of that data item, the Holder will down-convert its lock for that data item and send a message to the Master of this data item indicating that a down-convert has been performed. Subsequently, the Master sends a lock grant message to the Requestor of the data item to inform the Requestor that it has been granted a lock for the data item. By interpreting the block transfer message as a lock grant message, the down-convert message and the lock grant message can be eliminated, which results in improved performance.

Abstract translation: 提供了一种方法和装置，用于通过将块传输消息解释为锁定授权消息来改善与传送数据项相关联的性能并获得多节点系统中的锁定。 通常，当数据项的持有人将数据项（例如块）传送到该数据项的请求者时，持有者将对其数据项的锁定进行下转换，并向该数据项的主机发送一条消息，指示该数据项 已经进行了下转换。 随后，主人向数据项的请求者发送锁定授权消息，以通知请求者它已被授予数据项的锁定。 通过将块传输消息解释为锁定授权消息，可以消除下转换消息和锁定授权消息，这导致改进的性能。

公开(公告)号：WO2005013154A2

公开(公告)日：2005-02-10

申请号：PCT/US2004/024425

申请日：2004-07-28

Applicant: ORACLE INTERNATIONAL CORPORATION ,  BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

Inventor： BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

IPC: G06F17/30

CPC classification number: G06F17/30575

Abstract: 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 recovering the data owned by a failed node using multiple recovery nodes operating in parallel. The data owned by a failed node is reassigned to recovery nodes that have access to the shared disk on which the data resides. The recovery logs of the failed node are read by the recovery nodes, or by a coordinator process that distributes the recovery tasks to the recovery nodes.

Abstract translation: 描述了用于改善无共享数据库系统的性能的各种技术，其中运行无共享数据库系统的至少两个节点具有对盘的共享访问。 具体地，提供了用于使用并行操作的多个恢复节点来恢复由故障节点拥有的数据的技术。 由故障节点拥有的数据重新分配给可访问数据所在的共享磁盘的恢复节点。 故障节点的恢复日志由恢复节点或由将恢复任务分发到恢复节点的协调进程读取。

公开(公告)号：WO2002073416A3

公开(公告)日：2002-09-19

申请号：PCT/US2002/006981

申请日：2002-03-07

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： CHANDRASEKARAN, Sashikanth ,  BAMFORD, Roger ,  BRIDGE, William ,  BROWER, David ,  MACNAUGHTON, Neil ,  CHAN, Wilson ,  SRIHARI, Vinay

IPC: G06F12/00

Abstract: Techniques are provided for managing caches in a system with multiple caches that may contain different copies of the same data item. Specifically, techniques are provided for coordinating the write-to-disk operations performed on such data items to ensure that older versions of the data item are not written over newer versions, and to reduce the amount of processing required to recover after a failure. Various approaches are provided in which a master is used to coordinate with the multiple caches to cause a data item to be written to persistent storage. Techniques are also provided for managing checkpoints associated with the caches, where the checkpoints are used to determine the position at which to begin processing recovery logs in the event of a failure.

公开(公告)号：WO2002073416A2

公开(公告)日：2002-09-19

申请号：PCT/US2002/006981

申请日：2002-03-07

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： CHANDRASEKARAN, Sashikanth ,  BAMFORD, Roger ,  BRIDGE, William ,  BROWER, David ,  MACNAUGHTON, Neil ,  CHAN, Wilson ,  SRIHARI, Vinay

IPC: G06F12/00

CPC classification number: G06F12/0815 ,  G06F11/1448 ,  G06F11/1471 ,  G06F12/0804

Abstract: Techniques are provided for managing caches in a system with multiple caches that may contain different copies of the same data item. Specifically, techniques are provided for coordinating the write-to-disk operations performed on such data items to ensure that older versions of the data item are not written over newer versions, and to reduce the amount of processing required to recover after a failure. Various approaches are provided in which a master is used to coordinate with the multiple caches to cause a data item to be written to persistent storage. Techniques are also provided for managing checkpoints associated with the caches, where the checkpoints are used to determine the position at which to begin processing recovery logs in the event of a failure.

Abstract translation: 提供了用于管理具有多个高速缓存的系统中的高速缓存的技术，其可以包含相同数据项的不同副本。 具体地说，提供了用于协调对这些数据项执行的写盘操作的技术，以确保数据项的较早版本不会被写入较新的版本，并且减少在故障之后恢复所需的处理量。 提供了各种方法，其中使用主机与多个高速缓存进行协调以使数据项被写入持久存储器。 还提供了用于管理与高速缓存相关联的检查点的技术，其中检查点用于确定在发生故障的情况下开始处理恢复日志的位置。

公开(公告)号：WO2005013156A2

公开(公告)日：2005-02-10

申请号：PCT/US2004/024554

申请日：2004-07-28

Applicant: ORACLE INTERNATIONAL CORPORATION ,  BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

Inventor： BAMFORD, Roger ,  CHANDRASEKARAN, Sashikanth ,  PRUSCINO, Angelo

IPC: G06F17/30

CPC classification number: G06F17/3038 ,  G06F17/30575 ,  Y10S707/99943

Abstract: Various thechniques 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 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.

Abstract translation: 描述了各种技术用于提高无共享数据库系统的性能，其中至少两个运行无共享数据库系统的节点共享对磁盘的访问权限。 具体而言，提供了用于在不改变永久存储器上的数据的位置的情况下改变无共享数据库中的数据的所有权的技术。 由于数据的持久存储位置在数据所有权转移过程中没有发生变化，所以可以更自由地转移所有权，而且性能降低的程度要低于数据的物理重新定位所带来的性能损失。 还描述了各种技术以提供所有权的快速运行时间重新分配。 因为重新分配可以在运行期间执行，所以无需共享系统不必离线执行重新分配。 此外，这些技术描述了如何以相对精细的粒度执行重新分配，从而避免需要跨所有节点执行大量数据的批量重新分配，而仅仅重新分配其中一个节点上的少数数据项的所有权。

公开(公告)号：WO2002099701A3

公开(公告)日：2002-12-12

申请号：PCT/US2002/016886

申请日：2002-05-29

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： GANESH, Amit ,  BAMFORD, Roger

IPC: G06F17/30

Abstract: Techniques are provided for determining which data item version to supply to a query. According to the techniques, the determination is made by associating a new field, which indicates the time a data item version was current, with each data item version; associating a new field with each query, which indicates the last change that the query must see made by the transaction to which the query belongs; and determining which data item version to use to answer the query based, in part, on a comparison between the values of the two new fields.

公开(公告)号：WO2002099701A2

公开(公告)日：2002-12-12

申请号：PCT/US2002/016886

申请日：2002-05-29

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： GANESH, Amit ,  BAMFORD, Roger

IPC: G06F17/30

CPC classification number: G06F17/30548 ,  Y10S707/99952 ,  Y10S707/99954

Abstract: Techniques are provided for determining which data item version to supply to a query. According to the techniques, the determination is made by associating a new field, which indicates the time a data item version was current, with each data item version; associating a new field with each query, which indicates the last change that the query must see made by the transaction to which the query belongs; and determining which data item version to use to answer the query based, in part, on a comparison between the values of the two new fields.

Abstract translation: 提供了用于确定要向查询提供哪些数据项版本的技术。 根据该技术，通过将表示数据项目版本当前的时间的新字段与每个数据项目版本相关联来进行确定; 将新字段与每个查询相关联，这表示查询必须看到由查询所属的事务所做的最后一次更改; 以及部分地基于两个新字段的值之间的比较来确定用于回答查询的数据项版本。

公开(公告)号：EP1402414B1

公开(公告)日：2007-06-13

申请号：EP02731965.6

申请日：2002-05-29

Applicant: Oracle International Corporation

Inventor： GANESH, Amit ,  BAMFORD, Roger

IPC: G06F17/30

CPC classification number: G06F17/30548 ,  Y10S707/99952 ,  Y10S707/99954

Abstract: Techniques are provided for determining which data item version to supply to a query. According to the techniques, the determination is made by associating a new field, which indicates the time a data item version was current, with each data item version; associating a new field with each query, which indicates the last change that the query must see made by the transaction to which the query belongs; and determining which data item version to use to answer the query based, in part, on a comparison between the values of the two new fields.