公开(公告)号：US20070016548A1

公开(公告)日：2007-01-18

申请号：US11183267

申请日：2005-07-14

申请人： Balakrishna Iyer ,  Lin Qiao ,  Aamer Sachedina

发明人： Balakrishna Iyer ,  Lin Qiao ,  Aamer Sachedina

IPC分类号： G06F17/30

CPC分类号： G11B27/329

摘要： Techniques are provided for accessing sector data. An embedded storage function is received. One or more data management functions are generated in response to receiving the embedded storage function. The one or more data management functions are invoked to retrieve the sector data from a sector table.

摘要翻译： 提供了访问扇区数据的技术。 收到嵌入式存储功能。 响应于接收到嵌入式存储功能而产生一个或多个数据管理功能。 调用一个或多个数据管理功能以从扇区表检索扇区数据。

公开(公告)号：US20060206489A1

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

申请号：US11077579

申请日：2005-03-11

申请人： James Finnie ,  Taavi Burns ,  Matthew Huras ,  Sunil Kamath ,  Lan Pham ,  Kevin Rose ,  Aamer Sachedina ,  Roger Zheng

发明人： James Finnie ,  Taavi Burns ,  Matthew Huras ,  Sunil Kamath ,  Lan Pham ,  Kevin Rose ,  Aamer Sachedina ,  Roger Zheng

IPC分类号： G06F17/30

CPC分类号： G06F9/5016 ,  G06F9/5061

摘要： A method and system for improving memory access patterns of software systems on NUMA systems discovers NUMA system resources, where the NUMA system resources comprises a plurality of NUMA nodes; determines a plurality of database threads, processes, and objects for a database configuration; and generates a policy which assigns the plurality of database threads, processes, and objects to the plurality of NUMA nodes, wherein the generating is performed prior to initialization of the plurality of database threads, processes, and objects. The assignment of the database threads, processes, or objects to NUMA nodes is such that the amount of remote memory accesses is reduced. When the database thread, process, or object initializes, the database server queries the policy for its assigned NUMA node(s). The database thread, process, or object is then bound to the assigned NUMA node(s). In this manner, the costs from remote memory accesses are significantly reduced.

摘要翻译： 用于改进NUMA系统上的软件系统的存储器访问模式的方法和系统发现NUMA系统资源，其中NUMA系统资源包括多个NUMA节点; 确定数据库配置的多个数据库线程，进程和对象; 并且生成将多个数据库线程，进程和对象分配给多个NUMA节点的策略，其中在多个数据库线程，进程和对象的初始化之前执行生成。 将数据库线程，进程或对象分配给NUMA节点使得远程内存访问量减少。 当数据库线程，进程或对象初始化时，数据库服务器向其分配的NUMA节点查询策略。 然后将数据库线程，进程或对象绑定到已分配的NUMA节点。 以这种方式，远程存储器访问的成本显着降低。

公开(公告)号：US09571576B2

公开(公告)日：2017-02-14

申请号：US12955943

申请日：2010-11-30

申请人： Michael E. Factor ,  Matthew Albert Huras ,  Aamer Sachedina ,  Paula Kim Ta-Shma ,  Avishay Traeger

发明人： Michael E. Factor ,  Matthew Albert Huras ,  Aamer Sachedina ,  Paula Kim Ta-Shma ,  Avishay Traeger

IPC分类号： G06F15/173 ,  H04L29/08

CPC分类号： H04L67/1097

摘要： A storage appliance system is disclosed which may include at least one application server for locally executing an application, and one or more storage servers in communication with the application server for I/O transmission therebetween. Also disclosed are an application server, a method, and a computer program product.

摘要翻译： 公开了一种存储设备系统，其可以包括用于本地执行应用的至少一个应用服务器，以及与应用服务器通信的一个或多个存储服务器，用于在其间进行I / O传输。 还公开了应用服务器，方法和计算机程序产品。

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

摘要翻译： 在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描 ，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

公开(公告)号：US08086580B2

公开(公告)日：2011-12-27

申请号：US11034518

申请日：2005-01-11

申请人： Aamer Sachedina ,  Matthew Albert Huras ,  Keriley Kay Romanufa

发明人： Aamer Sachedina ,  Matthew Albert Huras ,  Keriley Kay Romanufa

IPC分类号： G06F7/00

CPC分类号： G06F17/30362

摘要： Provided are a method, system, and program for handling access requests to a page while copying an updated page of data to storage. An update to a page in a memory is received and indication is made that the page has an exclusive lock. The update is applied to the page and an operation is initiated to copy the updated page to a physical log in a storage in response to applying the update to the page. Reads and writes are allowed to proceed against the page while the operation to copy the updated page to the physical log in the storage is occurring.

摘要翻译： 提供了一种用于在将更新的数据页复制到存储时处理对页面的访问请求的方法，系统和程序。 接收对存储器中的页面的更新，并且指示该页面具有排他锁。 更新应用于页面，并且响应于将更新应用于页面，启动操作以将更新的页面复制到存储器中的物理日志。 允许读取和写入对页面进行操作，而将更新页面复制到存储器中的物理日志的操作正在发生。

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

摘要翻译： 在共享磁盘数据库系统中锁定通信可以通过以下几种方法进行减少：向锁管理器发送单个消息，以获得将来需要的操作所需的锁和操作可能包括行更新，行删除，大扫描 ，和行插入; 执行两次执行中的操作，其中在不执行操作的情况下确定操作所需的第一执行锁定，并且在第二执行中，单个消息被发送到锁管理器以进行所需的锁并且执行操作; 在可用空间搜索中，在实际执行行插入之前，向锁管理器发送行和页锁的单个消息; 并以不公平的方式给予锁。

公开(公告)号：US07111295B2

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

申请号：US09844470

申请日：2001-04-27

申请人： Aamer Sachedina ,  Matthew A Huras ,  Keriley K Romanufa

发明人： Aamer Sachedina ,  Matthew A Huras ,  Keriley K Romanufa

IPC分类号： G06F9/46

CPC分类号： G06F9/52

摘要： A computer system dynamically scales back latch requests for system resources. Tasks seeking access to system resources each dynamically determine the probability that the task will gain access to the latch relating to a given system resource. Where the task estimates that its probability is below a defined threshold, the task will suspend itself for a defined sleep time. The task dynamically adjusts the length of the sleep time based on the number of times the task enters the suspended state and on the relative changes in the estimated probability that the task will gain access to the resource.

摘要翻译： 计算机系统动态地缩小系统资源的锁存请求。 寻求访问系统资源的任务每个动态地确定任务将获得对与给定系统资源相关联的锁存器的访问的概率。 在任务估计其概率低于定义的阈值的情况下，任务将暂停自己定义的休眠时间。 任务根据任务进入暂停状态的次数以及任务将获得资源访问的概率的相对变化动态调整睡眠时间长度。

公开(公告)号：US20060155774A1

公开(公告)日：2006-07-13

申请号：US11034518

申请日：2005-01-11

申请人： Aamer Sachedina ,  Matthew Huras ,  Keriley Romanufa

发明人： Aamer Sachedina ,  Matthew Huras ,  Keriley Romanufa

IPC分类号： G06F17/30

CPC分类号： G06F17/30362

摘要： Provided are a method, system, and program for handling access requests to a page while copying an updated page of data to storage. An update to a page in a memory is received and indication is made that the page has an exclusive lock. The update is applied to the page and an operation is initiated to copy the updated page to a physical log in a storage in response to applying the update to the page. Reads and writes are allowed to proceed against the page while the operation to copy the updated page to the physical log in the storage is occurring.

摘要翻译： 提供了一种用于在将更新的数据页复制到存储时处理对页面的访问请求的方法，系统和程序。 接收对存储器中的页面的更新，并且指示该页面具有排他锁。 更新应用于页面，并且响应于将更新应用于页面，启动操作以将更新的页面复制到存储器中的物理日志。 允许读取和写入对页面进行操作，而将更新页面复制到存储器中的物理日志的操作正在发生。

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

摘要翻译： 日志记录中的操作排序包括：由节点对数据库对象执行更新操作; 将更新操作的日志记录由节点写入本地缓冲区，每个日志记录包括本地虚拟时间戳; 确定要执行将本地缓冲区中的日志记录写入永久存储器的日志刷新; 作为响应，向日志刷新序列服务器发送来自节点的请求以用于日志刷新序列号; 由节点接收日志刷新序列号; 将日志刷新序列号插入到本地缓冲区中的日志记录中; 并执行日志刷新以将本地缓冲区中的日志记录写入永久存储器，其中写入永久存储器的日志记录包括本地虚拟时间戳和日志刷新序列号。

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

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