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™.
HCL OneDB™ TimeSeries solutionDatabase administrators and applications developers use the HCL OneDB™ TimeSeries solution to store and analyze time series data.
Getting started with the HCL OneDB™ TimeSeries solutionBefore you can create a time series, decide on the properties of the time series and where to store the time series data. After you create a time series, you load the data and query the data.
Planning for accessing time series dataYou use SQL routines, Java™ classes and methods, and C API routines to access and manipulate time series data directly. You can also transform time series data into virtual tables that you can query with standard SQL statements.

Planning for accessing time series data

You use SQL routines, Java™ classes and methods, and C API routines to access and manipulate time series data directly. You can also transform time series data into virtual tables that you can query with standard SQL statements.

Call routines from within SQL statements or from within Java or C applications on either the client or the server computer.

Use TimeSeries SQL routines, Java classes and methods and API routines, and API routines that are written in C to perform the following types of operations to access or manipulate time series data:

Manipulate individual elements or sets of elements
Perform statistical and arithmetic calculations
Aggregate data
Convert between time stamps and offsets
Extract values for a time interval
Find or delete null elements
Remove older data by deleting a range of elements

Create virtual tables to view and query time series data by using standard SQL statements. You can display the results of TimeSeries SQL functions on time series data in virtual tables.

You can output time series data in XML format to display in applications.