公开(公告)号：US20060095478A1

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

申请号：US10978548

申请日：2004-11-01

申请人： Kevin Cherkauer ,  Scott Lashley ,  Steven Pearson ,  Effi Ofer ,  Xun Xue ,  Roger Zheng

发明人： Kevin Cherkauer ,  Scott Lashley ,  Steven Pearson ,  Effi Ofer ,  Xun Xue ,  Roger Zheng

IPC分类号： G06F17/30

CPC分类号： G06F11/2097 ,  G06F11/1662 ,  Y10S707/99953

摘要： A method and system are provided for providing a consistent reintegration of a failed primary instance as a new secondary instance with implementation of truncation of log records. Upon failure of a primary instance, a secondary instance may be reassigned as the new primary instance. Prior to reintegration, any portion of the database log of the failed primary that is after the log position of the new primary instance may be truncated, followed by a comparison of the log positions of both the new primary instance and the new secondary instance. In limited circumstances, the truncation of the log data generated by the failed primary instance after the point of failure is possible, and supports reintegration of the failed primary as a new secondary instance with limited overhead.

摘要翻译： 提供了一种方法和系统，用于将失败的主实例作为新的辅助实例提供一致的重新集成，并实现截断日志记录。 在主实例失败时，可以将辅助实例重新分配为新的主实例。 在重新集成之前，可能会截断新主要实例的日志位置之后的失败主数据库的数据库日志的任何部分，然后比较新的主实例和新的辅助实例的日志位置。 在有限的情况下，在故障点之后由失败的主实例生成的日志数据的截断是可能的，并且支持将故障主要重新集成为具有有限开销的新辅助实例。

公开(公告)号：US20060020634A1

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

申请号：US10896272

申请日：2004-07-20

申请人： Matthew Huras ,  Sarah Posner ,  James Fleet ,  Roger Zheng

发明人： Matthew Huras ,  Sarah Posner ,  James Fleet ,  Roger Zheng

IPC分类号： G06F17/30

CPC分类号： G06F16/2358

摘要： A method, computer program product and database management system for recording a change to a database in a log including a plurality of log records. The database management system is capable of concurrently processing and logging multiple database changes. A tracking descriptor is used in conjunction with first and second identifiers for each log record to reduce the amount of logic executed using latching for each log record.

摘要翻译： 一种用于在包括多个日志记录的日志中记录对数据库的改变的方法，计算机程序产品和数据库管理系统。 数据库管理系统能够同时处理和记录多个数据库更改。 跟踪描述符与每个日志记录的第一和第二标识符一起使用，以减少使用每个日志记录的锁存执行的逻辑量。

公开(公告)号：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节点。 以这种方式，远程存储器访问的成本显着降低。

公开(公告)号：US20050278393A1

公开(公告)日：2005-12-15

申请号：US10425804

申请日：2003-04-29

申请人： Matthew Huras ,  Dale McInnis ,  Effi Ofar ,  Michael Winer ,  Roger Zheng

发明人： Matthew Huras ,  Dale McInnis ,  Effi Ofar ,  Michael Winer ,  Roger Zheng

IPC分类号： G06F17/30

CPC分类号： G06F17/30368 ,  Y10S707/99953

摘要： A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on a lock instruction.

摘要翻译： 系统和相关方法通过仅处理所需的日志文件，并选择在恢复期间进行恢复时要处理的日志文件来选择性地处理日志文件以增强表空间恢复的性能。 系统和方法跳过不包含要恢复的表空间的感兴趣记录的日志文件的处理，并确定日志文件是否包含任何需要播放的内容，特别是用于恢复数据库中的子系统，例如 一个表空间。 日志文件的预处理未完成，而在创建日志文件时收集与日志文件ID信息相关的表空间ID。 在表空间恢复期间使用交叉相关信息来选择性地确定要处理哪些日志文件。 在没有全部数据库系统正在恢复的情况下，可能会跳过某些日志文件。 可以恢复数据库的子集，例如表空间，以及基于锁定指令确定要处理哪些日志文件。

公开(公告)号：US20070233990A1

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

申请号：US11278133

申请日：2006-03-30

申请人： Wojciech Kuczynski ,  Adam Storm ,  Roger Zheng ,  Sarah Posner ,  Christian Garcia-Arellano ,  Sam Lightstone

发明人： Wojciech Kuczynski ,  Adam Storm ,  Roger Zheng ,  Sarah Posner ,  Christian Garcia-Arellano ,  Sam Lightstone

IPC分类号： G06F12/00

CPC分类号： G06F17/30312 ,  Y10S707/99942 ,  Y10S707/99953

摘要： There are disclosed systems, computer program products, and methods for dynamically resizing memory pools used by database management systems. In one aspect, if a decrease in allocation to the memory pool is required, at least one page grouping that may be freed from the memory pool is identified as a candidate based on its position in a list of page groupings. If the page grouping contains any used memory blocks, the used memory blocks may be copied from a candidate page grouping to another page grouping in the list in order to free the candidate page grouping. Once the candidate page grouping is free of used memory blocks, the candidate page grouping may be freed from the memory pool. As an example, this method may be used for dynamically resizing locklists or lock memory.

摘要翻译： 公开了用于动态地调整由数据库管理系统使用的内存池的系统，计算机程序产品和方法。 在一个方面，如果需要减少对存储器池的分配，则可以根据其在页面分组列表中的位置来将可以从存储器池中释放的至少一个页面分组识别为候选。 如果页面分组包含任何使用的存储器块，则所使用的存储器块可以从候选页面分组复制到列表中的另一页面分组，以便释放候选页面分组。 一旦候选页面分组没有使用的存储器块，候选页面分组可以从存储器池中释放出来。 作为示例，该方法可以用于动态地调整锁定列表大小或锁定内存。

公开(公告)号：US20060123003A1

公开(公告)日：2006-06-08

申请号：US11008508

申请日：2004-12-08

申请人： Sam Lightstone ,  Sarah Posner ,  Michael Winer ,  Roger Zheng

发明人： Sam Lightstone ,  Sarah Posner ,  Michael Winer ,  Roger Zheng

IPC分类号： G06F17/30

CPC分类号： G06F16/2343

摘要： Disclosed are a data processing system implemented method, an article of manufacture and a data processing system for enabling a non-self actuated database transaction to lock onto a database component. The method includes identifying a self actuated transaction currently locking onto the database component, forcing the identified self actuated database transaction to release their lock on the database component if a lock mode between the non-self actuated database transaction and the identified self actuated database transaction is non-compatible, and permitting the non-self actuated database transaction to lock onto the database component if the lock modes between the non-self actuated database transaction and any database transactions currently locking onto the database component are compatible.

摘要翻译： 公开了一种数据处理系统实现的方法，制品和数据处理系统，用于使非自动数据库事务能够锁定到数据库组件上。 该方法包括识别当前锁定到数据库组件上的自动启动事务，如果非自动数据库事务与所识别的自动数据库事务之间的锁定模式是强制识别的自动数据库事务，则释放其对数据库组件的锁定 如果非自动数据库事务与当前锁定到数据库组件上的任何数据库事务之间的锁定模式是兼容的，则允许非自动数据库事务锁定到数据库组件上。