TimeSeries Data User's Guide

These topics contain information to assist you in using the TimeSeries extension with HCL Informix®.

These topics are written for the following audience:

Developers who write applications to access time series information that is stored in HCL Informix databases

Informix TimeSeries solution
Database administrators and applications developers use the Informix TimeSeries solution to store and analyze time series data.
Data types and system tables
Specialized data types and system tables handle time series data.
Create and manage a time series through SQL
Before you can load time series data into the database, you must configure database objects specific to your time series. You can manage data storage and remove data as necessary. You can run SQL statements to create and manage time series.
Virtual tables for time series data
A virtual table provides a relational view of your time series data.
Pattern matching searches
You can search time series data for matches to a particular pattern of values. For example, after you identify a pattern of abnormal electricity usage that indicates an outage, you can search for matches to that pattern to find other outages. Pattern matching searches find matches to a pattern that you supply. Pattern matching searches do not discover patterns in time series data.
Advanced analytics
Advanced analytics functions provide specialized methods of analyzing time series data for patterns or abnormalities.
Calendar pattern routines
You can use calendar pattern routines to manipulate calendar patterns.
Calendar routines
You can use calendar routines to manipulate calendars.
Time series SQL routines
Time series Java class library
You can use the time series Java™ class library to create and manage a time series from within Java applications or applets.
Time series API routines
The time series application programming interface routines allow application programmers to directly access a time series datum.
Appendixes