Teradata Support for Time Series Data | Teradata Vantage - Teradata Support for Time Series Data - Advanced SQL Engine - Teradata Database

Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
zzg1600277315070.ditamap
dita:ditavalPath
zzg1600277315070.ditaval
dita:id
B035-1208
lifecycle
previous
Product Category
Teradata Vantageā„¢
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