15.00 - 15.10 - Chapter 1 Introduction: The Data Warehouse - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

Initially, the data warehouse was a historical database, enterprise-wide and centralized, containing data derived from an operational database.

The data in the data warehouse was:

  • Subject-oriented
  • Integrated
  • Usually identified by a timestamp
  • Nonvolatile, that is, nothing was added or removed
  • Rows in the tables supporting the operational database were loaded into the data warehouse (the historical database) after they exceeded some well‑defined date.

    Data could be queried, but the responses returned only reflected historical information. In this sense, a data warehouse was initially static, and even if a historical data warehouse contained data that was being updated, it would still not be an active data warehouse.