公开(公告)号：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

IPC: G06F12/02 ,  G06F11/14

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

IPC: G06F12/00 ,  G06F16/17 ,  G06F3/06 ,  G06F12/12

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.

公开(公告)号：US10409695B2

公开(公告)日：2019-09-10

申请号：US15496743

申请日：2017-04-25

Applicant: SAP SE

Inventor： Dirk Thomsen

IPC: G06F11/14 ,  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. During such replay, updates to pages implicated by the recovery operations are blocked. In parallel to such blocking, modified pages are adaptively flushed to physical disk storage using a factor that is based on a number of pages written to the physical disk storage and a number of write I/O operations as part of the flushing of the modified pages. Subsequently, the database system is brought online after all of the recovery operations are replayed.

公开(公告)号：US10402389B2

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

申请号：US15496957

申请日：2017-04-25

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Christoph Roterring ,  Werner Thesing

IPC: G06F16/23 ,  G06F11/14 ,  G06F11/07 ,  G06F11/34 ,  G06F17/40 ,  G06F16/27 ,  G06F11/20 ,  G06F11/16

Abstract: Each of a plurality of database transactions are logged (i.e., recorded) in a log. Concurrent with the logging, one or more characteristics of the log are monitored. Thereafter, a savepoint is triggered when a pre-defined condition is met as indicated by the monitoring. The triggered savepoint can override or accelerate a savepoint that would have otherwise been triggered based on pre-specified parameters.

公开(公告)号：US10387398B2

公开(公告)日：2019-08-20

申请号：US15479094

申请日：2017-04-04

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Werner Thesing

IPC: G06F11/14 ,  G06F16/22 ,  G06F16/23 ,  G06F11/16

Abstract: Execution of a page flusher is initiated in an in-memory database system in which pages are loaded into memory and which has associated physical disk storage. Thereafter, the page flusher identifies pages that were last modified outside a pre-defined time window. The page flusher then flushes the identified modified pages to the physical disk storage.

公开(公告)号：US10360111B2

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

申请号：US15585557

申请日：2017-05-03

Applicant: SAP SE

Inventor： Dirk Thomsen

IPC: G06F11/14 ,  G06F12/0868

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.

公开(公告)号：US20180307718A1

公开(公告)日：2018-10-25

申请号：US15496957

申请日：2017-04-25

Applicant: SAP SE

Inventor： Dirk Thomsen ,  Christoph Rottering ,  Werner Thesing

IPC: G06F17/30 ,  G06F11/14 ,  G06F11/07 ,  G06F11/34 ,  G06F17/40

CPC classification number: G06F16/2358 ,  G06F11/0766 ,  G06F11/1471 ,  G06F11/1474 ,  G06F11/1662 ,  G06F11/2035 ,  G06F11/2097 ,  G06F11/3476 ,  G06F16/27 ,  G06F17/40 ,  G06F2201/80 ,  G06F2211/1038

Abstract: Each of a plurality of database transactions are logged (i.e., recorded) in a log. Concurrent with the logging, one or more characteristics of the log are monitored. Thereafter, a savepoint is triggered when a pre-defined condition is met as indicated by the monitoring. The triggered savepoint can override or accelerate a savepoint that would have otherwise been triggered based on pre-specified parameters.

公开(公告)号：US20170293453A1

公开(公告)日：2017-10-12

申请号：US15632110

申请日：2017-06-23

Applicant: SAP SE

Inventor： Ivan Schreter ,  Dirk Thomsen ,  Colin Florendo ,  Blaine French

IPC: G06F3/06 ,  G06F17/30

CPC classification number: G06F3/0661 ,  G06F3/0608 ,  G06F3/0673 ,  G06F16/1744 ,  G06F16/22 ,  G06F16/221 ,  G06F16/2282 ,  G06F16/23 ,  G06F16/24554

Abstract: Data records of a data set can be stored in multiple main part fragments retained in on-disk storage. Each fragment can include a number of data records that is equal to or less than a defined maximum fragment size. Using a compression that is optimized for each fragment, each fragment can be compressed. After reading at least one of the fragments into main system memory from the on-disk storage, an operation can be performed on the fragment or fragments while the in the main system memory.