External access to database container artifacts

Patent metadata

Field	Value
Publication number	US-10671630-B2
Application number	US-201615222035-A
Country	US
Kind code	B2
Filing date	Jul 28, 2016
Priority date	May 9, 2016
Publication date	Jun 2, 2020
Grant date	Jun 2, 2020

Abstract

A database includes a run-time database container, which provides an isolated computing environment for a database object deployed therein. The database further includes a public synonym object outside the run-time database container in the database. The public synonym object is associated with the database object deployed inside the run-time database container and provides external access to the database object deployed inside the run-time database container independent of the location of the run-time database container.

First claim

What is claimed is:

1. A computer-implemented method for providing external access to a database object inside a run-time database container of a database, the database container schema providing an isolated computing environment for one or more database objects deployed therein, the method comprising:
creating a public synonym object outside the run-time database container in the database, the public synonym object being associated with the database object that is inside the run-time database container, wherein creating the public synonym object comprises using a public synonym plugin to convert a design-time specification file into the public synonym object at design-time prior to run-time, wherein the design-time specification file is an artifact in a design-time container that is separate from the run-time database container, and wherein the public synonym is a singleton object with a single instantiation in the database; and
configuring the public synonym object as an external link to the database object that is inside the run-time database container independent of the name and location of the run-time database container.

2. The computer-implemented method of claim 1 , wherein namespace rules apply to database objects and database containers across the database, and wherein creating the public synonym object includes selecting a public synonym name under the same namespace rules applicable to database objects and database containers across the database.

3. The computer-implemented method of claim 1 , further comprising:
creating another public synonym object outside the run-time database container in the database; and
configuring the another public synonym object as an external link to another database object inside the run-time database container independent of the name and location of the run-time database container.

4. The computer-implemented method of claim 1 , further comprising assigning a container specific database role to a technical user entity, the container specific database role providing the technical user entity privileges to access the database object inside the container via the public synonym object.

5. The computer-implemented method of claim 4 , wherein assigning the container specific database role to the technical user entity includes assigning the container specific database role via a container application programming interface (API).

6. A non-transitory computer readable storage medium having instructions stored thereon, including instructions which, when executed by a microprocessor, cause a computer system to:
create a public synonym object outside a run-time database container in a database, the public synonym object being associated with a database object that is inside the run-time database container, wherein creating the public synonym object comprises using a public synonym plugin to convert a design-time specification file into the public synonym object at design-time prior to run-time, wherein the design-time specification file is an artifact in a design-time container that is separate from the run-time database container, and wherein the public synonym is a singleton object with a single instantiation in the database; and
configure the public synonym object as an external link to the database object that is inside the run-time database container independent of the name and location of the run-time database container.

7. The non-transitory computer readable storage medium of claim 6 , wherein namespace rules apply to database objects and database containers across the database, and wherein creating the public synonym object includes selecting a public synonym name under the same namespace rules applicable to database objects and database containers across the database.

8. The non-transitory computer readable storage medium of claim 6 , wherein the instructions, when executed by the microprocessor, further cause the computer system to:
create another public synonym object outside the run-time database container in the database, the another public synonym object being associated with another database object inside the run-time database container; and
configure the public synonym object as an external link to the another database object inside the run-time database container independent of the name and location of the run-time database container.

9. The non-transitory computer readable storage medium of claim 6 , wherein the instructions, when executed by the microprocessor, cause the computer system to:
assign a container specific database role to a technical user entity, the container specific database role providing the technical user entity privileges to access the database object inside the container via the public synonym object.

10. The non-transitory computer readable storage medium of claim 9 , wherein the instructions which, when executed by a microprocessor, cause the computer system to:
assign the container specific database role to the technical user entity via a container application programming interface (API).

11. A database system comprising:
at least one processor; and
a non-transitory computer readable storage medium having instructions stored thereon, including instructions which, when executed by the at least one processor, cause a computer system to:
instantiate a database, the database comprising:
a run-time database container providing an isolated computing environment for a database object deployed therein; and
a public synonym object outside the run-time database container in the database, the public synonym object being associated with the database object inside the run-time database container and providing external access to the database object inside the run-time database container independent of the location of the run-time database container, wherein the public synonym object is created using a public synonym plugin to convert a design-time specification file into the public synonym object at design-time prior to run-time, wherein the design-time specification file is an artifact in a design-time container that is separate from the run-time database container, and wherein the public synonym is a singleton object with a single instantiation in the database.

12. The database system of claim 11 , wherein namespace rules apply to database objects and database containers across the database, and wherein the public synonym object has a public synonym name conforming to the same namespace rules applicable to database objects and database containers across the database.

13. The database system of claim 11 , wherein the database further comprises:
another public synonym object outside the run-time database container in the database; and
the another public synonym object being associated with another database object inside the run-time database container and providing external access to the another database object inside the run-time database container independent of the location of the run-time database container.

14. The database system of claim 11 , wherein a container specific database role is assigned to a technical user entity, the container specific database role providing the technical user entity privileges to access the database object in the container via the public synonym object.

Assignees

• Sap Se

Inventors

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

Classifications

• G06F16/214 Primary

  Database migration support · CPC title

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F16/24554

  Unary operations; Data partitioning operations · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title

• G06F21/6218

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