Evaluation Of User Requirement Analysis Of Data Warehouse Design

1793 Words8 Pages
Evaluation of User Requirement Analysis in Data Warehouse Design
1.0 Introduction
A data warehouse (DW) can be acknowledged as one of the most complex information system modules available and it is a system that periodically retrieves and consolidates data from the sources into a dimensional or normalized data store. It is an integrated, subject-oriented, nonvolatile and a time-variant collection of data in support of management’s decisions (Inmon, 1993).
1.1 Data Warehouse Design Process
When considering the suggestions of various authors who are well known in the field, such as William Inmon and Ralph Kimball the DW design process can be divided into three main stages (Figure 1).

The first phase which is DW planning is aimed at determining the scope and the objectives of the DW. The second phase will be concentrating on individual data marts (DM) and will be repeated for each DM to be implemented. And according to the Figure 1, the second phase can be further divided into five distinct main phases. The final phase will focus on performance optimization and keeping the DW schema up-to-date. This paper will be focusing only on the requirement analysis phase.
In DW lifecycle, one of the most crucial phases that might affect all other phases of DW development is the Requirement Analysis phase. It is a process of collecting requirements from end user. The goal of this phase is to identify organizational objectives and elaborate requirements that could measure
Get Access