公开(公告)号：US20200310925A1

公开(公告)日：2020-10-01

申请号：US16371889

申请日：2019-04-01

Applicant: SAP SE

Inventor： Stephan Kottler ,  Martin Heidel ,  Peter Steinemann ,  Thorsten Glebe ,  Johannes Haeussler

IPC: G06F11/14 ,  G06F16/23

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.

公开(公告)号：US20200241792A1

公开(公告)日：2020-07-30

申请号：US16261315

申请日：2019-01-29

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F3/06 ,  G06F9/50

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.

公开(公告)号：US10698921B2

公开(公告)日：2020-06-30

申请号：US15445505

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Günter Radestock

IPC: G06F16/27 ,  G06F16/23

Abstract: A computer implemented method for initializing a secondary database system includes receiving table state information from a primary database system at a secondary database system. The table state information includes information identifying which tables had an open operation during a savepoint event. Metadata associated with the tables is parsed to identify table state information from the metadata and a lock is created for each table identified as having an open operation during the savepoint event. Afterwards, log transaction information is sequentially parsed. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US10481986B2

公开(公告)日：2019-11-19

申请号：US15647045

申请日：2017-07-11

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Christoph Roterring ,  Thorsten Glebe

IPC: G06F11/14 ,  G06F12/02 ,  G06F16/23

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.

公开(公告)号：US20190340275A1

公开(公告)日：2019-11-07

申请号：US15970715

申请日：2018-05-03

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F17/30

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.

公开(公告)号：US20190004937A1

公开(公告)日：2019-01-03

申请号：US15638189

申请日：2017-06-29

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Thorsten Glebe

IPC: G06F12/02 ,  G06F17/30

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.

公开(公告)号：US20180246948A1

公开(公告)日：2018-08-30

申请号：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: G06F17/30

CPC classification number: G06F16/273 ,  G06F11/2094 ,  G06F11/2097 ,  G06F16/2365 ,  G06F16/2455 ,  G06F2201/80 ,  G06F2201/855

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.

公开(公告)号：US20170109044A1

公开(公告)日：2017-04-20

申请号：US14885752

申请日：2015-10-16

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Colin Florendo ,  Ivan Schreter ,  Thorsten Glebe ,  David Wein

IPC: G06F3/06 ,  G06F17/30

CPC classification number: G06F16/22 ,  G06F12/00

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.