Technical Guidelines for Successful Data Warehousing

The list of points below should provide a set of guidelines for the design, construction and management of a successful data warehouse in any environment.

Should not be built on a rigid model

• Just as your business plans change, your organisation and its data collection processes change
• Don't let your data warehouse be so inflexible that it can't deal with a new database or ERP

Should be able to grow rapidly ⁄ exponentially

• A successful data warehouse will grow to fill the needs of all who see the benefit of using it - you must expect it to grow
• Therefore the decision that was taken to build it on a PC initially may not be a long term solution
• Do not limit yourself to a single operating system or a language or database platform that only works in one operating system