公开(公告)号：US12008012B2

公开(公告)日：2024-06-11

申请号：US18054515

申请日：2022-11-10

Applicant: SAP SE

Inventor： Edward-Robert Tyercha ,  Janardhan Hungund ,  Deepak Shrivastava

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/22

CPC classification number: G06F16/254 ,  G06F16/214 ,  G06F16/221 ,  G06F16/2282

Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.

公开(公告)号：US11526527B2

公开(公告)日：2022-12-13

申请号：US16375101

申请日：2019-04-04

Applicant: SAP SE

Inventor： Edward-Robert Tyercha ,  Janardhan Hungund ,  Deepak Shrivastava

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/22

Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.

公开(公告)号：US20230066096A1

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

申请号：US18054515

申请日：2022-11-10

Applicant: SAP SE

Inventor： Edward-Robert Tyercha ,  Janardhan Hungund ,  Deepak Shrivastava

IPC: G06F16/25 ,  G06F16/21 ,  G06F16/22

Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.

公开(公告)号：US11372845B2

公开(公告)日：2022-06-28

申请号：US16893703

申请日：2020-06-05

Applicant: SAP SE

Inventor： Deepak Shrivastava ,  Chaitanya Gottipati ,  Colin Florendo ,  Rolando Blanco ,  Michael Muehle ,  Awisha Makwana

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

Abstract: Disclosed herein are system, method, and computer program product embodiments for converting column loadable data in a database into a page loadable format. When a column oriented in-memory database needs to perform an operation on a table, the affected columns must be loaded fully into memory. In some cases, a database may partition tables, allowing for column fragments corresponding to those partitions to be loaded into memory. These column fragments may exceed available memory, such that it is beneficial to convert the column fragment into a page loadable format. Approaches are discussed herein for performing the conversion without the need to update global metadata during the process, allowing for multiple parallel column fragments to be updated, allowing data manipulation language (DML) operations to continue on the column during the conversion process, and reducing the impact of blocked parallel savepoint operations during the conversion process by chunking the conversion process.

公开(公告)号：US20200320087A1

公开(公告)日：2020-10-08

申请号：US16375101

申请日：2019-04-04

Applicant: SAP SE

Inventor： Edward-Robert Tyercha ,  Janardhan Hungund ,  Deepak Shrivastava

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/21

Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.