Database Designer
Vertica's Database Designer is a tool that:
- Analyzes your logical schema, sample data, and, optionally, your sample queries.
- Creates a Physical Schema design that can be deployed automatically or manually.
- Can be used by anyone without specialized database knowledge. Even business users can run Database Designer.
- Can be run and re-run any time for additional optimization without stopping the database.
Run the DBD
Run the Database Designer in one of the following ways:
- With the Management Console, as described in Using Management Console to Create a Design
- Programmatically, using the steps described in About Running Vertica Programmatically.
- With the Administration Tools by selecting Configuration Menu > Run Database Designer. For details, see Using the Administration Tools to Create a Design
Use the Database Designer to create one of the following types of designs:
- A comprehensive design that allows you to create new projections for all tables in your database.
- An incremental design that creates projections for all tables referenced in the queries you supply.
Database Designer benefits include:
- Accepting up to 100 queries in the query input file for an incremental design.
- Accepting unlimited queries for a comprehensive design.
- Producing higher quality designs by considering UPDATE and DELETE statements.
In most cases, the designs created by Database Designer provide optimal query performance within physical constraints. Database Designer uses sophisticated strategies to provide optimal query performance and data compression.