Using Database Designer to Create a Comprehensive Design

The Vertica Database Designer:

• Analyzes your logical schema, sample data, and, optionally, your sample queries.
• Creates a physical schema design (a set of projections) that can be deployed automatically or manually.
• Can be used by anyone without specialized database knowledge.
• Can be run and rerun any time for additional optimization without stopping the database.
• Uses strategies to provide optimal query performance and data compression.

Use Database Designer to create a comprehensive design, which allows you to create new projections for all tables in your database.

You can also use Database Designer to create an incremental design, which creates projections for all tables referenced in the queries you supply. For more information, see Incremental Design in the Administrator’s Guide.

You can create a comprehensive design with Database Designer using Management Console or through Administration Tools. You can also choose to run Database Designer programmatically (See About Running Database Designer Programmatically).