17.10 - Table Form: Basic Information - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
Language
English (United States)

This topic explains how to fill out the general information requests named at the top of the Table form.

Sources for the Required Information

The following table points to the sources for the data requested at the top of the Table form.

Information Source
System System form
Table name Entity name from your logical data model
Table type Entity type from your logical data model
Row count Varies.
  • If an existing electronic database contains the information, query that database for the cardinality of the table in one of two ways.

    Examine current statistics for the table.

    Execute a simple SELECT COUNT (*) request on the table.

  • If no existing database contains the information, consult with your users to make a best guess cardinality estimate based on estimates of known maxima, not averages.
Data protection Varied, depending on how your company operates. The following items are all likely sources for this information.
  • Users
  • Enterprise data model
  • IT policies and procedures
The following methods for protecting data are available. Note that while you can specify fallback at the table and join index level, RAID protection applies to your entire hardware configuration.
  • Fallback
  • Disk I/O integrity checking
  • RAID 1
  • RAID 5
  • RAID S
  • Disk I/O integrity checks