Physical Database Design - Advanced SQL Engine - Teradata Database

Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval
dita:id
B035-1094
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.

Much of physical design focuses on the performance aspects for the execution of queries using well-chosen indexes.

See Indexes and Maps through Designing for Missing Information for more information about physical database design.