公开(公告)号：US07694102B2

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

申请号：US11278130

申请日：2006-03-30

申请人： Christian Marcelo Garcia-Arellano ,  Sam Sampson Lightstone ,  Adam J. Storm ,  Wojciech Kuczynski ,  Matthew Albert Huras ,  Xun Xue ,  Matthew James Carroll

发明人： Christian Marcelo Garcia-Arellano ,  Sam Sampson Lightstone ,  Adam J. Storm ,  Wojciech Kuczynski ,  Matthew Albert Huras ,  Xun Xue ,  Matthew James Carroll

IPC分类号： G06F12/02 ,  G06F12/16 ,  G06F13/24

CPC分类号： G06F12/0646 ,  G06F12/0223

摘要： There are disclosed systems, computer program products, and methods for self-tuning memory. In an embodiment, a method for self-tuning memory comprises setting a tuning interval and a target range for free memory for a memory pool. If memory consumption falls outside of the set target range for free memory during a tuning interval, a new target size for the memory pool is set based on the target range for free memory. Memory allocation for the memory pool is increased or decreased for the next tuning interval, such that the new target size for the memory pool is reached. A decrement rate may be used to provide a controlled decrease of the memory pool over a plurality of tuning intervals if necessary, until the new target size for the memory pool is reached.

摘要翻译： 已经公开了系统，计算机程序产品和用于自调整存储器的方法。 在一个实施例中，一种用于自调整存储器的方法包括设置用于存储器池的空闲存储器的调谐间隔和目标范围。 如果内存消耗在调整间隔期间超出了可用内存的设置目标范围，则基于可用内存的目标范围设置内存池的新目标大小。 内存池的内存分配在下一个调整间隔内增加或减少，从而达到内存池的新目标大小。 如果需要，减量率可以用于在多个调谐间隔中提供存储池的受控减少，直到达到存储器池的新目标大小。

公开(公告)号：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.

摘要翻译： 根据本发明的一个实施例，提供了一种在数据库系统中检测和校正热页面的方法。 根据本发明的一个实施例，一种方法包括监视涉及数据库中的页面的事务，并确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时，增加页面争用计数器。 该方法然后确定页面争用计数器是否超过预定阈值，并且监视超出页面争用次数的页面之一上的事务。 该方法然后确定在超出页面争用次数的页面中是否访问了一行，并增加访问行的引用计数。 当参考计数超过第二预定阈值时，所访问的行被标记。 标记的行被移动到数据库中的另一个页面。

公开(公告)号：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.

摘要翻译： 根据本发明的一个实施例，一种在数据库系统中检测和校正热页面的方法包括监视涉及数据库中的页面的事务，并且确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时，增加页面争用计数器。 该方法然后确定页面争用计数器是否超过预定阈值，并且监视超出页面争用次数的页面之一上的事务。 该方法然后确定在超出页面争用次数的页面中是否访问了一行，并增加访问行的引用计数。 当参考计数超过第二预定阈值时，所访问的行被标记。 标记的行被移动到数据库中的另一个页面。

公开(公告)号：US20070233989A1

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

申请号：US11278130

申请日：2006-03-30

申请人： Christian Garcia-Arellano ,  Sam Lightstone ,  Adam Storm ,  Wojciech Kuczynski ,  Matthew Huras ,  Xun Xue ,  Matthew Carroll

发明人： Christian Garcia-Arellano ,  Sam Lightstone ,  Adam Storm ,  Wojciech Kuczynski ,  Matthew Huras ,  Xun Xue ,  Matthew Carroll

IPC分类号： G06F12/00

CPC分类号： G06F12/0646 ,  G06F12/0223

摘要： There are disclosed systems, computer program products, and methods for self-tuning memory. In an embodiment, a method for self-tuning memory comprises setting a tuning interval and a target range for free memory for a memory pool. If memory consumption falls outside of the set target range for free memory during a tuning interval, a new target size for the memory pool is set based on the target range for free memory. Memory allocation for the memory pool is increased or decreased for the next tuning interval, such that the new target size for the memory pool is reached. A decrement rate may be used to provide a controlled decrease of the memory pool over a plurality of tuning intervals if necessary, until the new target size for the memory pool is reached.

摘要翻译： 已经公开了系统，计算机程序产品和用于自调整存储器的方法。 在一个实施例中，一种用于自调整存储器的方法包括设置用于存储器池的空闲存储器的调谐间隔和目标范围。 如果内存消耗在调整间隔期间超出了可用内存的设置目标范围，则基于可用内存的目标范围设置内存池的新目标大小。 内存池的内存分配在下一个调整间隔内增加或减少，从而达到内存池的新目标大小。 如果需要，减量率可以用于在多个调谐间隔中提供存储池的受控减少，直到达到存储器池的新目标大小。

公开(公告)号：US20120089735A1

公开(公告)日：2012-04-12

申请号：US12902116

申请日：2010-10-11

申请人： Gopi K. Attaluri ,  James L. Finnie ,  Stewart L. Palmer ,  Piotr M. Plachta ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

发明人： Gopi K. Attaluri ,  James L. Finnie ,  Stewart L. Palmer ,  Piotr M. Plachta ,  Garret F. Swart ,  Xun Xue ,  Roger L. Q. Zheng

IPC分类号： G06F15/173

CPC分类号： G06F17/30362 ,  G06F9/5005 ,  G06F9/5038 ,  G06F9/524 ,  G06F9/526

摘要： In a shared data system comprising one or more primary nodes and a plurality of secondary nodes, global lock manager on a primary node manages locks for shared resources by exchanging an abstract lock state with local lock managers on the secondary nodes. The abstract lock state includes a particular representation of all of the applications on the nodes that are requesting or are granted locks. The exchange of these particular lock states instead of individual requests improves performance by increasing concurrency and reducing off-machine communication. A global deadlock detector on a node detects and resolves global deadlocks, in conjunction with local deadlock detectors on the secondary nodes.

摘要翻译： 在包括一个或多个主节点和多个次节点的共享数据系统中，主节点上的全局锁管理器通过与次节点上的本地锁管理器交换抽象锁状态来管理用于共享资源的锁。 抽象锁定状态包括节点上正在请求或被授予锁定的所有应用程序的特定表示。 这些特定锁定状态的交换而不是单独的请求通过增加并发性和减少机外通信来提高性能。 节点上的全局死锁检测器与辅助节点上的本地死锁检测器一起检测并解决全局死锁。

公开(公告)号：US20060218204A1

公开(公告)日：2006-09-28

申请号：US11089993

申请日：2005-03-25

申请人： Effi Ofer ,  David Mooney ,  Steven Pearson ,  Xun Xue ,  Kevin Cherkauer

发明人： Effi Ofer ,  David Mooney ,  Steven Pearson ,  Xun Xue ,  Kevin Cherkauer

IPC分类号： G06F17/30

CPC分类号： G06F11/202 ,  G06F11/1471 ,  G06F11/2097

摘要： A data processing implemented method and system and article of manufacture are provided for determining compatibility between a primary instance and a standby instance, the primary instance being characterized by a first log position indicator and a primary log chain fingerprint (FP-P) and the secondary instance being characterized by a second log position indicator and a secondary log chain fingerprint (FP-S); the FP-P and the FP-S each uniquely identifying a prescribed history of an associated data processing system. The method, for example, includes a series of steps comprising: comparing the first log position indicator with the second log position indicator to determine compatibility between the secondary instance and the primary instance; comparing the primary log chain fingerprint (FP-P) with the secondary log chain fingerprint (FP-S) to determine compatibility between the secondary instance and the primary instance; and indicating that the secondary instance is compatible with the primary instance when both of the above comparisons determine compatibility.

摘要翻译： 提供了一种数据处理实现的方法和系统及制品，用于确定主实例和备用实例之间的兼容性，主要实例由第一对数位置指示符和主日志链指纹（FP-P）表征，次要 其特征在于第二对数位置指示器和辅助对数链指纹（FP-S）; FP-P和FP-S每个唯一地标识相关联的数据处理系统的规定历史。 该方法例如包括一系列步骤，包括：将第一日志位置指示符与第二日志位置指示符进行比较，以确定辅助实例与主实例之间的兼容性; 将主日志链指纹（FP-P）与辅助日志链指纹（FP-S）进行比较，以确定辅助实例与主实例之间的兼容性; 并且当上述两个比较确定兼容性时，指示辅助实例与主实例兼容。

公开(公告)号：US20120084260A1

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

申请号：US12895644

申请日：2010-09-30

申请人： Kevin J. Cherkauer ,  Steven R. Pearson ,  Xun Xue ,  Roger L. Q. Zheng

发明人： Kevin J. Cherkauer ,  Steven R. Pearson ,  Xun Xue ,  Roger L. Q. Zheng

IPC分类号： G06F12/16 ,  G06F17/30

CPC分类号： G06F17/30368 ,  G06F11/1471 ,  G06F11/2094 ,  G06F11/2097 ,  G06F17/30008 ,  G06F17/30377 ,  G06F2201/80

摘要： Methods, systems and program products for log-shipping data replication from a primary system to a communicatively-coupled standby system. Embodiments of the invention may receive transactional log data at a standby system, from the primary system, and before the transactional log data is written to storage on the primary system. Embodiments may then receive a notification from the primary system indicating that the corresponding log data was written to storage on the primary system, and responsive to receiving the notification, may process the received transactional log data.

摘要翻译： 用于日志传送从主系统到通信耦合待机系统的数据复制的方法，系统和程序产品。 本发明的实施例可以在备用系统，主要系统和事务日志数据被写入主系统之间的存储器之前接收事务日志数据。 实施例然后可以从主系统接收指示对应的日志数据被写入主系统上的存储并且响应于接收到通知的通知可以处理所接收的事务日志数据。

公开(公告)号：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.

摘要翻译： 公开了一种用于管理共享资源的系统和方法。 该系统包括处理来自多个数据处理主机的锁定请求的主相关处理单元，该主相关处理单元还存储多个数据处理主机的第一当前锁定状态信息，第一当前锁定状态信息包括多个 由多个数据处理主机持有的锁。 所述系统还包括备用一致性处理单元，其存储比所述主相关处理单元更少的锁，由所述备用一致性处理单元存储的所述锁是包括在所述第一当前锁定状态信息中的锁的子集，所述备用一致性单元被配置为执行 响应于主要一致性处理单元的故障，主要一致性处理单元的多个活动使用锁定子集。

公开(公告)号：US20080189710A1

公开(公告)日：2008-08-07

申请号：US12105032

申请日：2008-04-17

申请人： David C. Kalmuk ,  Jon A. Lind ,  Hebert W. Pereyra ,  Xun Xue

发明人： David C. Kalmuk ,  Jon A. Lind ,  Hebert W. Pereyra ,  Xun Xue

IPC分类号： G06F9/46

CPC分类号： G06F9/544

摘要： An operating system directed to using special properties of a common inter-process communications mechanism (IPC), namely UNIX domain socket-pairs or stream-pipes alternatively as a storage medium for file-descriptors of UNIX processes. When a file-descriptor is written into a socket-pair, and closed in the UNIX process, the file remains open, but occupies no space in the process' file-table. The file-descriptor may later be read out of the socket-pair to reestablish it in the file-table, and access it. This property is implemented in an IPC mechanism of UNIX operating system whereby a process such as a dispatcher may manage more connections and processes than its file-table size allow. This provides scalability improvements of the UNIX operating system.

摘要翻译： 针对使用通用进程间通信机制（IPC）的特殊属性（即UNIX域套接字对或流管道）的操作系统作为UNIX进程的文件描述符的存储介质。 当文件描述符写入套接字对并在UNIX进程中关闭时，该文件保持打开，但在进程'file-table中不占用空间。 文件描述符可以稍后从套接字对中读出，以在文件表中重新建立文件描述符，并访问它。 该属性在UNIX操作系统的IPC机制中实现，其中诸如调度程序的进程可以管理比其文件表大小允许的更多的连接和进程。 这提供了UNIX操作系统的可扩展性改进。

公开(公告)号：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.