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™.
Calendar routinesYou can use calendar routines to manipulate calendars.

Calendar routines

You can use calendar routines to manipulate calendars.

Calendar routines can perform the following types of operations:

Create the intersection of calendars
Create the union of calendars
Return information about the calendar

Calendar routines can be useful when comparing time series that are based on different calendars. For example, to compare peak time business usage of a computer network across multiple countries requires accounting for different sets of public holidays in each country. An efficient way to handle this is to define a calendar for each country and then create the calendar intersections to perform business-day comparisons.

Calendar routines can be run in SQL statements or sent from an application using the function mi_exec.