Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Spatiotemporal Search for Moving Objects User's GuideThe HCL OneDB™ Spatiotemporal Search for Moving Objects User's Guide describes how to program applications to search data from moving objects in HCL OneDB™ databases using the spatiotemporal search extension.
Getting started with spatiotemporal search for moving objectsYou use spatiotemporal searches to track moving objects. You create a spatiotemporal search index on the time-stamped GPS data that is stored in a historian database as time series.
Spatiotemporal search indexingBefore you start indexing spatiotemporal data, you must decide how to configure the data and where to store the spatiotemporal tables and indexes.
Starting spatiotemporal indexingYou start spatiotemporal indexing by running the STS_SubtrackCreate function for the time series column.

Starting spatiotemporal indexing

You start spatiotemporal indexing by running the STS_SubtrackCreate function for the time series column.

Before you begin

The TimeSeries, Spatial, and R-tree index extensions must be registered in the database.

A time series table must exist.

Procedure

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.