US 2020/0004849 A1 · AUTOMATED DATABASE CREATION

Abstract

Techniques are disclosed relating to create a configuration for a database system. In some embodiments, program instructions of a change set for an application are received from a source code management (SCM) repository. In response to the receiving, a build process is performed that includes causing compilation of the received program instructions to produce program instructions executable to run the application. The build process also includes provisioning the configuration with a schema by retrieving a first set of metadata defining the schema and issuing corresponding data definition language (DDL) instructions to create the schema in the configuration. The build process includes provisioning the configuration with data by retrieving a second set of metadata defining the data and issuing corresponding data manipulation language (DML) instructions to insert the data into the configuration and storing the provisioned configuration in a repository as one of multiple configurations associated with multiple received change sets.

Claims20

Dependent claims

A method of creating a first configuration of a database system, wherein configurations of the database system differ based on source code management (SCM) change sets, a first type of metadata associated with a database schema, and a second type of metadata capable of causing a computer system to insert data into a configuration, the method comprising:

for each of the SCM change sets received by a first computer system during an interval, provisioning, through use of the first computer system, a configuration of the database system by using the first type of metadata to issue data definition language instructions to create the configuration of the database system including the database schema defined by the first type of metadata;
storing a plurality of the configurations so provisioned in a repository accessible to additional computer systems;
downloading at least one of the configurations to one of the additional computer systems;
and
for the downloaded configuration, provisioning, at the additional computer system, the downloaded configuration of the database system with the data by using the second type of metadata to issue data manipulation language instructions to insert the data into the downloaded configuration to create the first configuration.

2 more elements

A method of creating a configuration for a database system based on a submitted change set to a source code management (SCM) repository, the method comprising:

submitting, by a first computing system to the SCM repository, a change set including program instructions for an application executable to access the database system, wherein the submitting causes a second computing system to initiate a build process for the application that includes the second computing system provisioning the configuration with a schema by using a first set of metadata defining the schema to issue corresponding data definition language (DDL) instructions to create the schema in the configuration, wherein the build process includes storing the provisioned configuration in a repository as one a plurality of provisioned configurations associated with submitted change sets including program instructions for the application;
downloading, by the first computing system, one of the plurality of provisioned configurations;
and
provisioning, by the first computing system, the downloaded configuration with data by retrieving a second set of metadata defining the data and issuing corresponding data manipulation language (DML) instructions to insert the data into the downloaded configuration of the database system.

1 more element

Dependencies are inferred from the claim text.

Automated database creation

Life of this patent

Automated database creation

Life of this patent

Abstract

Claims20