Reserving key specifications

Patent metadata

Field	Value
Publication number	US-10657114-B2
Application number	US-201715824041-A
Country	US
Kind code	B2
Filing date	Nov 28, 2017
Priority date	Nov 28, 2017
Publication date	May 19, 2020
Grant date	May 19, 2020

Abstract

An import configuration section of a file is identified, where the import configuration identifies a database table. Key specifications of the database table are reserved based on the import configuration. A first and a second Boolean flag parameter associated with the database table is identified. A determination is made that i) a value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) a value of the second Boolean flag indicates removal of entries of the database table is allowed. In response to the determining entries are removed from the database table corresponding to the key specifications, and entries are imported from the file into the database table corresponding to the key specifications.

First claim

What is claimed is:

1. A computer-implemented method comprising:
identifying an import configuration section of a file, the import configuration identifying a database table;
reserving key specifications of the database table based on the import configuration;
identifying a first and a second Boolean flag parameter from the import configuration associated with the database table;
determining that i) a value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) a value of the second Boolean flag indicates removal of entries of the database table is allowed; and
in response to determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of entries of the database table is allowed:
i) removing entries from the database table corresponding to the key specifications, and
ii) importing entries from the file into the database table corresponding to the key specifications.

2. The method of claim 1 , further comprising:
determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed;
in response to determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed, determining that the database table excludes entries corresponding to the key specifications; and
in response to determining that the database table excludes entries corresponding to the key specifications, importing entries from the file into the database table corresponding to the key specifications.

3. The method of claim 2 , wherein importing entries from the file into the database table corresponding to the key specifications is independent of removing entries from the database table corresponding to the key specifications.

4. The method of claim 2 , in response to determining that the database table excludes entries corresponding to the key specifications, maintaining the existing entries of the database table.

5. The method of claim 1 , further comprising:
determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed;
in response to determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed, determining that the database table includes entries corresponding to the key specifications; and
in response to determining that the database table includes entries corresponding to the key specifications, generating an error signal.

6. The method of claim 1 , further comprising:
determining that the value of the first Boolean flag indicates importing of entries from the file into the database table is disallowed; and
in response to determining that the value of the first Boolean flag indicates importing of entries from the file into the database table is disallowed, preventing import of entries from the file into the database table.

7. The method of claim 6 , further comprising in response to determining that the value of the first Boolean flag indicates importing of entries from the file into the database table is disallowed, maintaining the existing entries of the database table.

8. The method of claim 6 , in response to determining that the value of the first Boolean flag indicates importing of entries from the file into the database table is disallowed, identifying a manual import of entries into the database table.

9. The method of claim 1 , further comprising generating a comma-separated values file from the database table after i) removing entries from the database table corresponding to the key specifications and ii) importing entries from the file into the database table corresponding to the key specifications.

10. A non-transitory, computer-readable medium storing one or more instructions executable by a computer system to perform operations comprising:
identifying an import configuration section of a file, the import configuration identifying a database table;
reserving key specifications of the database table based on the import configuration;
identifying a first and a second Boolean flag parameter from the import configuration associated with the database table;
determining that i) a value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) a value of the second Boolean flag indicates removal of entries of the database table is allowed; and
in response to determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of entries of the database table is allowed:
i) removing entries from the database table corresponding to the key specifications, and
ii) importing entries from the file into the database table corresponding to the key specifications.

11. The computer-readable medium of claim 10 , the operations further comprising:
determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed;
in response to determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed, determining that the database table excludes entries corresponding to the key specifications; and
in response to determining that the database table excludes entries corresponding to the key specifications, importing entries from the file into the database table corresponding to the key specifications.

12. The computer-readable medium of claim 11 , wherein importing entries from the file into the database table corresponding to the key specifications is independent of removing entries from the database table corresponding to the key specifications.

13. The computer-readable medium of claim 10 , the operations further comprising:
determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed;
in response to determining that i) the value of the first Boolean flag indicates importing of entries from the file into the database table is allowed, and that ii) the value of the second Boolean flag indicates removal of the entries of the database table is disallowed, determining that the database table includes entries corresponding to the key specifications; and
in response to determining that the database table includes entries corresponding to the key specifications, generating an error signal.

14. The computer-readable medium of claim 10 , the oper

Assignees

• Sap Se

Inventors

• Bregler Jonathan
• Bunte Alexander
• Harren Arne
• Kellner Andreas
• Kuntze Daniel
• Lueders Simon
• Sauermann Volker
• Schnaubelt Michael
• Tran Le-Huan Stefan

Classifications

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/2272 Primary

  Management thereof · CPC title

• G06F16/254 Primary

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title