• Patent Title: Self-adaptive parallel database page flusher
  • Application No.: US15585557
    Application Date: 2017-05-03
  • Publication No.: US10360111B2
    Publication 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
Self-adaptive parallel database page flusher
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
Information query
Patent Agency Ranking
0/0