-
1.发明申请公开(公告)号：US20080306990A1
公开(公告)日：2008-12-11
申请号：US12194464
申请日：2008-08-19
IPC分类号： G06F17/30
CPC分类号： G06F16/278
摘要： Performing a redistribute of data in a database system including a plurality of nodes is disclosed. The data includes a plurality of partitions distributed between the plurality of nodes. At least one new node is being added. At least one partition of the plurality of partitions is selected to be moved from the plurality of nodes only to the at least one new node. The at least one partition is moved only to the at least one new node. At least one partition is removed from the plurality of nodes.
摘要翻译： 公开了在包括多个节点的数据库系统中执行数据的再分配。 数据包括分布在多个节点之间的多个分区。 正在添加至少一个新节点。 多个分区中的至少一个分区被选择为仅从多个节点移动到至少一个新节点。 所述至少一个分区仅被移动到所述至少一个新节点。 从多个节点移除至少一个分区。
-
2.发明授权Handling access requests to a page while copying an updated page of data to storage 有权在将更新的数据页复制到存储时，处理对页面的访问请求公开(公告)号：US08086580B2
公开(公告)日：2011-12-27
申请号：US11034518
申请日：2005-01-11
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.
摘要翻译： 提供了一种用于在将更新的数据页复制到存储时处理对页面的访问请求的方法，系统和程序。 接收对存储器中的页面的更新，并且指示该页面具有排他锁。 更新应用于页面，并且响应于将更新应用于页面，启动操作以将更新的页面复制到存储器中的物理日志。 允许读取和写入对页面进行操作，而将更新页面复制到存储器中的物理日志的操作正在发生。
-
公开(公告)号：US08738579B2
公开(公告)日：2014-05-27
申请号：US10852914
申请日：2004-05-24
CPC分类号： G06F12/0862 , G06F12/0804 , G06F12/0866 , G06F2212/311 , G06F2212/465
摘要： A system and a method for performing a warm shutdown and restart of a buffer pool. The buffer content, including pages and control structures associated with these pages, is partitioned into blocks, where block is saved to a disk as a sequential file. The size of each block is selected to provide an optimal I/O efficiency during buffer pool shutdown and restart operations. Blocks can be saved simultaneously using a plurality of writer threads. During restart of the buffer pool, the control information is read from the disk and restored to the buffer pool using reader threads. The buffer pool may be made available for reference to pages while the reader threads are enabled to read the saved information by blocks, to facilitate a more rapid restoration of information in the buffer pool.
摘要翻译： 用于执行缓冲池的热关机和重新启动的系统和方法。 包括与这些页面相关联的页面和控制结构的缓冲区内容被分割成块，其中块被作为顺序文件保存到磁盘。 选择每个块的大小以在缓冲池关闭和重新启动操作期间提供最佳的I / O效率。 可以使用多个写入器线程同时保存块。 在重新启动缓冲池期间，从磁盘读取控制信息，并使用读取器线程将其还原到缓冲池。 可以使缓冲池可用于参考页面，同时读取器线程能够通过块读取保存的信息，以便于缓冲池中的信息更快速地恢复。
-
公开(公告)号：US20100223243A1
公开(公告)日：2010-09-02
申请号：US12394786
申请日：2009-02-27
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
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.
摘要翻译： 根据本发明的一个实施例，一种在数据库系统中检测和校正热页面的方法包括监视涉及数据库中的页面的事务，并且确定其中一个事务是否必须等待访问其中一个页面; 每次其中一个事务必须等待访问其中一个页面时，增加页面争用计数器。 该方法然后确定页面争用计数器是否超过预定阈值，并且监视超出页面争用次数的页面之一上的事务。 该方法然后确定在超出页面争用次数的页面中是否访问了一行，并增加访问行的引用计数。 当参考计数超过第二预定阈值时，所访问的行被标记。 标记的行被移动到数据库中的另一个页面。
-
公开(公告)号：US20080154842A1
公开(公告)日：2008-06-26
申请号：US11613773
申请日：2006-12-20
IPC分类号： G06F17/30
CPC分类号： G06F16/2453 , G06F16/21 , G06F16/284
摘要： A method to enhance relational database management system resiliency and query operations by minimizing CPU overhead and database page access latency and by facilitating database restoration and query efficiency. The method includes creating a clean database page in a buffer pool of a relational database management system, granting exclusive access to the clean database page within the buffer pool to an application that transitions the clean database page to a dirty database page by altering data store thereon, immediately downgrading exclusive access to the dirty database page to shared access in response to receiving an exclusive access termination request from the application, writing the dirty database page to a physical log, and releasing share access to the dirty database page.
摘要翻译： 通过最小化CPU开销和数据库页面访问延迟以及促进数据库恢复和查询效率来增强关系数据库管理系统弹性和查询操作的方法。 该方法包括在关系数据库管理系统的缓冲池中创建干净的数据库页面，授予对缓冲池内的干净数据库页面的独占访问权，通过改变其上的数据存储将清理数据库页面转换到脏数据库页面的应用程序 响应于从应用程序接收到独占访问终止请求，将脏数据库页面写入物理日志，并释放对脏数据库页面的共享访问，立即将对脏数据库页面的独占访问权降级到共享访问。
-
-
-
-
-
搜索结果
6 条记录 (耗时 0.017 秒)
