IBM® Informix® Warehouse Accelerator is a state-of-the-art in-memory database that uses affordable innovations in memory and processor technology and trends in novel ways to boost query performance. It is a disruptive technology that changes how organizations provide analytics to its operational and historical data. Informix Warehouse Accelerator uses columnar, in-memory approach to accelerate even the most complex warehouse and operational queries without application changes or tuning.

This IBM Redbooks® publication provides a comprehensive look at the technology and architecture behind the system. It contains information about the tools, data synchronization, and query processing capabilities of Informix Warehouse Accelerator, and provides steps to implement data analysis by using Informix Warehouse Accelerator within an organization.

This book is intended for IBM Business Partners and clients who are looking for low-cost solutions to boost data warehouse query performance.

Chapter 1. Introduction to IBM Informix Warehouse Accelerator

Chapter 2. Designing data marts

Chapter 3. Designing and sizing an IBM Informix Warehouse Accelerator environment

Chapter 4. IBM Informix Warehouse Accelerator installation and configuration

Chapter 5. Creating IBM Informix Warehouse Accelerator data marts

Chapter 6. Query execution

Chapter 7. Managing and refreshing an IBM Informix Warehouse Accelerator data mart

Chapter 8. IBM Informix Warehouse Accelerator server administration tasks

Chapter 9. Use of IBM Cognos Business Intelligence with IBM Informix Warehouse Accelerator

Chapter 10. IBM Informix Warehouse Accelerator proof of concept

Appendix A. Tools for IBM Informix Warehouse Accelerator