Database Setup
This page provides an overview on setting up a Vertica database . For complete details see Configuring the Database.
Prepare SQL Scripts and Data Files
Prepare the following files before installing Vertica:
- Logical schema script
- Loadable data files
- Load scripts
- Sample query script (training set)
Create the Database
Create the database after installing Vertica on at least one host:
-
Use the Administration Tools to:
- Create a database
- Connect to the database
- Use the Database Designer to design the physical schema.
-
Use the vsql interactive interface to run SQL scripts that:
- 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
Set up Security
For security-related tasks, see Security and Authentication .
- [Optional] Set up SSL
- [Optional] Set up client authentication
- Set up database users and privileges
Set up Incremental Loads
Set up periodic (trickle) loads, see Trickle Loading