Bc5901 Assignment Satisfaction

The Data Warehousing Development Lifecycle

I.

Planning

A.

Select the Implementation Strategy

1.

Top Down Approach

2.

Bottom Up Approach

3.

Combination Approach

B.

Select the Development Methodology

1.

Structured Analysis & Design (Waterfall) Method

2.

Spiral Development Method

C.

Develop the Business Objectives

1.

What is the target market for the data warehouse?

2.

What are currently used or planned platforms?

3.

What are planned capabilities in terms of features and functions?

4.

What are the various data sources that can and/or must be integrated into the

data warehouse?

5.

When should the data warehouse become operational?

D.

Select an Initial Implementation Scope

1.

Typical dimensions for restricting scope:

a)

Number & Types of Department Served

b)

Number of Data Sources Selected

c)

Subset of Enterprise Model Selected

d)

Budget Allocated

e)

Time Allocated for 1st Project

2.

Dimensions can be broadly divided into two categories:

a)

Scope determined from the perspective of the business user of the
warehouse
(1)

Who are the departments that need to use the data warehouse

initially and for what purpose?

(2)

What are the range of business queries that must be initially

answered by the data warehouse?

b)

Scope determination based on technology considerations

(1)

What is the size of the data warehouse metamodel?

(2)

What is the size of data inside the data warehouse?

(3)

What are the input sources of data and how many are they?

(4)

How usable is the data from the data sources?

(5)

How well are the data sources documented?

(6)

What is the level of Integrated Management Facilities?

(7)

What is the availability of logical models and CASE tools?Is

there an Enterprise Data Model available?

(8)

Can existing skills and human resources be used?Will thedata warehouse be implemented on existing platforms or onplatforms similar to existing ones?

E.

Select an Architectural Approach

1.

Operational storage versus using copies of operational data

2.

Data warehouse only

3.

Data marts only

4.

Data warehouse and data marts

5.

Platform and infrastructure partitioning

6.

Two-tier client/server architecture

7.

Three-tier client/server architecture

F.

Build a Program and Project Plans Budget

Чтобы скрыть свою маленькую тайну. Стратмор сохранял спокойствие. - И что же это за секрет. - Вы отлично знаете это. Это «Цифровая крепость».

0 comments

Leave a Reply

Your email address will not be published. Required fields are marked *