Using Database Designer to create a comprehensive design

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.

• Does not require 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 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.

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.