-
公开(公告)号：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.
-
公开(公告)号：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.
-
Patent Agency Ranking
公开(公告)号：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.
-
公开(公告)号：US10884796B2
公开(公告)日：2021-01-05
申请号：US15970730
申请日：2018-05-03
Applicant: SAP SE
Inventor： Tobias Scheuer , Dirk Thomsen
IPC: G06F9/48 , G06F16/27 , G06F16/242
Abstract: Systems and methods are described herein for job execution using system critical threads. An in-memory database system having pages loaded into a memory and having associated physical disk storage generates a safety critical thread pool. The safety critical thread pool has one or more safety critical threads associated with flushing the pages to the physical disk storage. Execution of the one or more safety critical threads is initiated within the safety critical thread pool. A job request to access data stored within the physical disk storage is received. Utilization levels of the one or more safety critical threads are monitored. Execution of the job request is permitted based on the utilization levels associated with the one or more safety critical threads.
-
公开(公告)号：US20200241792A1
公开(公告)日：2020-07-30
申请号：US16261315
申请日：2019-01-29
Applicant: SAP SE
Inventor： Dirk Thomsen , Thorsten Glebe
Abstract: Pages are loaded into a resource container from physical disk storage into memory of an in-memory database. The resource container includes a resource provider and the pages include a plurality of large object pages (LOBs). Thereafter, the resource provider is used to allocate portions of the memory and control blocks to the pages. A job is triggered when an amount of memory allocated to LOBs by the resource provider exceeds a predefined first level. The job evicts LOBs from memory until the amount of memory allocated to LOBs is below a predefined second level.
-
公开(公告)号：US10558530B2
公开(公告)日：2020-02-11
申请号：US15646904
申请日：2017-07-11
Applicant: SAP SE
Inventor： Dirk Thomsen , Werner Thesing
Abstract: A savepoint is initiated in an in-memory database system that is associated with a plurality of modified pages and comprises a pre-critical phase, a critical phase, and a post-critical phase. Thereafter, as part of the critical phase, a physical page number is assigned to each page in the critical phase. Further, as part of the critical phase, each page assigned a physical page number is individually locked. Subsequently, each page is handed over from a corresponding first thread to a corresponding second thread to copy such page into a corresponding shadow page as part of the post-critical phase.
-
公开(公告)号：US20190354407A1
公开(公告)日：2019-11-21
申请号：US15980581
申请日：2018-05-15
Applicant: SAP SE
Inventor： Daniel Booss , Dirk Thomsen
Abstract: Resources are loaded into a resource container in an in-memory database system in which pages are loaded into memory and having associated physical disk storage. Each resource is assigned a new time stamp when such resource is loaded into the resource container. At least some of the references are subsequently accessed and time stamps associated with these accesses resources are selectively updated based on the type of access. These time stamps are later used to evict least recently used resources (as indicated by their time stamps) from the resource container.
-
-
-
-
-
-
-
-
-
Search Results
77
records
(took 0.021 seconds)
