Data Warehouses are known for storing data over time, both historical point-in-time transactions as well as temporal data that is valid over a range of time. Storing this data is one thing, but retrieving it to answer critical business questions can be a Structured Query Language (SQL) challenge...
A topic that is essential for all SQL programmers and database designers. This session examines the mysteries of the English text that appears when an EXPLAIN is requested.
In this session we will define the concept of Teradata Active Enterprise Intelligence (AEI) and describe seven key elements for evolving from traditional data warehousing to active data warehousing.
One of the more difficult challenges in database management and administration is determining where and how to implement a new RDBMS feature or function. In this presentation we’ll look at the DBQL data available for evaluation of tables and columns used within a workload and how this data can be leveraged for determining candidates for MLPPI (Multi-Level Partitioned Primary Index).
Increasing numbers of Teradata users are introducing tactical queries alongside the more traditional strategic work and near real time data loading ...