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.