15.00 - Sources for the Required Information - Teradata Database

Teradata Database Design

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

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