a presentation

1
a presentation by W H Inmon
rtm001
2
prior to data warehousing there was a world of
transaction processing systems
this world took 25 years to build and is
called the legacy systems environment. It
was built to optimize - - the capture of data
- the storage of data - the online access of
data
rtm002
3
there were several problems with the legacy
environment
legacy environment
- data was not integrated - there was no
historical data - there was no summary data
rtm002
4
- in order to run my business properly, I need -
- integrated data - historical data - detailed
and summary data
rtm002
5
thus borne was the notion of the data warehouse
oper
DSS
rtm002
6
1990
data warehouse today
oper
DSS
dss applications
data mart
edw
ex wh
I/t
ODS
data mining wh
near line/ secondary storage
7
rtm004
8
automated creation of code
rtm006
9
getting ERP data into a data warehouse
I/t
rtm006
10
- integrated data - granular data - historical
data - corporate data - the basis for
reconciliation - large volumes
rtm007
11
the edw grows in size and in cost
rtm007
12
an office building without a foundation
rtm007
13
edw
appl
DSS
the ODS serves to integrate legacy
applications and to provide a basis for
operational DSS processing
rtm008
14
the feedback loop into the ODS from the edw is an
important feature creating a class IV ODS
rtm008
15
activity monitor
cross media data manager
near line/ secondary storage
by extending data to near line/secondary storage,
the costs of the warehouse environment are
decreased dramatically and the capacity is
extended to infinity
rtm010
16
exploration warehouse
very ad hoc queries
in memory technology
with an exploration warehouse - - the cost of
exploration drops dramatically - the speed of
exploration accelerates - the capabilities of
exploration increase exponentially
rtm013
17
data mining warehouse
exploration warehouse
data mining warehouse
rtm013
18
multiple enterprise data warehouses
rtm015
19
- crm - eCommerce - ERP
the foundation of dss applications is a data
warehouse
rtm015
20
data marts
- OLAP - multi dimensional
data mart
star join structures
rtm015