15.00 - Physical Database Design - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Physical Database Design

Physical database design is the commitment of all the previous design stages to a physical reality.

Entities, attributes, and relationships are identified and normalized in previous phases of the design process. Attribute sets are assigned to domains.

The physical design phase identifies and creates the actual databases, base tables, constraints, indexes, partitioning, views, macros, triggers, and other objects that define the physical database that drives your data warehouse.

See Chapter 8: “Teradata Database Indexes and Partitioning” through Chapter 13: “Designing for Missing Information” for more information about physical database design.