Home
Extending 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 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™.
extensions and modulesThese topics describe how to use built-in database extensions and separately installed 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.

Defining a calendar

A 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.

Procedure

To create a calendar:

Optional: Create a named calendar pattern by inserting a row into the CalendarPatterns table by using the format of the CalendarPattern data type.
A named calendar pattern is useful if you plan to use the same calendar pattern in multiple calendars.
Create a calendar by inserting a row into the CalendarTable table by using the format of the Calendar data type. Include either the name of an existing calendar pattern or a calendar pattern definition.

Results

To use a predefined calendar, specify one when you create a time series with the TSCreate or TSCreateIrr function. You can change a predefined calendar to meet your needs by updating the row for the calendar in the CalendarTable table.