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

1. 发明申请

US20150120687A1 REDUCING DATABASE LOCKING CONTENTION USING MULTI-VERSION DATA RECORD CONCURRENCY CONTROL 有权
标题翻译：使用多版本数据记录同步控制减少数据库锁定内容
公开(公告)号：US20150120687A1
公开(公告)日：2015-04-30
申请号：US14063263
申请日：2013-10-25
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Fabian Nagel , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30362
摘要： Managing a multi-version data record database is provided. A mapping is maintained between a logical record identifier and committed and uncommitted physical record identifiers corresponding to data records using an indirection mapping table. Entries are updated within an index to point to the logical record identifier instead of the committed and uncommitted physical record identifiers. The committed physical record identifier corresponding to a data record is read from the indirection mapping table to access a committed version of the data record while a writer is modifying the data record to prevent the writer from blocking a reader. An uncommitted physical record identifier corresponding to the data record is written in the indirection mapping table to insert a new uncommitted version of the data record within a data table while the reader is reading the committed version of the particular data record to prevent the reader from blocking the writer.
摘要翻译：提供了管理多版本数据记录数据库。在逻辑记录标识符和使用间接映射表对应于数据记录的已提交和未提交的物理记录标识符之间保持映射。在索引中更新条目以指向逻辑记录标识符，而不是已提交和未提交的物理记录标识符。在写入器正在修改数据记录以防止写入器阻塞读取器时，从间接映射表读取对应于数据记录的提交的物理记录标识符以访问数据记录的提交版本。将与数据记录相对应的未提交的物理记录标识符写入间接映射表，以在读取器读取特定数据记录的提交版本时将数据记录的新的未提交版本插入到数据表内，以防止读取器阻塞作家。

2. 发明授权

US09959245B2 Access frequency approximation for remote direct memory access 有权
公开(公告)号：US09959245B2
公开(公告)日：2018-05-01
申请号：US14755835
申请日：2015-06-30
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Kenneth A. Ross
IPC分类号： G06F15/167 , G06F15/173 , H04L12/26
CPC分类号： G06F15/17331 , H04L43/06 , H04L43/08 , H04L43/16
摘要： A method includes the following steps. One or more records are accessed from a database memory bypassing a database access mechanism of a database system. Data representing access frequency of the one or more records are collected. The collected access frequency data for the one or more records are maintained. The access frequency data for the one or more records are aggregated until the access frequency reaches a threshold value. The aggregated access frequency data are asynchronously reported for the one or more records to the database system.

3. 发明授权

US09904706B2 Deferring data record changes using query rewriting 有权
公开(公告)号：US09904706B2
公开(公告)日：2018-02-27
申请号：US14020076
申请日：2013-09-06
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad S. Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30592
摘要： Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

4. 发明申请

US20160103860A1 SUPPORTING TRANSIENT SNAPSHOT WITH COORDINATED/UNCOORDINATED COMMIT PROTOCOL 审中-公开
标题翻译：支持与协调/不协调的委托协议的瞬时动作
公开(公告)号：US20160103860A1
公开(公告)日：2016-04-14
申请号：US14509683
申请日：2014-10-08
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad S. Hamedani , Kenneth A. Ross , Adam J. Storm
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/30315 , G06F17/30353 , G06F17/30356 , G06F17/30368 , G06F17/30371 , G06F17/30377 , G06F17/30592 , G06F2201/84
摘要： Methods and a system are provided. A method includes maintaining an in-page log for records in each of a plurality of data pages of a multi-version database. The method further includes adding record update information to the in-page log when a corresponding one of the records is deleted or updated. The method also includes consulting the in-page log for a recently updated one of the records or a recently deleted one of the records to determine a record status thereof. The method additionally includes spilling, by a processor-based overflow manager, to overflow pages when the in-page log is full. The data pages include any of row-oriented data pages and column-oriented data pages.
摘要翻译：提供方法和系统。一种方法包括在多版本数据库的多个数据页的每一个中维护用于记录的页内日志。该方法还包括当记录中的相应记录被删除或更新时，将记录更新信息添加到页内日志中。该方法还包括咨询页内日志以获取最近更新的一个记录或最近删除的一个记录以确定其记录状态。该方法还包括当页内日志已满时，基于处理器的溢出管理器溢出溢出页面。数据页面包括面向行的数据页面和面向列的数据页面。

5. 发明授权

US09305046B2 Compressing a multi-version database 有权
公开(公告)号：US09305046B2
公开(公告)日：2016-04-05
申请号：US13969538
申请日：2013-08-17
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30356 , G06F17/30153 , G06F17/30309 , G06F17/30312
摘要： Managing a multi-version database is provided. A logical record identifier to physical record row identifier indirection mapping table on a solid-state storage device is extended to include a plurality of delta blocks. A delta block within the plurality of delta blocks is maintained for each primary key in a plurality of primary keys associated with a data table on a magnetic hard disk storage device.

6. 发明授权

US09275095B2 Compressing a multi-version database 有权
标题翻译：压缩多版本数据库
公开(公告)号：US09275095B2
公开(公告)日：2016-03-01
申请号：US13955764
申请日：2013-07-31
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30356 , G06F17/30153 , G06F17/30309 , G06F17/30312
摘要： Managing a multi-version database is provided. A logical record identifier to physical record row identifier indirection mapping table on a solid-state storage device is extended to include a plurality of delta blocks. A delta block within the plurality of delta blocks is maintained for each primary key in a plurality of primary keys associated with a data table on a magnetic hard disk storage device.
摘要翻译：提供管理多版本数据库。将固态存储设备上的物理记录行标识符间接映射表的逻辑记录标识符扩展为包括多个增量块。在与磁性硬盘存储设备上的数据表相关联的多个主键中的每个主键上维持多个增量块内的增量块。

7. 发明授权

US09268804B2 Managing a multi-version database 有权
公开(公告)号：US09268804B2
公开(公告)日：2016-02-23
申请号：US13969537
申请日：2013-08-17
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/3023
摘要： Managing different versions of a data record is provided. A mapping is maintained between a version-independent logical record identifier and a version-dependent physical record row identifier that correspond to each data record within a plurality of data records of a data table using a logical record identifier to physical record row identifier indirection mapping table. Entries within leaf pages of an index associated with the data table are updated to point to the version-independent logical record identifier corresponding to a data record instead of pointing to the version-dependent physical record row identifier corresponding to the data record. The logical record identifier to physical record row identifier indirection mapping table is updated in response to performing an operation on the data record instead of updating the entries within the leaf pages of the index associated with the data table.

8. 发明申请

US20150363455A1 PREPLAYING TRANSACTIONS THAT MIX HOT AND COLD DATA 审中-公开
标题翻译：预处理混合热和冷数据的交易
公开(公告)号：US20150363455A1
公开(公告)日：2015-12-17
申请号：US14304600
申请日：2014-06-13
申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30 , G06F12/14 , G06F12/02
摘要： Methods and systems for performing database transactions include executing a first transaction request in a preplay mode that locks the requested data with a prefetch-lock and reads one or more requested data items from storage into a main memory buffer; locking the requested data items with a read/write lock after said data items are read into the main memory buffer; and performing the requested transaction on the data items in the main memory buffer using a processor.
摘要翻译：用于执行数据库事务的方法和系统包括以预先播放模式执行第一事务请求，该预先播放模式通过预取锁来锁定所请求的数据，并从存储器读取一个或多个所请求的数据项到主存储器缓冲器中; 在所述数据项被读入主存储器缓冲器之后，用读/写锁定锁定所请求的数据项; 以及使用处理器对所述主存储器缓冲器中的数据项执行所请求的交易。

9. 发明申请

US20150074041A1 DEFERRING DATA RECORD CHANGES USING QUERY REWRITING 审中-公开
公开(公告)号：US20150074041A1
公开(公告)日：2015-03-12
申请号：US14036780
申请日：2013-09-25
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad S. Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30592
摘要： Staging data record changes from a faster storage medium to a slower storage medium using data query rewriting is provided. In response to receiving a data query corresponding to a particular data record, it is determined whether the data query is one of a transactional data query or an analytical data query. In response to determining that the data query is a transactional data query, the transactional data query is rewritten to apply transactional delta changes to the particular data record on a storage-class memory of a computer. In response to determining that the data query is an analytical data query, the analytical data query is rewritten to select and reconcile each data record corresponding to the particular data record stored on the storage-class memory with the particular data record stored on a persistent data storage device of the computer.

10. 发明申请

US20150039573A1 COMPRESSING A MULTI-VERSION DATABASE 有权
标题翻译：压缩多版本数据库
公开(公告)号：US20150039573A1
公开(公告)日：2015-02-05
申请号：US13955764
申请日：2013-07-31
申请人： International Business Machines Corporation
发明人： Bishwaranjan Bhattacharjee , Mustafa Canim , Mohammad Sadoghi Hamedani , Kenneth A. Ross
IPC分类号： G06F17/30
CPC分类号： G06F17/30356 , G06F17/30153 , G06F17/30309 , G06F17/30312
摘要： Managing a multi-version database is provided. A logical record identifier to physical record row identifier indirection mapping table on a solid-state storage device is extended to include a plurality of delta blocks. A delta block within the plurality of delta blocks is maintained for each primary key in a plurality of primary keys associated with a data table on a magnetic hard disk storage device.
摘要翻译：提供管理多版本数据库。将固态存储设备上的物理记录行标识符间接映射表的逻辑记录标识符扩展为包括多个增量块。在与磁性硬盘存储设备上的数据表相关联的多个主键中的每个主键上维持多个增量块内的增量块。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式