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.
TimeSeries Data User's GuideThe HCL OneDB™ TimeSeries Data User's Guide contains information to assist you in using the TimeSeries extension with HCL OneDB™.
Create and manage a time series through SQLBefore you can load time series data into the database, you must configure database objects specific to your time series. You can manage data storage and remove data as necessary. You can run SQL statements to create and manage time series.
Defining a calendarA time series definition must include a calendar. A calendar includes a calendar pattern, which can be defined separately or within the calendar definition.You can create a calendar or choose a predefined calendar.
Predefined calendarsYou can use predefined calendars when you create a time series.

Predefined calendars

You can use predefined calendars when you create a time series.

Predefined calendars are stored in rows in the CalendarTable table. You can change a predefined calendar by updating the row for the calendar in the CalendarTable table.

If you upgrade from a previous release of the HCL OneDB™ TimeSeries solution or the TimeSeries DataBlade® module and an existing calendar is defined with the same name as one of the predefined calendars, the existing calendar is not replaced by the predefined calendar.

The following table contains the properties of predefined calendars.

Table 1. Predefined calendars
Calendar name	Interval duration	Start date and time
ts_1min	Once a minute	2011-01-01 00:00:00.00000
ts_15min	Once every 15 minutes	2011-01-01 00:00:00.00000
ts_30min	Once every 30 minutes	2011-01-01 00:00:00.00000
ts_1hour	Once an hour	2011-01-01 00:00:00.00000
ts_1day	Once a day	2011-01-01 00:00:00.00000
ts_1week	Once a week	2011-01-02 00:00:00.00000
ts_1month	Once a month	2011-01-01 00:00:00.00000
ts_1year	Once a year	2011-01-01 00:00:00.00000