公开(公告)号：US20220350786A1

公开(公告)日：2022-11-03

申请号：US17867487

申请日：2022-07-18

Applicant: SAP SE

Inventor： NILESH GOHAD ,  Adrian DRAGUSANU ,  Neeraj KULKARNI ,  Dheren GALA

IPC: G06F16/22 ,  G06F9/54 ,  G06F16/2455 ,  G06F12/0882

Abstract: Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.

公开(公告)号：US20210311923A1

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

申请号：US16878894

申请日：2020-05-20

Applicant: SAP SE

Inventor： Nilesh Gohad ,  Adrian DRAGUSANU ,  Neeraj KULKARNI ,  Dheren GALA

IPC: G06F16/22 ,  G06F16/2455 ,  G06F12/0882 ,  G06F9/54

Abstract: Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.

公开(公告)号：US20220027354A1

公开(公告)日：2022-01-27

申请号：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/23 ,  G06F12/02 ,  G06F3/06 ,  G06F16/22 ,  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.

公开(公告)号：US20210326263A1

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

申请号：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/0862 ,  G06F12/0882 ,  G06F16/22 ,  G06F16/24

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.