Setting Up the Database
The process of setting up a Vertica database is described in detail in the Database Administrator's Guide. It involves:
Preparing SQL Scripts and Data Files
The first part of the setup procedure can be done well before Vertica is installed. It consists of preparing the following files:
- logical schema script
- sample query script (training set)
- loadable data files (dimension table and fact tables)
- load scripts
Creating the Database
This part requires that you have installed Vertica on at least one host. The following steps are not in sequential order:
You will use the 
Administration Tools to:
The tools needed for administering a Vertica database are provided in the form of a graphical user interface that allows you to perform various tasks quickly and easily. The tools also provide a convenient way to connect to a database using vsql. Always run the Administration Tools on the Administration Host if possible.
vsql is the Vertica implementation of psql, a character-based, interactive, front-end that is part of PostgreSQL and used by other database management systems. It allows you to type in SQL statements and see the results. It also provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.
$ /opt/vertica/bin/adminTools
See the Administration Tools Reference for a complete description.
You will use the vsql interactive interface to execute SQL scripts that:
vsql is the Vertica implementation of psql, a character-based, interactive, front-end that is part of PostgreSQL and used by other database management systems. It allows you to type in SQL statements and see the results. It also provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.
- create tables and constraints
- create projections
Test the Empty Database
- test for sufficient projections using the sample query script
- test the projections for K-Safety
Test the Partially Loaded Database
- load the dimension tables
- partially load the fact table
- check system resource usage
- check query execution times
- check projection usage
Complete the Fact Table Load
- monitor system usage
- complete the fact table load
Setting Up Security
- set up database users and privileges
Set Up Incremental Loads
- set up periodic or "trickle" loads
