Informix Solutions

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.

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?

Watch the video (00:04:42)

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

Learn how Informix Warehouse Accelerator dramatically speeds up even the most complex warehouse queries, without any tuning or changes to business applications!

Informix library
Find solutions, industry reports, white papers, videos and more
Visit the library

Related links

Join the conversation

Informix discussions, idea sharing, direct interactions with experts, and more, are happening all day, every day.