SQL_Add
function, as described below.SQL_Add
:SQL_Add
SQL_Add
has two key inputs that specify:‘ts’
), a set of operations (specify ‘ops’
), or a set of master operations (specify ‘mops’
),SQL_Add
to add master operations, operations, and time series to the database.install.m
script. Users wishing to add additional features using custom time-series code or different types of inputs to existing code files, can either edit the default INP_ops.txt and INP_mops.txt files provided with the repository, or create new input files for their custom analysis methods (as explained for operations and master operations).SQL_Add
which sets up the Results table of the database and ensures that the indexing relationships in the database are properly maintained.install
script populates the database with the default library of highly comparative time-series analysis code. The formatted input file specifying these pieces of code and their input parameters is INP_mops.txt in the Database directory of the repository. This step can be reproduced using the following command:SQL_Add
in the same way as described above. For example, lines corresponding to the new code can be added to the current INP_mops.txt file, or by generating a new input file and running SQL_Add
on the new input file. Once in the database, the software will then run the new pieces of code. Note that SQL_Add
checks for repeats that already exist in the database, so that duplicate database entries cannot be added with SQL_Add
.INP_ops.txt
, as follows:SQL_Add
function indexes the operation keywords to an OperationKeywords table that produces a unique identifier for each keyword, and another linking table that allows operations with each keyword to be retrieved efficiently.SQL_Add
, which imports time series data (stored in time-series data files) and associated keyword metadata (assigned to each time series) to the database.SQL_Add('ts','INP_test_ts.txt')
, as well as a sample .mat file input as INP_test_ts.mat, which can be added as SQL_Add('ts','INP_test_ts.mat')
.