Table Form | Database Design | Teradata Vantage - Table Form - 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ā„¢
The Table form:
  • Extends the fully attributed table model created through the logical database design by collecting table- and column-level data demographic information and adding it to the model.
  • Provides input to the physical design of the database.

This form introduces data demographics to the ATM process. Supporting analysis requires you to determine various cumulants and then to add that data to information derived from the Column Names and Constraints and Report/Query Analysis forms.

The form supports the seventh, eighth, and ninth steps in the ATM process (see Goals of the ATM Process).

Approaches to Filling Out the Table Form

Because the determination of data demographics for columns that will be treated as multicolumn indexes is far more complex than the determination of similar data for single column index columns, the sample analysis and the way you fill out the Table form differs slightly for the single column and multicolumn situations.

The following table points to the Table form topics that apply to the two situations:

Information Collected for the Table Forms

Table form information falls into these broad categories:
  • Miscellaneous
  • Access
  • Data demographics

Miscellaneous Information

  • Column name
  • Identity column
  • Primary key/foreign key
  • Constraint number
  • Primary index/secondary index
    Note the following things about this point.
    • This form is filled out during the logical design phase and indexes should not be defined this soon in the process.
    • A table might be a nonpartitioned NoPI object, and a table or join index might be a column-partitioned object, in which case it would not have a primary index.
  • Sample data

Transcribe this information from the completed Column Names and Constraints form to the Table form.

Access Information

The following Table form information describes value and join accesses:
  • Value access frequency
  • Join access frequency
  • Join access rows

Transcribe this information from the completed Report/Query Analysis form to the Table form.

Data Demographics

The following Table form information describes the demographics of your data:
  • Distinct values
  • Maximum rows/value
  • Rows/null
  • Typical rows/value
  • Change rating

This information applies only to those columns that have been identified by the Report/Query Analysis activity as taking part in value and join accesses.

The Table form introduces data demographics to the ATM process for the first time. The sources for this information are varied and you might have to use a variety of resources to obtain the data.

Details of this activity are provided in Table Form: Data Demographics for Single-Column Database Objects.