Asynchronous row to object enrichment of database change streams

    公开(公告)号:US11494408B2

    公开(公告)日:2022-11-08

    申请号:US16581253

    申请日:2019-09-24

    Abstract: A first copy of a database object may be constructed prior to applying a designated database update request to a first database. The database object may be represented by a plurality of database table rows in the first database, and the request may update one or more of the plurality of rows. The request may be applied to the first database to update the one or more of the plurality of rows in the first database. A second copy of the database object may be constructed after applying the database update request to the first database. A message identifying a difference between the first copy of the database object and a second copy of the database object may be transmitted to a remote computing device.

    Parallel processing of disjoint change streams into a single stream

    公开(公告)号:US10678773B2

    公开(公告)日:2020-06-09

    申请号:US15686640

    申请日:2017-08-25

    Abstract: Technology for tracking changes to a database and providing the changes to a subscribing computing device. In an illustrative implementation, a method may involve subscribing a computing device to changes of a portion of a multi-tenant database and accessing a plurality of change events stored in a log of the multi-tenant database in parallel. The method may further involve storing the plurality of change events in a persistent data store separate from the multi-tenant database and processing the plurality of change events to create an ordered set of change events. The ordered set of change events may then be provided to the computing device that subscribed to the changes.

    Undo based logical rewind in a multi-tenant system

    公开(公告)号:US10936571B1

    公开(公告)日:2021-03-02

    申请号:US15929353

    申请日:2020-04-28

    Abstract: Methods and systems for providing a rewind of table data in a data management system include: storing a table having table data that defines a plurality of rows and a plurality of columns that define a plurality of cells; capturing change data associated with changes to at least one of the plurality of rows, the plurality of columns, and the plurality of cells; associating the change data with a transaction having a transaction identifier; storing the transaction and the change data in a change bus; retrieving the change data from the change bus based on a rewind request; performing a rewind of a subset of the changes by performing a reverse operation of the change data relating to the subset of changes and according to a reverse operation order; and outputting a clone of the table based on the rewind of the changes of the table.

    Techniques for processing database tables using indexes

    公开(公告)号:US11132383B2

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

    申请号:US15885512

    申请日:2018-01-31

    Abstract: Techniques are disclosed relating to processing data stored within database tables in a parallelized manner. In various embodiments, a computer system maintains a database having a database table storing data for a plurality of tenants and an index structure storing indexes for accessing data stored in the database table. In some embodiments, the computer system receives, from a particular tenant, a request to perform a task that includes operating on particular data. In some embodiments, the computer system determines a portion of the index structure corresponding to the particular tenant and divides a range of indexes within that portion into a plurality of index sub-ranges. In various embodiments, the computer system processes portions of the task in parallel by determining an index sub-range for each of a plurality of threads and causing each of the threads to operate on a portion of the particular data specified by its index sub-range.

    BRANCH-BASED RECOVERY IN A DATABASE SYSTEM

    公开(公告)号:US20210064601A1

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

    申请号:US16552119

    申请日:2019-08-27

    Abstract: A staging table created in a database system may store a snapshot of live database table captured prior to an unintended change to the live database table. One or more entries in the staging table may be updated to incorporate one or more intended changes to the live database table that occurred after the unintended change. The live database table may be updated by merging each of the updated entries from the staging table to the live database table. The updated database table may eliminate the unintended change.

Patent Agency Ranking