公开(公告)号：US07392335B2

公开(公告)日：2008-06-24

申请号：US11351675

申请日：2006-02-10

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

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

IPC分类号： G06F12/14

CPC分类号： G06F9/526

摘要： A method and system are provided for performing anticipatory changes to a resource governed by a locking mechanism. Entities (such as transactions in a database system) that want to modify a resource request permission to modify the resource. However, prior to receiving permission, they make anticipatory changes to a private version of the resource. The entities are prevented from making the anticipatory changes permanent until they receive permission to make the changes. Because they can make the changes, and proceed to other operations, before receiving permission, any delay in receiving permission has less adverse effect on their performance.

摘要翻译： 提供了一种方法和系统，用于对由锁定机构控制的资源执行预期的改变。 要修改资源请求修改资源的权限的实体（如数据库系统中的事务）。 但是，在获得许可之前，他们会对资源的私有版本做出预期的更改。 这些实体被阻止使预期变化持续，直到他们获得进行更改的许可。 由于可以进行变更，进行其他操作，在获得许可之前，任何延迟的接收许可对其性能的影响较小。

公开(公告)号：US20100211681A1

公开(公告)日：2010-08-19

申请号：US12389306

申请日：2009-02-19

申请人： Wilson Chan ,  Angelo Pruscino ,  Tak Fung Wang ,  Cheng-Lu Hsu

发明人： Wilson Chan ,  Angelo Pruscino ,  Tak Fung Wang ,  Cheng-Lu Hsu

IPC分类号： G06F15/173

CPC分类号： G06F15/173 ,  G06F9/5011 ,  G06F2209/5021 ,  G06F2209/508

摘要： Described herein are techniques for dynamically monitoring and managing resource usages of processes running on a node in a multi-node database system. High resource usages of processes can be proactively detected and alleviated, thereby making such a node to perform significantly better than otherwise.

摘要翻译： 这里描述了用于动态地监视和管理在多节点数据库系统中的节点上运行的进程的资源使用的技术。 可以主动检测和缓解过程的高资源使用，从而使这样的节点执行得比其他节点显着更好。

公开(公告)号：US20100186016A1

公开(公告)日：2010-07-22

申请号：US12356382

申请日：2009-01-20

申请人： Wilson Chan ,  Angelo Pruscino ,  Ahmed S. Abbas ,  Tak Fung Wang

发明人： Wilson Chan ,  Angelo Pruscino ,  Ahmed S. Abbas ,  Tak Fung Wang

IPC分类号： G06F9/50

CPC分类号： G06F9/4881

摘要： Described herein are techniques for dynamically monitoring and rebalancing priority levels of processes running on a computing node. Runaway processes and starved processes can be proactively detected and prevented, thereby making such a node to perform significantly better and more responsively than otherwise.

摘要翻译： 这里描述的是用于动态地监视和重新平衡在计算节点上运行的进程的优先级的技术。 可以主动检测和防止失控进程和饥饿进程，从而使这样的节点比其他节点执行显着更好和更响应。

公开(公告)号：US20060015542A1

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

申请号：US10891433

申请日：2004-07-13

申请人： Stefan Pommerenk ,  Carol Colrain ,  Wilson Chan ,  Angelo Pruscino

发明人： Stefan Pommerenk ,  Carol Colrain ,  Wilson Chan ,  Angelo Pruscino

IPC分类号： G06F12/00

CPC分类号： G06F11/1469 ,  G06F11/1471 ,  G06F2201/80

摘要： A method and apparatus for selecting one or more instances to perform database recovery is provided. According to one aspect, one or more performance metrics are determined for each instance on each node in a cluster. Based on these performance metrics, which may be weighted to give one or more metrics more significance relative to the other metrics, an overall score is determined for each instance on each surviving node when a node in the cluster fails. One or more instances with the highest of these scores are selected. The selected instances are assigned the task of performing the database recovery process. Because instances best able to handle to database recovery process are selected, the database recovery process consumes less time, thereby making data accessible in less time after a node fails.

摘要翻译： 提供了用于选择一个或多个实例以执行数据库恢复的方法和装置。 根据一个方面，针对集群中的每个节点上的每个实例确定一个或多个性能度量。 基于这些性能度量，其可以被加权以给出相对于其他度量更重要的一个或多个指标，当集群中的节点发生故障时，为每个存活节点上的每个实例确定整体得分。 选择这些分数中最高的一个或多个实例。 所选实例被分配执行数据库恢复过程的任务。 因为选择了能够处理数据库恢复过程的实例，所以数据库恢复过程消耗更少的时间，从而使节点在节点出现故障后更少的时间可以访问数据。

公开(公告)号：US08549002B2

公开(公告)日：2013-10-01

申请号：US12152535

申请日：2008-05-15

申请人： Thomas Herter ,  Angelo Pruscino

发明人： Thomas Herter ,  Angelo Pruscino

IPC分类号： G06F17/30

CPC分类号： G06F11/3006 ,  G06F11/3082 ,  G06F11/328 ,  G06F11/3433

摘要： Systems, methods, and other embodiments associated with producing a proximity display of correlated load metrics associated with members of a cluster are described. One example method includes acquiring metrics data (e.g., load data) from nodes in a cluster. The example method may also include determining a cluster element state based on the metrics data and determining relationships between members of the set of related cluster elements. The method may also include identifying element metric representations for cluster elements based on cluster element states and identifying locations on a proximity display at which element metric representations are to be displayed. The locations may depend on relationships between cluster element states. The method may also include displaying element metric representations at the computed locations to produce a proximity display of correlated load metrics.

公开(公告)号：US07711916B2

公开(公告)日：2010-05-04

申请号：US11127699

申请日：2005-05-11

申请人： Sashikanth Chandrasekaran ,  Angelo Pruscino ,  James Williams

发明人： Sashikanth Chandrasekaran ,  Angelo Pruscino ,  James Williams

IPC分类号： G06F12/00

CPC分类号： G06F3/0605 ,  G06F3/0649 ,  G06F3/0685 ,  G06F12/0866

摘要： Techniques are described for storing portions of files on different storage devices based on the devices' respective storage class. For example, different extents from a large file within a system, application, or database may be stored on different storage devices. The storage devices may be part of a single storage system that includes some storage devices that have different performance capabilities. The decision of where, within the storage classes, to store data may be based on the access patterns of the data. Access patterns regarding file extents are tracked using respective access bits, which are set when a memory block associated with an extent is accessed via an I/O operation. In one embodiment, an access bitmap is modified to account for cached blocks of file extents.

摘要翻译： 描述了用于基于设备的相应存储类将文件的部分存储在不同存储设备上的技术。 例如，系统，应用程序或数据库中的大文件的不同范围可以存储在不同的存储设备上。 存储设备可以是包括具有不同性能能力的一些存储设备的单个存储系统的一部分。 在存储类中存储数据的位置的决定可以基于数据的访问模式。 使用相应的访问位追踪关于文件扩展区的访问模式，当通过I / O操作访问与扩展区相关联的存储器块时，该访问位被设置。 在一个实施例中，修改访问位图以考虑文件盘区的缓存块。

公开(公告)号：US20090287720A1

公开(公告)日：2009-11-19

申请号：US12152535

申请日：2008-05-15

申请人： Thomas Herter ,  Angelo Pruscino

发明人： Thomas Herter ,  Angelo Pruscino

IPC分类号： G06F17/30

CPC分类号： G06F11/3006 ,  G06F11/3082 ,  G06F11/328 ,  G06F11/3433

摘要： Systems, methods, and other embodiments associated with producing a proximity display of correlated load metrics associated with members of a cluster are described. One example method includes acquiring metrics data (e.g., load data) from nodes in a cluster. The example method may also include determining a cluster element state based on the metrics data and determining relationships between members of the set of related cluster elements. The method may also include identifying element metric representations for cluster elements based on cluster element states and identifying locations on a proximity display at which element metric representations are to be displayed. The locations may depend on relationships between cluster element states. The method may also include displaying element metric representations at the computed locations to produce a proximity display of correlated load metrics.

摘要翻译： 描述了与生成与集群的成员相关联的相关负载度量的接近显示相关联的系统，方法和其他实施例。 一个示例性方法包括从集群中的节点获取度量数据（例如，加载数据）。 示例性方法还可以包括基于度量数据确定集群元素状态并确定该组相关集群元素的成员之间的关系。 该方法还可以包括基于聚类元素状态识别针对簇元素的元素度量表示，并且识别要在哪个元素度量表示被显示的接近度显示上的位置。 位置可能取决于集群元素状态之间的关系。 该方法还可以包括在计算的位置处显示元素度量表示以产生相关负载度量的接近显示。

公开(公告)号：US07451290B2

公开(公告)日：2008-11-11

申请号：US11433174

申请日：2006-05-11

申请人： Sashikanth Chandrasekaran ,  Angelo Pruscino

发明人： Sashikanth Chandrasekaran ,  Angelo Pruscino

IPC分类号： G06F12/00

CPC分类号： G06F3/064 ,  G06F3/0608 ,  G06F3/0676 ,  G06F17/30067 ,  Y10S707/99942

摘要： A method and mechanism is disclosed for implementing storage and compression in a computer system. Each granular portion of a file can be individually stored in either a compressed storage unit or an uncompressed storage unit. The storage units can be allocated apriori or on an as-needed basis.

摘要翻译： 公开了一种用于在计算机系统中实现存储和压缩的方法和机制。 文件的每个粒度部分可以单独存储在压缩存储单元或未压缩存储单元中。 存储单元可以根据需要分配或者根据需要。

公开(公告)号：US08510334B2

公开(公告)日：2013-08-13

申请号：US12613502

申请日：2009-11-05

申请人： Wilson Wai Shun Chan ,  Angelo Pruscino

发明人： Wilson Wai Shun Chan ,  Angelo Pruscino

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30362

摘要： A method and apparatus for managing shared resources in a clustered database management system is provided. In an embodiment, multiple master nodes exist in a database management system. A master node receives a lock request from a second node. The lock request is a request for a lock on a shared resource. The master node grants the lock request to the second node. While the second node holds the lock, the second node causes the master node to modify the shared resource.

摘要翻译： 提供了一种用于管理群集数据库管理系统中的共享资源的方法和装置。 在一个实施例中，多个主节点存在于数据库管理系统中。 主节点从第二个节点接收锁定请求。 锁定请求是对共享资源的锁定的请求。 主节点向第二个节点授予锁定请求。 当第二节点保存锁时，第二节点使主节点修改共享资源。

公开(公告)号：US20100103781A1

公开(公告)日：2010-04-29

申请号：US12258344

申请日：2008-10-24

申请人： Vikram Rai ,  Alok Srivastava ,  Angelo Pruscino ,  Sameer Joshi

发明人： Vikram Rai ,  Alok Srivastava ,  Angelo Pruscino ,  Sameer Joshi

IPC分类号： G04C11/04

CPC分类号： G06F1/12 ,  H04J3/0667

摘要： Techniques are described herein for synchronizing cluster time. According to one technique, a master node is appointed in a cluster. Other “slave” nodes periodically synchronize their clocks with the master node. To synchronize its clock with the master node, a slave node sends a timestamped message to the master node, which also timestamps the message and sends the message back to the slave node, which then timestamps the message again. Based on the timestamps, the slave node is able to determine the difference between the master node's clock's time and slave node's clock's time, compensating for the message travel time between master node and slave node. Depending on various circumstances, and based on the determined difference, the slave node adjusts its clock so that the time indicated by the slave node's clock at least begins to approach more closely the time indicated by the master node's clock.

摘要翻译： 这里描述了用于同步集群时间的技术。 根据一种技术，在簇中指定主节点。 其他“从”节点周期性地将其时钟与主节点同步。 为了将其时钟与主节点同步，从节点向主节点发送时间戳消息，主节点还对消息进行时间戳，并将消息发送回从节点，从节点再次对消息进行时间戳。 基于时间戳，从节点能够确定主节点的时钟和从节点的时钟时间之间的差异，从而补偿主节点和从节点之间的消息传播时间。 根据各种情况，根据确定的差异，从节点调整其时钟，使从节点的时钟指示的时间至少开始接近主节点时钟指示的时间。