Posted by Jeffery Bridges on September 18, 2001 at 22:56:29:

In Reply to: Datawarehouse performance issues posted by Patterson on September 18, 2001 at 10:34:51:

The following article titled:

Realizing the Strategic Value of Data Warehousing

seems to relate to the specific issues that you have listed. It provides a strategic framework for understanding what are the potential failures in data warehouse implementation initiatives, discusses what 'typical' data warehouse failure projects entail, and suggests a 5-step process for approaching data warehousing to avoid the key failures:

1.Align The Data Warehouse With The Business Objectives.

2.Create A Business Driven Information Architecture.

3. Be Focused—Build The Foundation In A Modular Fashion.

4.Create Dynamic Data Marts.

5.Manage Expectations About Data Quality And Compromise.

Overall, it provides a strategic framework that is an alternative to the "build everything and users will come" approach to data warehouse construction to preempt the key potential failures.

The framework could be used for defining the more micro level issues, some of which you have listed in your message.

You may try to check up the relevant specific literatures for each of the micro issues to review the currently available metrics and adapt them to your specific needs in congruence with the overall framework.
For instance, there are specific metrics on 'data integrity' in literature on databases, similarly there are existing metrics on connectivity uptime and on-time delivery which you will find often spelt out in the SLAs (service level agreements) that define many IT infrastructure outsourcing contracts.

• Realizing the Strategic Value of Data Warehousing

---

Follow Ups:

• Re: Datawarehouse performance: Walking the Talk Jeffery Bridges 09:30:23 09/19/01 (1)
  • Re: Datawarehouse performance: Walking the Talk Martyn R Jones 05:35:26 09/20/01 (0)
• Bill Inmon - rehashed one more time Martyn R Jones 04:07:03 09/19/01 (0)

---

Click Here to Post Follow Up in New Forums

    Knowledge Management Think Tank (New)

  

 Subject: 

Message: