Synchronized backup and recovery of database systems
    3.
    发明授权
    Synchronized backup and recovery of database systems 有权
    数据库系统的同步备份和恢复

    公开(公告)号:US09575849B2

    公开(公告)日:2017-02-21

    申请号:US14553276

    申请日:2014-11-25

    IPC分类号: G06F11/00 G06F11/14 G06F17/30

    摘要: Disclosed herein are system, method, and computer program product embodiments for utilizing a backup catalog to perform synchronized backup and recovery of heterogeneous database systems. An embodiment operates by performing a global data backup of a heterogeneous database system comprising a first database management system (DBMS) at a first server and a second DBMS at a second server and recording a global data backup entry identifying the global data backup into a backup catalog. Upon receiving log backup notifications regarding asynchronous log backups on the first server and the second server, log backup entries identifying the asynchronous log backups are recorded into the backup catalog. To successfully perform a point-in-time recovery, the embodiment operates by using the backup catalog to identify data and log backups required for the recovery of the first and second servers to a recovery timestamp associated with the point-in-time recovery.

    摘要翻译: 本文公开了用于利用备份目录来执行异构数据库系统的同步备份和恢复的系统,方法和计算机程序产品实施例。 实施例通过执行包括第一服务器处的第一数据库管理系统(DBMS)和第二服务器处的第二DBMS的异构数据库系统的全局数据备份来操作,并将识别全局数据备份的全局数据备份条目记录到备份 目录。 在第一台服务器和第二台服务器上收到有关异步日志备份的日志备份通知后,将记录异步日志备份的日志备份条目记录到备份目录中。 为了成功执行时间点恢复,本实施例通过使用备份目录来识别将第一和第二服务器恢复到与时间点恢复相关联的恢复时间戳所需的数据和日志备份来进行操作。

    Execution of negated conditions using a bitmap
    4.
    发明授权
    Execution of negated conditions using a bitmap 有权
    使用位图执行否定条件

    公开(公告)号:US09471634B2

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

    申请号:US14206531

    申请日:2014-03-12

    IPC分类号: G06F17/30

    摘要: Disclosed herein are system, method, and computer program product embodiments for accelerating database queries containing bitmap-based conditions. An embodiment operates by determining a bitmap, where the bitmap represents a set of rows that have satisfied a conjunct that precedes a negated condition in a query expression and restricting the evaluation of the negated condition to the set of rows represented by the bitmap.

    摘要翻译: 本文公开了用于加速包含基于位图的条件的数据库查询的系统,方法和计算机程序产品实施例。 实施例通过确定位图来进行操作,其中位图表示满足在查询表达式中的否定条件之前的结合的行的集合,并且将否定条件的评估限制为由位图表示的行集合。