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

公开(公告)号：US09690799B2

公开(公告)日：2017-06-27

申请号：US15015042

申请日：2016-02-03

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F3/0661 ,  G06F3/0608 ,  G06F3/0673 ,  G06F17/30153 ,  G06F17/30312 ,  G06F17/30315 ,  G06F17/30339 ,  G06F17/30345 ,  G06F17/30486

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.