-
公开(公告)号:US12147558B2
公开(公告)日:2024-11-19
申请号:US17968136
申请日:2022-10-18
Applicant: SAP SE
Inventor: Patrick Voelker , Holger Mack , Meinolf Block , Thorsten Glebe , Mihnea Andrei , Yong Sik Kwon , Dirk Thomsen , Martin Schindewolf , Martin Kittel , Myung Sun Park , Beomsoo Kim , Martin Heidel , Christian Bensberg , Fabian Garagnon , Michael Muehle , Sergej Hardock , Johannes Beigel , Sascha Zorn , Christoph Hohner , Andreas Hartel
Abstract: A database system includes a persistent storage system, a memory storing metadata defining a tenant object and a plurality of database artifacts, a first instance of the tenant object, the first instance associated with a first plurality of the database artifacts including first data associated with the first instance of the tenant object, and a second instance of the tenant object, the second instance associated with a second plurality of the database artifacts including second data associated with the second instance of the tenant object. A processing unit is to execute program code of a database instance to cause the database system to encrypt the first data associated with the first instance of the tenant object using a first public encryption key and store the encrypted first data in the persistent storage system, and encrypt the second data associated with the second instance of the tenant object using a second public encryption key and store the encrypted second data in the persistent storage system.
-
公开(公告)号:US11216440B2
公开(公告)日:2022-01-04
申请号:US15970739
申请日:2018-05-03
Applicant: SAP SE
Inventor: Dirk Thomsen , Thorsten Glebe
IPC: G06F16/23
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.
-
公开(公告)号:US20190026302A1
公开(公告)日:2019-01-24
申请号:US15654179
申请日:2017-07-19
Applicant: SAP SE
Inventor: Dirk THOMSEN , Thorsten Glebe
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.
-
公开(公告)号:US11544180B2
公开(公告)日:2023-01-03
申请号:US15970704
申请日:2018-05-03
Applicant: SAP SE
Inventor: Dirk Thomsen , Thorsten Glebe
IPC: G06F12/02 , G06F12/1009 , G06F16/27 , G06F3/06 , G06F9/455
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.
-
公开(公告)号:US20210373893A1
公开(公告)日:2021-12-02
申请号:US16883241
申请日:2020-05-26
Applicant: SAP SE
Inventor: Dirk Thomsen , Thorsten Glebe , Tobias Scheuer , Werner Thesing , Johannes Gloeckle
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.
-
公开(公告)号:US10810116B2
公开(公告)日:2020-10-20
申请号:US15638189
申请日:2017-06-29
Applicant: SAP SE
Inventor: Dirk Thomsen , Thorsten Glebe
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.
-
公开(公告)号:US20190340276A1
公开(公告)日:2019-11-07
申请号:US15970739
申请日:2018-05-03
Applicant: SAP SE
Inventor: Dirk Thomsen , Thorsten Glebe
IPC: G06F17/30
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.
-
公开(公告)号:US20190018742A1
公开(公告)日:2019-01-17
申请号:US15647045
申请日:2017-07-11
Applicant: SAP SE
Inventor: Dirk Thomsen , Christoph Roterring , Thorsten Glebe
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.
-
9.
公开(公告)号:US10068197B2
公开(公告)日:2018-09-04
申请号:US14859006
申请日:2015-09-18
Applicant: SAP SE
Inventor: Andrei Suvernev , Thorsten Glebe , Volkmar Soehner , Daniel Booss
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.
-
公开(公告)号:US20180239676A1
公开(公告)日:2018-08-23
申请号:US15436535
申请日:2017-02-17
Applicant: SAP SE
Inventor: Thorsten Glebe , Werner Thesing , Christoph Roterring
CPC classification number: G06F11/1469 , G06F11/1471 , G06F11/2038 , G06F11/2094 , G06F11/2097 , G06F12/0253 , G06F2212/1041 , G06F2212/1044 , G06F2212/702
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 database system is later brought online after all of the recovery operations are replayed.
-
-
-
-
-
-
-
-
-