With business and technology projects, or really any kind of project, there are always going to be those elusive aspects that seem minor but can help you trim cost and streamline the project. Maybe these pointers are simple, or familiar, but hopefully one of them will be something you have never heard or thought of.
Temper your users expectations of data warehouse performance.
Most users are accustomed to using the transaction processing system, which is designed for performance, or they use applications on their own PCs. A data warehouse does not work in the same fashion and the response time can vary. The amount of queries processed can vary by time of month and the number of users could grow suddenly as they become familiar with the warehouse functions. All these aspects can affect performance. If you prepare your users for these instances you can avoid expensive design modifications.
Use aggregate tables and partitioning to enhance query performance.
The simplest way to enhance performance is to learn how to use aggregate tables and partitioning. Combining data and dividing tables are the most common ways to enhance query performance. These are the things to try before you start upgrading software or hardware.
Sometimes the overuse of technology can make the data warehouse more complex than it needs to be.
The more technically stylish the data warehouse becomes the more chance that
Benjamin Vigil is a technical editor at SearchCRM's parent TechTarget.
This was first published in January 2002