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.
Spatiotemporal search tablesThe spatiotemporal search tables contain spatiotemporal data and information about spatiotemporal search indexes.
STS_InstanceTable tableThe STS_InstanceTable table contains the association between a time series instance and a subtrack definition.

STS_InstanceTable table

The STS_InstanceTable table contains the association between a time series instance and a subtrack definition.

Every time series that has subtrack records in a subtrack table has a row in the STS_InstanceTable table.

The following table lists the columns of the STS_InstanceTable table.

Table 1. The STS_InstanceTable table
Column name	Data type	Description
instance_id	BIGINT	The time series instance ID. The primary key. The time series instance ID is listed in the TSInstanceTable table. See TSInstanceTable table.
subtrack_id	INTEGER	The unique ID of the subtrack table.