Planning for loading time series data
When you plan to load time series data, you must choose the loading method and where to store the data on disk.
The following table summarizes the methods of loading data that you can use, depending on how much data you need to load and the format of the data.
| Data to load | Methods |
|---|---|
| Bulk data from a file that is created by your data collection application | Use and
the HCL®
OneDB® TimeSeries Plug-in for Data
Studio to
create a load job for a delimited file. Write a custom loader program that runs time series SQL routines. Create a virtual table and load data that is in standard relational format. Use the BulkLoad SQL function. The file must be formatted according to the BulkLoad function requirements. |
| Data in a database, including databases in database servers other than | Use and
the HCL
OneDB TimeSeries Plug-in for Data
Studio to
create a load job for data in a database. Write a custom loader program that runs time series SQL routines. |
| Alter or add one or more elements to edit incorrect data or insert missing values | Use the InsElem SQL function
to insert an element or the PutElem SQL function
to update an element. Use the InsSet SQL function
to insert multiple elements or the PutSet SQL function
to update multiple elements. Create a virtual table and use a standard SQL INSERT statement. You can add or update elements. |