15.00 - Data Warehousing Support - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Data Warehousing Support

Relational databases that support data warehousing are optimized to support decision support applications in all the forms listed below and more.

  • Ad hoc SQL or natural language-generated SQL queries
  • Repeatedly stated queries in the form of macros, embedded SQL applications, or stored procedures
  • Data mining and OLAP explorations
  • The data in the warehouse is stored in the form of multiple normalized tables that model your enterprise. The decision support applications that explore these data often perform full file scans of multiple large tables, making them processing intensive. Because processing time is directly related to data volume, the responsiveness of the system is heavily affected by the size of the underlying database.