-
公开(公告)号：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.
-
公开(公告)号：US20180335949A1
公开(公告)日：2018-11-22
申请号：US15600633
申请日：2017-05-19
Applicant: SAP SE
Inventor： Dirk Thomsen
IPC: G06F3/06 , G06F12/123
Abstract: Allocation of an entry in a variable size entry container is initiated in an in-memory database system. The variable size entry container includes a plurality of pages forming a chain. Thereafter, it is determined whether free space is found within the pre-existing pages. If free space is found, the entry is allocated in the free space. Otherwise, a new page is created and appended to the chain so that the entry can be allocated on such new page.
-
公开(公告)号：US20180322050A1
公开(公告)日：2018-11-08
申请号：US15585557
申请日：2017-05-03
Applicant: SAP SE
Inventor： Dirk Thomsen
IPC: G06F12/0804 , G06F3/06 , G06F11/14
CPC classification number: G06F11/1469 , G06F12/0868 , G06F2201/80 , G06F2212/1032
Abstract: Execution of a page flusher is initiated in an in-memory database system in which pages are loaded into memory and having associated physical disk storage by a resource flush thread using a queue. Thereafter, pages are identified that have been loaded into the memory of the database system and which have been modified. These identified pages are to be flushed to the physical disk storage. Each page is assigned with a different ordered physical page number. These identified pages are added to the queue. Subsequently, asynchronous write I/O is triggered causing the identified pages to be flushed to the physical disk storage and stored in the physical disk storage according to their assigned physical page numbers such that, if at least one predetermined performance condition is met, a subset of the identified pages in the queue are flushed to physical disk storage.
-
公开(公告)号：US09830109B2
公开(公告)日：2017-11-28
申请号：US15369618
申请日：2016-12-05
Applicant: SAP SE
Inventor： David Wein , Mihnea Andrei , Dirk Thomsen , Ivan Schreter
CPC classification number: G06F3/065 , G06F3/0608 , G06F3/0617 , G06F3/0644 , G06F3/0673 , G06F3/0685 , G06F17/30315 , G06F17/30339 , G06F17/3048 , G06F17/30575
Abstract: The subject matter disclosed herein provides methods for materializing data from an in-memory array to one or more pages. An in-memory array holding a column of data can be maintained. One or more pages can be maintained. Each of the one or more pages can have one or more rows for storing the column of data. At least one of the one or more pages can be marked for materialization. The column of data can be materialized by copying the data from the in-memory array to the one or more rows of the one or more pages. The materializing can be based on the marking. Related apparatus, systems, techniques, and articles are also described.
-
公开(公告)号：US12298860B2
公开(公告)日：2025-05-13
申请号：US18487515
申请日：2023-10-16
Applicant: SAP SE
Inventor： Dirk Thomsen
Abstract: Embodiments of the present disclosure include techniques for backing up data. In one embodiment, a plurality of read requests are issued. In response to the read requests, a plurality of data pages are retrieved. The plurality of data pages are stored in a plurality of buffers. During said storing, for each data page, an indication that storage of a particular data page of the plurality of data pages has been completed is generated. In response to an indication that storage of a particular data page has been completed, the data page is processed with one of a plurality of jobs, where a plurality of data pages are processed by the plurality of jobs in parallel.
-
Patent Agency Ranking
公开(公告)号：US20250123929A1
公开(公告)日：2025-04-17
申请号：US18487515
申请日：2023-10-16
Applicant: SAP SE
Inventor： Dirk Thomsen
Abstract: Embodiments of the present disclosure include techniques for backing up data. In one embodiment, a plurality of read requests are issued. In response to the read requests, a plurality of data pages are retrieved. The plurality of data pages are stored in a plurality of buffers. During said storing, for each data page, an indication that storage of a particular data page of the plurality of data pages has been completed is generated. In response to an indication that storage of a particular data page has been completed, the data page is processed with one of a plurality of jobs, where a plurality of data pages are processed by the plurality of jobs in parallel.
-
公开(公告)号：US20230195747A1
公开(公告)日：2023-06-22
申请号：US17554300
申请日：2021-12-17
Applicant: SAP SE
Inventor： Dirk Thomsen
IPC: G06F16/27 , G06F16/2455 , G06F16/22
CPC classification number: G06F16/27 , G06F16/24568 , G06F16/2246
Abstract: Computer-readable media, methods, and systems are disclosed for improving performance when dropping database snapshots by linking converter streams associated with adjacent snapshots in a database system. A request is received to drop a snapshot. The database system iterates a first converter tree associated with a first converter stream to identify a first physical page number to be loaded. A physical page corresponding to the first physical page number is loaded. The database system iterates a second converter tree associated with a second converter stream to identify a second physical page number to be loaded. The second physical page number is queried from an iterator associated with the first converter tree. Responsive to determining that the physical page associated with the second physical page number is not present in main memory, the in-memory database system loads from disk, the physical page associated with the second physical page number.
-
公开(公告)号：US11683161B2
公开(公告)日：2023-06-20
申请号：US17333623
申请日：2021-05-28
Applicant: SAP SE
Inventor： Dirk Thomsen
CPC classification number: H04L9/0833 , G06F21/6218 , H04L9/0643 , H04L9/0894
Abstract: Computer-readable media, methods, and systems are disclosed for managing group-level database encryption keys under group-level encryption in a database management system. Upon startup of the database management system, persisted database entries are sequentially processed to produce an in-memory data structure comprising a set of encryption group identifier metadata tuples having an encryption group identifier and a valid-from save point cycle version. The set of encryption group identifier metadata tuples is mapped to a set of key identifier tuples including a local secure store identifier and a group-level encryption key identifier. A set of group-level encryption keys is received from a key management system, according to which a group-level encryption key is mapped to each encryption group identifier metadata tuple. Finally, an in-memory representation of the mapping between the set of encryption group identifier metadata tuples, the set of key identifier tuples, and the set of group-level encryption keys is constructed.
-
公开(公告)号：US20220385459A1
公开(公告)日：2022-12-01
申请号：US17333623
申请日：2021-05-28
Applicant: SAP SE
Inventor： Dirk Thomsen
Abstract: Computer-readable media, methods, and systems are disclosed for managing group-level database encryption keys under group-level encryption in a database management system. Upon startup of the database management system, persisted database entries are sequentially processed to produce an in-memory data structure comprising a set of encryption group identifier metadata tuples having an encryption group identifier and a valid-from save point cycle version. The set of encryption group identifier metadata tuples is mapped to a set of key identifier tuples including a local secure store identifier and a group-level encryption key identifier. A set of group-level encryption keys is received from a key management system, according to which a group-level encryption key is mapped to each encryption group identifier metadata tuple. Finally, an in-memory representation of the mapping between the set of encryption group identifier metadata tuples, the set of key identifier tuples, and the set of group-level encryption keys is constructed.
-
公开(公告)号：US11106653B2
公开(公告)日：2021-08-31
申请号：US15970715
申请日：2018-05-03
Applicant: SAP SE
Inventor： Dirk Thomsen , Thorsten Glebe
IPC: G06F16/23
Abstract: Execution of an exclusive lock of a page in a database is initiated. Thereafter, subsequent to the initiation of the execution of the exclusive lock, at least one non-exclusive lock for the page in the database is received. The execution of the exclusive lock is selectively timed out based on at least one savepoint statistic. While the exclusive lock is timed out, at least one of the received non-exclusive locks is executed. Further, the exclusive lock can be restarted after the execution of the at least one of the received non-exclusive locks.
-
-
-
-
-
-
-
-
-
Search Results
81
records
(took 0.017 seconds)
