PAST-STATE BACKUP GENERATOR AND INTERFACE FOR DATABASE SYSTEMS

    公开(公告)号:US20220004462A1

    公开(公告)日:2022-01-06

    申请号:US17478162

    申请日:2021-09-17

    Abstract: An interface for requesting, and technique for generation of, a backup of a past state of a database table are provided. Changes made to a database table are accumulated, in durable storage, and snapshots of partitions of the table are obtained. The accumulated changes and the successive partition snapshots are used to generate a past state of the database at any point in time across a continuum between successive snapshots. Although each partition of the table may have a snapshot that was generated at a time different from when other partition snapshots were generated, changes from respective change logs may be selectively log-applied to distinct partitions of a table to generate backup in the past of the entire table at common point-in-time across partitions.

    INDEXES ON NON-MATERIALIZED VIEWS
    3.
    发明申请

    公开(公告)号:US20200167424A1

    公开(公告)日:2020-05-28

    申请号:US16200600

    申请日:2018-11-26

    Abstract: A database management system receives a request to create an index for a virtual view of a database table. In response to the request, the database management system identifies relationships between the columns of the virtual view and columns of the database table. The database management system generates an index on the database table, where columns are included in the generated index based on the identified relationships and the definition of the virtual view. Queries of the virtual view are assisted by the generated index of the underlying table.

    Past-state backup generator and interface for database systems

    公开(公告)号:US11579981B2

    公开(公告)日:2023-02-14

    申请号:US17478162

    申请日:2021-09-17

    Abstract: An interface for requesting, and technique for generation of, a backup of a past state of a database table are provided. Changes made to a database table are accumulated, in durable storage, and snapshots of partitions of the table are obtained. The accumulated changes and the successive partition snapshots are used to generate a past state of the database at any point in time across a continuum between successive snapshots. Although each partition of the table may have a snapshot that was generated at a time different from when other partition snapshots were generated, changes from respective change logs may be selectively log-applied to distinct partitions of a table to generate backup in the past of the entire table at common point-in-time across partitions.

    Past-state backup generator and interface for database systems

    公开(公告)号:US11126505B1

    公开(公告)日:2021-09-21

    申请号:US16101153

    申请日:2018-08-10

    Abstract: An interface for requesting, and technique for generation of, a backup of a past state of a database table are provided. Changes made to a database table are accumulated, in durable storage, and snapshots of partitions of the table are obtained. The accumulated changes and the successive partition snapshots are used to generate a past state of the database at any point in time across a continuum between successive snapshots. Although each partition of the table may have a snapshot that was generated at a time different from when other partition snapshots were generated, changes from respective change logs may be selectively log-applied to distinct partitions of a table to generate backup in the past of the entire table at common point-in-time across partitions.

Patent Agency Ranking