ShapeletSupervised Example - Teradata Vantage

Input

The input table has 10 price observations for four stocks. The column period contains time values, represented by integers.

SQL Call

SELECT * FROM ShapeletSupervised (
  ON shapelets_train AS InputTable
  OUT TABLE ModelTable (shapelets_model)
  USING
  IDColumn ('id')
  TimeColumn ('period')
  TargetColumn ('stockprice')
  ResponseColumn ('stock_category')
  SAXMinWindowSize (3)
  SAXMaxWindowSize (6)
  SAXOutputFrequency (1)
  SAXSymbolsPerWindow (3)
  RandomProjections (10)
  TimeInterval (1)
) AS dt;

Output

 stats                         
 ----------------------------- 
 shapelet model table created.
 number of shapelets : 1      
 number of rows : 6

SELECT * FROM shapelets_model;

 shapelet_id time_instant value_col split_value        left_child_id right_child_id left_class right_class 
 ----------- ------------ --------- ------------------ ------------- -------------- ---------- ----------- 
           1            1  67.12512 1.2180900573730469             0              0 healthcare technology 
           1            2      66.0 1.2180900573730469             0              0 healthcare technology 
           1            3 66.500158 1.2180900573730469             0              0 healthcare technology 
           1            4  64.12512 1.2180900573730469             0              0 healthcare technology 
           1            5 64.750082 1.2180900573730469             0              0 healthcare technology 
           1            6 65.375038 1.2180900573730469             0              0 healthcare technology

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.