|
|
|
|
|
|
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.
Designing a 
logical schema for Vertica database is essentially an exercise in dimensional modeling, the universal standard for data warehousing. This document explains only the most basic concepts of dimensional modeling. If you are converting a normalized schema to a data warehouse schema, contact Technical Support for a consultation or refer to the published literature on the topic.
To implement your logical schema design, write an SQL script (plain text file) that creates the tables in your database and defines the required referential integrity constraints. You will use vsql to execute this script to create the actual logical schema of your database.