Designing data warehousing applications

You design data warehousing applications with the SQL Warehousing Tool (SQW) in the Design Studio. Data warehousing applications consist of extract, load, and transform (ELT) operations that are run inside a Db2® database.

The Design Studio is an Eclipse-based tool that provides a graphical user interface for designing data warehousing applications. The key design tasks are:

Modeling data flows: You can design a data flow to model SQL-based data movement and transformation by placing operators in a canvas, defining their properties, and connecting their ports.
Modeling data mining flows: You can create a mining flow for key data mining operations by placing operators in a canvas, defining their properties, and connecting their ports.
Embedding data flows and data mining flows inside control flows: You can sequence data flows and mining flows, integrate external commands, programs, and stored procedures, and provide conditional processing logic for a data warehousing application inside a control flow.
Preparing deployment packages: You can create an application profile (.apxmi), generate code for the profile, and create the package (a .zip file) to make the processes of the application available for scheduling, execution, and administration. Deployment packages can consist of one or more control flows.

After you design your data warehousing applications in the Design Studio, you or someone else can use the Administration Console to deploy, administer, and monitor data warehousing applications on another system.