Informix Warehouse

Achieve faster time to value for data analysis and reporting by bringing the value of Informix to your warehouse applications.

All “for-purchase” editions of IBM Informix include an integrated set of tooling to help build, deploy, operate, and maintain a robust data warehousing infrastructure that can deliver data to business decision makers. These tools include an Extract-Load-Transform (ELT) tool in an easy to use GUI environment that simplifies design and deployment of an Informix warehouse. The integrated tooling also includes Design Studio and the Warehouse Administration Console.

For businesses seeking “speed of thought” analysis of warehouse data or operational data, two editions of Informix complement the integrated tooling with additional, patent-pending software technology that exponentially accelerates even the most complex queries. Informix Advanced Enterprise Edition and Informix Advanced Workgroup Edition both leverage this technology known as the Informix Warehouse Accelerator (IWA). IWA loads data completely into system memory in a compressed form, using a special columnar scheme developed by IBM. As queries come in, the Informix database passes them to the Informix Warehouse Accelerator which can scan billions of rows of data in seconds to return immediate results.

The Informix Warehouse Accelerator was designed to be completely transparent to any business applications so no application changes are needed to take advantage of accelerated query performance. Users can utilize front-end analysis and reporting tools such as IBM Cognos, or develop mash-ups and other dashboards.

Informix offers tremendous cost-savings since it can run on commodity hardware and can simultaneously meet or surpass service level agreements for both transactional and analytical workloads, eliminating the need for separate OLAP systems.

Informix Warehouse Accelerator Accelerates Warehouse Queries up to 100X or More!

Watch this flash video to hear how Informix Warehouse Accelerator dramatically speeds up even the most complex warehouse queries, without any tuning or changes to business applications!

For hybrid environments, Informix has a number of unique capabilities that cannot be matched by either conventional data warehousing vendors or traditional data warehouses.

Philip Howard, Bloor Research

Contact IBM

Considering a purchase?

Related Reading

IBM Informix powers OLTP and analytics for data-driven businesses


Informix for your Warehouse

Extreme warehouse speed for fast business decisions

Put your analytics applications into overdrive

Bloor Research: Informix in hybrid workload environments

OVUM Report: Speed is everything for Informix Warehouse Accelerator

IBM Informix Warehouse Accelerator: Performance is everything