Premise of the SQL Script Generation Use Case

The SQL Script Generation use case described in this section is based on the following premises:

• The Data Analysts define the workflow for model building and scoring.

• The Data Analysts use the new script generation feature to hand over a set of SQL scripts to the Application Developer for deployment.

• The Application Developers deploy the scripts to the target or production database, where they can schedule the scripts to run periodically. This allows the model to be built with fresh customer data every time the scripts are run.

• Demo Database: The use case uses a demo database table INSUR_CUST_LTV_SAMPLE, which can be installed to a users account.

• Predefined workflow: The use case explains the procedure with the help of the predefined workflow codegen_workflow.

See Also:

• About the Sample Workflow

• Performing Prerequisite Tasks

• Location of Demo Workflow Files

• Loading the Sample Data Using a Script

• Location of Demo Workflow Files
  The workflow file codegen_workflow.xml which contains the predefined workflow is available in the SQL Developer installation location at: sqldeveloper_home\dataminer\demos\workflows.