Teradata Support for Time Series Data | Teradata Vantage - 17.00 - Teradata Support for Time Series Data - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Advanced SQL Engine
Teradata Database
June 2020
Programming Reference
Time series data is unstructured machine-generated sensor data that is continuously produced and collected by a wide range of applications and devices that make up the Internet of Things. Time series data is typically composed of:
  • A unique identifier: One or more columns that identify the data source, for example, BuoyID or Vehicle Identification Number (VIN).
  • A timecode: A timestamp or date indicating when the data was collected, for example: '2017-07-07 10:32:12.122200'.
  • A sequence number: Data is stored first in the order in which it was collected. If different data arrives at exactly the same time, the sequence number differentiates between the data.
  • Measurements: One or more measurements collected at a point in time, for example:
    • Temperature, salinity, wave height, wave speed, and wave direction
    • Engine temperature, oil temperature, oil pressure, tire inflation ratio