Invention Grant
- Patent Title: Self-adaptive parallel database page flusher
-
Application No.: US15585557Application Date: 2017-05-03
-
Publication No.: US10360111B2Publication Date: 2019-07-23
- Inventor: Dirk Thomsen
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Jones Day
- Main IPC: G06F11/14
- 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.
Public/Granted literature
- US20180322050A1 Self-Adaptive Parallel Database Page Flusher Public/Granted day:2018-11-08
Information query