Optimization of non-exclusive access database consistent change

    公开(公告)号:US11216440B2

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

    申请号:US15970739

    申请日:2018-05-03

    Applicant: SAP SE

    Abstract: A request is received for a first non-exclusive lock to read a page in a database. Thereafter, execution of the at least one non-exclusive lock is initiated. Later, a request for an exclusive lock to modify the page in the database is received. Subsequently, a request is received for a second non-exclusive lock. In response, an amount of time to finish the first request and the second request is estimated. The second non-exclusive lock is allowed to execute in parallel to the first non-exclusive if the determined amount of time to finish the second non-exclusive lock is less than an estimated amount of time needed by the first non-exclusive lock. Alternatively, execution of the second non-exclusive lock is delayed to after the execution of the exclusive lock if the determined amount of time to finish the second non-exclusive lock is greater than an amount of time needed by the first non-exclusive lock.

    Persistent Directory For Variable-Size Entry Container Free-Space Handling

    公开(公告)号:US20190026302A1

    公开(公告)日:2019-01-24

    申请号:US15654179

    申请日:2017-07-19

    Applicant: SAP SE

    Abstract: Disclosed herein are embodiments for free-space handling in pages and in-memory containers allowing variable-size data entries. An example system may determine expanses of unallocated space, within a page loaded in memory and configured to allocate a first data entry of a first size within the page that may also allocate at least one subsequent data entry of a second size different from the first size; save, into memory, transient free-space information corresponding to the page, including first position information for a first number of expanses of contiguous unallocated space within the page; evict the page from memory, writing allocated data entries contained therein to persistent storage; store, into persistent storage, persistent free-space information corresponding to the page, including second position information for a second number of expanses of unallocated space within the page, the second number being less than the first number; and discard the transient free-space information.

    In-memory database page allocation

    公开(公告)号:US11544180B2

    公开(公告)日:2023-01-03

    申请号:US15970704

    申请日:2018-05-03

    Applicant: SAP SE

    Abstract: A provisional page to be filled with data is allocated in an in-memory database system in which pages are loaded into memory and having associated physical disk storage a provisional page to be filled with data. Thereafter, the provisional page is filled with data. The provisional page is register after the provisional page has been filled with data such that consistent changes in the database are not required for the provisional page prior to the registering.

    PARALLEL LOAD OF MAPPING CONTAINERS FOR DATABASE SYSTEM START AND RESTART OPERATIONS

    公开(公告)号:US20210373893A1

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

    申请号:US16883241

    申请日:2020-05-26

    Applicant: SAP SE

    Abstract: Aspects of the current subject matter are directed to an approach in which a parallel load operation of file ID mapping containers is accomplished at start and/or restart of a database system. Parallel load operation of file ID mapping and/or large binary object (LOB) file ID mapping is done among a plurality of scanning engines into a plurality of data buffers that are associated with each of the plurality of scanning engines. Each scanning engine operates on a certain path of a page chain of a page structure including the mapping, causing the page chain to be split among scanning engines to process maps. Contents of the data buffers are pushed to mapping engines via a queue. The mapping engines load the file ID mapping and the LOB file ID mapping into maps for in-system access.

    In-memory database with page size adaptation during loading

    公开(公告)号:US10810116B2

    公开(公告)日:2020-10-20

    申请号:US15638189

    申请日:2017-06-29

    Applicant: SAP SE

    Abstract: Loading of a page into memory of an in-memory database system is initiated. Thereafter, a new page size for the page in memory is allocated corresponding to a greater of a current page size and an intended page size. Later, the page is loaded into the allocated memory so that a consistent change can be opened. Content within the page is reorganized according to the new page size followed by the consistent change being closed.

    Optimization of Non-Exclusive Access Database Consistent Change

    公开(公告)号:US20190340276A1

    公开(公告)日:2019-11-07

    申请号:US15970739

    申请日:2018-05-03

    Applicant: SAP SE

    Abstract: A request is received for a first non-exclusive lock to read a page in a database. Thereafter, execution of the at least one non-exclusive lock is initiated. Later, a request for an exclusive lock to modify the page in the database is received. Subsequently, a request is received for a second non-exclusive lock. In response, an amount of time to finish the first request and the second request is estimated. The second non-exclusive lock is allowed to execute in parallel to the first non-exclusive if the determined amount of time to finish the second non-exclusive lock is less than an estimated amount of time needed by the first non-exclusive lock. Alternatively, execution of the second non-exclusive lock is delayed to after the execution of the exclusive lock if the determined amount of time to finish the second non-exclusive lock is greater than an amount of time needed by the first non-exclusive lock.

    Automatic Adoption of Parallelized Database Garbage Collection

    公开(公告)号:US20190018742A1

    公开(公告)日:2019-01-17

    申请号:US15647045

    申请日:2017-07-11

    Applicant: SAP SE

    Abstract: Recovery of a database system by taking the database system offline is initiated. Thereafter, recovery operations specified by a redo log of the database system are replayed. A cleanup log is generated that identifies cleanup operations occurring during the replay of the recovery operations for garbage collection. Concurrent with the startup of the database, garbage collection of the cleanup operations as specified in the database savepoint is initiated. In addition, concurrent with the replay of the recovery operations, garbage collection of the cleanup operations specified by the cleanup log is initiated. The amount of parallelization of the garbage collection can be varied based on utilized processor resources. The database system is later brought online after all of the recovery operations are replayed.

    Method and apparatus for making changes to a quantity for a time interval within a time series

    公开(公告)号:US10068197B2

    公开(公告)日:2018-09-04

    申请号:US14859006

    申请日:2015-09-18

    Applicant: SAP SE

    Abstract: A method is described that involves providing a persisted quantity for a time series time interval to a first transaction, then, providing the same persisted quantity to a second transaction that operates in parallel with the first transaction. The second transaction is not permitted to change the persisted quantity. The method also involves replacing the persisted quantity with a second persisted quantity within the time series. The second persisted quantity is determined by the first transaction. The method also involves writing a persisted quantity change for the time series time interval. The persisted quantity change is determined by the second transaction.

Patent Agency Ranking