DEFERRING DATA RECORD CHANGES USING QUERY REWRITING

    公开(公告)号:US20150074041A1

    公开(公告)日:2015-03-12

    申请号:US14036780

    申请日:2013-09-25

    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.

    SUPPORTING UPDATABLE REPEATED VALUES OVER VARIABLE SCHEMA

    公开(公告)号:US20170109392A1

    公开(公告)日:2017-04-20

    申请号:US14886684

    申请日:2015-10-19

    IPC分类号: G06F17/30

    摘要: Data within a database is partitioned into one or more sets of read-only data pages and one or more sets of append-only data pages, wherein each set of read-only data pages is associated to one of the one or more sets of append-only data pages. A repeated map is maintained for at least one of the one or more sets of append-only data pages. An operational position map is maintained for at least one of the one or more sets of append-only data pages. A request is received to update one or more records in a given set of read-only pages, wherein at least one of the one or more records comprises repeated values. The repeated map and operational position map of the append-only pages associated with the given set of read-only pages are updated in response to the request. The one or more sets of append-only pages are automatically merged with their respective set of read-only pages on a periodic basis to create one or more new sets of read-only pages.

    Accelerating multiversion concurrency control using hardware transactional memory
    5.
    发明授权
    Accelerating multiversion concurrency control using hardware transactional memory 有权
    使用硬件事务内存来加速多版本并发控制

    公开(公告)号:US09442837B2

    公开(公告)日:2016-09-13

    申请号:US14623656

    申请日:2015-02-17

    IPC分类号: G06K5/00 G06F12/02 G06F9/46

    CPC分类号: G06F9/467

    摘要: Atomically updating shared data in a transactional memory system comprising transactional memory storage and a transactional memory enabled processor. The computer creates a pointer stored in a stable memory location that is used to locate a shared data stored in a second memory location. The computer accesses the shared data and loads the pointer used to locate the accessed shared data into transactional memory storage. The computer updates the accessed shared data using copy-on-write, whereby the updated shared data is stored in a third memory location, and performs the atomic update of the shared data by updating the pointer such that it locates the updated shared data stored in the third memory location.

    摘要翻译: 在包括事务性存储器存储器和事务性存储器使能处理器的事务存储器系统中原子地更新共享数据。 计算机创建存储在稳定存储器位置中的指针,其用于定位存储在第二存储器位置中的共享数据。 计算机访问共享数据,并将用于定位被访问的共享数据的指针加载到事务性存储器中。 计算机使用写时复制来更新访问的共享数据,由此更新的共享数据被存储在第三存储器位置中,并通过更新指针来执行共享数据的原子更新,使得它定位存储在 第三个内存位置。

    Database Query Processing Using Horizontal Data Record Alignment of Multi-Column Range Summaries
    6.
    发明申请
    Database Query Processing Using Horizontal Data Record Alignment of Multi-Column Range Summaries 有权
    数据库查询处理使用多列范围摘要的水平数据记录对齐

    公开(公告)号:US20150347549A1

    公开(公告)日:2015-12-03

    申请号:US14293827

    申请日:2014-06-02

    IPC分类号: G06F17/30

    摘要: Organizing data within a database is provided. In response to determining that a group of coarsified data records within a database table is not an aligned group of data records, a virtually replicated subgroup of coarsified data records that corresponds to the group of coarsified data records is generated from different groups of coarsified data records within the database table. The virtually replicated subgroup of coarsified data records is aligned with the corresponding group of coarsified data records.

    摘要翻译: 提供数据库内的数据组织。 响应于确定数据库表中的一组粗化的数据记录不是对齐的数据记录组,从粗化数据记录的不同组生成对应于粗化数据记录组的虚拟复制的粗化数据记录子组 在数据库表中。 粗化数据记录的虚拟复制子组与相应的粗化数据记录组对齐。

    Deferring data record changes using query rewriting

    公开(公告)号:US09904706B2

    公开(公告)日:2018-02-27

    申请号:US14020076

    申请日:2013-09-06

    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.

    ACCELERATING MULTIVERSION CONCURRENCY CONTROL USING HARDWARE TRANSACTIONAL MEMORY
    8.
    发明申请
    ACCELERATING MULTIVERSION CONCURRENCY CONTROL USING HARDWARE TRANSACTIONAL MEMORY 有权
    使用硬件交互式存储器加速多重同步控制

    公开(公告)号:US20160239410A1

    公开(公告)日:2016-08-18

    申请号:US14623656

    申请日:2015-02-17

    IPC分类号: G06F12/02 G06F9/46

    CPC分类号: G06F9/467

    摘要: Atomically updating shared data in a transactional memory system comprising transactional memory storage and a transactional memory enabled processor. The computer creates a pointer stored in a stable memory location that is used to locate a shared data stored in a second memory location. The computer accesses the shared data and loads the pointer used to locate the accessed shared data into transactional memory storage. The computer updates the accessed shared data using copy-on-write, whereby the updated shared data is stored in a third memory location, and performs the atomic update of the shared data by updating the pointer such that it locates the updated shared data stored in the third memory location.

    摘要翻译: 在包括事务性存储器存储器和事务性存储器使能处理器的事务存储器系统中原子地更新共享数据。 计算机创建存储在稳定存储器位置中的指针,其用于定位存储在第二存储器位置中的共享数据。 计算机访问共享数据,并将用于定位被访问的共享数据的指针加载到事务性存储器中。 计算机使用写时复制来更新访问的共享数据,由此更新的共享数据被存储在第三存储器位置中,并通过更新指针来执行共享数据的原子更新,使得它定位存储在 第三个内存位置。

    SUPPORTING TRANSIENT SNAPSHOT WITH COORDINATED/UNCOORDINATED COMMIT PROTOCOL
    9.
    发明申请
    SUPPORTING TRANSIENT SNAPSHOT WITH COORDINATED/UNCOORDINATED COMMIT PROTOCOL 审中-公开
    支持与协调/不协调的委托协议的瞬时动作

    公开(公告)号:US20160103860A1

    公开(公告)日:2016-04-14

    申请号:US14509683

    申请日:2014-10-08

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 提供方法和系统。 一种方法包括在多版本数据库的多个数据页的每一个中维护用于记录的页内日志。 该方法还包括当记录中的相应记录被删除或更新时,将记录更新信息添加到页内日志中。 该方法还包括咨询页内日志以获取最近更新的一个记录或最近删除的一个记录以确定其记录状态。 该方法还包括当页内日志已满时,基于处理器的溢出管理器溢出溢出页面。 数据页面包括面向行的数据页面和面向列的数据页面。

    Supporting updatable repeated values over variable schema

    公开(公告)号:US10409799B2

    公开(公告)日:2019-09-10

    申请号:US14886684

    申请日:2015-10-19

    摘要: Data within a database is partitioned into one or more sets of read-only data pages and one or more sets of append-only data pages, wherein each set of read-only data pages is associated to one of the one or more sets of append-only data pages. A repeated map is maintained for at least one of the one or more sets of append-only data pages. An operational position map is maintained for at least one of the one or more sets of append-only data pages. A request is received to update one or more records in a given set of read-only pages, wherein at least one of the one or more records comprises repeated values. The repeated map and operational position map of the append-only pages associated with the given set of read-only pages are updated in response to the request. The one or more sets of append-only pages are automatically merged with their respective set of read-only pages on a periodic basis to create one or more new sets of read-only pages.