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.
Estimate your spatial dataThe total amount of space you need for spatial data is equal to the size of spatial tables plus the size of the spatial indexes.
Estimating the smart large object storage spaceA spatial data value is stored in row if the value is less than or equal to 930 bytes. However, if the value is greater than 930 bytes, only a pointer of 64 bytes is stored in row. This pointer refers to the smart large object in which the actual data is stored.

Estimating the smart large object storage space

A spatial data value is stored in row if the value is less than or equal to 930 bytes. However, if the value is greater than 930 bytes, only a pointer of 64 bytes is stored in row. This pointer refers to the smart large object in which the actual data is stored.

About this task

Important: Store sbspaces on a disk separate from both the table and the indexes.

To estimate the amount of smart large object storage space:

Procedure

Determine the smart large object ratio using the following formula:
```
smart large object ratio = (spatial column size / 1920)
```
The smart large object ratio cannot be greater than 1. So if the smart large object ratio you calculate is greater than one, set it to 1.
Multiply your smart large object ratio by the number of rows in your table to obtain the amount of smart large object space used by your table:
```
smart large object space = ( ( smart large object ratio ) *
       number of rows)
```
Determine the amount of in-line table space required using the following formula:
```
in-line space = (size of spatial table) - (smart large object space)
```