公开(公告)号：US11423000B2

公开(公告)日：2022-08-23

申请号：US16878894

申请日：2020-05-20

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.

公开(公告)号：US11775496B2

公开(公告)日：2023-10-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

CPC classification number: G06F16/2282 ,  G06F9/54 ,  G06F12/0882 ,  G06F16/221 ,  G06F16/2237 ,  G06F16/24552

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.

公开(公告)号：US11256680B2

公开(公告)日：2022-02-22

申请号：US16411700

申请日：2019-05-14

Applicant: SAP SE

Inventor： Nilesh Gohad ,  Amit Pathak ,  Dheren Gala

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/22 ,  G06F12/02 ,  G06F16/2455

Abstract: Systems and methods may include execution of a database workload on a plurality of database tables, collection of execution statistics associated with execution of the database workload, determination of an in-memory row storage cache size for multi-version concurrency control based on the collected execution statistics, and configuration of a database system to allocate the in-memory row storage cache size for multi-version concurrency control.

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