Early Database Transaction Visibility
    2.
    发明公开

    公开(公告)号:US20240118982A1

    公开(公告)日:2024-04-11

    申请号:US18045260

    申请日:2022-10-10

    CPC classification number: G06F11/2092 G06F16/2455 G06F2201/85

    Abstract: The disclosed techniques reduce a responsiveness time for a secondary node state of a database in switching from a second computing node to replace a first computing node acting in a primary node state, with both computing nodes performing the same database queries. The second node receives information regarding queries performed by the first node while in the primary state. In some embodiments, the second node retrieves, from a transaction log, log records detailing operations performed for database transactions. In some embodiments, the second node inserts, based on the log records, data records of the transactions into an in-memory cache of the second node that stores chains of database records from different transactions. Upon receiving sufficient information to switch to the primary state, the second node changes a mode of operation during failover making a committed transaction available for reads by subsequent database queries prior to record reordering.

    INDEX FOR MULTI-LEVEL DATA STRUCTURES
    3.
    发明公开

    公开(公告)号:US20240320204A1

    公开(公告)日:2024-09-26

    申请号:US18680140

    申请日:2024-05-31

    CPC classification number: G06F16/2264

    Abstract: Techniques are disclosed relating to index metadata that is usable for accessing multi-level data structures. A computer system may operate a database, including maintaining a set of records having a set of corresponding keys. The computer system may create multi-level data structures that facilitate key range lookups against those records. A given multi-level data structure may store key information indicative of a subset of the corresponding keys. The computer system may create separate index metadata that is usable for accessing the multi-level data structures. The index metadata may specify indications of key information that is stored in the multi-level data structures and locations of the multi-level data structures. The computer system may perform a key range lookup that includes using the index metadata to determine a particular set of the multi-level data structures whose key information corresponds to a key range of the key range lookup.

    Early database transaction visibility

    公开(公告)号:US12086041B2

    公开(公告)日:2024-09-10

    申请号:US18045260

    申请日:2022-10-10

    CPC classification number: G06F11/2092 G06F16/2455 G06F2201/85

    Abstract: The disclosed techniques reduce a responsiveness time for a secondary node state of a database in switching from a second computing node to replace a first computing node acting in a primary node state, with both computing nodes performing the same database queries. The second node receives information regarding queries performed by the first node while in the primary state. In some embodiments, the second node retrieves, from a transaction log, log records detailing operations performed for database transactions. In some embodiments, the second node inserts, based on the log records, data records of the transactions into an in-memory cache of the second node that stores chains of database records from different transactions. Upon receiving sufficient information to switch to the primary state, the second node changes a mode of operation during failover making a committed transaction available for reads by subsequent database queries prior to record reordering.

    DOWNGRADING DATABASE SOFTWARE
    5.
    发明公开

    公开(公告)号:US20240256255A1

    公开(公告)日:2024-08-01

    申请号:US18313067

    申请日:2023-05-05

    CPC classification number: G06F8/65 G06F16/217

    Abstract: Techniques for downgrading of database software. Code areas that may affect downgradability may be delineated with code markers. Changes to these sections can be made to prevent a new database version from being built unless a process is taken to indicate that any new features be designated as available, but not yet allowed for N software releases. This provides a downgrade window of N releases that will support functionality currently allowed by the database. In response to receiving a downgrade request to a target older database software version, that request can be permitted if all the database features are available or allowed in the target version. If at least one of the database features is not available in the target version, the downgrade requested is not permitted. If the request is permitted, the downgrade operation is commenced.

    DATABASE NODE SOFT RESTART
    7.
    发明公开

    公开(公告)号:US20240118973A1

    公开(公告)日:2024-04-11

    申请号:US17938423

    申请日:2022-10-06

    CPC classification number: G06F11/1438 H04L67/10 G06F2201/80

    Abstract: Techniques are disclosed relating to restarting a database node. A database node may allocate memory segments that include a restart segment for storing data records. The database node may spawn processes to read a log and replay log records of the log to update the restart segment to store data records. The database node may determine to perform a restart operation to transition from a first mode to a second mode. Performing the restart operation may include ceasing reading the log at a stop position and storing, based on the stop position, database state information that enables the processes to resume reading the log from the stop position. The database node may further deallocate the memory segments except for the restart segment and terminate the processes. After performing the restart operation, the database node may spawn the processes, which may resume reading the log based on the database state information.

Patent Agency Ranking