IBM Informix Data Warehousing

Important

IBM® Informix® Dynamic Server editions were withdrawn and new Informix editions are available. Some products were also renamed. The Informix Warehouse Feature is renamed Informix SQL Warehouse Tool.

Data warehousing overview

These documents provide a high-level overview of dimensional databases and data warehousing with IBM Informix.

• Overview of warehousing in Informix: Use your existing Informix infrastructure to power business intelligence solutions, with tools that simplify warehouse design and deployment.
• Overview of Informix data warehousing information (Version 11.70): In addition to designing and implementing Informix dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries. This topic contains many useful data warehousing links.

Dimensional Database Model

These documents provide key design concepts you need to understand before you build a data warehouse.

• Overview of dimensional databases (Version 11.70)
• Dimensional databases (Version 11.50): Dimensional databases are the optimal type of database for data warehousing. Dimensional databases are relational databases that use a dimensional data model to organize data.
• Design a dimensional model (Version 11.50): These topics describe how to build a data warehouse by designing a dimensional data model for your business. Learn how a dimensional model differs from a transactional model. Learn to analyze the business processes in your organization to design a model for your dimensional data.
• Implement a dimensional database (Version 11.70):
• Implement a dimensional database (Version 11.50): These topics show the SQL statements you use to implement the dimensional data model.

Informix Warehouse Accelerator

These documents provide key design concepts you need to understand before you build a data warehouse.

• Overview of Informix Warehouse Accelerator (Version 11.70): Use the accelerator to process warehouse queries more quickly, without increasing maintenance requirements or changing application infrastructure.
• IBM Informix Warehouse Accelerator — Performance is Everything: This paper provides a comprehensive overview that includes performance results from customer testing, information about architecture options, configuration suggestions, and designing data marts.
• Informix Warehouse Accelerator: This blog contains a wide range of tips, best practices, and other valuable information about using Informix Warehouse Accelerator.
• Installing Informix Warehouse Accelerator (Version 11.70): You can install Informix Warehouse Accelerator on the same computer as the Informix database server or on a separate computer. Before you install the accelerator, ensure that your computers meet the software and hardware prerequisites, and that you have decided which architecture you want to implement.
• Accelerator configuration: After you install Informix Warehouse Accelerator, you must configure the accelerator, connect the database server to the accelerator, and enable query acceleration.
• IBM Smart Analytics Optimizer Studio (Version 11.70): These topics describe the Eclipse-based administration interface included with Informix Warehouse Accelerator.

Informix SQL Warehousing Tool

The Informix SQL Warehousing Tool is an integrated platform for the design and administration of data warehousing applications. The tool includes an application development component and an administration component.

• Overview of the Informix SQL Warehouse Tool (Version 11.70)
• Overview of Informix Warehouse Feature (Version 11.50): You can use the Informix SQL Warehouse Tool to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.
• Using Informix for your Data Warehouse: This paper describes the components that are used to design and administer a data warehouse with the Informix SQL Warehouse Tool.
• Installation requirements (Version 11.70)
• Installation requirements for Informix Warehouse Feature (Version 11.50): These topics describe the hardware and software that you need before you use the Informix SQL Warehouse Tool. You must also have a database for metadata storage setup, and the proper authorizations.
• Installing the Informix SQL Warehouse Tool (Version 11.70)
• Installing Informix Warehouse Feature (Version 11.50): Learn about the installation requirements for the Informix SQL Warehouse Tool, installing the tool on multiple computers, and how to run the installation program.
• Configuring the Informix SQL Warehouse Tool (Version 11.70)
• Configuring Informix Warehouse Feature (Version 11.50): After you install the Informix SQL Warehouse Tool, you must configure the settings for security and user access, the services for logging and notifications, the database connections, and the system resources.
• "Get started with Informix Warehouse Feature, Part 1: Model your data warehouse using Design Studio (Version 11.50):" This tutorial introduces you to the Informix Warehouse feature and how to accomplish data warehousing using Informix. You will follow an imaginary business scenario, where the Informix Warehouse Feature is used to design and populate the new warehouse repository.
• "Get started with Informix Warehouse Feature, Part 2: Extract, load, and transform your data in Design Studio (Version 11.50):" This tutorial is the second part of the "Get started with Informix Warehouse Feature" series. You will learn about data and control flows, extracting, loading, and transforming (ETL) operators and design data flows. You will continue to use Design Studio to create and test the jobs for ELT data from various sources (typically, OLTP databases and external files) into the target warehouse repository on Informix.
• Transforming data (Version 11.70)
• Transforming data (Version 11.50): These topics describe how to use the Informix SQL Warehousing Tool Design Studio to simplify data transformation by designing and managing SQL warehousing applications.

Community

These links provide access to community sites, forums, blogs, etc. for Informix.

• Informix Community: These topics link to many Informix community sites, including the International Informix Users Group (IIUG), the Informix Exchange, forums and wikis, and blogs.
• Informix Chat with the Lab series: Check this website regularly to find the latest Informix webcasts about useful topics such as tuning and exploiting new features.
• Informix on Facebook: Become a fan of Informix on Facebook and see news, announcements, and event photos.

Send Feedback

Use these links to send comments to IBM about the product and documentation.

• Send documentation feedback: We welcome your feedback about any of the books, online help, wizards, or information center topics for Information Management products. Your comments are sent to the authors to help improve IBM product information.