Getting started with the Informix TimeSeries solution

Before 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 creating a time series
When you create a time series, you define a set of properties.
Planning for data storage
Time series data is stored in containers within dbspaces. You can use the default containers that are created in the same dbspace as the table into which you are loading data or you can create containers in separate dbspaces. You can estimate how much storage space you need. Rolling window containers have specific storage requirements.
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.
Planning for replication of time series data
You can replicate time series data with high-availability clusters and Enterprise Replication. Review the restrictions and requirements before you set up replication.
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.

Parent topic: Informix TimeSeries solution