Database Designer
Vertica's 
Database Designer tool:
The Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data and generates a set of projections in the form of an SQL script to be executed after you create the tables but before you load any data. The script creates a minimal set of superprojections to ensure K-Safety, and optionally pre-join projections. In most cases, the projections created by the Database Designer provide excellent query performance within physical constraints. You can, however, write a custom projection script should the Database Designer not meet your needs.
A superprojection is a projection that contains every column of a table in the Logical Schema. A table can have multiple superprojections with different sort orders.
- analyzes your logical schema, sample data, and sample queries
A logical schema consists of a set of tables and referential integrity constraints in a Vertica database. The objects in the logical schema are visible to SQL users. The logical schema does not include projections, which make up the physical schema.
- creates a physical schema design (projections) in the form of an SQL script that you execute
A physical schema consists of a set of projections used to store data on disk. The projections in the physical schema are based on the objects in the Logical Schema.
In most cases, the designs created by the Database Designer provide excellent query performance within physical constraints. The Database Designer uses very complex strategies to provide excellent ad-hoc query performance while using disk space efficiently.
You can, however, design custom projections as described in the Database Administrator's Guide (Advanced). This option is intended for advanced users only and should be used as advised by Technical Support.
To submit problem reports, questions, comments, and suggestions, please use the Technical Support page on the Vertica Systems, Inc. Web site:
http://www.vertica.com/support
You must be a registered user in order to access the page.
Before reporting a problem, please run the Diagnostics Utility described in the Troubleshooting Guide and attach the resulting .zip file.
For More Information
