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.
Spatial Data User's GuideThe HCL OneDB™ Spatial Data User's Guide contains information to assist you in using the HCL® OneDB® spatial extension. The HCL® OneDB® spatial extension adds custom data types and supporting routines to the server.
R-tree indexesAn index organizes access to data so that entries can be found quickly, without searching every row. The R-tree access method enables you to index multidimensional objects.
The spatial operator class ST_Geometry_OpsAn operator class defines operators, called strategy functions, that can use an index. The operator class that the HCL® OneDB® spatial data types require ST_Geometry_Ops.

The spatial operator class ST_Geometry_Ops

An operator class defines operators, called strategy functions, that can use an index. The operator class that the HCL® OneDB® spatial data types require ST_Geometry_Ops.

Restriction: Do not use rtree_ops, the default R-tree operator class for the secondary access method.

The strategy functions for the ST_Geometry_Ops operator classes are:

ST_Contains()
ST_Crosses()
ST_Equals()
SE_EnvelopesIntersect()
ST_Intersects()
SE_Nearest()
SE_NearestBbox()
ST_Overlaps()
ST_Touches()
ST_Within()