Query Acceleration for Business Using IBM Informix Warehouse Accelerator
An IBM Redbooks publication
Published 06 November 2013
ISBN-10: 0738438928
ISBN-13: 9780738438924
IBM Form #: SG24-8150-00
(252 pages)
View online
Authors: Whei-Jen Chen, Nigel Campbell, Martin Fuerderer, Frederick Ho, Holger Kirstein, Keshava Murthy, Ramanathan Sivaguru
Abstract
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.
Table of contents
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