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.
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.
Vertica strongly recommends that you follow the tutorial procedure in the Quick Start to get hands-on experience with the process of configuring a database before you begin this section.
Logical Schema