公开(公告)号：US07277897B2

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

申请号：US10831401

申请日：2004-04-23

申请人： Roger J. Bamford ,  Sashikanth Chandrasekaran ,  Angelo Pruscino

发明人： Roger J. Bamford ,  Sashikanth Chandrasekaran ,  Angelo Pruscino

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  G06F9/5083 ,  Y10S707/972 ,  Y10S707/99944

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

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

公开(公告)号：US20070185872A1

公开(公告)日：2007-08-09

申请号：US11346822

申请日：2006-02-03

申请人： Eugene Ho ,  Wilson Wai Chan ,  Tak Wang ,  Angelo Pruscino ,  Tolga Yurek

发明人： Eugene Ho ,  Wilson Wai Chan ,  Tak Wang ,  Angelo Pruscino ,  Tolga Yurek

IPC分类号： G06F17/30

CPC分类号： G06F9/526 ,  G06F2209/522 ,  G06F2209/523

摘要： A method and apparatus for managing locks in a database system is provided. A master node grants a lock on a first resource and a group of resources that includes the first resource to a first requester node. The requester node receives a mapping corresponding to the group of resources that may indicate that a lock already exists for a second resource in the group. If the requester node desires a lock on a resource located in the group, the requester node grants itself the lock without notifying the master node. A second requester node requests a lock for a particular resource in the group of resources. The first requester node grants the lock on the particular resource and updates the mapping to indicate that a different node holds a lock for the particular resource.

摘要翻译： 提供了一种用于管理数据库系统中的锁的方法和装置。 主节点向包括第一资源的第一资源和一组资源授予对第一请求者节点的锁定。 请求者节点接收对应于可以指示组中的第二资源的锁已经存在的资源组的映射。 如果请求者节点希望对位于组中的资源进行锁定，则请求者节点自己给予锁定而不通知主节点。 第二个请求者节点向资源组中的特定资源请求锁。 第一个请求者节点授予对特定资源的锁定，并更新映射以指示不同的节点持有特定资源的锁。

公开(公告)号：US07152148B2

公开(公告)日：2006-12-19

申请号：US10810786

申请日：2004-03-26

申请人： James Williams ,  William Bridge ,  Richard Long ,  Patrick Ritto ,  Thomas Sepez ,  Angelo Pruscino

发明人： James Williams ,  William Bridge ,  Richard Long ,  Patrick Ritto ,  Thomas Sepez ,  Angelo Pruscino

IPC分类号： G06F12/14

CPC分类号： G06F17/30952 ,  G06F11/1435 ,  G06F17/30067 ,  G06F21/604 ,  G06F21/6227 ,  G06F21/805 ,  Y10S707/99936

摘要： Methods are provided for communicating with and regulating access to a storage system contained within a file system. Storage access keys are used to communicate to the file system changes in location of data stored in the storage system. Fence keys are used to regulate access to the storage system.

公开(公告)号：US07120651B2

公开(公告)日：2006-10-10

申请号：US10831248

申请日：2004-04-23

申请人： Roger J. Bamford ,  Sashikanth Chandrasekaran ,  Angelo Pruscino

发明人： Roger J. Bamford ,  Sashikanth Chandrasekaran ,  Angelo Pruscino

IPC分类号： G06F12/16 ,  G06F13/00

CPC分类号： G06F17/3048 ,  G06F12/0871 ,  G06F12/0893 ,  Y10S707/99952

摘要： Various techniques are described for improving the performance of a multiple node system by allocating, in two or more nodes of the system, partitions of a shared cache. A mapping is established between the data items managed by the system, and the various partitions of the shared cache. When a node requires a data item, the node first determines which partition of the shared cache corresponds to the required data item. If the data item does not currently reside in the corresponding partition, the data item is loaded into the corresponding partition even if the partition does not reside on the same node that requires the data item. The node then reads the data item from the corresponding partition of the shared cache.

摘要翻译： 描述了各种技术，用于通过在系统的两个或更多个节点中分配共享高速缓存的分区来提高多节点系统的性能。 在系统管理的数据项和共享缓存的各个分区之间建立映射。 当节点需要数据项时，节点首先确定共享缓存的哪个分区对应于所需的数据项。 如果数据项当前不在相应的分区中，则即使分区不在需要数据项的同一节点上，数据项也会被加载到相应的分区中。 然后，节点从共享高速缓存的相应分区读取数据项。

公开(公告)号：US5150472A

公开(公告)日：1992-09-22

申请号：US424455

申请日：1989-10-20

申请人： Ted E. Blank ,  Donald F. Ferguson ,  Jeffrey A. Frey ,  Angelo Pruscino ,  Robert R. Rogers ,  Erhard Rahm

发明人： Ted E. Blank ,  Donald F. Ferguson ,  Jeffrey A. Frey ,  Angelo Pruscino ,  Robert R. Rogers ,  Erhard Rahm

IPC分类号： G06F12/08 ,  G06F12/10 ,  G06F12/12

CPC分类号： G06F12/0862 ,  G06F12/121 ,  G06F12/0866 ,  G06F2212/311 ,  G06F2212/6026

摘要： Page management mechanisms provide candidates for page stealing and prefetching from a main storage data cache of shared data when the jobs sharing the data are accessing it in a sequential manner. Pages are stolen behind the first reader in the cache, and thereafter at locations least likely to be soon re-referenced by trailing readers. A "clustering" of readers may be promoted to reduce I/O contention. Prefetching is carried out so that the pages most likely to be soon referenced by one of the readers are brought into the cache.

公开(公告)号：US09027025B2

公开(公告)日：2015-05-05

申请号：US11736132

申请日：2007-04-17

申请人： Michael Zoll ,  Wilson Wai Shun Chan ,  Angelo Pruscino ,  Tak Fung Wang

发明人： Michael Zoll ,  Wilson Wai Shun Chan ,  Angelo Pruscino ,  Tak Fung Wang

IPC分类号： G06F9/46 ,  G06F11/34

CPC分类号： G06F11/3409 ,  G06F2201/81 ,  G06F2201/86

摘要： Techniques for monitoring resources of a computer system are provided. A monitoring process collects and reports utilization data for one or more resources of a computer system, such as CPU, memory, disk I/O, and network I/O. Instead of reporting just an average of the collected data over a period of time (e.g., 10 seconds), the monitoring process at least reports individually collected resource utilization values. If one or more of the utilization values exceed specified thresholds for the respective resources, then an alert may be generated. In one approach, the monitoring process is made a real-time priority process in the computer system to ensure that the memory used by the monitoring process is not swapped out of memory. Also, being a real-time priority process ensures that the monitoring process obtains a CPU in order collect resource utilization data even when the computer system is in a starvation mode.

摘要翻译： 提供了一种监控计算机系统资源的技术。 监视过程收集并报告计算机系统的一个或多个资源（例如CPU，存储器，磁盘I / O和网络I / O）的利用率数据。 监视过程至少报告单独收集的资源利用价值，而不是仅在一段时间（例如10秒）内报告所收集的数据的平均值。 如果一个或多个利用率值超过相应资源的指定阈值，则可以生成警报。 在一种方法中，监控过程在计算机系统中被实现为一个实时优先级过程，以确保监视进程使用的内存不会被交换出内存。 而且，作为实时优先级过程，即使计算机系统处于饥饿模式，也可以确保监视进程获得CPU以便收集资源利用率数据。

公开(公告)号：US08839272B2

公开(公告)日：2014-09-16

申请号：US13450396

申请日：2012-04-18

申请人： Frederick S. Glover ,  Diane Lebel ,  Thomas J. Engle ,  Angelo Pruscino

发明人： Frederick S. Glover ,  Diane Lebel ,  Thomas J. Engle ,  Angelo Pruscino

IPC分类号： G06F3/00 ,  G06F9/44

CPC分类号： G06F9/545 ,  G06F9/468 ,  G06F11/3034

摘要： The approaches described herein provide support for application specific policies for conventional operating systems. In an embodiment, a kernel module representing a kernel subsystem is executed within an operating system's kernel. The kernel subsystem may be configured to respond to particular requests with one or more default actions. Additionally, the kernel subsystem may define a number of sub-modules which represent application specific policies that deviate from the default actions. Each sub-module may define one or more sets of conditions which indicate when the sub-module is applicable to a request and one or more sets of corresponding actions to take when the conditions are met. When an application sends a request to the kernel subsystem, the kernel subsystem determines whether the request meets the conditions of a particular sub-module. If the particular sub-module's conditions are met, the kernel subsystem performs the corresponding actions of the particular sub-module.

摘要翻译： 本文描述的方法为常规操作系统的应用特定策略提供支持。 在一个实施例中，表示内核子系统的内核模块在操作系统的内核中被执行。 内核子系统可以被配置为用一个或多个默认动作响应特定请求。 此外，内核子系统可以定义多个子模块，这些子模块表示偏离默认动作的应用程序特定策略。 每个子模块可以定义一个或多个条件集合，其指示子模块何时可应用于请求以及满足条件时要采取的一组或多组相应动作。 当应用程序向内核子系统发送请求时，内核子系统确定请求是否满足特定子模块的条件。 如果满足特定子模块的条件，则内核子系统执行特定子模块的相应动作。

公开(公告)号：US08234517B2

公开(公告)日：2012-07-31

申请号：US10831413

申请日：2004-04-23

申请人： Roger J. Bamford ,  Sashikanth Chandrasekaran ,  Angelo Pruscino

发明人： Roger J. Bamford ,  Sashikanth Chandrasekaran ,  Angelo Pruscino

IPC分类号： G06F11/00

CPC分类号： G06F17/30575

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

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

公开(公告)号：US08220001B2

公开(公告)日：2012-07-10

申请号：US12371534

申请日：2009-02-13

申请人： Wilson Chan ,  Deepti Srivastava ,  Tolga Yurek ,  Yu Kin Ho ,  John Hsu ,  Tak Fung Wang ,  Angelo Pruscino

发明人： Wilson Chan ,  Deepti Srivastava ,  Tolga Yurek ,  Yu Kin Ho ,  John Hsu ,  Tak Fung Wang ,  Angelo Pruscino

IPC分类号： G06F9/455 ,  G06F9/46

CPC分类号： G06F11/0709 ,  G06F11/0757

摘要： Described herein are techniques for adaptively managing timers that are used in various layers of a node. In many cases, the number of timers that occur in the system is reduced by proactively and reactively adjusting values of the timers based on conditions affecting the system, thereby making such a system to perform significantly better and more resiliently than otherwise.

摘要翻译： 这里描述了用于自适应地管理在节点的各个层中使用的定时器的技术。 在许多情况下，系统中发生定时器的次数通过主动地和根据影响系统的条件来反应性地调整定时器的值来减少，从而使这样一个系统比其他系统执行得更好，更有弹性。

公开(公告)号：US08103642B2

公开(公告)日：2012-01-24

申请号：US11346822

申请日：2006-02-03

申请人： Eugene Ho ,  Wilson Wai Shun Chan ,  Tak Fung Wang ,  Angelo Pruscino ,  Tolga Yurek

发明人： Eugene Ho ,  Wilson Wai Shun Chan ,  Tak Fung Wang ,  Angelo Pruscino ,  Tolga Yurek

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F15/173

CPC分类号： G06F9/526 ,  G06F2209/522 ,  G06F2209/523

摘要： A method and apparatus for managing locks in a database system is provided. A master node grants a lock on a first resource and a group of resources that includes the first resource to a first requester node. The requester node receives a mapping corresponding to the group of resources that may indicate that a lock already exists for a second resource in the group. If the requester node desires a lock on a resource located in the group, the requester node grants itself the lock without notifying the master node. A second requester node requests a lock for a particular resource in the group of resources. The first requester node grants the lock on the particular resource and updates the mapping to indicate that a different node holds a lock for the particular resource.

摘要翻译： 提供了一种用于管理数据库系统中的锁的方法和装置。 主节点向包括第一资源的第一资源和一组资源授予对第一请求者节点的锁定。 请求者节点接收对应于可以指示组中的第二资源的锁已经存在的资源组的映射。 如果请求者节点希望对位于组中的资源进行锁定，则请求者节点自己给予锁定而不通知主节点。 第二个请求者节点向资源组中的特定资源请求锁。 第一个请求者节点授予对特定资源的锁定，并更新映射以指示不同的节点持有特定资源的锁。