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

公开(公告)号：US11151126B2

公开(公告)日：2021-10-19

申请号：US16866766

申请日：2020-05-05

Applicant: SAP SE

Inventor： Colin Florendo ,  Mihnea Andrei ,  Amit Pathak ,  Robert Schulze ,  Adrian Dragusanu ,  Reza Sherkat ,  Sebastian Seifert ,  Christian Lemke

IPC: G06F16/22 ,  G06F16/23 ,  G06F12/02 ,  G06F3/06 ,  G06F12/0882 ,  G06F16/2455 ,  G06F12/0875 ,  G06F9/48

Abstract: Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.

公开(公告)号：US10698921B2

公开(公告)日：2020-06-30

申请号：US15445505

申请日：2017-02-28

Applicant: SAP SE

Inventor： Colin Florendo ,  Michael Muehle ,  Thorsten Glebe ,  Rolando Blanco ,  Chaitanya Gottipati ,  Nirvik Basak ,  Günter Radestock

IPC: G06F16/27 ,  G06F16/23

Abstract: A computer implemented method for initializing a secondary database system includes receiving table state information from a primary database system at a secondary database system. The table state information includes information identifying which tables had an open operation during a savepoint event. Metadata associated with the tables is parsed to identify table state information from the metadata and a lock is created for each table identified as having an open operation during the savepoint event. Afterwards, log transaction information is sequentially parsed. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20200050699A1

公开(公告)日：2020-02-13

申请号：US16059665

申请日：2018-08-09

Applicant: SAP SE

Inventor： Calvin Hua ,  Reza Sherkat ,  Colin Florendo ,  Mihnea Andrei

IPC: G06F17/30 ,  H03M7/40

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a memory optimization system for inverted indexes. An embodiment operates by determining a value identifier corresponding to a value to be searched for in a database based on a query. From a lookup table, a prefix of an offset corresponding to a location in a compressed posting list that identifies row locations where the value is found in the database is retrieved. From a directory page, a suffix of the offset corresponding to the location is retrieved. The offset is generated based on the prefix and the suffix. From the posting list, row identifiers corresponding to the generated offset are retrieved. The retrieved row identifiers are returned responsive to the query.

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

公开(公告)号：US20170109044A1

公开(公告)日：2017-04-20

申请号：US14885752

申请日：2015-10-16

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Colin Florendo ,  Ivan Schreter ,  Thorsten Glebe ,  David Wein

IPC: G06F3/06 ,  G06F17/30

CPC classification number: G06F16/22 ,  G06F12/00

Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.

公开(公告)号：US20160154815A1

公开(公告)日：2016-06-02

申请号：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.

Abstract translation: 数据集的数据记录可以存储在保留在磁盘存储中的多个主要部分片段中。 每个片段可以包括等于或小于所定义的最大片段大小的多个数据记录。 使用针对每个片段优化的压缩，可以压缩每个片段。 在从磁盘存储器读入主系统存储器中的至少一个片段之后，可以在主系统存储器中对片段或片段执行操作。

公开(公告)号：US12292884B2

公开(公告)日：2025-05-06

申请号：US18674387

申请日：2024-05-24

Applicant: SAP SE

Inventor： Colin Florendo ,  Surendra Vishnoi ,  Janardhan Hungund ,  Manuel Caroli

IPC: G06F3/06 ,  G06F9/48 ,  G06F12/02 ,  G06F12/0875 ,  G06F12/0882 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

Abstract: Disclosed herein are system, method, and computer program product embodiments for maintaining of a geometric object in a database. An embodiment operates by a database maintaining a first page storing a data block in the database's on-disk store such that the data block stores at least one byte of the geometric object. After receiving the request for the geometric object, the database loads the page storing the geometric object in the in-memory store and determines the size of the geometric object. Based on the size of the geometric object, the database stores the geometric object in the in-memory store directly or in a heap of the in-memory store.

公开(公告)号：US11775488B2

公开(公告)日：2023-10-03

申请号：US17699747

申请日：2022-03-21

Applicant: SAP SE

Inventor： Panfeng Zhou ,  Vivek Kandiyanallur ,  Colin Florendo ,  Robert Schulze ,  Zheng-Wei She ,  Yanhong Wang ,  Amarnadh Sai Eluri

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/22 ,  G06N5/04

CPC classification number: G06F16/213 ,  G06F16/221 ,  G06F16/2255 ,  G06N5/04

Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.

公开(公告)号：US11755565B2

公开(公告)日：2023-09-12

申请号：US17496108

申请日：2021-10-07

Applicant: SAP SE

Inventor： Colin Florendo ,  Mihnea Andrei ,  Amit Pathak ,  Robert Schulze ,  Adrian Dragusanu ,  Reza Sherkat ,  Sebastian Seifert ,  Christian Lemke

IPC: G06F16/24 ,  G06F16/23 ,  G06F12/02 ,  G06F3/06 ,  G06F16/22 ,  G06F12/0882 ,  G06F16/2455 ,  G06F12/0875 ,  G06F9/48

CPC classification number: G06F16/2379 ,  G06F3/0604 ,  G06F3/064 ,  G06F3/0673 ,  G06F9/4843 ,  G06F12/0223 ,  G06F12/0246 ,  G06F12/0875 ,  G06F12/0882 ,  G06F16/221 ,  G06F16/2219 ,  G06F16/2228 ,  G06F16/2237 ,  G06F16/2255 ,  G06F16/2272 ,  G06F16/2282 ,  G06F16/24552 ,  G06F16/24558 ,  G06F2212/1024 ,  G06F2212/1044

Abstract: Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.