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 |
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 HCL OneDB™ |
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. |