You start spatiotemporal indexing by running the STS_SubtrackCreate
function for the time series column.
The TimeSeries, Spatial, and R-tree index extensions must be registered in the database.
A time series table must exist.
To start spatiotemporal indexing:
- Prepare storage spaces for your spatiotemporal data.
- Optional: If you are using multiple CPU virtual processors, set the PRELOAD_DLL_FILE configuration
parameter to the path for the spatiotemporal shared library file in the
onconfig file and then restart the database server:
PRELOAD_DLL_FILE $INFORMIXDIR/extend/sts.version/sts.bld
The
version is the version number of the spatiotemporal search extension.
- Optional: Set default parameters for configuring spatiotemporal data and storage by running the
STS_SetDefaultParameters function.
- Run the STS_SubtrackCreate function for the time series. A subtrack table and spatiotemporal search system tables are created. If you configured
Scheduler tasks, the subtrack table is populated and indexed.
- If you did not configure a Scheduler task with the STS_SubtrackCreate
function, run the STS_SubtrackBuild function to populate the subtrack table and
index the initial set of data.