Vertica database Logical and physical schema concepts

Logical schema

The logical schema in Vertica is not to diferent from any SQL database. Vertica has Schemas, Tables, Views and Referential Integrity constraints that are visible to SQL users.

Physical Schema

The physical storage schema in Vertica is based on collections of table columns called projections. Projections can be compared with materialized views optimized for query execution. For more on projections see the next tutorials