15.00 - Approaches to Handling Standalone Derived Data - Teradata Database

Teradata Database Design

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

Approaches to Handling Standalone Derived Data

There are occasions when you might want to denormalize standalone calculations for performance reasons. Base the decision to denormalize on the following demographic information, all of which is derived through the ATM process described in Chapter 6: “The Activity Transaction Modeling Process”:

  • Number of tables and rows involved
  • Access frequency
  • Data volatility
  • Data change schedule