-
公开(公告)号：US11170023B2
公开(公告)日：2021-11-09
申请号：US15445593
申请日：2017-02-28
Applicant: SAP SE
Inventor： Colin Florendo , Michael Muehle , Thorsten Glebe , Rolando Blanco , Chaitanya Gottipati , Nirvik Basak , Martin Heidel , Peter Steinemann , Vivek Kandiyanallur , Shiping Chen , Sarika Iyer , Jörn Schmidt
IPC: G06F16/27 , G06F16/23 , G06F16/2455 , G06F11/20
Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号：US11086832B2
公开(公告)日：2021-08-10
申请号：US14885752
申请日：2015-10-16
Applicant: SAP SE
Inventor： Panfeng Zhou , Colin Florendo , Ivan Schreter , Thorsten Glebe , David Wein
Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.
-
公开(公告)号：US10810092B2
公开(公告)日：2020-10-20
申请号：US15959744
申请日：2018-04-23
Applicant: SAP SE
Inventor： Christian Bensberg , Steffen Geissinger , Thorsten Glebe
Abstract: Provided are systems and methods for storing checkpoints of an in-memory storage device. In one example, the method may include detecting database transactions performed on a slice of an in-memory storage and storing a record of the database transactions in a log file, receiving a request to persist the slice of in-memory storage, the request comprising a timing indicator corresponding to a timing of database transactions, trimming the log file based on the timing indicator to remove a record of one or more database transactions from the log file that occurred prior to the timing indicator and to preserve a record of one or more database transactions that occurred after the timing indicator, and persisting, to disk, data from the slice of in-memory storage and the trimmed log file preserving the record of the one or more database transactions that occurred after the timing indicator.
-
公开(公告)号：US20190340277A1
公开(公告)日：2019-11-07
申请号：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.
-
公开(公告)号：US20190324866A1
公开(公告)日：2019-10-24
申请号：US15959744
申请日：2018-04-23
Applicant: SAP SE
Inventor： Christian Bensberg , Steffen Geissinger , Thorsten Glebe
Abstract: Provided are systems and methods for storing checkpoints of an in-memory storage device. In one example, the method may include detecting database transactions performed on a slice of an in-memory storage and storing a record of the database transactions in a log file, receiving a request to persist the slice of in-memory storage, the request comprising a timing indicator corresponding to a timing of database transactions, trimming the log file based on the timing indicator to remove a record of one or more database transactions from the log file that occurred prior to the timing indicator and to preserve a record of one or more database transactions that occurred after the timing indicator, and persisting, to disk, data from the slice of in-memory storage and the trimmed log file preserving the record of the one or more database transactions that occurred after the timing indicator.
-
Patent Agency Ranking
公开(公告)号：US20170322960A1
公开(公告)日：2017-11-09
申请号：US15150301
申请日：2016-05-09
Applicant: SAP SE
Inventor： Thorsten Glebe , Martin Heidel , Michael Muehle , Felix Knittel , Reza Sherkat
CPC classification number: G06F16/2228 , G06F3/0608 , G06F3/064 , G06F3/0674 , G06F16/2219
Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.
-
公开(公告)号：US11416349B2
公开(公告)日：2022-08-16
申请号：US17008380
申请日：2020-08-31
Applicant: SAP SE
Inventor： Thorsten Glebe , Werner Thesing , Christoph Roterring
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.
-
公开(公告)号：US11176004B2
公开(公告)日：2021-11-16
申请号：US16371889
申请日：2019-04-01
Applicant: SAP SE
Inventor： Stephan Kottler , Martin Heidel , Peter Steinemann , Thorsten Glebe , Johannes Haeussler
Abstract: A method, a system, and a computer program product for performing testing of continuous log replays in a database system. A redo log generated for a data record in a database is received. The redo log is indicative of a change in persistency of the data record in the database. Based on the change in persistency recorded in the redo log, a redo handler in the plurality of handlers is selected for execution of a replay of the received redo log. Using the selected redo log, replay of the redo log is executed to generate a state of the data record prior to the change in persistency recoded in the redo log.
-
公开(公告)号：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.
-
公开(公告)号：US10795779B2
公开(公告)日：2020-10-06
申请号：US15436535
申请日：2017-02-17
Applicant: SAP SE
Inventor： Thorsten Glebe , Werner Thesing , Christoph Roterring
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.
-
-
-
-
-
-
-
-
-
Search Results
38
records
(took 0.014 seconds)
