专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20110137861A1 Methods for Achieving Efficient Coherent Access to Data in a Cluster of Data Processing Computing Nodes 审中-公开
标题翻译：在数据处理计算节点集群中实现对数据的有效连贯访问的方法
公开(公告)号：US20110137861A1
公开(公告)日：2011-06-09
申请号：US12634463
申请日：2009-12-09
申请人： Rodney C. Burnett , David A. Elko , Ronen Grosman , Jimmy R. Hill , Matthew A. Huras , Mark A. Kowalski , Daniel H. Lepore , Keriley K. Romanufa , Aamer Sachedina , Xun Xue
发明人： Rodney C. Burnett , David A. Elko , Ronen Grosman , Jimmy R. Hill , Matthew A. Huras , Mark A. Kowalski , Daniel H. Lepore , Keriley K. Romanufa , Aamer Sachedina , Xun Xue
IPC分类号： G06F17/00 , G06F15/167
CPC分类号： G06F16/2308
摘要： A coherency manager provides coherent access to shared data by receiving a copy of updated database data from a host computer through RDMA, the copy including updates to a given database data; storing the copy of the updated database data as a valid copy of the given database data in local memory; invalidating local copies of the given database data on other host computers through RDMA; receiving acknowledgements from the other host computers through RDMA that the local copies of the given database data have been invalidated; and sending an acknowledgement of receipt of the copy of the updated database data to the host computer through RDMA. When the coherency manager receives a request for the valid copy of the given database data from a host computer through RDMA, it retrieves the valid copy of the given database data from the local memory and returns the valid copy through RDMA.
摘要翻译：一个一致性管理器通过从主计算机通过RDMA接收更新的数据库数据的副本来提供对共享数据的一致访问，该副本包括对给定数据库数据的更新; 将更新的数据库数据的副本存储为本地存储器中的给定数据库数据的有效副本; 通过RDMA使其他主机上的给定数据库数据的本地副本无效; 通过RDMA从其他主机计算机接收到给定数据库数据的本地副本已被无效的确认; 并通过RDMA向主计算机发送对更新的数据库数据的副本的接收的确认。当一致性管理器通过RDMA从主机接收到给定数据库数据的有效副本的请求时，它从本地存储器检索给定数据库数据的有效副本，并通过RDMA返回有效副本。

2. 发明申请

US20110137874A1 Methods to Minimize Communication in a Cluster Database System 有权
标题翻译：最小化群集数据库系统中的通信的方法
公开(公告)号：US20110137874A1
公开(公告)日：2011-06-09
申请号：US12632750
申请日：2009-12-07
申请人： Ronen Grosman , Matthew A. Huras , Timothy R. Malkemus , Keriley K. Romanufa , Aamer Sachedina , Kelly W. Schlamb , Nickolay V. Tchervenski , Xun Xue
发明人： Ronen Grosman , Matthew A. Huras , Timothy R. Malkemus , Keriley K. Romanufa , Aamer Sachedina , Kelly W. Schlamb , Nickolay V. Tchervenski , Xun Xue
IPC分类号： G06F17/00
CPC分类号： G06F17/30368 , G06F11/1471 , G06F17/30353 , G06F17/30377
摘要： An ordering of operations in log records includes: performing update operations on a shared database object by a node; writing log records for the update operations into a local buffer by the node, the log records each including a local virtual timestamp; determining that a log flush to write the log records in the local buffer to a persistent storage is to be performed; in response, sending a request from the node to a log flush sequence server for a log flush sequence number; receiving the log flush sequence number by the node; inserting the log flush sequence number into the log records in the local buffer; and performing the log flush to write the log records in the local buffer to the persistent storage, where the log records written to the persistent storage comprises the local virtual timestamps and the log flush sequence number.
摘要翻译：日志记录中的操作顺序包括：由节点对共享数据库对象执行更新操作; 将更新操作的日志记录由节点写入本地缓冲区，每个日志记录包括本地虚拟时间戳; 确定要执行将本地缓冲区中的日志记录写入永久存储器的日志刷新; 作为响应，向日志刷新序列服务器发送来自节点的请求以用于日志刷新序列号; 由节点接收日志刷新序列号; 将日志刷新序列号插入到本地缓冲区中的日志记录中; 并执行日志刷新以将本地缓冲区中的日志记录写入永久存储器，其中写入永久存储器的日志记录包括本地虚拟时间戳和日志刷新序列号。

3. 发明授权

US08666958B2 Approaches to reducing lock communications in a shared disk database 有权
标题翻译：减少共享磁盘数据库中的锁通信的方法
公开(公告)号：US08666958B2
公开(公告)日：2014-03-04
申请号：US12626714
申请日：2009-11-27
申请人： James L. Finnie , Ronen Grosman , Matthew A. Huras , Keriley K. Romanufa , Aamer Sachedina , Garret F. Swart , Xun Xue , Roger L. Q. Zheng
发明人： James L. Finnie , Ronen Grosman , Matthew A. Huras , Keriley K. Romanufa , Aamer Sachedina , Garret F. Swart , Xun Xue , Roger L. Q. Zheng
IPC分类号： G06F7/00
CPC分类号： G06F17/30362
摘要： Lock communications in a shared disk database system is reduced by several approaches: sending a single message to a lock manager for locks required for an operation and locks that will be required in the future, the operations may include row update, row delete, large scan, and row insert; performing an operation in two executions, where in a first execution locks required for the operation is determined without performing the operation, and in a second execution a single message is sent to a lock manager for the required locks and the operation is performed; in free space searching, sending a single message to a lock manager for row and page locks before a row insert is actually performed; and granting locks in an unfair manner.
摘要翻译：在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

4. 发明申请

US20110131192A1 Approaches to Reducing Lock Communications In a Shared Disk Database 有权
标题翻译：在共享磁盘数据库中减少锁定通信的方法
公开(公告)号：US20110131192A1
公开(公告)日：2011-06-02
申请号：US12626714
申请日：2009-11-27
申请人： James L. Finnie , Ronen Grosman , Matthew A. Huras , Keriley K. Romanufa , Aamer Sachedina , Xun Xue , Roger L.Q. Zheng
发明人： James L. Finnie , Ronen Grosman , Matthew A. Huras , Keriley K. Romanufa , Aamer Sachedina , Xun Xue , Roger L.Q. Zheng
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F17/30362
摘要： Lock communications in a shared disk database system is reduced by several approaches: sending a single message to a lock manager for locks required for an operation and locks that will be required in the future, the operations may include row update, row delete, large scan, and row insert; performing an operation in two executions, where in a first execution locks required for the operation is determined without performing the operation, and in a second execution a single message is sent to a lock manager for the required locks and the operation is performed; in free space searching, sending a single message to a lock manager for row and page locks before a row insert is actually performed; and granting locks in an unfair manner.
摘要翻译：在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

5. 发明授权

US09229970B2 Methods to minimize communication in a cluster database system 有权
标题翻译：最小化集群数据库系统中的通信的方法
公开(公告)号：US09229970B2
公开(公告)日：2016-01-05
申请号：US12632750
申请日：2009-12-07
申请人： Ronen Grosman , Matthew A. Huras , Timothy R. Malkemus , Keriley K. Romanufa , Aamer Sachedina , Kelly W. Schlamb , Nickolay V. Tchervenski , Xun Xue
发明人： Ronen Grosman , Matthew A. Huras , Timothy R. Malkemus , Keriley K. Romanufa , Aamer Sachedina , Kelly W. Schlamb , Nickolay V. Tchervenski , Xun Xue
IPC分类号： G06F17/00 , G06F17/30 , G06F11/14
CPC分类号： G06F17/30368 , G06F11/1471 , G06F17/30353 , G06F17/30377
摘要： An ordering of operations in log records includes: performing update operations on a database object by a node; writing log records for the update operations into a local buffer by the node, the log records each including a local virtual timestamp; determining that a log flush to write the log records in the local buffer to a persistent storage is to be performed; in response, sending a request from the node to a log flush sequence server for a log flush sequence number; receiving the log flush sequence number by the node; inserting the log flush sequence number into the log records in the local buffer; and performing the log flush to write the log records in the local buffer to the persistent storage, where the log records written to the persistent storage comprises the local virtual timestamps and the log flush sequence number.
摘要翻译：日志记录中的操作排序包括：由节点对数据库对象执行更新操作; 将更新操作的日志记录由节点写入本地缓冲区，每个日志记录包括本地虚拟时间戳; 确定要执行将本地缓冲区中的日志记录写入永久存储器的日志刷新; 作为响应，向日志刷新序列服务器发送来自节点的请求以用于日志刷新序列号; 由节点接收日志刷新序列号; 将日志刷新序列号插入到本地缓冲区中的日志记录中; 并执行日志刷新以将本地缓冲区中的日志记录写入永久存储器，其中写入永久存储器的日志记录包括本地虚拟时间戳和日志刷新序列号。

6. 发明申请

US20110145627A1 IMPROVING DATA AVAILABILITY DURING FAILURE DETECTION AND RECOVERY PROCESSING IN A SHARED RESOURCE SYSTEM 有权
标题翻译：在共享资源系统中的故障检测和恢复处理过程中改善数据可用性
公开(公告)号：US20110145627A1
公开(公告)日：2011-06-16
申请号：US12635599
申请日：2009-12-10
申请人： Matthew A. HURAS , Roger L. Zheng , Aamer Sachedina , James L. Finnie , Keriley K. Romanufa , Xun Xue , Andrew D. Buckler , Stewart L. Palmer
发明人： Matthew A. HURAS , Roger L. Zheng , Aamer Sachedina , James L. Finnie , Keriley K. Romanufa , Xun Xue , Andrew D. Buckler , Stewart L. Palmer
IPC分类号： G06F11/20 , G06F9/50
CPC分类号： G06F9/526 , G06F11/2028 , G06F11/2038 , G06F11/2046 , G06F2201/825
摘要： A system and method for managing shared resources is disclosed. The system includes a primary coherency processing unit which processes lock requests from a plurality of data processing hosts, the primary coherency processing unit also storing a first current lock state information for the plurality of data processing hosts, the first current lock state information including a plurality of locks held by the plurality of data processing hosts. The system further includes a standby coherency processing unit storing fewer locks than the primary coherency processing unit, the locks stored by the standby coherency processing unit being a subset of locks included in the first current lock state information, the standby coherency unit configured to perform a plurality of activities of the primary coherency processing unit using the subset of locks in response to a failure of the primary coherency processing unit.
摘要翻译：公开了一种用于管理共享资源的系统和方法。该系统包括处理来自多个数据处理主机的锁定请求的主相关处理单元，该主相关处理单元还存储多个数据处理主机的第一当前锁定状态信息，第一当前锁定状态信息包括多个由多个数据处理主机持有的锁。所述系统还包括备用一致性处理单元，其存储比所述主相关处理单元更少的锁，由所述备用一致性处理单元存储的所述锁是包括在所述第一当前锁定状态信息中的锁的子集，所述备用一致性单元被配置为执行响应于主要一致性处理单元的故障，主要一致性处理单元的多个活动使用锁定子集。

7. 发明授权

US08046633B2 Improving data availability during failure detection and recovery processing in a shared resource system 有权
标题翻译：在共享资源系统中的故障检测和恢复处理期间提高数据可用性
公开(公告)号：US08046633B2
公开(公告)日：2011-10-25
申请号：US12635599
申请日：2009-12-10
申请人： Matthew A. Huras , Roger L. Zheng , Aamer Sachedina , James L. Finnie , Keriley K. Romanufa , Xun Xue , Andrew D. Buckler , Stewart L. Palmer
发明人： Matthew A. Huras , Roger L. Zheng , Aamer Sachedina , James L. Finnie , Keriley K. Romanufa , Xun Xue , Andrew D. Buckler , Stewart L. Palmer
IPC分类号： G06F11/00
CPC分类号： G06F9/526 , G06F11/2028 , G06F11/2038 , G06F11/2046 , G06F2201/825
摘要： A system and method for managing shared resources is disclosed. The system includes a primary coherency processing unit which processes lock requests from a plurality of data processing hosts, the primary coherency processing unit also storing a first current lock state information for the plurality of data processing hosts, the first current lock state information including a plurality of locks held by the plurality of data processing hosts. The system further includes a standby coherency processing unit storing fewer locks than the primary coherency processing unit, the locks stored by the standby coherency processing unit being a subset of locks included in the first current lock state information, the standby coherency unit configured to perform a plurality of activities of the primary coherency processing unit using the subset of locks in response to a failure of the primary coherency processing unit.
摘要翻译：公开了一种用于管理共享资源的系统和方法。该系统包括处理来自多个数据处理主机的锁定请求的主相关处理单元，该主相关处理单元还存储多个数据处理主机的第一当前锁定状态信息，第一当前锁定状态信息包括多个由多个数据处理主机持有的锁。所述系统还包括备用一致性处理单元，其存储比所述主相关处理单元更少的锁，由所述备用一致性处理单元存储的所述锁是包括在所述第一当前锁定状态信息中的锁的子集，所述备用一致性单元被配置为执行响应于主要一致性处理单元的故障，主要一致性处理单元的多个活动使用锁定子集。

8. 发明申请

US20100223243A1 AUTOMATIC DETECTION AND CORRECTION OF HOT PAGES IN A DATABASE SYSTEM 失效
标题翻译：自动检测和校正数据库系统中的热页
公开(公告)号：US20100223243A1
公开(公告)日：2010-09-02
申请号：US12394786
申请日：2009-02-27
申请人： Matthew Albert Huras , Keriley Kay Romanufa , Aamer Sachedina , Xun Xue
发明人： Matthew Albert Huras , Keriley Kay Romanufa , Aamer Sachedina , Xun Xue
IPC分类号： G06F12/02 , G06F17/30
CPC分类号： G06F17/30306
摘要： According to one embodiment of the present invention, a method for detecting and correcting hot pages in a database system is provided. According to one embodiment of the present invention, a method includes monitoring transactions involving pages in a database and determining if one of the transactions had to wait for access to one of the pages; incrementing a page contention counter each time one of the transactions had to wait for access to one of the pages. The method then determines if the page contention counter exceeds a predetermined threshold and monitors transactions on one of the pages for which the page contention count was exceeded. The method then determines if a row was accessed in the page for which the page contention count was exceeded and increments a reference count for the accessed row. the accessed rows are flagged when the reference count exceeds a second predetermined threshold. The flagged rows are moved to another page in the database.
摘要翻译：根据本发明的一个实施例，提供了一种在数据库系统中检测和校正热页面的方法。根据本发明的一个实施例，一种方法包括监视涉及数据库中的页面的事务，并确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时，增加页面争用计数器。该方法然后确定页面争用计数器是否超过预定阈值，并且监视超出页面争用次数的页面之一上的事务。该方法然后确定在超出页面争用次数的页面中是否访问了一行，并增加访问行的引用计数。当参考计数超过第二预定阈值时，所访问的行被标记。标记的行被移动到数据库中的另一个页面。

9. 发明授权

US08250111B2 Automatic detection and correction of hot pages in a database system 失效
标题翻译：在数据库系统中自动检测和更正热页
公开(公告)号：US08250111B2
公开(公告)日：2012-08-21
申请号：US12394786
申请日：2009-02-27
申请人： Matthew Albert Huras , Keriley Kay Romanufa , Aamer Sachedina , Xun Xue
发明人： Matthew Albert Huras , Keriley Kay Romanufa , Aamer Sachedina , Xun Xue
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： According to one embodiment of the present invention, a method of detecting and correcting hot pages in a database system includes monitoring transactions involving pages in a database and determining if one of the transactions had to wait for access to one of the pages; incrementing a page contention counter each time one of the transactions had to wait for access to one of the pages. The method then determines if the page contention counter exceeds a predetermined threshold and monitors transactions on one of the pages for which the page contention count was exceeded. The method then determines if a row was accessed in the page for which the page contention count was exceeded and increments a reference count for the accessed row. The accessed rows are flagged when the reference count exceeds a second predetermined threshold. The flagged rows are moved to another page in the database.
摘要翻译：根据本发明的一个实施例，一种在数据库系统中检测和校正热页面的方法包括监视涉及数据库中的页面的事务，并且确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时，增加页面争用计数器。该方法然后确定页面争用计数器是否超过预定阈值，并且监视超出页面争用次数的页面之一上的事务。该方法然后确定在超出页面争用次数的页面中是否访问了一行，并增加访问行的引用计数。当参考计数超过第二预定阈值时，所访问的行被标记。标记的行被移动到数据库中的另一个页面。

10. 发明授权

US07007150B2 Memory balancing and optimization services 失效
公开(公告)号：US07007150B2
公开(公告)日：2006-02-28
申请号：US10401329
申请日：2003-03-27
申请人： Gary Valentin , Paul M. Bird , Matthew A Huras , Xun Xue
发明人： Gary Valentin , Paul M. Bird , Matthew A Huras , Xun Xue
IPC分类号： G06F12/00
CPC分类号： G06F9/5016
摘要： Memory balancing and optimization services (MBOS) control a size of a plurality of memory heaps, and a memory optimizer for allocating and de-allocating memory for a plurality of respective memory consumers. The MBOS may be instantiated within an application program such as a database management system providing services to memory consumers within the application. Alternatively, the MBOS may be instantiated within an operating system for providing services to memory consumers that are applications such as database management systems, e-commerce engines, operating systems, customer relationship management (CRM), enterprise resource planning (ERP), or supply chain management (SCM). Alternatively, an MBOS is instantiated within the operating system to provide services to applications and an MBOS is instantiated within each application to provide services to memory consumers within the application.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式