15.00 - Activity Transaction Modeling - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Activity Transaction Modeling

The Activity Transaction Modeling (ATM) process extends the logical data model by beginning to attach physical attributes to it. In doing so, the ATM process undertakes the following activities:

  • Identifies the business rules of the enterprise that apply to the information to be stored in the data warehouse
  • Initiates the process of identifying and defining attribute domains and constraints for physical columns
  • Identifies and models database applications
  • Identifies and models application transactions
  • Summarizes table and join accesses by column across transactions
  • Compiles a preliminary set of data demographics by computing table cardinalities, value distributions, and attaching change ratings to columns
  • This information is compiled and used as input to the physical design process.

    The ATM process is described in detail in Chapter 6: “The Activity Transaction Modeling Process.”