Skip to main content

Using Informix for your Warehouse

Extreme Speed for Faster Decisions

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

Using Informix for a data warehouse is an ideal solution for users who want to build end-to-end business intelligence and reporting solutions.

With the IBM Informix Ultimate Warehouse Edition, an offering designed to dramatically accelerate analytic queries, customers can realize significant performance gains without requiring changes to business applications. Built upon the Informix Ultimate Edition, this edition includes the Informix Warehouse Accelerator that leverages a deep columnar approach to accelerate queries up to 100 times, and often more. Warehouse costs are lowered even further since no database tuning is required. Customers can also realize up to 80% disk savings on their warehouse with the compression functionality that is included in this edition.

Users can utilize front-end analysis and reporting tools, like IBM Cognos®, or develop mashups and other dashboards. Informix customers can simplify operational complexity and reduce costs by using a single database server for mixed workload environments.

The Informix Warehouse Accelerator is available as part of the Informix Ultimate Warehouse Edition and the Informix Growth Warehouse Edition, however all for-purchase editions of Informix include a set of tools to build a powerful warehouse platform to lower costs and increase profits by doing more with existing operational data and infrastructure. These tools include a state of the art Extract-Load-Transform (ELT) tool, in an easy to use GUI/Eclipse environment that simplifies design and deployment of an Informix warehouse. This comprehensive platform provides the foundation needed to cost effectively deploy and build next-generation analytic solutions using Informix.