-
公开(公告)号：US20230185675A1
公开(公告)日：2023-06-15
申请号：US17546406
申请日：2021-12-09
Applicant: SAP SE
Inventor： Dirk Thomsen
CPC classification number: G06F11/1469 , G06F21/64 , G06F21/602 , G06F2201/84
Abstract: Computer-readable media, methods, and systems are disclosed for processing backup and recovery of pages in an in-memory database system employing tenant-based, group-level encryption for a plurality of tenants. Page metadata for a page may be collected. The page may comprise a header and a set of page contents. The page metadata may be stored with the page header. When a backup request is received, the page may be loaded into a backup stream. The page may be loaded with the header unencrypted and the page contents encrypted. When a recovery request is received, the data page may be retrieved from the backup stream. A converter may be rebuilt using the page metadata. The data page may then be written to the main memory of the database system. The page contents may be decrypted by the converter.
-
公开(公告)号：US11657046B1
公开(公告)日：2023-05-23
申请号：US17554506
申请日：2021-12-17
Applicant: SAP SE
Inventor： Dirk Thomsen
IPC: G06F16/24 , G06F16/2453 , G06F16/2455
CPC classification number: G06F16/2453 , G06F16/24552 , G06F16/24557
Abstract: Computer-readable media, methods, and systems are disclosed for improving performance when dropping database snapshots in an in-memory database by pruning tree branches in one or more converters associated with a snapshot of an in-memory database. A request to compare at least two database snapshots is received. Physical pages associated with at least one of the two database snapshots are loaded. First and second converter streams are iterated. Physical block numbers of intermediate converter pages to which the first and second converter streams currently point are compared. If the physical page numbers are all non-equal, the physical pages referenced by the second converter stream are set to free. If any of the physical page numbers are equal, subsequent traversal of a corresponding converter subtree in the first and second converter streams may be skipped to improve performance.
-
公开(公告)号：US20220382898A1
公开(公告)日：2022-12-01
申请号：US17333578
申请日：2021-05-28
Applicant: SAP SE
Inventor： Dirk Thomsen
Abstract: Computer-readable media, methods, and systems are disclosed for encrypting and decrypting data pages in connection with a database employing group-level encryption. A request to load a group-level encrypted logical data page into main memory is received, the data page being identified by a logical page number. A block of group-level encrypted data is loaded into the main memory of the database system from an address corresponding to the physical block number. A block of group-level encrypted data is loaded into the main memory of the database system. A header associated with the block of group-level encrypted data is decrypted using a data-volume encryption key, and an encryption-group identifier is accessed from the decrypted header. A group-level encryption key is retrieved from a key manager, and the remainder of the block of group-level encrypted data is decrypted using the group-level encryption key.
-
公开(公告)号：US20220382712A1
公开(公告)日：2022-12-01
申请号：US17333484
申请日：2021-05-28
Applicant: SAP SE
Inventor： Dirk Thomsen , Axel Schroeder
Abstract: Computer-readable media, methods, and systems are disclosed for minimizing data volume growth in a database system under changes to an encryption status of a plurality of data pages persisted to a database. Initially, a request is received to update an encryption parameter associated with the database. Next, it is determined whether a candidate page requires encryption changes. In response to determining that the candidate page is not currently in use by one or more active database snapshots and not currently loaded in main memory, the candidate page is loaded into main memory. Next, an encryption operation is performed on the candidate page, and the encrypted page is designated for persistence. Finally, based on a current number of candidate pages already encrypted during a current save point cycle, the selective iteration is paused until a subsequent save point cycle.
-
公开(公告)号：US11429388B2
公开(公告)日：2022-08-30
申请号：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.
-
Patent Agency Ranking
公开(公告)号：US11222007B2
公开(公告)日：2022-01-11
申请号：US15970727
申请日：2018-05-03
Applicant: SAP SE
Inventor： Dirk Thomsen , Thorsten Glebe , Blaise Lengrand
Abstract: Checking of a database snapshot of an active database is initiated. Thereafter, an anchor page associated with a most recent snapshot that links to a restart page is read. Subsequently, the linked restart page is read. It is then initially determined, based on the reading of the anchor page and the restart page, whether the snapshot is accurate. If it is initially determined that the snapshot is not accurate, the anchor page and the restart page are re-read until a final determination is made that whether the snapshot is accurate. Alternatively, if not is initially determined that the snapshot is accurate, then data is provided (e.g., displayed, loaded into memory, transmitted to a remote computing system, stored in physical persistence, etc.) that indicates that the snapshot is accurate.
-
公开(公告)号：US20200241968A1
公开(公告)日：2020-07-30
申请号：US16261146
申请日：2019-01-29
Applicant: SAP SE
Inventor： Dirk Thomsen
IPC: G06F11/14
Abstract: A temporary page is allocated in which pages are loaded into main memory and having associated physical disk storage. The temporary page is also flagged as being temporary. Subsequently, a savepoint is initiated for the database so that, during the savepoint, the temporary page can be modified without acquiring a consistent change while preventing other non-temporary pages from being modified. Later, the savepoint can be finalized to enable the database to be rolled back to a point in time corresponding to the savepoint as part of a recovery process.
-
公开(公告)号：US20190354470A1
公开(公告)日：2019-11-21
申请号：US15981548
申请日：2018-05-16
Applicant: SAP SE
Inventor： Dirk Thomsen , Torsten Strahl
Abstract: A plurality of pages are loaded into an in-memory data container forming part of an in-memory database as part of a backup process. Memory available for other database operations in the database are monitored. When the monitored available memory is below a pre-defined level, at least a portion of the pages loaded into the data container are flushed into physical persistence. Related apparatus, systems, and methods are also described.
-
公开(公告)号：US20190340118A1
公开(公告)日：2019-11-07
申请号：US15970704
申请日：2018-05-03
Applicant: SAP SE
Inventor： Dirk Thomsen , Thorsten Glebe
IPC: G06F12/02 , G06F12/1009 , G06F17/30 , 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.
-
公开(公告)号：US10452613B2
公开(公告)日：2019-10-22
申请号：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.
-
-
-
-
-
-
-
-
-
Search Results
77
records
(took 0.029 seconds)
