Global checkpoint SCN
    1.
    发明授权
    Global checkpoint SCN 有权
    全球检查点SCN

    公开(公告)号:US07991775B2

    公开(公告)日:2011-08-02

    申请号:US12244640

    申请日:2008-10-02

    IPC分类号: G06F17/30

    摘要: Described herein are techniques for generating a global checkpoint system change number and computing a snapshot query using the global checkpoint system change number without a need to acquire global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.

    摘要翻译: 这里描述了用于生成全局检查点系统改变号码并使用全局检查点系统改变号码计算快照查询而不需要获取全局锁的技术。 在许多情况下,消除了获取全局锁的需求,从而节省了处理全局锁的开销。

    GLOBAL CHECKPOINT SCN
    2.
    发明申请
    GLOBAL CHECKPOINT SCN 有权
    全球检验点

    公开(公告)号:US20100036843A1

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

    申请号:US12244640

    申请日:2008-10-02

    IPC分类号: G06F17/30

    摘要: Described herein are techniques for generating a global checkpoint system change number and computing a snapshot query using the global checkpoint system change number without a need to acquire global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.

    摘要翻译: 这里描述了用于生成全局检查点系统改变号码并使用全局检查点系统改变号码计算快照查询而不需要获取全局锁的技术。 在许多情况下,消除了获取全局锁的需求,从而节省了处理全局锁的开销。

    Techniques for improved read-write concurrency
    5.
    发明申请
    Techniques for improved read-write concurrency 有权
    改进的读写并发技术

    公开(公告)号:US20080071997A1

    公开(公告)日:2008-03-20

    申请号:US11521908

    申请日:2006-09-15

    IPC分类号: G06F13/00 G06F12/14

    摘要: Techniques are provided for performing changes to a resource governed by a locking mechanism. An entity (such as a server instance in a database system cluster) requests permission to modify the resource. In response to the request, the entity receives a first lock on the resource, which grants permission to perform the change to the resource without making the change permanent. After receiving the first lock, the entity performs the change to a copy of the resource that resides in shared memory without making another copy of the resource. After performing the change and until receiving permission to make the change permanent, the entity prevents the change to the resource from becoming permanent. After performing the change, the entity receives a second lock on the resource, which grants the entity permission to make the change permanent. After receiving the second lock, the entity ceases to prevent the change to the resource from becoming permanent.

    摘要翻译: 提供了用于对由锁定机构管理的资源进行更改的技术。 实体(如数据库系统集群中的服务器实例)请求修改资源的权限。 响应于该请求,实体在资源上接收到第一个锁定,该权限允许对资源执行更改,而不会使更改永久性。 在接收到第一个锁定之后,实体对驻留在共享内存中的资源的副本执行更改,而不创建资源的另一个副本。 执行变更后,直到获得变更永久性的许可,实体将防止资源变为永久性。 执行更改后,实体将在资源上收到第二个锁定,该实体授予实体永久性更改权限。 收到第二个锁后,实体停止防止资源变为永久性。

    Techniques for improved read-write concurrency
    6.
    发明授权
    Techniques for improved read-write concurrency 有权
    改进的读写并发技术

    公开(公告)号:US07600063B2

    公开(公告)日:2009-10-06

    申请号:US11521908

    申请日:2006-09-15

    IPC分类号: G06F12/00

    摘要: Techniques are provided for performing changes to a resource governed by a locking mechanism. An entity (such as a server instance in a database system cluster) requests permission to modify the resource. In response to the request, the entity receives a first lock on the resource, which grants permission to perform the change to the resource without making the change permanent. After receiving the first lock, the entity performs the change to a copy of the resource that resides in shared memory without making another copy of the resource. After performing the change and until receiving permission to make the change permanent, the entity prevents the change to the resource from becoming permanent. After performing the change, the entity receives a second lock on the resource, which grants the entity permission to make the change permanent. After receiving the second lock, the entity ceases to prevent the change to the resource from becoming permanent.

    摘要翻译: 提供了用于对由锁定机构管理的资源进行更改的技术。 实体(如数据库系统集群中的服务器实例)请求修改资源的权限。 响应于该请求,实体在资源上接收到第一个锁定,该权限允许对资源执行更改,而不会使更改永久性。 在接收到第一个锁定之后,实体对驻留在共享内存中的资源的副本执行更改,而不创建资源的另一个副本。 执行变更后,直到获得变更永久性的许可,实体将防止资源变为永久性。 执行更改后,实体将在资源上收到第二个锁定,该实体授予实体永久性更改权限。 收到第二个锁后,实体停止防止资源变为永久性。

    Managing replacement of data in a cache on a node based on caches of other nodes
    10.
    发明授权
    Managing replacement of data in a cache on a node based on caches of other nodes 有权
    基于其他节点的缓存管理节点上的缓存中的数据替换

    公开(公告)号:US06633891B1

    公开(公告)日:2003-10-14

    申请号:US09652384

    申请日:2000-08-31

    IPC分类号: G06F1730

    摘要: A mechanism is described for managing the caches on nodes in a cluster. The caches are globally managed so that a data item may be retained in any cache on the nodes. This may be accomplished by, for example, a replacement policy for replacing data items stored in the buffers of the caches, where a buffer is selected for replacement in a manner that accounts for factors that include the state of the caches of other nodes. Some cached data items are designated as globally shared, and assigned (either statically or dynamically) a primary cache. For example, if a buffer holds a copy of a data item whose primary cache is another node, then the data item in the buffer is favored for replacement over a local data item or a global data item for which this is the primary cache. According to another aspect of the invention, the cache retention value of buffers on different nodes are compared, and the buffer with the lowest cache retention value is selected for replacement. According to yet another aspect of the present invention, the replacement policy accounts for the configuration of other caches in the cluster.

    摘要翻译: 描述了一种用于管理群集中节点上的高速缓存的机制。 高速缓存被全局管理,使数据项可以保留在节点上的任何高速缓存中。 这可以通过例如用于替换存储在高速缓存的缓冲器中的数据项的替换策略来实现,其中以考虑到包括其他节点的高速缓存的状态的因素的方式选择用于替换的缓冲器。 一些缓存的数据项被指定为全局共享,并被分配(静态地或动态地)主缓存。 例如,如果缓冲器保存其主缓存是另一个节点的数据项的副本,则缓冲器中的数据项有利于替换本地数据项或作为主缓存的全局数据项。 根据本发明的另一方面,比较不同节点上的缓冲器的缓存保留值,并选择具有最低缓存保留值的缓冲器进行替换。 根据本发明的另一方面,替换策略考虑了集群中其他高速缓存的配置。