15.00 - Ad Hoc Queries and Enterprise Tactical Support - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Ad Hoc Queries and Enterprise Tactical Support

Tactical queries are focused on operational decision making rather than enterprise discovery or bookkeeping activities. They typically have the following characteristics:

  • Relatively simple syntax
  • Direct access
  • Highly tuned
  • Have expected response latencies on the order of 20 seconds or less, and are often expected to return a response in less than one second.
  • The Teradata data warehouse provides facilities such as the Priority Scheduler (see Utilities: Volume 2 (L-Z)) to fully integrate workload mixes of both tactical and strategic queries across the enterprise, enabling executives and frontline decision makers alike to access the same single version of the truth concurrently.

    See Chapter 16: “Design Issues for Tactical Queries” for many of the special considerations you must take into account when designing to support tactical queries.