Automatic recovery of a failed standby database in a cluster
    1.
    发明授权
    Automatic recovery of a failed standby database in a cluster 有权
    自动恢复群集中的故障备用数据库

    公开(公告)号:US09514160B2

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

    申请号:US13794112

    申请日:2013-03-11

    CPC classification number: G06F17/30289 G06F17/30575 G06F17/30581

    Abstract: A method, system, and computer program product. The method for non-intrusive redeployment of a standby database facility comprises configuring a database system having a shared lock manager process to synchronize two or more concurrent access instances, then granting lock requests for access to a cache of database blocks. At some moment in time, the shared lock manager process may fail, and a monitor process detects the failure or other stoppage of the shared lock manager process. A new shared lock manager process and other processes are started, at least one of which serves for identifying the database blocks in the cache that have not yet been written to the database. The identified blocks are formed into a recovery set of redo operations. During this time, incoming requests for access to the cache of database blocks are briefly blocked, at least until the recovery set of redo operations has been formed.

    Abstract translation: 一种方法,系统和计算机程序产品。 用于非侵入式重新部署备用数据库设施的方法包括配置具有共享锁管理器进程的数据库系统以同步两个或多个并发访问实例,然后授予对数据库块的高速缓存的锁定请求。 在某个时刻,共享锁管理器进程可能会失败,并且监视进程检测到共享锁管理器进程的故障或其他停止。 启动新的共享锁管理器进程和其他进程,其中至少一个用于识别高速缓存中尚未写入数据库的数据库块。 所识别的块被形成恢复一组重做操作。 在此期间,暂时阻止访问数据库块的缓存的传入请求,至少在恢复组重做操作已经形成之前。

    LOADING AND RELOADING AN IN-MEMORY COPY OF A DATABASE OBJECT WITHOUT BLOCKING CONCURRENT UPDATES TO THE DATABASE OBJECT
    3.
    发明申请
    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: 这里描述了将数据库对象的一部分加载到易失性存储器中而不阻止数据库操作语言事务的技术。 这些技术涉及使由事务影响的块加载的数据项无效,称为在加载时间之前启动并在加载时间后提交的跨接事务。 识别这些跨越事务涉及查看与加载在存储器中的数据项集相关联的一个或多个事务列表。 交易列表可以以提交的反时间顺序读取,以识别满足在加载开始之前开始的准则的事务,而不是在加载时间之前提交,并影响加载到存储器中的数据项。

    Caching Large Objects In A Computer System With Mixed Data Warehousing And Online Transaction Processing Workload
    4.
    发明申请
    Caching Large Objects In A Computer System With Mixed Data Warehousing And Online Transaction Processing Workload 审中-公开
    在具有混合数据仓库和在线事务处理工作负载的计算机系统中缓存大对象

    公开(公告)号:US20140095802A1

    公开(公告)日:2014-04-03

    申请号:US13831462

    申请日:2013-03-14

    CPC classification number: G06F12/128 G06F12/126 G06F16/24561

    Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a database system receives request to access a target data object. The database system determines whether the request to access the target data object is associated with a first type of workload or a second type of workload. In response to determining that the request is associated with the first type of workload, the target data object replaces a least recently used data object in a cache. In response to determining that the request is associated with the second type of workload, the target data object is cached based on an associated access-level value.

    Abstract translation: 提供了在混合工作负载环境中管理缓存数据对象的技术。 在一个实施例中,数据库系统接收访问目标数据对象的请求。 数据库系统确定访问目标数据对象的请求是否与第一类工作负载或第二类工作负载相关联。 响应于确定该请求与第一类型的工作负载相关联,目标数据对象将替换高速缓存中最近最少使用的数据对象。 响应于确定该请求与第二类型的工作负载相关联,基于相关联的访问级别值来缓存目标数据对象。

Patent Agency Ranking