COMPUTERWORLD & Atre Associates
S p e c i a l A d v e r t i s i n g S u p p l e m e n t
A Visual Tool to
Data Warehouse
Implementation
Data Warehouse/
Data Mart Navigator
step 1
Determine Users'
Needs
• Does the company
need a
data
warehouse... or eve
n a data
mart?
• What are the busin
ess obje
ctives?
• Where do I get the
data fro
m?
• Perform cost/ben
efit
analysis, project
estimation and ri
sk
assessment.
step
12
De
plo
ym
ent
& S
yste
ms M
anag
ement
Ho
w c
an
I p
rov
ide
secu
rity, b
ackup
,
rec
ove
ry a
nd
the
nec
essa
ry
ca
pab
iliti
e
s fo
r a p
rodu
ction
da
ta w
are
hou
se o
r dat
a mart
?
• H
ow
ca
n re
sou
rces
be
allo
cat
e
d b
est?
• H
ow
c
an
the
grow
th
of t
he
dat
a be
acc
o
mm
oda
ted?
• H
ow
can
every
-
thin
g b
e ke
pt
run
nin
g
sm
oot
hly?
st
ep
11
On
lin
e A
na
lyt
ic
al
Pr
oc
es
sin
g (
OL
AP
)
• H
ow
ca
n u
se
rs
an
aly
ze
the
da
ta?
• H
ow
ca
n t
he
ne
ce
ss
ar
y n
um
be
r
of
di
me
ns
ion
s b
e d
ete
rm
ine
d?
• H
ow
ca
n
us
er
s s
ee
the
da
ta
re
pr
es
en
te
d i
n m
ult
ipl
e
di
m
en
si
on
s?
• H
ow
ca
n t
he
y u
se
th
e
OL
AP
to
ols
?
st
ep
10
Da
ta
M
in
in
g
Ho
w
do
If
in
d
pa
tte
rn
s
in
th
e
da
ta
?
•H
ow
ca
n
th
os
e
pa
tte
rn
s
be
us
ed
fo
rr
ev
en
ue
gr
ow
th
?
•H
ow
ca
n
to
ol
s
be
us
ed
to
fu
rth
er
id
en
tif
y
th
e
da
ta
w
ar
eh
ou
se
or
da
ta
m
ar
t?
ste
p
9
Pro
tot
yp
ing
,Q
ue
ryin
g
&
Re
po
rtin
g
•
Us
e
qu
ery
an
d
re
po
rtin
g
too
ls?
•D
ev
elo
p
ap
plic
atio
ns
?
us
er
inv
olv
em
en
t?
•
Im
ple
m
en
ta
pro
toty
pe
w
ith
Ho
w
do
I:
step
8
Det
erm
ine
Mid
dlew
are
Con
necti
vity
•
Dir
ect
data
acc
ess
•
On
goin
g c
onn
ectio
n
wa
reh
ous
e o
r da
ta m
art?
dat
a t
o th
e ta
rge
t da
ta
Ho
w
d
o I
con
nec
t the
sou
rce
step 7
Transfo
rmation,
Transportatio
n, Population
or data
mart.
• Pop
ulate th
e data wareh
ouse
• Tra
nsport
the data.
• Tra
nsform
the data.
ware
house
or data mart?
How
do I bu
ild the data
step
6
Data Ac
quisi
tion
& Cl
ean
s
ing
data m
art?
for the
data
war
eho
use
or t
he
data fro
m va
r
ious
sou
rce
s
• Aggreg
ate
• Summa
rize
• Reconc
ile
• Cleans
e
• Scrub
• Extract
How do I
:
ste
p 5
Co
ns
tru
ct
the
M
et
ad
at
a R
ep
os
ito
ry
me
tad
at
a
re
po
sit
or
y.
us
er
’s
vie
w
of
th
e
• D
ete
rm
in
e t
he
bu
sin
es
s
• B
uil
d a
re
po
sit
or
y.
ac
ce
ss
ed
?
it a
nd
ho
w
it
ca
n b
e
wh
at,
wh
o c
an
ac
ce
ss
tra
ck
of
wh
a
t m
ea
ns
Ho
w
do
I k
ee
p
step
2
Dete
rmin
e D
BM
S S
erv
e
r P
latf
orm
• W
hich
data
base
serv
ers
d
o w
e
alrea
dy h
ave?
• De
term
ine
cost
, inte
ro
pera
-
ability
and
staff
train
i
ng
cons
idera
tion
s.
• De
term
ine
DBM
S
serv
er
platfo
rm
base
d
on
Retu
rn
on In
vestm
ent
(R
OI)
ste
p
3
De
ter
m
ine
Ha
rdw
are
Pla
tfo
rm
W
he
re
sh
ou
ld
the
da
ta
w
are
ho
us
e
or
da
ta
m
art
be
ho
us
ed
?
•
W
hic
h
ha
rdw
are
pla
tfo
rm
s
do
w
e
alr
ea
dy
ha
ve
?
•
De
ter
m
ine
co
sts
,in
ter
op
er-
ab
ility
an
d
sta
fftr
ain
ing
co
ns
ide
rat
ion
s.
•
De
ter
m
ine
ha
rdw
are
ba
se
d
on
Re
tur
n
on
Inv
es
tm
en
t(R
OI)
.
ste
p
4
In
fo
rm
ati
on
&
Da
ta
M
od
eli
ng
Bu
ild
ing
an
In
fo
rm
atio
n
M
od
el
•
Ho
w
do
Iu
se
a
da
ta
m
od
el
to
ex
pre
ss
re
lat
ion
sh
ips
be
-
tw
ee
n
th
e
da
ta
?
•R
es
olv
e
ac
ce
ss
an
d
us
ag
e
iss
ue
s.
•D
ete
rm
ine
th
e
log
ica
l
an
d
ph
ys
ica
ld
es
ign
of
th
e
da
ta
w
are
-
ho
us
e
or
da
ta
m
art
.
Special Fold-out Poster
Presented by:
Developed by:
Sponsored by:
COMPUTERWORLD
The Newsweekly for IT Leaders
Atre Associates, Inc.
Leading Data Warehouse/Data Mart Consultants
step 1
Determine Users'
Needs
• Does the company
need a
data
warehouse... or eve
n a data
mart?
• What are the busin
ess obje
ctives
?
• Where do I get the
data fro
m?
• Perform cost/ben
efit
analysis, project
estimation and
risk
assessment.
ste
p 1
2
De
plo
ym
ent
& S
yste
ms M
anag
ement
Ho
w
ca
n I
pro
vide
sec
urity
, bac
kup,
rec
ov
ery
and
the
nec
essa
ry
ca
pa
bili
ties
for
a pr
oduc
tion
da
ta
wa
reh
ous
e or
data
mart?
• H
ow
can
res
ourc
es be
all
oc
ate
d b
est?
• H
ow
can
the
grow
th
of
the
dat
a be
ac
com
mo
date
d?
• H
ow
can
ever
y-
thi
ng
be
kept
run
nin
g
sm
oot
hly?
s
te
p
11
O
nl
in
e
A
na
ly
tic
al
Pr
oc
es
si
ng
(O
LA
P)
•
H
ow
ca
n
us
er
s
an
al
yz
e
th
e
da
ta
?
•
H
ow
ca
n
th
e
ne
ce
ss
ar
y n
um
be
r
of
di
m
en
si
on
s
be
de
te
rm
in
ed
?
•
H
o
w
ca
n
us
er
s
se
e
th
e
da
ta
re
p
re
se
nt
ed
in
m
ul
tip
le
di
m
en
si
on
s?
•
H
o
w
ca
n
th
ey
us
e
th
e
O
LA
P
to
ol
s?
st
e
p
10
D
a
ta
M
in
in
g
H
o
w
d
o
I
fi
n
d
p
a
tt
e
rn
s
in
th
e
d
a
ta
?
•
H
o
w
c
a
n
th
o
se
p
a
tt
e
rn
s
b
e
u
se
d
fo
r
re
ve
n
u
e
g
ro
w
th
?
•
H
o
w
c
a
n
to
o
ls
b
e
u
se
d
to
fu
rt
h
e
r
id
e
n
ti
fy
p
a
tt
e
rn
s
in
th
e
d
a
ta
w
a
re
h
o
u
se
o
r
d
a
ta
m
a
rt
?
st
ep
9
P
ro
to
ty
p
in
g,
Q
ue
ry
in
g
&
R
ep
or
tin
g
•
U
se
q
u
e
ry
a
n
d
re
p
or
tin
g
to
ols
?
•
D
e
ve
lo
p
a
p
p
lic
a
tio
ns
?
u
se
r
in
vo
lv
e
m
e
n
t?
•
Im
p
le
m
e
n
t
a
p
ro
to
ty
p
e
w
ith
H
o
w
d
o
I:
s
tep
8
De
ter
m
ine
M
idd
lew
are
Con
nec
tivity
•
Dir
ec
t d
ata
ac
ces
s
•
On
go
ing
co
nn
ect
ion
w
are
ho
us
e
or
da
ta
ma
rt?
da
ta
to
the
tar
ge
t da
ta
H
ow
do
I c
on
ne
ct th
e
sou
rce
step 7
Transf
ormatio
n, Transporta
tion, Population
or data
mart.
• Pop
ulate th
e data wareh
ouse
• Tra
nsport
the data.
• Tra
nsform
the data.
ware
house
or data mart?
How
do I bu
ild the data
step
6
Data A
cquis
ition
& C
lean
sing
data m
art?
for the
data
war
eho
use
or t
he
…data f
rom v
ario
us s
our
ces
• Summ
arize
• Aggreg
ate
• Recon
cile
•
Scrub
• Clean
se
• Extrac
t
How do
I…
st
ep
5
Co
ns
tru
ct
th
e
M
et
ad
at
a
Re
po
si
to
ry
m
et
ad
at
a
re
po
si
to
ry
.
us
er
’s
vi
ew
of
th
e
•
De
te
rm
in
e
th
e
bu
si
ne
ss
•
Bu
ild
a
re
po
si
to
ry
.
ac
ce
ss
ed
?
it a
nd
ho
w
it
ca
n
be
w
ha
t,
w
ho
ca
n
ac
ce
ss
tra
ck
of
w
ha
t m
ea
ns
Ho
w
do
I k
ee
p
ste
p
2
Dete
rmin
e D
BM
S
Se
rve
r P
lat
fo
rm
• W
hich
da
tab
ase
ser
ver
s d
o
w
e
alr
ead
y ha
ve?
• D
eter
mi
ne
cos
t, in
tero
pe
ra-
abilit
y a
nd
sta
ff tr
ain
ing
con
side
ratio
ns.
• D
e
term
ine
DB
M
S
se
rve
r
pl
atfo
rm
bas
ed
on
Re
tur
n
on
Inve
stm
en
t (R
OI)
ste
p
3
D
ete
rm
in
e
H
ar
dw
ar
e
P
la
tfo
rm
W
he
re
sh
o
u
ld
th
e
d
a
ta
w
a
re
h
o
u
se
or
da
ta
m
a
rt
b
e
h
o
u
se
d
?
•
W
hic
h
ha
rd
w
ar
e
pl
at
fo
rm
s
do
w
e
a
lre
a
d
y
h
a
ve
?
•
D
et
er
m
in
e
co
st
,
in
te
ro
p
e
r-
ab
ilit
y
a
n
d
sta
ff
tra
in
in
g
co
ns
id
e
ra
tio
n
s.
•
D
et
e
rm
in
e
h
a
rd
w
a
re
ba
se
d
on
R
e
tu
rn
o
n
In
ve
stm
en
t
(R
O
I).
st
e
p
4
In
fo
rm
a
tio
n
&
D
a
ta
M
o
d
e
lin
g
B
u
ild
in
g
a
n
In
fo
rm
a
tio
n
M
o
d
e
l
•
H
o
w
d
o
I
u
se
a
d
a
ta
m
o
d
e
lto
e
xp
re
ss
re
la
tio
n
sh
ip
s
b
e
-
tw
e
e
n
th
e
d
a
ta
?
•
R
e
so
lv
e
a
c
c
e
ss
a
n
d
u
sa
g
e
is
su
e
s.
•
D
e
te
rm
in
e
th
e
lo
g
ic
a
l
a
n
d
p
h
ys
ic
a
ld
e
sig
n
o
f
th
e
d
a
ta
w
a
re
-
h
o
u
se
o
r
d
a
ta
m
a
rt.
© 1997, Atre Associates, Inc. Note: Product listings are not intended to be exhaustive. Products listed are merely representati
ve of their respective categories. The Data W
arehouse Navigator is a trademark of Computerworld, Inc.
COMPUTERWORLD
The Newsweekly for IT Leaders
Leading Data Warehouse/Data Mart Consultants
http://www.atre.com
Presented by:
Atre Associates, Inc.
Developed by:
®
For
add
itio
na
l co
pie
s o
f th
is p
ost
er,
ple
ase
ca
ll 1
(8
00
) 5
44
-7
33
7.
Navigator
Determine Users' Needs
Relational Data:
❑ Cincom Systems SUPRA (Tbytes)
❑ Computer Associates Int'l
OpenIngres
(Tbytes)
❑ IBM DB2 Products (Tbytes)
❑ Informix
Informix
(DSA)
(Tbytes)
❑ NCR Teradata RDBMS (Tbytes)
❑ Oracle Corp. Oracle (Tbytes)
❑ Sybase System11 & IQ (Tbytes)
❑ Tandem NonStop SQL (Tbytes)
❑ Other _______________
Legacy Data:
❑ Cincom Systems TOTAL
❑ Computer Associates Int'l
CA-IDMS, CA-Datacom
❑ Computer Corp. of America
MODEL-204
❑ Digital Equipment Corp.
RMS
(Gbytes)
❑ IBM IMS, VSAM, SAM
❑ Information Builders FOCUS
❑ Oracle/Digital Equipment Corp.
Rdb
(Gbytes)
❑ Software AG ADABAS
❑ Other _______________
Groupware:
❑ IBM/Lotus Notes
❑ Microsoft Exchange
❑ Novell Groupwise
❑ Other _______________
Other Sources:
❑ Dow Jones
❑ Image Data
❑ Internet
❑ NCR Business Discovery,
Information
Discovery
❑ Newsfeeds
❑ Other _______________
Determine Hardware Platform
MVS-Based or Midrange:
❑ DEC VAX
❑ IBM, AS/400
❑ Other _______________
Unix-Based:
❑ Data General
❑ Hewlett-Packard
❑ IBM
❑ NCR WorldMark Series
❑ Sequent Computer Systems
❑ Siemens Pyramid
❑ Silicon Graphics
❑ Sun Microsystems
❑ Unisys
❑ Other _______________
Windows/Windows NT- & Intel-Based:
❑ DEC Alpha
❑ IBM and Compatibles
❑ NCR WorldMark Series
❑ Other _______________
Disk Storage:
❑ EMC Corp.
(Disk Array with RAID)
❑ IBM (Adstar Distributed
Storage
Manager)
❑ Storage Computer Corp.
❑ Storage Technology
(Iceberg)
❑ Other _______________
Information & Data Modeling
Data Modeling:
❑ Cayenne Software
Groundworks
Terrain
❑ Hyperion Analyst
❑ LBMS Systems Engineer,
Process
Engineer
❑ Logic Works
ERwin,
BPwin
❑ NCR Application
Transaction
Modeling
❑ Oracle Corp. Designer/2000
❑ Popkin Software System Architect
❑ Powersoft/Sybase S-Designor
❑ SILVERRUN Technologies, Inc.
SILVERRUN
❑ Other _______________
Determine DBMS Server Platform
Relational DBMS:
❑ Computer Associates Int'l
OpenIngres (Tbytes)
❑ IBM DB2 Products (Tbytes)
❑ Informix
Informix
(DSA)
(Tbytes)
❑ Microsoft Corp.
SQL Server (Gbytes)
❑ NCR Teradata Scalable Data
Warehouse
(Tbytes)
❑ Oracle Corp.
Oracle (Tbytes)
❑ Red Brick
Warehouse
(Tbytes)
❑ Sybase
System11
&
IQ
(Tbytes)
❑ Tandem
NonStop SQL (Tbytes)
❑ Other _______________
Relational Parallel Server:
❑ IBM DB2 Parallel Edition
❑ Informix Informix OnLine
Extended Parallel Server (XPS)
❑ NCR Teradata RDBMS
❑ Oracle Corp.
Parallel Server Option (PSO)
❑ Red Brick
Warehouse VPT and xPP
❑ Sybase MPP Server
❑ Tandem NonStop SQL/MP
❑ Other _______________
Multidimensional Databases (MDD):
❑ Arbor Software Essbase
❑ Gentia Software GentiaDB
❑ Holistic Systems Holos
❑ Hyperion Enterprise
❑ Kenan Technologies
Acumate
ES
❑ Pilot (The Cognizant Corp.)
Pilot Analysis Server
❑ SAS Institute System Basic
❑ Other _______________
Construct Metadata Repository
❑ Carleton Passport, MetaCenter
❑ Evolutionary Technologies Int'l
(ETI)
Metadata Exchange Library
❑ Hewlett-Packard
Intelligent
Warehouse
❑ IBM DataGuide/2
❑ Intellidex Metadata Manager
❑ Platinum Technology
PR/MVS Open Edition
Environment,
DataShopper
❑ Prism Solutions
Dictionary
Manager
❑ R&O Rochade Repository
❑ Other _______________
Data Acquisition & Cleansing
❑ Carleton Passport
❑ Evolutionary Technologies
Int'l
(ETI) Extract Tool Suite
❑ Informatica PowerMart
❑ Information Builders
EDA/Copy
Manager
❑ NCR Teradata RDBMS
Fast
Load/Multi-load
❑ Platinum Technology
InfoRefiner
❑ Prism Solutions Warehouse
Manager,
Change
Manager
❑ QDB Solutions (Prism Solutions)
Prism Quality Manager
❑ SAS Institute SAS System
❑ Software AG Natural,
Natural
Construct
❑ Other _______________
Address Cleansing:
❑ Apertus Technologies
Enterprise/Integrator,
Enterprise/Access
❑ Group 1 Software NADIS, LSF
❑ Harte-Hanks Data Technologies
Trillium Software System
❑ Postalsoft Library Products
❑ Vality Technology
Integrity Data Reengineering Tool
❑ Other _______________
Data Transformation, Transportation & Population
❑ Carleton Passport
❑ Computer Associates Int'l
CA-OpenIngres
Replicator,
XCOM
❑ DB Star Migration Tool Suite
❑ Hyperion Analyst
❑ IBM DataPropagator
(Relational
&
Non-Relational)
❑ IBM/Lotus Notes Pump
❑ Informatica PowerMart
❑ Intersolv DataDirect,
SmartData
❑ NCR Teradata RDBMS
Fast
Load/Multi-load
❑ Oracle Corp.
Symmetric
Replication
❑ Platinum Technology
InfoPump,
InfoTransport
❑ Praxis OmniReplicator
❑ Prism Solutions
❑ Sagent Technology, Inc.
Data
Mart
Server
❑ SAS Institute SAS System
❑ Smart Corp.
The SMART DB Workbench
❑ Sterling Software
CONNECT:Direct
❑ Sybase
Replication
Server
❑ VMark Software HyperStar
❑ Other _______________
Determine Middleware Connectivity
❑ Computer Associates Int'l
CA-LDM,
XCOM
❑ Cross Access Corp.
Data Delivery System
❑ Information Builders
EDA/SQL
❑ NCR TOP END
❑ NCR Teradata Database Query Mgr.
❑ Oracle Corp. SQLNet
❑ Sybase Enterprise Connector
❑ Software AG SourcePoint
❑ Other _______________
Deployment & Systems Management
❑ Computer Associates Int'l
CA-UniCenter
❑ Hewlett-Packard
Intelligent
Warehouse
❑ NCR TOP END, LifeKeeper
& Teradata RDBMS Tools
❑ Tivoli
Management Environment (IBM)
❑ Other _______________
Data Mining
❑ Angoss KnowledgeSEEKER
❑ ASA DB Profile
❑ Data Mind Corp.
Data
Mind
Professional
❑ Epsilon Data Management EQL
❑ Group 1 Software Model Max,
Smart Marketing Suite
❑ HyperParallel //Discovery
❑ IBM Intelligent Miner
❑ Information Discovery IDIS:3
❑ Integral Solutions Ltd Clementine
❑ NCR Knowledge Discovery
Workbench
(KDW)
❑ Pavilion Technologies
Process
Insights
❑ Pilot (The Cognizant Corp.)
Pilot Decision Support Suite
❑ SAS Institute Data Mining
❑ Silicon Graphics MineSet
❑ Other _______________
Prototyping, Querying & Reporting
Ad hoc Queries & Reports:
❑ Borland ReportSmith
❑ Cognos Power Play
❑ Crystal Reports (Seagate)
Crystal Info, Crystal Reports
❑ Hewlett-Packard
Information
Access
❑ Intersolv DataDirect Explorer
❑ NCR Management
Discovery
Tool
❑ Oracle Corp. Discoverer/2000
❑ Platinum Technology
InfoReports
❑ Sybase InfoMaker
❑ Other _______________
Advanced Queries & Reports:
❑ Andyne Computing GQL
❑ Brio Technology BrioQuery
❑ Business Objects
BusinessObjects
❑ Cognos Impromptu
❑ Computer Associates Int'l
CA-Visual
Express
❑ Information Builders FOCUS
❑ IQ Software Intelligent Query
❑ Platinum Technology
Forest & Trees
❑ SAS Institute SAS System
❑ Software AG Esperant
❑ Sterling Software
Vision:Clearaccess
Vision:Clearmanage
❑ Other _______________
Online Analytical Processing (OLAP)
OLAP:
❑ Axciom Market GEO
❑ Advanced Visual Systems
AVS
Express
❑ Andyne Computing PaBLO
❑ Business Objects
BusinessObjects
❑ Cognos Impromptu, PowerPlay
❑ Comshare Commander
❑ Dimensional Insight
CrossTarget,
DataFountain
❑ Gentia Software GentiaDB
❑ Holistic Systems Holos
❑ Hyperion Analyst, Enterprise
❑ IBM Intelligent Decision Server,
ShowCase
Vista
❑ IQ Software IQ/Smart Server
❑ Kenan Technologies Acumate
❑ MapInfo MapInfo Desktop
❑ MathSoft Rainier
❑ NCR Management
Discovery
Tool
❑ NetCube Cube Tech
❑ Oracle Corp.
Express Objects, Express Analyzer
❑ Pilot (The Cognizant Corp.)
LightShip
Professional
❑ SAS Institute Application System,
EIS,
Visualization
Analytical
Object
Server
❑ Other _______________
ROLAP (Relational OLAP):
❑ Information Advantage
DecisionSuite
❑ Informix MetaCube
❑ MicroStrategy
DSS Agent, DSS Executive,
DSS Server, DSS Architect,
DSS
Web
❑ Platinum Technology
InfoBeacon
❑ Other _______________
Navigator
T H E
http://www.ncr.com
Data Warehouse/Data Mart
Data Warehouse/Data Mart
1
5
9
12
Determine
Users’ Needs
Data Warehouse/Data Mart Sequencing Chart
DBMS
Platform
Hardware
Platform
Data
Modeling
Metadata
Repository
Data Acquisition
& Cleansing
Transformation,
Transportation, Population
Middleware
Connectivity
Prototyping,
Querying & Reporting
Data
Mining
Online Analytical
Processing (OLAP)
Deployment &
Systems Management
Data
Mining
2
3
4
6
7
8
10
11
10
Wyszukiwarka
Podobne podstrony:
Domowa przyprawa warzywna id 14 Nieznany
EdM wzmacniacze for stud id 150 Nieznany
Dz U 2000 Nr 28 poz 346 id 14 Nieznany
Dz U 2005 nr 25 poz 202 id 14 Nieznany
dostepnosc farmaceutyczna id 14 Nieznany
DORADZANIE W SAMOLECZENIU id 14 Nieznany
drDubas produkcja biomasy id 14 Nieznany
dzwigar kratowy Model (3) id 14 Nieznany
Dyrektywa Rady 2000 76 WE id 14 Nieznany
dzielenie i laczenie kont id 14 Nieznany
dziewczynka z zapalkami 5 id 14 Nieznany
Druk Filozofia jakoci TQM id 14 Nieznany
Dyrektywa Rady 1999 13 WE id 14 Nieznany
dyzury zespol germanistow id 14 Nieznany
Dyrektywa PED 97 23 CE EN id 14 Nieznany
6 for prozniowe id 43632 Nieznany (2)
więcej podobnych podstron