Exporting and importing database containers

Patent metadata

Field	Value
Publication number	US-11275758-B2
Application number	US-201916406757-A
Country	US
Kind code	B2
Filing date	May 8, 2019
Priority date	May 9, 2016
Publication date	Mar 15, 2022
Grant date	Mar 15, 2022

Abstract

A computer-implemented method for exporting a database container from a database includes exporting database container metadata including artifact definitions in the metadata along with the actual metadata content to a database management system, exporting the database container including the database objects deployed therein to the database management system. The exporting of the database container includes exporting dependencies and structures of the database objects deployed therein, but not the actual content of the database objects. In some instances, however, exporting of the database container can include exporting the actual content of the database objects in response to user request. The method further includes packing the exported database container metadata and the exported database container in an archive. The data in the archive can be unpacked in substantially reverse order to import the database container into another database.

First claim

What is claimed is:

1. A computer-implemented method for exporting a database container from a database, the method comprising:
exporting, by the database and to a database management system (DBMS) managing at least two databases including the database, database container metadata of the database container, the database container metadata including artifact definitions identifying one or more tables or views in the database container metadata along with object metadata content;
exporting, by the database and to the DBMS, the database container, the database container including one or more database objects deployed in the database container, and a database container schema providing an isolated computing environment for the one or more database objects deployed in the database container, wherein exporting the database container includes exporting dependencies and structures of the one or more database objects deployed in the database container, without exporting data content of the one or more database objects; and
packing, by the DBMS, the exported database container metadata and the exported database container in an archive.

2. The computer-implemented method of claim 1 , wherein exporting the database container includes:
exporting dependencies and structures of the deployed one or more database objects; and
in response to a user request, exporting data content of the deployed one or more database objects.

3. The computer-implemented method of claim 1 , wherein exporting the database container includes exporting a synonym object deployed in the database container as a link to an object external to the database container in the database.

4. The computer-implemented method of claim 1 further comprising:
exporting common metadata in the database; and
packing the exported common metadata in the archive along with the exported database container metadata and the exported database container.

5. The computer-implemented method of claim 4 , wherein exporting common metadata in the database includes:
using predefined SQL statements of the DBMS; and
extracting only container-related data subsets.

6. The computer-implemented method of claim 5 , wherein extracting only container-related data subsets includes:
creating tables with the same structures as the objects identified by the common metadata; and
transferring only container-related data rows.

7. The computer-implemented method of claim 1 further comprising unpacking data saved in the archive in substantially reverse order to import the database container into another database.

8. A non-transitory computer readable storage medium having instructions stored thereon, including instructions which, when executed by a microprocessor, cause a computer system to:
export, by a database and to a database management system (DBMS) managing at least two databases including the database, database container metadata of the database container, the database container metadata including artifact definitions identifying one or more tables or views in the database container metadata along with object metadata content;
export, by the database and to the DBMS, the database container, the database container including one or more database objects deployed in the database container, and a database container schema providing an isolated computing environment for the one or more database objects deployed in the database container, wherein exporting the database container includes exporting dependencies and structures of the one or more database objects deployed in the database container, without exporting data content of the one or more database objects; and
pack, by the DBMS, the exported database container metadata and the exported database container in an archive.

9. The non-transitory computer readable storage medium of claim 8 , wherein exporting the database container includes:
exporting dependencies and structures of the deployed one or more database objects; and
in response to a user request, exporting data content of the deployed one or more database objects.

10. The non-transitory computer readable storage medium of claim 8 , wherein exporting the database container includes exporting a synonym object deployed in the database container as a link to an object external to the database container in the database.

11. The non-transitory computer readable storage medium of claim 8 , the instructions further causing the computer system to:
export common metadata in the database; and
pack the exported common metadata in the archive along with the exported database container metadata and the exported database container.

12. The non-transitory computer readable storage medium of claim 11 , wherein exporting common metadata in the database includes:
using predefined SQL statements of the DBMS; and
extracting only container-related data subsets.

13. The non-transitory computer readable storage medium of claim 12 , wherein extracting only container-related data subsets includes:
creating tables with the same structures as the objects identified by the common metadata; and
transferring only container-related data rows.

14. The non-transitory computer readable storage medium of claim 8 , the instructions further causing the computer system to:
unpacking data saved in the archive in substantially reverse order to import the database container into another database.

15. A computer-implemented system, comprising:
one or more computers; and
one or more computer memory devices interoperably coupled with the one or more computers and having tangible, non-transitory, machine-readable media storing one or more instructions that, when executed by the one or more computers, perform one or more operations comprising:
exporting, by a database and to a database management system (DBMS) managing at least two databases including the database, database container metadata of the database container, the database container metadata including artifact definitions identifying one or more tables or views in the database container metadata along with object metadata content;
exporting, by the database and to the DBMS, the database container, the database container including one or more database objects deployed in the database container, and a database container schema providing an isolated computing environment for the one or more database objects deployed in the database container, wherein exporting the database container includes exporting dependencies and structures of the one or more database objects deployed in the database container, without exporting data content of the one or more database objects; and
packing, by the DBMS, the exported database container metadata and the exported database container in an archive.

16. The computer-implemented system of claim 15 , wherein exporting the database container includes:
exporting dependencies and structures of the deployed one or more database objects; and
in response to a user request, exporting data content of the deployed one or more database objects.

17. The computer-implemented system of claim 15 , wherein exporting the database container includes exporting a synonym object deployed in the database container as a link to an object external to the database container in the database.

Assignees

• Sap Se

Inventors

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

Classifications

• G06F16/214 Primary

  Database migration support · CPC title

• G06F21/6218

  to a system of files or objects, e.g. local or distributed file system or database · CPC title

• G06F16/24554

  Unary operations; Data partitioning operations · CPC title

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title