Patch-up operations on invalidity data

    公开(公告)号:US10372699B2

    公开(公告)日:2019-08-06

    申请号:US15264978

    申请日:2016-09-14

    Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.

    PATCH-UP OPERATIONS ON INVALIDITY DATA
    2.
    发明申请

    公开(公告)号:US20180075079A1

    公开(公告)日:2018-03-15

    申请号:US15264978

    申请日:2016-09-14

    CPC classification number: G06F16/2322 G06F16/2365

    Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.

    LOADING AND RELOADING AN IN-MEMORY COPY OF A DATABASE OBJECT WITHOUT BLOCKING CONCURRENT UPDATES TO THE DATABASE OBJECT
    5.
    发明申请
    LOADING AND RELOADING AN IN-MEMORY COPY OF A DATABASE OBJECT WITHOUT BLOCKING CONCURRENT UPDATES TO THE DATABASE OBJECT 审中-公开
    对数据库对象加载和重新存储内存副本,而不会阻塞对数据库对象的同步更新

    公开(公告)号:US20160350363A1

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

    申请号:US14983481

    申请日:2015-12-29

    Abstract: Techniques are herein described for loading a portion of a database object into volatile memory without blocking database manipulation language transactions. The techniques involve invalidating data items loaded from blocks affected by a transaction, referred to as a straddling transaction that started before the load time and committed after the load time. Identifying these straddling transactions involves reviewing one or more transaction lists associated with the set of data items loaded in memory. The transaction list may be read in reverse temporal order of commit to identify a transaction meeting the criteria of starting before the load start, not committing before the load time, and affecting a data item loaded in memory.

    Abstract translation: 这里描述了将数据库对象的一部分加载到易失性存储器中而不阻止数据库操作语言事务的技术。 这些技术涉及使由事务影响的块加载的数据项无效,称为在加载时间之前启动并在加载时间后提交的跨接事务。 识别这些跨越事务涉及查看与加载在存储器中的数据项集相关联的一个或多个事务列表。 交易列表可以以提交的反时间顺序读取,以识别满足在加载开始之前开始的准则的事务,而不是在加载时间之前提交,并影响加载到存储器中的数据项。

    In place point-in-time recovery of pluggable databases
    6.
    发明授权
    In place point-in-time recovery of pluggable databases 有权
    即时恢复可插拔数据库

    公开(公告)号:US09298564B2

    公开(公告)日:2016-03-29

    申请号:US13830349

    申请日:2013-03-14

    Abstract: In an approach, a database server maintains a container database which comprises: one or more pluggable databases, a root database that stores an undo log for rolling back transactions on the consolidated database, and a redo log for replaying modifications to the container database. The database server restores a particular pluggable with a backup version that corresponds to a first point in time. The database server generates a clone database loaded with a backup version of the root database that corresponds to the first point in time. The database server applies the redo log to recover the particular pluggable database and the clone database to a second point in time that is later than the first point in time. The database server identifies, based on the clone database, one or more active transactions on the particular pluggable database. The database server rolls back the one or more active transactions.

    Abstract translation: 在一种方法中,数据库服务器维护一个容器数据库,它包括:一个或多个可插拔数据库,存储用于在统一数据库上回滚事务的撤销日志的根数据库,以及重播对容器数据库的修改的重做日志。 数据库服务器使用与第一个时间点对应的备份版本恢复特定的可插拔。 数据库服务器生成加载有与第一个时间点相对应的根数据库的备份版本的克隆数据库。 数据库服务器应用重做日志将特定的可插拔数据库和克隆数据库恢复到晚于第一个时间点的第二个时间点。 数据库服务器根据克隆数据库识别特定可插拔数据库上的一个或多个活动事务。 数据库服务器回滚一个或多个活动事务。

    MULTI-VERSION CONCURRENCY CONTROL ON IN-MEMORY SNAPSHOT STORE OF ORACLE IN-MEMORY DATABASE
    8.
    发明申请
    MULTI-VERSION CONCURRENCY CONTROL ON IN-MEMORY SNAPSHOT STORE OF ORACLE IN-MEMORY DATABASE 有权
    存储器内存数据库的内存存储器的多版本同步控制

    公开(公告)号:US20150088822A1

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

    申请号:US14337183

    申请日:2014-07-21

    Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

    Abstract translation: 提供的技术用于以一种格式持续保持数据,但使数据库可以以多种格式提供给数据库服务器。 例如,数据可用于查询处理的格式之一是基于磁盘格式,而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中,以减少与保持数据与数据的磁盘格式副本同步的开销。

    MECHANISM TO RUN OLTP WORKLOAD ON IN-MEMORY DATABASE UNDER MEMORY PRESSURE
    9.
    发明申请
    MECHANISM TO RUN OLTP WORKLOAD ON IN-MEMORY DATABASE UNDER MEMORY PRESSURE 有权
    在存储器压力下的内存数据库中运行OLTP工作负载的机制

    公开(公告)号:US20150088811A1

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

    申请号:US14337182

    申请日:2014-07-21

    Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

    Abstract translation: 提供的技术用于以一种格式持续保持数据,但使数据库可以以多种格式提供给数据库服务器。 例如,数据可用于查询处理的格式之一是基于磁盘格式,而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中,以减少与保持数据与数据的磁盘格式副本同步的开销。

Patent Agency Ranking