Lecture 6B - The Need For Data Warehouse

Question 0

Encountered constraints

Answer 0

1. IT receives too many ad hoc requests
2. IT receives too many changes to ad hoc requests
3. The moment users realize that they can extract information, doomsday happens
4. Reports are very IT personnel dependent
5. Very rigid report environment

Question 1

Characteristics of a strategic information

Answer 1

T- timely
A- accessible 
C- credible 
I- integrated
D- data integrity

Question 2

Data warehouse is an informational environment that;

Answer 2

1. Provides an integrated and total view of the enterprise
2. Makes the enterprises current and historical information easily available for strategic decision making
3. Makes decision-support transactions possible without hindering operational systems.
4. Renders the organization’s information consistent.
5. Presents a flexible and interactive source of strategic information.

Question 3

Characteristics of a data warehouse

Answer 3

1. Ideal environment for data analysis and decision support
2. Fluid, flexible and interactive
3. 100% user driven
4. Very responsive and conducive to the ask-answer-ask again pattern
5. Discovers answer to complex, unpredictable questions

Question 4

Decision support system

Answer 4

1. Ad Hoc reports
2. Special extract programs
3. Small application
4. Information center
5. Decision support system
6. Executive information system