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. You can create a data mart for time series data to query on other dimensions than time.
Call routines from within SQL statements or from within Java or C applications on either the client or the server computer.
- 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.
If you want to query time series data on dimensions other than time, such as customer or location, or run analytic functions, you can create data marts with Informix® Warehouse Accelerator. Informix Warehouse Accelerator can efficiently run queries on the typically large amounts of time series data. You can control the time range of time series values that you load into the accelerator.
You can output time series data in XML format to display in applications.