ch05-thedataresource
TRANSCRIPT
-
7/25/2019 ch05-TheDataResource
1/19
E. Wainright Martin
Carol V. Brown
Daniel W. DeHayesJeffrey A. HofferWilliam C. Perkins
MANAGINGMANAGINGINFORMATIONINFORMATION
TECHNOLOGYTECHNOLOGYFIFH EDII!"
CHAPTER 5
THE DATA RESOURCE
-
7/25/2019 ch05-TheDataResource
2/19
2005 Pearson Prentie!Ha""
!
Or%ani&ations o'"( not )'ntion "on% *it#o'tritia" +'siness (ata
Cost to re$"ae (ata *o'"( +e ,er- #i%#
Ti.e to reoni"e inonsistent (ata .a- +e too "on%
Data o)ten nee(s to +e aesse( /'i"-
1HY MANAGE DATA
Page 135
-
7/25/2019 ch05-TheDataResource
3/19
2005 Pearson Prentie!Ha""
!
Page 135
Data .o(e"in%in,o",es4 Met#o(o"o%- or ste$s )o""o*e( to i(enti)-
an( (esri+e (ata entities Notation or a *a- to i""'strate (ata entities
%ra$#ia""-
TECHNICALASPECTS OF
MANAGING THE DATA RESOURCEData model6
o,era"" .a$ )or +'siness (ata nee(e( to e))eti,e"- .ana%e
t#e (ata
-
7/25/2019 ch05-TheDataResource
4/19
2005 Pearson Prentie!Ha""
!
Page 135
Entit-!re"ations#i$ (ia%ra. 8ERD9
Most o..on .et#o( )or re$resentin% a (ata .o(e" an(or%ani&ationa" (ata nee(s Ca$t'res entities an( t#eir re"ations#i$s
Entities6 t#in%s a+o't *#i# (ata are o""ete( Attri+'tes6 at'a" e"e.ents o) (ata t#at are to +e o""ete(
TECHNICALASPECTS OF
MANAGING THE DATA RESOURCEThe Data Model
-
7/25/2019 ch05-TheDataResource
5/19
2005 Pearson Prentie!Ha""
!
Page 135 Figure 5.1 Entity-Relationship Diagram
NOTE:#Entities are C$stomer% !r&er% an& Pro&$'t.#Attri($tes of the C$stomer entity 'o$l& (e
'$stomer last name% first name% street% 'ity% )
TECHNICALASPECTS OF
MANAGING THE DATA RESOURCEThe Data Model
-
7/25/2019 ch05-TheDataResource
6/19
2005 Pearson Prentie!Ha""
!
Page 13
Enter$rise .o(e"in% 8a $roess )o's9 To$!(o*n a$$roa# Desri+es or%ani&ation an( (ata
re/'ire.ents at #i%# "e,e" in(e$en(ent o)re$orts sreens or (etai"e( s$ei)iations
Not +iase( +- #o* +'siness o$erates to(a-
TECHNICALASPECTS OF
MANAGING THE DATA RESOURCEData Modeling
-
7/25/2019 ch05-TheDataResource
7/19 2005 Pearson Prentie!Ha""
!
Page 13
Enterprise !odeling "teps#
Di,i(e *or into .a
-
7/25/2019 ch05-TheDataResource
8/19 2005 Pearson Prentie!Ha""
!
Page 13
>ie* inte%ration 8a (ata o't$'t )o's9 ?otto.!'$ a$$roa# Ea# re$ort sreen )or. (o'.ent
$ro('e( )ro. (ata+ases )irst @ ea#a""e( a 'ser ,ie*
TECHNICALASPECTS OF
MANAGING THE DATA RESOURCEData Modeling
-
7/25/2019 ch05-TheDataResource
9/19
2005 Pearson Prentie!Ha""
!
Page 13
'ie( )ntegration "teps#
Create 'ser ,ie*s
I(enti)- (ata e"e.ents in ea# 'ser ,ie* an( $'t into astr't're a""e( a nor.a" )or.
Nor.a"i&e 'ser ,ie*s
Inte%rate set o) entities )ro. nor.a"i&ation into one (esri$tion
TECHNICALASPECTS OF
MANAGING THE
DATA
RESOURCE
Data Modeling
*ormali+ation6
$roess o) reatin% si.$"e (ata str't'res )ro. .ore o.$"eB
ones
-
7/25/2019 ch05-TheDataResource
10/19
2005 Pearson Prentie!Ha""
!
Page 13,
TECHNICALASPECTS OF
MANAGING THE
DATA
RESOURCE
Database Architecture
Dataase
s#are( o""etion o) "o%ia""- re"ate( (ata or%ani&e( to.eet nee(s o) an or%ani&ation
Dataase Ar%hite%ture6
*a- in *#i# t#e (ata are str't're( an( store( in t#e
(ata+ase
-
7/25/2019 ch05-TheDataResource
11/19
2005 Pearson Prentie!Ha""!
Page 13/
TECHNICALASPECTS OFMANAGING THE DATA RESOURCE
SiB +asi (ata+ase ar#itet'res4
Hierar#ia" 8to$!(o*n or%ani&ation9
2 Net*or 8#i%#!,o"'.e transation $roessin%9
3 Re"ationa" 8(ata arran%e( in si.$"e ta+"es9
7 O+
-
7/25/2019 ch05-TheDataResource
12/19
2005 Pearson Prentie!Ha""!
Page 130
TECHNICALASPECTS OFMANAGING THE DATA RESOURCE
A D?MS #e"$s .ana%e (ata +- $ro,i(in%se,en )'ntions4
Data stora%e retrie,a" '$(ate
2 ?a'$
3 Reo,er-
7 Inte%rit- ontro"
5 Se'rit- ontro"
: Con'rren- ontro"
; Transation ontro"
Tools for Managing Data
-
7/25/2019 ch05-TheDataResource
13/19
2005 Pearson Prentie!Ha""!
Page 130-12
TECHNICALASPECTS OFMANAGING THE DATA RESOURCE
Contains:
De)inition o) ea# entit-
re"ations#i$ an( (atae"e.ent
Dis$"a- )or.ats
Inte%rit- r'"es
Se'rit- restritions
>o"'.e an( si&es List o) a$$"iations t#at 'se
t#e (ata
Tools for Managing Data
Data Di%tionaryDire%tory 4DDD
entra" en-"o$e(ia o) (ata (e)initions an( 'sa%e
in)or.ation @ a (ata+ase a+o't (ata
-
7/25/2019 ch05-TheDataResource
14/19
2005 Pearson Prentie!Ha""!
Page 12
TECHNICALASPECTS OFMANAGING THE DATA RESOURCEDatabase Programming
6uery language
a 7 GL non$roe('ra" $ro%ra..in% "an%'a%e to o+tain
(ata )ro. a (ata+ase o)ten $ro,i(e( +- t#e D?MS
SQLquery language example:
"E7ECT 8RDER9: C;"T8!ER9: C;"T*A!E:
8RDER-DATE FR8! C;"T8!ER: 8RDER 21$25>
A*D C;"T8!ER.C;"T8!ER9 ?
8RDER.C;"T8!ER9
-
7/25/2019 ch05-TheDataResource
15/19
2005 Pearson Prentie!Ha""!
T#e nee( to .ana%e (ata is $er.anent
Data an eBist at se,era" "e,e"s
A$$"iation so)t*are s#o'"( +e se$arate )ro. t#e(ata+ase
A$$"iation so)t*are an +e "assi)ie( +- #o* t#e-treat (ata
Data a$t're
2 Data trans)er
3 Data ana"-sis an( $resentation
MANAGERIAL ISSUES IN
MANAGING
DATA
Page 12
Principles in Managing Data
-
7/25/2019 ch05-TheDataResource
16/19
2005 Pearson Prentie!Ha""!
Page 1$ Figure 5.
-
7/25/2019 ch05-TheDataResource
17/19
2005 Pearson Prentie!Ha""!
MANAGERIAL ISSUES IN
MANAGING
DATA
Page 1
The Data Management Process
Figure 5. Asset !anagement Fun%tions
-
7/25/2019 ch05-TheDataResource
18/19
2005 Pearson Prentie!Ha""!
Data Administration
Page 152
e- )'ntions o) t#e (ata a(.inistration %ro'$4
Promote and control data sharing
Analyze the impact of changes to application systems when data definitions change
Maintain the data dictionary Reduce redundant data and processing
Reduce system maintenance costs and improve system development productivity
Improve quality and security of data
Insure data integrity
MANAGERIAL ISSUES IN
MANAGING
DATA
-
7/25/2019 ch05-TheDataResource
19/19
2005 Pearson Prentie!Ha""
Data Administration
Page 152-151
e- )'ntions o) t#e (ata+ase a(.inistrator 8D?A94
T'nin% (ata+ase .ana%e.ent s-ste.s
Se"etion an( e,a"'ation o) an( trainin% on (ata+ase te#no"o%-
P#-sia" (ata+ase (esi%n
Desi%n o) .et#o(s to reo,er )ro. (a.a%e to (ata+ases
P#-sia" $"ae.ent o) (ata+ases on s$ei)i o.$'ters an( stora%e (e,ies
T#e inter)ae o) (ata+ases *it# te"eo..'niations an( ot#er te#no"o%ies
MANAGERIAL ISSUES INMANAGING DATA