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

1. 发明申请

US20080228834A1 Delaying Database Writes For Database Consistency 有权
标题翻译：延迟数据库写入数据库一致性
公开(公告)号：US20080228834A1
公开(公告)日：2008-09-18
申请号：US11685871
申请日：2007-03-14
申请人： Laurion D. Burchall , Andrew E. Goodsell , Brett A. Shirley
发明人： Laurion D. Burchall , Andrew E. Goodsell , Brett A. Shirley
IPC分类号： G06F12/00
CPC分类号： G06F17/30368 , G06F11/1471 , G06F11/2038 , G06F17/30371 , G06F2201/80
摘要： A continuous set of committed transactions can be lost without destroying the integrity of the database, by deferring the writing of the database pages stored in cache to the database on stable storage. A waypoint tracks a point in the transaction log following which transactions have not been applied to the database on stable storage and thus records after the waypoint are not needed for recovery to a consistent database. When there is a failover of an active database on Node A to a passive database on Node B, log records are compared starting with the most current and moving backwards and the point at which divergence in the log occurs is determined. When the lost portion of the log occurs after the point indicated by after the waypoint, the database is recoverable by log-based incremental reseed.
摘要翻译：通过将存储在缓存中的数据库页面写入稳定存储的数据库，可以丢失一组连续的已提交事务，而不会破坏数据库的完整性。航路点跟踪事务日志中的一个点，其中哪些事务尚未应用于稳定存储上的数据库，因此在恢复到一致的数据库后不需要航点的记录。当节点A上的活动数据库故障切换到节点B上的被动数据库时，日志记录将从最新和向后移动以及发生日志发散的点进行比较。当日志的丢失部分发生在航点之后指示的点之后，数据库可以通过基于日志的增量重新进行恢复。

2. 发明申请

US20120151173A1 INHERITANCE OF GROWTH PATTERNS FOR DERIVED TABLES 有权
标题翻译：生成模式对衍生表的保留
公开(公告)号：US20120151173A1
公开(公告)日：2012-06-14
申请号：US12967847
申请日：2010-12-14
申请人： Brett A. Shirley , Marcus E. Markiewicz
发明人： Brett A. Shirley , Marcus E. Markiewicz
IPC分类号： G06F12/06
CPC分类号： G06F12/023 , G06F17/30306 , G06F17/30339
摘要： Systems and methods are disclosed in which a derived table can inherit a growth pattern from a template table. A growth pattern is used to define how memory is allocated to a table as the table grows. The derived table can inherit the growth pattern defined by its template table or it can provide an override growth pattern. Inheritance of the growth pattern can be performed by explicit copying or by reference or link. Growth patterns can be edited, and the edits can be applied universally or locally.
摘要翻译：公开了系统和方法，其中派生表可以从模板表继承增长模式。增长模式用于定义当表的增长时如何将内存分配给表。派生表可以继承其模板表定义的增长模式，也可以提供覆盖增长模式。增长模式的继承可以通过显式复制或引用或链接来执行。可以编辑增长模式，并且可以普遍地或本地地应用编辑。

3. 发明授权

US08108587B2 Free-space reduction in cached database pages 有权
标题翻译：缓存数据库页面中的自由空间减少
公开(公告)号：US08108587B2
公开(公告)日：2012-01-31
申请号：US12472103
申请日：2009-05-26
申请人： Brett A. Shirley , Laurion Burchall , Matthew Gossage
发明人： Brett A. Shirley , Laurion Burchall , Matthew Gossage
IPC分类号： G06F12/08 , G06F13/00
CPC分类号： G06F12/0802 , G06F2212/465 , G06F2212/466
摘要： A computing system stores a database comprising pages. Each of the pages is the same size. When a page is requested, a block of virtual memory addresses is associated with the page and a set of physical data storage locations is committed to the block of virtual memory addresses. A copy of the page is then stored into the set of physical data storage locations. Physical data storage locations committed to the virtual memory addresses associated with available free space in the copy of the page are deallocated, thereby allowing reuse of these physical data storage locations. A reference to the copy of the page is then returned.
摘要翻译：计算系统存储包含页面的数据库。每个页面的大小相同。当请求页面时，一块虚拟存储器地址与页面相关联，并且一组物理数据存储位置被提交到虚拟存储器地址块。然后将页面的副本存储到物理数据存储位置集合中。提交到与页面副本中的可用可用空间相关联的虚拟内存地址的物理数据存储位置被释放，从而允许重新使用这些物理数据存储位置。然后返回对该页面副本的引用。

4. 发明授权

US07249281B2 Method and system for backing up and restoring data of a node in a distributed system 有权
标题翻译：用于备份和恢复分布式系统中节点数据的方法和系统
公开(公告)号：US07249281B2
公开(公告)日：2007-07-24
申请号：US10628806
申请日：2003-07-28
申请人： Brett A. Shirley , Gregory C. Johnson
发明人： Brett A. Shirley , Gregory C. Johnson
IPC分类号： G06F11/00
CPC分类号： G06F11/1458 , G06F11/1453 , G06F11/1464 , G06F11/1469 , G06F2201/82 , G06F2201/84
摘要： A method and system for backing up and restoring a data set on a node of a distributed system prevents conflicts in data replication caused by restoration from backup data. Before a node is backed up, state data of the data set of the node are set to mark the data set as “backed up.” The data set also stores a lowest serial number for uncommitted changes. A snapshot of the data set, including the state data, of the node is then taken to provide a backup copy. When the backup copy is later used to restore the data set of the node, the “backed up” value of the state data of the restored data set serves as a notification to the replication server of the node that the data set has been restored, so that the replication server will switch to a new Node ID for labeling new changes for replication to other nodes in the distributed system.
摘要翻译：用于备份和还原分布式系统节点上的数据集的方法和系统可以防止由备份数据恢复引起的数据复制中的冲突。在备份节点之前，将节点数据集的状态数据设置为将数据集标记为“备份”。数据集还存储未提交更改的最低序列号。然后获取节点的数据集的快照（包括状态数据）以提供备份副本。当备份副本稍后用于恢复节点的数据集时，恢复的数据集的状态数据的“备份”值作为数据集已恢复的节点的复制服务器的通知，以便复制服务器将切换到新的节点ID，以标记新的更改以复制到分布式系统中的其他节点。

5. 发明授权

US09135158B2 Inheritance of growth patterns for derived tables 有权
标题翻译：派生表的增长模式的继承
公开(公告)号：US09135158B2
公开(公告)日：2015-09-15
申请号：US12967847
申请日：2010-12-14
申请人： Brett A. Shirley , Marcus E. Markiewicz
发明人： Brett A. Shirley , Marcus E. Markiewicz
IPC分类号： G06F12/02 , G06F17/30
CPC分类号： G06F12/023 , G06F17/30306 , G06F17/30339
摘要： Systems and methods are disclosed in which a derived table can inherit a growth pattern from a template table. A growth pattern is used to define how memory is allocated to a table as the table grows. The derived table can inherit the growth pattern defined by its template table or it can provide an override growth pattern. Inheritance of the growth pattern can be performed by explicit copying or by reference or link. Growth patterns can be edited, and the edits can be applied universally or locally.
摘要翻译：公开了系统和方法，其中派生表可以从模板表继承增长模式。增长模式用于定义当表的增长时如何将内存分配给表。派生表可以继承其模板表定义的增长模式，也可以提供覆盖增长模式。增长模式的继承可以通过显式复制或引用或链接来执行。可以编辑增长模式，并且可以普遍地或本地地应用编辑。

6. 发明授权

US08621267B2 Extended page patching 有权
标题翻译：扩展页面修补
公开(公告)号：US08621267B2
公开(公告)日：2013-12-31
申请号：US12968478
申请日：2010-12-15
申请人： Alexandre Santana da Costa , Umair Ahmad , Brett A. Shirley , Matthew G. Gossage
发明人： Alexandre Santana da Costa , Umair Ahmad , Brett A. Shirley , Matthew G. Gossage
IPC分类号： G06F11/00
CPC分类号： G06F11/004 , G06F11/1004 , G06F11/142
摘要： The embodiments described herein generally relate to methods and systems for using an extended patching procedure for correction or repair of logical data portions, pages, or sectors of a computer data storage device. The extended patching procedure targets for repair not only the page(s) appearing to be defective or unusable based on a failed read operation for a data transfer request, but also additional pages. Determining the additional pages to include for automatic patching is based on: statistical distribution analyzes to include pages within the physical or logical vicinity of the original page, information about the underlying storage device technology or Input/Output (I/O) subsystem, and/or historical data about error conditions for areas related to the original page. Preemptively patching pages based on extended page lists improves system performance by reducing the total number of costly repair processes and by avoiding situations involving correction actions that fail to resolve.
摘要翻译：本文描述的实施例一般涉及用于使用扩展修补程序来校正或修复计算机数据存储设备的逻辑数据部分，页面或扇区的方法和系统。扩展修补程序的目标是修复不仅基于数据传输请求的读取操作失败的页面看起来是有缺陷的或不可用的，而且还包括附加的页面。确定要包括用于自动修补的附加页面基于：统计分布分析以包括原始页面的物理或逻辑附近的页面，关于底层存储设备技术或输入/输出（I / O）子系统的信息，和/ 或关于原始页面相关区域的错误条件的历史数据。基于扩展页面列表的先发性修补页面可以通过减少昂贵的修复过程的总数，并避免涉及无法解决的纠正措施的情况，从而提高系统性能。

7. 发明申请

US20120159262A1 EXTENDED PAGE PATCHING 有权
标题翻译：扩展页面调整
公开(公告)号：US20120159262A1
公开(公告)日：2012-06-21
申请号：US12968478
申请日：2010-12-15
申请人： Alexandre Santana da Costa , Umair Ahmad , Brett A. Shirley , Matthew G. Gossage
发明人： Alexandre Santana da Costa , Umair Ahmad , Brett A. Shirley , Matthew G. Gossage
IPC分类号： G06F11/34 , G06F17/30
CPC分类号： G06F11/004 , G06F11/1004 , G06F11/142
摘要： The embodiments described herein generally relate to methods and systems for using an extended patching procedure for correction or repair of logical data portions, pages, or sectors of a computer data storage device. The extended patching procedure targets for repair not only the page(s) appearing to be defective or unusable based on a failed read operation for a data transfer request, but also additional pages. Determining the additional pages to include for automatic patching is based on: statistical distribution analyses to include pages within the physical or logical vicinity of the original page, information about the underlying storage device technology or Input/Output (I/O) subsystem, and/or historical data about error conditions for areas related to the original page. Preemptively patching pages based on extended page lists improves system performance by reducing the total number of costly repair processes and by avoiding situations involving correction actions that fail to resolve.
摘要翻译：本文描述的实施例一般涉及用于使用扩展修补程序来校正或修复计算机数据存储设备的逻辑数据部分，页面或扇区的方法和系统。扩展修补程序的目标是修复不仅基于数据传输请求的读取操作失败的页面看起来是有缺陷的或不可用的，而且还包括附加的页面。确定要包括用于自动修补的附加页面基于：统计分布分析以包括原始页面的物理或逻辑附近的页面，关于底层存储设备技术或输入/输出（I / O）子系统的信息，和/ 或关于原始页面相关区域的错误条件的历史数据。基于扩展页面列表预先修补页面通过减少昂贵的修复过程的总数并避免涉及无法解决的纠正措施的情况，从而提高系统性能。

8. 发明申请

US20100306444A1 Free-Space Reduction in Cached Database Pages 有权
标题翻译：缓存数据库页面中的自由空间减少
公开(公告)号：US20100306444A1
公开(公告)日：2010-12-02
申请号：US12472103
申请日：2009-05-26
申请人： Brett A. Shirley , Laurion Burchall , Matthew Gossage
发明人： Brett A. Shirley , Laurion Burchall , Matthew Gossage
IPC分类号： G06F12/08 , G06F12/16
CPC分类号： G06F12/0802 , G06F2212/465 , G06F2212/466
摘要： A computing system stores a database comprising pages. Each of the pages is the same size. When a page is requested, a block of virtual memory addresses is associated with the page and a set of physical data storage locations is committed to the block of virtual memory addresses. A copy of the page is then stored into the set of physical data storage locations. Physical data storage locations committed to the virtual memory addresses associated with available free space in the copy of the page are deallocated, thereby allowing reuse of these physical data storage locations. A reference to the copy of the page is then returned.
摘要翻译：计算系统存储包含页面的数据库。每个页面的大小相同。当请求页面时，一块虚拟存储器地址与页面相关联，并且一组物理数据存储位置被提交到虚拟存储器地址块。然后将页面的副本存储到物理数据存储位置集合中。提交到与页面副本中的可用可用空间相关联的虚拟内存地址的物理数据存储位置被释放，从而允许重新使用这些物理数据存储位置。然后返回对该页面副本的引用。

9. 发明授权

US08868618B2 Usage-optimized tables 有权
标题翻译：使用优化表
公开(公告)号：US08868618B2
公开(公告)日：2014-10-21
申请号：US12968124
申请日：2010-12-14
申请人： Naresh Sundaram , Marcus E. Markiewicz , Brett A. Shirley
发明人： Naresh Sundaram , Marcus E. Markiewicz , Brett A. Shirley
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30377
摘要： Systems and methods are disclosed for employing usage-optimized tables with a computer database system. In one embodiment, the database system stores create, update, and delete database operations in the usage-optimized table. The create, update, and delete database operations remain in the usage-optimized table until a flush condition is reached. When the flush condition is reached, the create, update, and delete operations are transferred to their corresponding real tables. In embodiments, the read operation does not flush the contents of the usage-optimized table to the real table. In such embodiments, the database system modifies read operations to account for data resident on the usage-optimized tables.
摘要翻译：公开了采用使用优化表与计算机数据库系统的系统和方法。在一个实施例中，数据库系统将创建，更新和删除数据库操作存储在使用优化表中。创建，更新和删除数据库操作将保留在使用优化表中，直到达到冲洗条件。当达到冲洗条件时，创建，更新和删除操作将传输到其相应的实际表。在实施例中，读取操作不将使用优化表的内容刷新到真实表。在这样的实施例中，数据库系统修改读取操作以考虑驻留在使用优化表上的数据。

10. 发明授权

US08768890B2 Delaying database writes for database consistency 有权
标题翻译：延迟数据库写入数据库一致性
公开(公告)号：US08768890B2
公开(公告)日：2014-07-01
申请号：US11685871
申请日：2007-03-14
申请人： Laurion D. Burchall , Andrew E. Goodsell , Brett A. Shirley
发明人： Laurion D. Burchall , Andrew E. Goodsell , Brett A. Shirley
IPC分类号： G06F17/30
CPC分类号： G06F17/30368 , G06F11/1471 , G06F11/2038 , G06F17/30371 , G06F2201/80
摘要： A continuous set of committed transactions can be lost without destroying the integrity of the database, by deferring the writing of the database pages stored in cache to the database on stable storage. A waypoint tracks a point in the transaction log following which transactions have not been applied to the database on stable storage and thus records after the waypoint are not needed for recovery to a consistent database. When there is a failover of an active database on Node A to a passive database on Node B, log records are compared starting with the most current and moving backwards and the point at which divergence in the log occurs is determined. When the lost portion of the log occurs after the point indicated by after the waypoint, the database is recoverable by log-based incremental reseed.
摘要翻译：通过将存储在缓存中的数据库页面写入稳定存储器上的数据库，可以丢失一组连续的已提交事务，而不会破坏数据库的完整性。航路点跟踪事务日志中的一个点，其中哪些事务尚未应用于稳定存储上的数据库，因此在恢复到一致的数据库后不需要航点的记录。当节点A上的活动数据库故障切换到节点B上的被动数据库时，日志记录将从最新和向后移动以及发生日志发散的点进行比较。当日志的丢失部分发生在航点之后指示的点之后，数据库可以通过基于日志的增量重新进行恢复。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式