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

Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
qby1588121512748.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1094
lifecycle
previous
Product Category
Teradata Vantageā„¢

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