-
公开(公告)号:US12153816B2
公开(公告)日:2024-11-26
申请号:US17944610
申请日:2022-09-14
Applicant: SAP SE
Inventor: Prateek Agarwal , Simhachala Sasikanth Gottapu , Sarika Iyer , Prasanta Ghosh , Colin Florendo
IPC: G06F3/06
Abstract: Disclosed herein are system, method, and computer program product embodiments for adaptive caching for hybrid columnar databases with heterogeneous page sizes. An embodiment operates by scanning one or more pools comprising one or more pages of the same size in a buffer cache. The embodiment determines an increment of a reuse rate for the pools in the buffer cache within a time interval. The embodiment determines a cumulative reuse rate that is the sum of the increments of the reuse rate over several time intervals. The embodiment determines a gliding average reuse rate of the cumulative reuse rate over several time intervals. The embodiment compares the average reuse rates of the plurality of the pools to a threshold to dynamically determine whether a pool should reuse memory from the existing pages of the same pool or rebalance memory from one or more victim pools.
-
公开(公告)号:US20230011790A1
公开(公告)日:2023-01-12
申请号:US17944610
申请日:2022-09-14
Applicant: SAP SE
Inventor: PRATEEK AGARWAL , Simhachala Sasikanth Gottapu , Sarika Iyer , Prasanta Ghosh , Colin Florendo
IPC: G06F3/06
Abstract: Disclosed herein are system, method, and computer program product embodiments for adaptive caching for hybrid columnar databases with heterogeneous page sizes. An embodiment operates by scanning one or more pools comprising one or more pages of the same size in a buffer cache. The embodiment determines an increment of a reuse rate for the pools in the buffer cache within a time interval. The embodiment determines a cumulative reuse rate that is the sum of the increments of the reuse rate over several time intervals. The embodiment determines a gliding average reuse rate of the cumulative reuse rate over several time intervals. The embodiment compares the average reuse rates of the plurality of the pools to a threshold to dynamically determine whether a pool should reuse memory from the existing pages of the same pool or rebalance memory from one or more victim pools.
-
公开(公告)号: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.
-
公开(公告)号:US11481134B1
公开(公告)日:2022-10-25
申请号:US17328656
申请日:2021-05-24
Applicant: SAP SE
Inventor: Prateek Agarwal , Simhachala Sasikanth Gottapu , Sarika Iyer , Prasanta Ghosh , Colin Florendo
IPC: G06F3/06
Abstract: Disclosed herein are system, method, and computer program product embodiments for adaptive caching for hybrid columnar databases with heterogeneous page sizes. An embodiment operates by receiving a request to load a new page of memory from a disk in a buffer cache. The embodiment scans one or more pools comprising one or more pages of the same size in a buffer cache. The embodiment determines an increment of a reuse rate for the pools in the buffer cache within a time interval. The embodiment determines a cumulative reuse rate that is the sum of the increments of the reuse rate over several time intervals. The embodiment determines a gliding average reuse rate of the cumulative reuse rate over several time intervals. The embodiment compares the average reuse rates of the plurality of the pools to a threshold to dynamically determine whether a pool should reuse memory from the existing pages of the same pool or rebalance memory from one or more victim pools.
-
公开(公告)号:US11170023B2
公开(公告)日:2021-11-09
申请号: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: G06F16/27 , G06F16/23 , G06F16/2455 , G06F11/20
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.
-
公开(公告)号:US11442862B2
公开(公告)日:2022-09-13
申请号:US16850310
申请日:2020-04-16
Applicant: SAP SE
Inventor: Robert Schulze , Adrian Dragusanu , Anup Ghatage , Colin Florendo , Mihnea Andrei , Randall Hammon , Sarika Iyer , Simhachala Sasikanth Gottapu , Yanhong Wang
IPC: G06F12/08 , G06F12/0862 , G06F12/0882 , G06F16/24 , G06F16/22
Abstract: Disclosed herein are system, method, and computer program product embodiments for performing fair prefetching. An embodiment operates by splitting a data vector into a first subrange and a second subrange. The embodiment performs a first chance prefetch operation on the first subrange based on a fixed number of pages, thereby loading a set of pages of the first subrange into a main memory. The embodiment performs the first chance prefetch operation on the second subrange based on the fixed number of pages, thereby loading a first set of pages of the second subrange into the main memory. The embodiment performs a second chance prefetch operation on the second subrange based on the performing the first chance prefetch operation on the second subrange, thereby loading a second set of pages of the second subrange into the main memory. The embodiment then executes the query.
-
公开(公告)号:US10769034B2
公开(公告)日:2020-09-08
申请号:US15452391
申请日:2017-03-07
Applicant: SAP SE
Inventor: Sarika Iyer , Vivek Kandiyanallur , Martin Heidel , Rolando Blanco , Stephan Kottler , Carsten Thiel , Peter Steinemann , Jörn Schmidt , Colin Florendo , Michael Muehle , Chaitanya Gottipati
IPC: G06F17/30 , G06F11/14 , G06F16/23 , G06F16/2453
Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.
-
公开(公告)号:US20180260287A1
公开(公告)日:2018-09-13
申请号:US15452391
申请日:2017-03-07
Applicant: SAP SE
Inventor: Sarika Iyer , Vivek Kandiyanallur , Martin Heidel , Rolando Blanco , Stephan Kottler , Carsten Thiel , Peter Steinemann , Jörn Schmidt , Colin Florendo , Michael Muehle , Chaitanya Gottipati
Abstract: Objects across multiple database manipulation language (DML) redo log records are cached, during continuous replay of redo log records on a secondary system, for the same table partition to enable reuse of such cached objects. Later, these cached objects can be reused as they are accessed during the sequential processing of DML redo records for a specific table partition.
-
-
-
-
-
-
-