Skip to main content

Solving Business Problems with Informix TimeSeries

An IBM Redbooks publication


Published on 21 September 2012

  1. .EPUB (2.4 MB)
  2. .PDF (1.9 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738437239
ISBN-13: 9780738437231
IBM Form #: SG24-8021-00

Authors: S Vaibhav Dantale, Tony Hays, Anup Nair and Jacques Roy

    menu icon


    The world is becoming more and more instrumented, interconnected, and intelligent in what IBM® terms a smarter planet, with more and more data being collected for analysis. In trade magazines, this trend is called big data.

    As part of this trend, the following types of time-based information are collected:

    • Large data centers support a corporation or provide cloud services. These data centers need to collect temperature, humidity, and other types of
    • information over time to optimize energy usage.

    • Utility meters (referred to as smart meters) allow utility companies to collect information over a wireless network and to collect more data than ever before.

    IBM Informix® TimeSeries is optimized for the processing of time-based data and can provide the following benefits:

    • Storage savings: Storage can be optimized when you know the characteristics of your time-based data. Informix TimeSeries often uses one third of the storage space that is required by a standard relational database.
    • Query performance: Informix TimeSeries takes into consideration the type of data to optimize its organization on disk and eliminates the need for some large indexes and additional sorting. For these reasons and more, some queries can easily have an order of magnitude performance improvement compared to standard relational.
    • Simpler queries: Informix TimeSeries includes a large set of specialized functions that allow you to better express the processing that you want to execute. It even provides a toolkit so that you can add proprietary algoritms to the library.

    This IBM Redbooks® publication is for people who want to implement a solution that revolves around time-based data. It gives you the information that you need to get started and be productive with Informix TimeSeries.

    Table of Contents

    Chapter 1. Overview of IBM Informix

    Chapter 2. A use case for the Informix TimeSeries feature

    Chapter 3. Defining your TimeSeries environment

    Chapter 4. Implementing Informix TimeSeries

    Chapter 5. Querying TimeSeries data

    Chapter 6. Managing the ecosystem

    Appendix A. Reference material

    Appendix B. Enterprise historian database example

    Appendix C. Distribution grid monitoring enabler


    Others who read this also read