# US 2023/0066096 A1 · Data transfer in a computer-implemented database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0066096 A1
- Document ID: US20230066096A1
- Status: Published application
- Kind: A1
- Application number: 18/054,515
- Filed: 2022-11-10
- Published: 2023-03-02
- Earliest claimed: 2019-04-04
- Assignees: Sap SE
- Applicants: Sap SE
- Inventors: Edward-Robert Tyercha; Janardhan Hungund; Deepak Shrivastava
- Web page: https://patentgrep.com/patent/US20230066096A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/214: {Database migration support}
- G06F 16/221: {Column-oriented storage; Management thereof}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim at position 1

1-20. (canceled)

### Claim 21

A computer-implemented 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 a first column and a second column, wherein metadata associated with the data table designates that first data associated with the first column should not be transferred in response to the command for the data transfer and the metadata further designates that the second data associated with the second column should be transferred in response to the command;
in response to receiving the command for the data transfer, determining, based on the metadata, whether at least one of the columns of the database table including the first column and the second column have been designated for the data transfer; and
in response to the determining, executing the command to transfer the data in the database according to the designated columns, such that the second data associated with the second column is transferred in response to the command.

### Claim 22 (depends on 21)

The computer-implemented method of claim 21, wherein the data table includes a plurality of columns including the first column and the second column, and wherein the data table is associated with the metadata.

### Claim 23 (depends on 22)

The computer-implemented method of claim 22, wherein transfer of the second data associated with the second column is transferred by copying to a destination storage device.

### Claim 24 (depends on 23)

The computer-implemented method of claim 23, wherein the transfer of the second data includes a data structure of the plurality of columns including the first column and the second column, wherein the data structure is maintained as part of the transfer without providing the first data.

### Claim 25 (depends on 21)

The computer-implemented method of claim 21, wherein the client machine comprises a computing system used by a user issuing the command for the data transfer.

### Claim 26 (depends on 21)

The computer-implemented method of claim 21, wherein the command is an import command that further includes an indication providing metadata that designates that the first data of the first column should not be imported in response to the command.

### Claim 27 (depends on 21)

The computer-implemented method of claim 21, wherein the command is an export command that further includes an indication providing metadata that designates that the first data of the first column should not be exported in response to the command.

### Claim 28

A system comprising:
at least one programmable processor; and
a non-transitory machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations 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 a first column and a second column, wherein metadata associated with the data table designates that first data associated with the first column should not be transferred in response to the command for the data transfer and the metadata further designates that the second data associated with the second column should be transferred in response to the command;
in response to receiving the command for the data transfer, determining, based on the metadata, whether at least one of the columns of the database table including the first column and the second column have been designated for the data transfer; and
in response to the determining, executing the command to transfer the data in the database according to the designated columns, such that the second data associated with the second column is transferred in response to the command.

### Claim 29 (depends on 28)

The system of claim 28, wherein the data table includes a plurality of columns including the first column and the second column, and wherein the data table is associated with the metadata.

### Claim 30 (depends on 29)

The system of claim 29, wherein transfer of the second data associated with the second column is transferred by copying to a destination storage device.

### Claim 31 (depends on 30)

The system of claim 30, wherein the transfer of the second data includes a data structure of the plurality of columns including the first column and the second column, wherein the data structure is maintained as part of the transfer without providing the first data.

### Claim 32 (depends on 28)

The system of claim 28, wherein the client machine comprises a computing system used by a user issuing the command for the data transfer.

### Claim 33 (depends on 28)

The system of claim 28, wherein the command is an import command that further includes an indication providing metadata that designates that the first data of the first column should not be imported in response to the command.

### Claim 34 (depends on 28)

The system of claim 28, wherein the command is an export command that further includes an indication providing metadata that designates that the first data of the first column should not be exported in response to the command.

### Claim 35

A non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations 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 a first column and a second column, wherein metadata associated with the data table designates that first data associated with the first column should not be transferred in response to the command for the data transfer and the metadata further designates that the second data associated with the second column should be transferred in response to the command;
in response to receiving the command for the data transfer, determining, based on the metadata, whether at least one of the columns of the database table including the first column and the second column have been designated for the data transfer; and
in response to the determining, executing the command to transfer the data in the database according to the designated columns, such that the second data associated with the second column is transferred in response to the command.
