Database Schema Design

This section contains the following topics:

• Logical Schema Design - Tables and Views
• Physical Schema Design - Projections

Data Warehouse makes a clean distinction between the logical data model, which defines the tables and columns, and the physical data model, which identifies how the data is organized using the columnar storage and distributed across the cluster nodes. 

For more information on differences between the LDM and the PDM, see Data Warehouse Logical and Physical Model.