# US 11,307,960 B2 · Parameter-based deployment control for deployment of database artifacts > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,307,960 B2 - Document ID: US11307960B2 - Status: Granted - Kind: B2 - Application number: 16/458,535 - Filed: 2019-07-01 - Published: 2019-10-24 - Granted: 2022-04-19 - Earliest claimed: 2016-05-09 - Assignees: Sap SE - Applicants: Sap SE - Inventors: Le-Huan Stefan Tran; Jonathan Bregler; Alexander Bunte; Arne Harren; Andreas Kellner; Daniel Kuntze; Vladislav Leonkev; Simon Lueders; Volker Sauermann; Michael Schnaubelt - Web page: https://patentgrep.com/patent/US11307960B2 ## CPC - G06F 11/3495: {for systems} - G06F 11/302: {where the computing system component is a software system} - G06F 11/3466: {Performance evaluation by tracing or monitoring} - G06F 11/3476: {Data logging (G06F11/14, G06F11/2205 take precedence)} - G06F 11/3636: {by tracing the execution of the program} - G06F 16/211: {Schema design and management} - G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)} - G06F 16/258: {Data format conversion from or to a database} - G06F 16/289: {Object oriented databases} - G06F 2201/865: Monitoring of software - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## 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 ### Claim 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 perform operations comprising: determining at least one database artifact of a plurality of artifacts, the at least one database artifact specifying at least one database object to be deployed within a database system using at least one deployment procedure of a plurality of deployment procedures that are executable in an order defined by a dependency graph; receiving at least one selectable parameter value for at least one deployment procedure parameter for the at least one deployment procedure of the plurality of deployment procedures; and executing the plurality of deployment procedures, in the order defined by the dependency graph, 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. ### Claim 2 (depends on 1) 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. ### Claim 3 (depends on 1) 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. ### Claim 4 (depends on 1) The computer program product of claim 1, wherein the operations further comprise: receiving the at least one selectable parameter value and replace a default parameter value for the at least one deployment procedure parameter therewith. ### Claim 5 (depends on 1) The computer program product of claim 1, wherein the operations further comprise: storing the at least one selectable parameter value in a parameter table; and retrieving, 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. ### Claim 6 (depends on 1) 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. ### Claim 7 (depends on 1) The computer program product of claim 1, wherein the at least one database artifact comprises 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. ### Claim 8 (depends on 1) The computer program product of claim 1, wherein the at least one database artifact comprises a plurality of database artifacts, and further wherein the at least one selectable parameter value applies to all of the plurality of database artifacts. ### Claim 9 (depends on 1) The computer program product of claim 1, wherein the at least one database artifact comprises a plurality of database artifacts, each classified as a type of corresponding types of artifact conversion processes, and the operations further comprise: 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. ### Claim 10 (depends on 1) The computer program product of claim 1, wherein the plurality of deployment procedures comprises 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. ### Claim 11 A computer-implemented method, the method comprising: determining, by one or more processors, at least one database artifact of a plurality of artifacts, the at least one database artifact specifying at least one database object to be deployed within a database system using at least one deployment procedure of a plurality of deployment procedures that are executable in an order defined by a dependency graph; receiving, by the one or more processors, at least one selectable parameter value for at least one deployment procedure parameter for the at least one deployment procedure of the plurality of deployment procedures; and executing, by the one or more processors, the plurality of deployment procedures, in the order defined by the dependency graph, 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. ### Claim 12 (depends on 11) The computer-implemented method of claim 11, 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 comprising at least one executable database object. ### Claim 13 (depends on 11) The computer-implemented method of claim 11, 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. ### Claim 14 (depends on 11) The computer-implemented method of claim 11, further comprising: storing the at least one selectable parameter value in a parameter table; and retrieving, 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. ### Claim 15 (depends on 11) The computer-implemented method of claim 11, wherein the at least one database artifact comprises 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. ### Claim 16 (depends on 11) The computer-implemented method of claim 11, wherein the at least one database artifact comprises a plurality of database artifacts, and further wherein the at least one selectable parameter value applies to all of the plurality of database artifacts. ### Claim 17 (depends on 11) The computer-implemented method of claim 11, wherein the plurality of deployment procedures comprises 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. ### Claim 18 A system comprising: at least one processor; 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: determining at least one database artifact of a plurality of artifacts, the at least one database artifact specifying at least one database object to be deployed within a database system using at least one deployment procedure of a plurality of deployment procedures that are executable in an order defined by a dependency graph; receiving at least one selectable parameter value for at least one deployment procedure parameter for the at least one deployment procedure of the plurality of deployment procedures; and executing the plurality of deployment procedures, in the order defined by the dependency graph, 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. ### Claim 19 (depends on 18) The system of claim 18, 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 comprising at least one executable database object and 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. ### Claim 20 (depends on 18) The system of claim 18, wherein the operations further comprise: storing the at least one selectable parameter value in a parameter table; and retrieving, 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.