公开(公告)号：US09235531B2

公开(公告)日：2016-01-12

申请号：US13305670

申请日：2011-11-28

申请人： Pedro Celis ,  Dexter Paul Bradshaw ,  Sadashivan Krishnamurthy ,  Georgiy I. Reynya ,  Chengliang Zhang ,  Hanumantha Rao Kodavalla

发明人： Pedro Celis ,  Dexter Paul Bradshaw ,  Sadashivan Krishnamurthy ,  Georgiy I. Reynya ,  Chengliang Zhang ,  Hanumantha Rao Kodavalla

IPC分类号： G06F12/00 ,  G06F12/12 ,  G06F9/45 ,  G06F12/08

CPC分类号： G06F12/121 ,  G06F8/4442 ,  G06F12/08 ,  G06F12/0866 ,  G06F12/0893 ,  G06F12/0897 ,  G06F12/12

摘要： A buffer manager that manages blocks of memory amongst multiple levels of buffer pools. For instance, there may be a first level buffer pool for blocks in first level memory, and a second level buffer pool for blocks in second level memory. The first level buffer pool evicts blocks to the second level buffer pool if the blocks are not used above a first threshold level. The second level buffer pool evicts blocks to a yet lower level if they have not used above a second threshold level. The first level memory may be dynamic random access memory, whereas the second level memory may be storage class memory, such as a solid state disk. By using such a storage class memory, the working block set of the buffer manager may be increased without resorting to lower efficiency random block access from yet lower level memory such as disk.

摘要翻译： 缓冲管理器，用于管理多级缓冲池中的内存块。 例如，可能存在第一级存储器中的块的第一级缓冲池，以及用于第二级存储器中的块的第二级缓冲池。 如果不在第一阈值级别以上使用块，则第一级缓冲池将块移动到第二级缓冲池。 如果第二级缓冲池没有使用高于第二阈值级别，那么第二级缓冲池将块移动到较低级别。 第一级存储器可以是动态随机存取存储器，而第二级存储器可以是诸如固态盘的存储类存储器。 通过使用这样的存储类存储器，可以增加缓冲器管理器的工作块集，而不需要从低级存储器（例如盘）获得较低效率的随机数据块访问。

公开(公告)号：US20120072652A1

公开(公告)日：2012-03-22

申请号：US13305670

申请日：2011-11-28

申请人： Pedro Celis ,  Dexter Paul Bradshaw ,  Sadashivan Krishnamurthy ,  Georgiy I. Reynya ,  Chengliang Zhang ,  Hanumantha Rao Kodavalla

发明人： Pedro Celis ,  Dexter Paul Bradshaw ,  Sadashivan Krishnamurthy ,  Georgiy I. Reynya ,  Chengliang Zhang ,  Hanumantha Rao Kodavalla

IPC分类号： G06F12/00

CPC分类号： G06F12/121 ,  G06F8/4442 ,  G06F12/08 ,  G06F12/0866 ,  G06F12/0893 ,  G06F12/0897 ,  G06F12/12

摘要： A buffer manager that manages blocks of memory amongst multiple levels of buffer pools. For instance, there may be a first level buffer pool for blocks in first level memory, and a second level buffer pool for blocks in second level memory. The first level buffer pool evicts blocks to the second level buffer pool if the blocks are not used above a first threshold level. The second level buffer pool evicts blocks to a yet lower level if they have not used above a second threshold level. The first level memory may be dynamic random access memory, whereas the second level memory may be storage class memory, such as a solid state disk. By using such a storage class memory, the working block set of the buffer manager may be increased without resorting to lower efficiency random block access from yet lower level memory such as disk.

摘要翻译： 缓冲管理器，用于管理多级缓冲池中的内存块。 例如，可能存在第一级存储器中的块的第一级缓冲池，以及用于第二级存储器中的块的第二级缓冲池。 如果不在第一阈值级别以上使用块，则第一级缓冲池将块移动到第二级缓冲池。 如果第二级缓冲池没有使用高于第二阈值级别，那么第二级缓冲池将块移动到较低级别。 第一级存储器可以是动态随机存取存储器，而第二级存储器可以是诸如固态盘的存储类存储器。 通过使用这样的存储类存储器，可以增加缓冲器管理器的工作块集，而不需要从低级存储器（例如盘）获得较低效率的随机数据块访问。

公开(公告)号：US08370310B2

公开(公告)日：2013-02-05

申请号：US13041091

申请日：2011-03-04

申请人： Robin Dhananjay Dhamankar ,  Hanumantha Rao Kodavalla

发明人： Robin Dhananjay Dhamankar ,  Hanumantha Rao Kodavalla

IPC分类号： G06F15/16 ,  G06F17/20

CPC分类号： G06F17/30303 ,  G06F11/1471 ,  G06F2201/80

摘要： Managing database recovery time. A method includes receiving user input specifying a target recovery time for a database. The method further includes determining an amount of time to read a data page of the database from persistent storage. The method further includes determining an amount of time to process a log record of the database to apply changes specified in the log record to a data page. The method further includes determining a number of dirty pages that presently would be read in recovery if a database failure occurred. The method further includes determining a number of log records that would be processed in recovery if a database failure occurred. The method further includes adjusting at least one of the number of dirty pages that presently would be read in recovery or the number of log records that would be processed in recovery to meet the specified target recovery time.

摘要翻译： 管理数据库恢复时间。 一种方法包括接收指定数据库的目标恢复时间的用户输入。 该方法还包括确定从持久存储器读取数据库的数据页面的时间量。 该方法还包括确定处理数据库的日志记录的时间量以将在日志记录中指定的改变应用于数据页。 该方法还包括确定在发生数据库故障时当前将在恢复中读取的脏页数。 该方法还包括确定在发生数据库故障时将在恢复中处理的日志记录的数量。 该方法还包括调整目前将在恢复中读取的脏页数的数目或将在恢复中处理以满足指定的目标恢复时间的日志记录的数目中的至少一个。

公开(公告)号：US20120226668A1

公开(公告)日：2012-09-06

申请号：US13041091

申请日：2011-03-04

申请人： Robin Dhananjay Dhamankar ,  Hanumantha Rao Kodavalla

发明人： Robin Dhananjay Dhamankar ,  Hanumantha Rao Kodavalla

IPC分类号： G06F17/30

CPC分类号： G06F17/30303 ,  G06F11/1471 ,  G06F2201/80

摘要： Managing database recovery time. A method includes receiving user input specifying a target recovery time for a database. The method further includes determining an amount of time to read a data page of the database from persistent storage. The method further includes determining an amount of time to process a log record of the database to apply changes specified in the log record to a data page. The method further includes determining a number of dirty pages that presently would be read in recovery if a database failure occurred. The method further includes determining a number of log records that would be processed in recovery if a database failure occurred. The method further includes adjusting at least one of the number of dirty pages that presently would be read in recovery or the number of log records that would be processed in recovery to meet the specified target recovery time.

摘要翻译： 管理数据库恢复时间。 一种方法包括接收指定数据库的目标恢复时间的用户输入。 该方法还包括确定从持久存储器读取数据库的数据页面的时间量。 该方法还包括确定处理数据库的日志记录的时间量以将在日志记录中指定的改变应用于数据页。 该方法还包括确定在发生数据库故障时当前将在恢复中读取的脏页数。 该方法还包括确定在发生数据库故障时将在恢复中处理的日志记录的数量。 该方法还包括调整目前将在恢复中读取的脏页数的数目或将在恢复中处理以满足指定的目标恢复时间的日志记录的数目中的至少一个。

公开(公告)号：US08818960B2

公开(公告)日：2014-08-26

申请号：US13051970

申请日：2011-03-18

申请人： Robin Dhananjay Dhamankar ,  Hanumantha Rao Kodavalla

发明人： Robin Dhananjay Dhamankar ,  Hanumantha Rao Kodavalla

IPC分类号： G06F7/00

CPC分类号： G06F11/1469 ,  G06F17/30306 ,  G06F17/30477

摘要： Embodiments are directed to implementing a transitional redo phase to allow pre-redo phase data access and to determining which data pages including unprocessed transactions are to be processed during a transitional redo phase. In an embodiment, a computer system initiates an analysis phase of a database recovery that scans a database transaction log and builds a dirty page table that includes pages corresponding to unprocessed data transactions. The computer system determines from the dirty page table which pages are to be processed during the transitional redo phase, before the final redo phase. The computer system processes the determined pages during the transitional redo phase, before the final redo phase is reached and, upon completion of the system transaction undo phase, makes available those pages that were processed during the transitional redo phase, as well as those database pages that are not scheduled for processing during the final redo phase.

摘要翻译： 实施例涉及实现过渡重做阶段，以允许重做前相位数据访问，并确定在过渡重做阶段期间处理包括未处理事务的数据页面。 在一个实施例中，计算机系统启动扫描数据库事务日志的数据库恢复的分析阶段，并构建包含与未处理的数据事务相对应的页面的脏页表。 计算机系统从脏页表确定在过渡重做阶段期间在最后重做阶段之前要处理的页面。 计算机系统在过渡重做阶段期间处理确定的页面，在达到最后的重做阶段之前，并且在完成系统事务撤销阶段后，使得在过渡重做阶段期间处理的那些页面以及那些数据库页面 这些计划在最后重做阶段没有计划进行处理。

公开(公告)号：US07765361B2

公开(公告)日：2010-07-27

申请号：US11562053

申请日：2006-11-21

申请人： Robin Dhananjay Dhamankar ,  Vishal Kathuria ,  Sethu Kalavakur ,  Gayathri Venkataraman ,  Avraham Levy ,  Hanumantha Rao Kodavalla ,  Chunjia Li ,  Eric Ray Christensen

发明人： Robin Dhananjay Dhamankar ,  Vishal Kathuria ,  Sethu Kalavakur ,  Gayathri Venkataraman ,  Avraham Levy ,  Hanumantha Rao Kodavalla ,  Chunjia Li ,  Eric Ray Christensen

IPC分类号： G06F12/16

CPC分类号： G06F12/0804 ,  G06F11/1471 ,  G06F12/0866 ,  G06F17/30368

摘要： To ensure that logs representative of data changes are durably written, localized storage media cache is flushed to force a write to stable storage. Log sequence number tracking is leveraged to determine if log data in a localized storage media cache is likely to have not been written to durable storage. When this condition is likely, a FLUSH_CACHE command is issued to a storage media controller to force a durable write. This allows recovery of data changes to a transactional system even when its associated storage media does not provide write-ordering guarantees. Moreover, flushing of the storage media cache can be accomplished at a frequency that provides an upper bound on a maximum time between a transaction commit and data being made durable.

摘要翻译： 为了确保代表数据更改的日志持久写入，本地化存储介质缓存被刷新以强制写入稳定的存储。 利用日志序列号跟踪来确定本地化存储介质缓存中的日志数据是否可能尚未写入持久存储。 当这种情况很可能时，会向存储介质控制器发出FLUSH_CACHE命令以强制持久写入。 即使在关联的存储介质不提供写入顺序保证的情况下，也可以将数据更改恢复到事务性系统。 此外，存储介质缓存的刷新可以以提供交易提交和数据被持久的最大时间之间的上限的频率来实现。

公开(公告)号：US20090182746A1

公开(公告)日：2009-07-16

申请号：US12014764

申请日：2008-01-15

申请人： Pravin Mittal ,  Hanumantha Rao Kodavalla

发明人： Pravin Mittal ,  Hanumantha Rao Kodavalla

IPC分类号： G06F17/00

CPC分类号： G06F17/30362

摘要： Described is a technology by which a database management system more efficiently processes read requests than write requests for a read-mostly database table, which is a database table that is generally read far more often than written. A lock partitioning mechanism may be implemented to provide a read lock for each CPU of a plurality of CPUs, in which only one read lock is acquired to process a read request. A database table state changing mechanism may be implemented that more efficiently processes read requests relative to write requests by maintaining the database table in a read-only state until a write request is processed. When a write request is received, the database table is changed to a read-write state to process the write request. The database table is then reset back to a read-only state, such as by running a background thread.

摘要翻译： 描述了一种数据库管理系统通过该技术更有效地处理读请求而不是对主要为大多数的数据库表的写入请求，该数据库表是通常比写入更多的数据库表。 可以实现锁定分隔机构以为多个CPU中的每个CPU提供读锁定，其中仅获取一个读取锁来处理读取请求。 可以实现数据库表状态改变机制，其通过将数据库表保持在只读状态来更有效地处理相对于写请求的读请求，直到写请求被处理。 当接收到写请求时，将数据库表更改为读写状态以处理写请求。 然后将数据库表重新设置为只读状态，例如通过运行后台线程。

公开(公告)号：US20080120470A1

公开(公告)日：2008-05-22

申请号：US11562053

申请日：2006-11-21

申请人： Robin Dhananjay Dhamankar ,  Vishal Kathuria ,  Sethu Kalavakur ,  Gayathri Venkataraman ,  Avraham Levy ,  Hanumantha Rao Kodavalla ,  Chunjia Li ,  Eric Ray Christensen

发明人： Robin Dhananjay Dhamankar ,  Vishal Kathuria ,  Sethu Kalavakur ,  Gayathri Venkataraman ,  Avraham Levy ,  Hanumantha Rao Kodavalla ,  Chunjia Li ,  Eric Ray Christensen

IPC分类号： G06F12/08

CPC分类号： G06F12/0804 ,  G06F11/1471 ,  G06F12/0866 ,  G06F17/30368

摘要： To ensure that logs representative of data changes are durably written, localized storage media cache is flushed to force a write to stable storage. Log sequence number tracking is leveraged to determine if log data in a localized storage media cache is likely to have not been written to durable storage. When this condition is likely, a FLUSH_CACHE command is issued to a storage media controller to force a durable write. This allows recovery of data changes to a transactional system even when its associated storage media does not provide write-ordering guarantees. Moreover, flushing of the storage media cache can be accomplished at a frequency that provides an upper bound on a maximum time between a transaction commit and data being made durable.

摘要翻译： 为了确保代表数据更改的日志持久写入，本地化存储介质缓存被刷新以强制写入稳定的存储。 利用日志序列号跟踪来确定本地化存储介质缓存中的日志数据是否可能尚未写入持久存储。 当这种情况很可能时，会向存储介质控制器发出FLUSH_CACHE命令以强制持久写入。 即使在关联的存储介质不提供写入顺序保证的情况下，也可以将数据更改恢复到事务性系统。 此外，存储介质缓存的刷新可以以提供交易提交和数据被持久的最大时间之间的上限的频率来实现。

公开(公告)号：US07366740B2

公开(公告)日：2008-04-29

申请号：US10903187

申请日：2004-07-30

申请人： Martin J. Sleeman ,  Artem A. Oks ,  Hanumantha Rao Kodavalla ,  Nigel R. Ellis

发明人： Martin J. Sleeman ,  Artem A. Oks ,  Hanumantha Rao Kodavalla ,  Nigel R. Ellis

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/3051 ,  G06F17/30306 ,  G06F17/30371 ,  Y10S707/954 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： The present invention is directed a logical consistency checker (LCC) working alone or in conjunction with a physical consistency checker (PCC) and/or a data reliability system (DRS) for a database files system of a hardware/software interface system. Logical data correction pertains to logical data corruptions for entities (e.g., items, extensions, and/or relationships in an item-based operating system, where an item-based operating system is one example of an item-based hardware/software interface system). In this regard, a LCC analyses and corrects logical damage to entities representatively stored in the data store in order to ensure that all such entities in said data store are both consistent and conform to the data model rules.

摘要翻译： 本发明涉及一种单独或与硬件/软件接口系统的数据库文件系统的物理一致性检查器（PCC）和/或数据可靠性系统（DRS）一起工作的逻辑一致性检验器（LCC）。 逻辑数据校正涉及实体的逻辑数据损坏（例如，基于项目的操作系统中的项目，扩展和/或关系，其中基于项的操作系统是基于项目的硬件/软件接口系统的一个示例） 。 在这方面，LCC分析并纠正代表性地存储在数据存储中的实体的逻辑损害，以便确保所述数据存储中的所有这些实体都是一致的并且符合数据模型规则。

公开(公告)号：US07676481B2

公开(公告)日：2010-03-09

申请号：US11121284

申请日：2005-05-03

申请人： Vishal Kathuria ,  Hanumantha Rao Kodavalla ,  Martin J. Sleeman ,  Robin Dhananjay Dhamankar

发明人： Vishal Kathuria ,  Hanumantha Rao Kodavalla ,  Martin J. Sleeman ,  Robin Dhananjay Dhamankar

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F9/4493 ,  G06F11/1448 ,  Y10S707/99942

摘要： A system and method for serialization and/or de-serialization of file system item(s) and associated entity(ies)is provided. A file system “item” comprises a core class which can include property(ies). Through serialization, a consistent copy of the item and associated entity(ies), such as fragment(s), link(s) with other item(s) and/or extension(s),if any, can be captured. The serialization system includes an identification component that identities entity(ies) associated with an item and a serialization component that serializes the item and associated entity(ies). The serialization component can further serialize a header that includes information associated with the item and associated entity(ies). The header can facilitate random access to the item and associated entity(ies). The serialization system can expose application program interface(s) (API's) that facilitate the copying, moving and/or transfer of an item and its associated entity(ies) from one location to another location.

摘要翻译： 提供了一种用于文件系统项目和关联实体的序列化和/或解串行化的系统和方法。 文件系统“项目”包括可以包括属性的核心类。 通过序列化，可以捕获项目和关联实体（例如片段，与其他项目和/或扩展）的链接（如果有的话）的一致副本。 序列化系统包括识别组件，其与项目相关联的身份实体和串行化项目和关联实体的序列化组件。 序列化组件可以进一步序列化包括与项目和关联实体相关联的信息的报头。 标题可以促进对项目和关联实体的随机访问。 序列化系统可以公开应用程序接口（API），其便于将项目及其相关联的实体从一个位置复制，移动和/或传送到另一个位置。