Copy of 5

1
Data Warehousing Today Moving From Pilot to
Production
a presentation by W H Inmon
2
pilot
production
- the issue of size - management -
investment - usability - politics
3
pilot
it is absolutely normal for the initial iteration
of the data warehouse to be reshaped in many ways
- - volumes of data - structure of data
- granularity of data
4
pilot
data warehouse users operate in a mode of tell me
what I say I want then I can tell you what I
really want
when you build your pilot, your end users does
not know what they want
5
pilot
farmers
explorers
a few large queries
lots of small queries
6
the workload for explorers and farmers is mixed
in the pilot mode
7
why you can get away with lax management in the
pilot environment
pilot
small mixed workload
inexpensive processor with lots of capacity
small amounts of data
8
pilot
this world is getting ready to explode
9
pilot
the size of the work load will grow exponentially
10
pilot
queries that were bad in the pilot environment
are horrible in the production environment
11
pilot
what once were thought to be stable requirements
are found out to be incomplete and incorrect
requirements
12
pilot
the sheer volume of data grows - historical
data - summary/detail data - unknown data
13
pilot
with an increased workload there is an increasing
need to separate explorers and farmers
14
which way the pilot is going to go is anybodys
guess
15
there are some real dangers - - overrun
- response time inadequacy - not meeting users
requirements - inadequate technological
foundation - not understanding architecture
production
16
pilot
with a monitor you can see - - who is using
the system - what data they are using - how
big the queries are - when is the system being
used, etc.
17
pilot
what changes are there over time?
- changes in requests - changes in data used -
changes in size of requests - changes in farmers
and explorers - changes in requirements