Best practices for data warehousing environments

The best practice papers described in this section provide practical guidelines and techniques to help you use DB2® software efficiently in data warehousing environments.

Data warehousing environments are data management systems typically designed to optimize the performance of data analysis queries on large data repositories. The IBM® Smart Analytics System environment, which incorporates IBM InfoSphere® Warehouse software, DB2 Database for Linux, UNIX, and Windows software, and IBM Cognos® software, represents a best practice configuration of hardware and software for data warehousing environments. While many of the scenarios documented in the best practice papers referred in this section were extensively tested with the IBM Smart Analytics System software, they also apply to other product configurations.