You can create a Mining flow
for SQL processing and key data mining operations
by placing operators in a canvas, defining their properties, and connecting
their ports.
Before
you can use the Design Studio to model your data flows,
you must create a data warehousing project.
The data warehousing project contains
artifacts such as your data flows and control flows.
Working mode for mining flows
You can
work in online mode or in offline mode to create
mining flows. In online mode, you are working against a database.
In offline mode, you are working against an existing data model.
Creating data warehousing projects Before you can use the Design Studio to model
your data or mining flows, you must create a data warehousing project.
The data warehousing project contains
artifacts such as your data, control, and mining flows.
Creating a mining flow
You can create a mining flow by using a solution plan,
or by directly using the flow editor.
Testing and modifying your mining flow
When
your mining flow design is complete, you can validate
the mining flow, generate the SQL code, and run the mining flow from
the Design Studio. You can follow the progress of the mining flow
as it runs, modify some mining settings, and then rerun the flow.
Adding variables to your mining flow
You
can add variables to your mining flows and run the
mining flow multiple times with different values for the variables.
When a mining flow with variables is deployed as part of a SQL warehousing
application on the application server, the current values to be substituted
for the variables can be specified when starting the process instance.
Running a mining flow
You can run the
complete mining flow or individual SQL
statements in a step-by-step process.