This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
How to create a design
There are three ways to create a design using Database Designer:.
There are three ways to create a design using Database Designer:
The following table shows what Database Designer capabilities are available in each tool:
|
Database Designer Capability |
Management Console |
Running Database Designer Programmatically |
Administrative Tools |
|
Create design |
Yes |
Yes |
Yes |
|
Design name length (# of characters) |
16 |
32 |
16 |
|
Build design (create design and deployment scripts) |
Yes |
Yes |
Yes |
|
Create backup script |
|
|
Yes |
|
Set design type (comprehensive or incremental) |
Yes |
Yes |
Yes |
|
Set optimization objective |
Yes |
Yes |
Yes |
|
Add design tables |
Yes |
Yes |
Yes |
|
Add design queries file |
Yes |
Yes |
Yes |
|
Add single design query |
|
Yes |
|
|
Use query repository |
Yes |
Yes |
|
|
Set K-safety |
Yes |
Yes |
Yes |
|
Analyze statistics |
Yes |
Yes |
Yes |
|
Require all unsegmented projections |
Yes |
Yes |
|
|
View event history |
Yes |
Yes |
|
|
Set correlation analysis mode (Default = 0) |
|
Yes |
|
1 - Using administration tools to create a design
To use the Administration Tools interface to create an optimized design for your database, you must be a DBADMIN user.
To use the Administration Tools interface to create an optimized design for your database, you must be a DBADMIN user. Follow these steps:
-
Log in as the dbadmin user and start Administration Tools.
-
From the main menu, start the database for which you want to create a design. The database must be running before you can create a design for it.
-
On the main menu, select Configuration Menu and click OK.
-
On the Configuration Menu, select Run Database Designer and click OK.
-
On the Select a database to design window, enter the name of the database for which you are creating a design and click OK.
-
On the Enter the directory for Database Designer output window, enter the full path to the directory to contain the design script, deployment script, backup script, and log files, and click OK.
For information about the scripts, see Building a design.
-
On the Database Designer window, enter a name for the design and click OK.
-
On the Design Type window, choose which type of design to create and click OK.
For details, see Design Types.
-
The Select schema(s) to add to query search path window lists all the schemas in the database that you selected. Select the schemas that contain representative data that you want Database Designer to consider when creating the design and click OK.
For details about choosing schema and tables to submit to Database Designer, see Design Tables with Sample Data.
-
On the Optimization Objectives window, select the objective you want for the database optimization:
-
The final window summarizes the choices you have made and offers you two choices:
-
Proceed with building the design, and deploying it if you specified to deploy it immediately. If you did not specify to deploy, you can review the design and deployment scripts and deploy them manually, as described in Deploying designs manually.
-
Cancel the design and go back to change some of the parameters as needed.
-
Creating a design can take a long time.To cancel a running design from the Administration Tools window, enter Ctrl+C.
To create a design for the VMart example database, see Using Database Designer to create a comprehensive design in Getting Started.