What to Consider when choosing a Warehouse Solution?
The following diagram illustrates a process to follow in order to answer the question:
Business Requirements could be of three types:
- Business Subject Areas including better Campaign Management, increasing Product or Customer Profitability or improved Risk Management etc.
- Usage areas such as Standard reporting, analytical, business services, research
- Service levels on performance, availability, and timeliness of data
For example: With customers or campaigns the final benefits may be as follows:
Future Business Requirements
Why consider Future Business Requirements?
It is a more strategic approach to data warehousing. Tactical is often a way of deferring or avoiding responsibility for future costs and issues
- Increases potential to leverage upfront investment for future projects by
- Reducing time to delivery of future projects
- Reducing Incremental costs of future projects
- Reducing ongoing management costs
- Reducing the “stove pipe” effect (proliferation of data marts)
- Reduces disruption to warehouse for future projects
- Helps avoid choosing a warehouse now, that will not suit your needs in the future
- Helps avoid taking an implementation approach that will have to be re-implemented later wrt to areas such as ETL, Analytics or Security
Based on the Business Model
Warehouse functions define what users do to access and analyze information in the Warehouse
- Standard reporting
- Text Analytics
- Data Mining
- Web Services
Impact of Warehouse Functions
- Performance Impact
- Data Mining tends to be longer running activity
- OLAP tends to be driven by shorter directed queries
- In database ETL impacts resources (Batch vs Trickle Feed etc)
- Data Warehouse Packaging - edition to choose.
Warehouse OperationsWarehouse Operations focuses on Non Functional Requirements especially the following three:
- User workload
- Batch workload
- Warehouse trickle feed
- Initial data volume
- Incremental data volumes e.g. growth per year
- System Availability
- Disaster Recovery
What “System Availability” means is that the warehousing system meets business service levels for availability – it could be 99.9% within Standard Business Hours or as per your business’s definition. Several technology factors play a part in availability including Work load management i.e. Query response times, database availability both software and hardware and system upgrades. Consider all factors and choose simplest approach to achieve availability and also consider all levels of redundancy before making a choice.
Learn more in the coming weeks - stay tuned!!