PARAMETER-BASED DEPLOYMENT CONTROL FOR DEPLOYMENT OF DATABASE ARTIFACTS

• US 20190324884A1
• Filed: 07/01/2019
• Published: 10/24/2019
• Est. Priority Date: 05/09/2016
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: 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
• Granted Patent: US 11,307,960 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/302 where the computing system component is a software system
• CPC Class Codes: G06F 11/3466 Performance evaluation by tracing or monitoring
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 11/3495 for systems
• CPC Class Codes: G06F 11/3636 by tracing the execution of the program
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 2201/865 Monitoring of software

Abstract

Parameter-based deployment control for database objects is provided, in which processes for deploying database artifacts into a database as database objects are implemented. Many different techniques may be used in executing such deployment processes, including whether and how to combine various deployment-related jobs, identify/record/assess/correct potential errors, govern or instruct artifact conversion operations, or generally manage available resources with respect to executing the deployment(s) efficiently. By providing for selectable parameter values that are executed in an efficient, e.g., hierarchical, manner, deployment procedures may be implemented in a highly efficient and customizable manner.

Claims

1. A computer program product, the computer program product being tangibly embodied on a non-transitory computer-readable storage medium and comprising instructions that, when executed, are configured to cause at least one computing device to:

determine at least one database artifact, the at least one database artifact specifying at least one database object to be deployed within a database system using a plurality of deployment procedures;

receive at least one selectable parameter value for at least one deployment procedure parameter for at least one of the plurality of deployment procedures; and

execute the plurality of deployment procedures, using the at least one selectable parameter value for the at least one deployment procedure parameter of the at least one deployment procedure, to thereby deploy the at least one database object into the database system.

2. The computer program product of claim 1, wherein the at least one database artifact provides a declarative description of the at least one database object, and the plurality of deployment procedures are configured to convert the at least one database artifact into the at least one database object including at least one executable database object.

3. The computer program product of claim 1, wherein the plurality of deployment procedures govern conversion of the at least one database artifact into the at least one database object and any associated interaction with the database system.

4. The computer program product of claim 1, wherein the instructions, when executed by the at least one computing device, are further configured to:

receive the at least one selectable parameter value and replace a default parameter value for the at least one deployment procedure parameter therewith.

5. The computer program product of claim 1, wherein the instructions, when executed by the at least one computing device, are further configured to:

store the at least one selectable parameter value in a parameter table; and

retrieve, during the execution of a corresponding deployment procedure of the plurality of deployment procedures, the at least one selectable parameter value from the parameter table for use in the execution of the corresponding deployment procedure.

6. The computer program product of claim 1, wherein the at least one selectable parameter value applies to a single database artifact of the at least one database artifact.

7. The computer program product of claim 1, wherein the at least one database artifact includes a plurality of database artifacts, each classified as a type of corresponding types of artifact conversion processes, and further wherein the at least one selectable parameter value applies to database artifacts of a selected type.

8. The computer program product of claim 1, wherein the at least one database artifact includes a plurality of database artifacts, and further wherein the at least one selectable parameter value applies to all of the plurality of database artifacts.

9. The computer program product of claim 1, wherein the at least one database artifact includes a plurality of database artifacts, each classified as a type of corresponding types of artifact conversion processes, and further wherein the instructions, when executed by the at least one computing device, are further configured to execute the plurality of deployment procedures including:

checking applicability of the at least one selectable parameter value, in order, with respect to a corresponding parameter of a single database artifact, a corresponding parameter of all database artifacts associated with a type of artifact conversion process, or a corresponding parameter of all of the plurality of database artifacts;

applying the selectable parameter value and ceasing further applicability checking when applicability is found; and

applying a default parameter value when no applicability is found.

10. The computer program product of claim 1, wherein the plurality of deployment procedures includes at least one call to a called program, and the at least one selectable parameter value is included within the at least one call and defines a storage location for a trace message to be written by the called program logging a result of an execution of the at least one call by the called program.

11. A method of executing instructions stored on a non-transitory computer-readable storage medium using at least one processor, the method comprising:

initiating at least one deployment procedure for deploying at least one database object into a database system, the at least one deployment procedure associated with at least one default parameter value for at least one parameter thereof;

determining at least one selectable parameter value for the at least one parameter;

creating a parameter table populated with the at least one selectable parameter value; and

executing the at least one deployment procedure using the at least one selectable parameter value retrieved from the parameter table, in place of the at least one default parameter value.

12. The method of claim 11, wherein the at least one deployment procedure includes at least one artifact conversion process for converting at least one database artifact providing a declarative description of the at least one database object into the at least one database object as part of the deploying of the at least one database object.

13. The method of claim 11, wherein the at least one database artifact includes a plurality of database artifacts, each classified as a type of corresponding types of artifact conversion processes, and further wherein the at least one selectable parameter value applies to one of:

a single database artifact of the at least one database artifact, database artifacts of a selected type, or all of the plurality of database artifacts.

14. The method of claim 11, wherein the executing the at least one deployment procedure comprises:

checking applicability of the at least one selectable parameter value, in order, with respect to a corresponding parameter of a single database artifact, a corresponding parameter of all database artifacts associated with a type of artifact conversion process, or a corresponding parameter of all of the plurality of database artifacts.

15. A system comprising:

a parameter handler configured to receive at least one selectable parameter value for at least one deployment procedure parameter for a plurality of deployment procedures;

a deployment engine configured to initiate execution of the plurality of deployment procedures, the plurality of deployment procedures including a plurality of types of artifact conversion processes for converting a corresponding plurality of types of database artifacts into database objects to be deployed within a database system, the deployment engine including

an optimization engine configured to receive and store the at least one selectable parameter value, and

a deployment procedure controller configured to select a deployment procedure parameter included within at least one deployment procedure of the plurality of deployment procedures, and fetch the stored at least one selectable parameter value for population therewith of the at least one deployment procedure parameter.

16. The system of claim 15 wherein the at least one selectable parameter value applies to one of:

a single database artifact of the database artifacts, database artifacts of a selected type of the plurality of types of database artifacts, or all of the database artifacts.

17. The system of claim 16 wherein the deployment procedure controller is further configured to check applicability of the at least one selectable parameter value, in order, with respect to a corresponding parameter of the single database artifact, a corresponding parameter of the database artifacts associated with the selected type of artifact conversion process, or a corresponding parameter of all of the database artifacts.

18. The system of claim 15, wherein the plurality of database artifacts provides declarative descriptions of the database objects, and the plurality of deployment procedures govern conversion of the database artifacts into the database objects and associated interaction with the database system.

19. The system of claim 15, wherein the deployment procedure controller is configured to receive the at least one selectable parameter value and replace a corresponding default deployment procedure parameter value therewith for the at least one deployment procedure parameter.

20. The system of claim 15, wherein the plurality of deployment procedures includes at least one call to a called program, and the at least one selectable parameter value is included within the at least one call and defines a storage location for a trace message to be written by the called program logging a result of an execution of the at least one call by the called program.