CR
Fase
Act!"a" "e P#$%ect$
1. ANALIZAR LA INFRAESTRUCTURA Fase 1: ANÁLISIS TECNOLÓGICA TECNOLÓGICA DE BASE BASE DE DATOS REQUERIDA POR LA ORGANIZACIÓN.
Pla!+car la c$!+&#rac%! (el sste,a ,a!ea($r (e base (e (at$s. Fase -: PLANEACIÓN Desarr$llar la base (e (at$s c$! s#s $bet$s c$!+&#rac%! (e ac#er($ al )la! re'#er,e!t$s (e la $r&a!*ac%!.
N$&'#e "e (a act!"a" "e a)#e*"+a,e
AA1 - Establecer la !"raestr#ct#ra tec!$l%&ca re'#er(a )$r la $r&a!*ac%!
AA -Establecer l$s sste,as ,a!ea($res (e base (e (at$s.
AA/ - I(e!t+car t0c!cas (e !tel&e!ca (e !e&$c$s (e a ac#er($ c$! l$s re'#er,e!t$s (e la $r&a!*ac%!
AA2 - Crear la base (e (at$s (e ac#er($ al )la! re'#er,e!t$s (e la $r&a!*ac%!.
DE ACUERDO CON LOS REQUERI5IENTOS DE LA ORGANIZACIÓN 2. ESTABLECER LOS NI3ELES DE SER3ICIO
AA7 REALIZAR ACTI3IDADES DE RESGUARDO8 RESTAURACIÓN 4
ESTANDARES 4 REQUERI5IENTOS DE LA ORGANIZACIÓN
CONTINGENCIAS DE ACUERDO A LOS PLANES ESTABLECIDOS AA9 REALIZAR ACTI3IDADES DE SINCRONIZACIÓN DE ACUERDO A LOS REQUERI5IENTOS DE LA ORGANIZACIÓN
AA: -ESTABLECER NI3ELES DE SER3ICIO DE ACUERDO CON LOS REQUERI5IENTOS DE LA ORGANIZACIÓN
Fase 3: EJECUCIÓN 6. DESARROLLAR 5ANTENI5IENTO PRE3ENTI3O8 CORRECTI3O O PROACTI3O PARA GARANTIZAR NI3ELES DE SER3ICIO REQUERIDOS POR LA ORGANIZACIÓN
AA; APLICAR T
AA1= RE3ISAR EL CO5PORTA5IENTO 4 EL FUNCIONA5IENTO DE LAS BASES DE DATOS
AA11 CONFIR5AR EL CU5PLI5IENTO POL?TICAS DE SEGURIDAD
7> EFECTUAR ACCIONES AA1 APLICAR ACCIONES DE PROTECCIÓN DE PROTECCIÓN A LA A LA BASE DE DATOS Fase .: E/ALUACIÓN E/ALUACIÓN BASE DE DATOS DATOS
AA1/ PRODUCIR DOCU5ENTACIÓN T
ONOG ON OGRA RAMA MA ES ESPE PECI CIAL ALIZ IZAC ACIÓ IÓN N TEC TECNO NOL LÓG ÓGIC ICA A EN EN GES GESTI TIÓN ÓN Y SEG SEGUR URID IDAD AD DE B
Res0(ta"$ "e a)#e*"+a,e
c$&)ete*ca
I(e!t+car la !"raestr#ct#ra tec!$l%&ca (s)#esta e! el ,a!e$ (e las bases (e (at$s )ara (eter,!ar las a,e!a*as @#l!erabl(a(es $bet$ (e la se&#r(a( (e la !"$r,ac%!.
Da&!%stc$ Da&!%stc$ (el !@el (e se&#r(a( (e la !"$r,ac%! (e ac#er($ c$! las !$r,as !ter!ac$!ales !ter!ac$!ales el $bet$ (e !e&$c$.
Pla!ear l$s )r$ces$s (e !stalac%! c$!+&#rac%! (el sste,a ,a!ea($r (e base (e (at$s8 la rec#)erac%! a!te (esastres !"$r,tc$s (e ac#er($ c$! el )r$ce(,e!t$ s#&er($ )$r el "abrca!te8 las )$ltcas las !eces(a(es es)ec+cas (e la $r&a!*ac%!. $r&a!*ac%!.
A(,!strac%! (e las Bases (e Dat$s &ara!t*a!($ la !te&r(a(8 (s)$!bl(a( cal(a( (e l$s (at$s.
Crear la base (e (at$s c$! s#s $bet$s a )artr (e la ar'#tect#ra (e+!(a c$!"$r,e a l$s re'#er,e!t$s (e la $r&a!*ac%!.
A(,!strac%! (e las bases (e (at$s &ara!t*a!($ la !te&r(a(8 (s)$!bl(a( cal(a( (e l$s (at$s.
Eec#tar tareas (e ,&rac%!8 s!cr$!*ac%!8 res)al($ (e las bases (e
A(,!strac%! (e las bases (e (at$s
(at$s e !tel&e!ca (e !e&$c$s (e ac#er($ c$! las !eces(a(es (e la $r&a!*ac%!
&ara!t*a!($ &ara!t*a!($ la !te&r(a(8 (s)$!bl(a( (s)$!bl(a( cal(a( (e l$s (at$s.
Gest$!ar l$s !c(e!tes )rese!ta($s e! la $)erac%! c$! las bases (e (at$s8 &ara!t*a!($ c$!t!#(a( e! s# "#!c$!a,e!t$ (e ac#er($ c$! l$s !@eles (e ser@c$ establec($s
O)t,*ar el "#!c$!a,e!t$ (e las bases A(,!strac%! (e las bases (e (at$s (e (at$s #sa!($ t0c!cas $re!ta(as a &ara!t*a!($ &ara!t*a!($ la !te&r(a(8 (s)$!bl(a( (s)$!bl(a( ,e$rar el (ese,)e$ (el ser@c$ cal(a( (e l$s (at$s. 3er+car el c$,)$rta,e!t$ el "#!c$!a,e!t$ (e las bases (e (at$s as$ca($ al re!(,e!t$8 c$!tr$l (e access$s c$!c#rre!ca a tra@0s (e la lect#ra (e !(ca($res ,etrcas8 )ara &ara!t*ar c$!t!#(a( c$!t!#(a( (el ser@c$ l$s !@eles e&($s Real*ar las acc$!es (e )r$tecc%! (e la BD (e ac#er($ c$! las )$ltcas (e la $r&a!*ac%! l$s )la!es (e c$!t!&e!cas c$!t!&e!cas establec($s C$,)r$bar el c#,)l,e!t$ (e las )$ltcas (e se&#r(a( s&#e!($ l$s )r$t$c$les establec($s Elab$rar ($c#,e!tac%! t0c!ca (e la se&#r(a( (e la !"$r,ac%! (e las bases (e (at$s se&! )r$ce(,e!t$s (e la $r&a!*ac%! !$r,as !ter!ac$!ales.
Da&!%stc$ Da&!%stc$ (el !@el (e se&#r(a( (e la !"$r,ac%! (e ac#er($ c$! las !$r,as !ter!ac$!ales el $bet$ (e !e&$c$.
ASES DE DATOS
E!"e*cas 1. Real*ar la "#!(a,e!tac%! s$bre l$s c$!ce)t$s relac$!a($s c$! la !"raestr#ct#ra tec!$l%&ca (e la $r&a!*ac%!. . S#ste!tar las !eces(a(es (e a('#sc%! (e !#e@$s e'#)$s )ara la $r&a!*ac%! (e ac#er($ c$! l$s re'#er,e!t$s s#,!stra($s /. Partc)ar e! el "$r$ )ara s$cal*ar s# )r$)#esta (e !"raestr#ct#ra )ara la st#ac%! )r$)#esta e@al#ar las )r$)#estas (e s#s c$,)aer$s. 2. Establecer #! )la! (e c$,)ras )ara a('#rr S$"tare e! la $r&a!*ac%! 6. 3er+car la a)lcac%! (e la !$r,a ISO 9==18 a tra@0s (e #tl*ac%! (e #!a )la!tlla a)lca(a s$bre #!a st#ac%! )rese!ta(a &e!erar #! ($c#,e!t$ c$! l$s ele,e!t$s a ,e$rar. 7. Partc)ar (e e!c#e!tr$ s!cr%!c$ ($!(e se 3al(ar! l$s ("ere!tes )r$ces$s c$!$c,e!t$s a('#r($s (#ra!te esta )r,era act@(a( (e )r$ect$. 1. Pr$)#esta (e la ar'#tect#ra tec!$l%&ca )ara la Alcal(a (e Sa! A!t$!$ (el Se!a .Partc)ac%! e! el F$r$ S$cal*ac%! e@al#ac%! (e las )r$)#estas tec!$l%&casH /. Pla! (e I!stalac%! )ara el S5BD selecc$!a($ se&! el cas$ (e est#($/. 2. Pla! (e c$!+&#rac%! rec#)erac%! a!te (esastres )ara el S5BD. 1. Desarr$ll$ (el C#est$!ar$ I(e!t+car t0c!cas (e !tel&e!ca (e !e&$c$sH . Dse$ L%&c$ (e la base (e (at$s 1. Desarr$ll$ (el C#est$!ar$ Gest%! s$bre S5BDH . I!"$r,e (e !stalac%! (el S5BD /. I,)le,e!tac%! (e la estr#ct#ra (e (at$s 2. Caracterstcas8 c$!+&#rac%! c$!+&#rac%! &est%! (el S5BD 6. I!"$r,e s$bre la eec#c%! (el Pla! (e c$!+&#rac%! 7. Bl$& (e Gr#)$s (e traba$ )ara el (se$ (e #!a b$(e&a (e (at$s c$!str#cc%! (e #! c#b$ 9. F$r$ te,tc$ S$cal*ac%! e@al#ac%! (e las )r$)#estas )ara la Ar'#tect#ra (e #!a b$(e&a (e (at$sH 1. 3al(ac%! (e t0c!cas (e ,&rac%! erra,e!tas ETCL . Pla! (e 5&rac%! (e Dat$s )ara Sa! A!t$!$ (el SENA. /. 5&rac%! (e Bases (e Dat$s 1. Pla! (e res)al($ )ara las secretaras (e G$ber!$ Jace!(a (e Sa! A!t$!$ (el SENA
. C$)as (e Se&#r(a( (e las Secretaras Secretaras (e G$ber!$ Jace!(a (e la Alcal(a (e Sa! A!t$!$ (el SENA /. 3(e$ t#t$ral es)e$s (e bases (e (at$s 1. C#est$!ar$ Bases (e Dat$s Dstrb#(asH . F$r$ te,tc$ re)lcac%! (e base (e (at$s /. Bl$& re)lcac%! (e base (e (at$s 1. C#est$!ar$> N@el (e Ser@c$H. Ser@c$H. . De+!c%! (e l$s !@eles (e ser@c$ ac#er($ c$rres)$!(e!te /. Dsear "$r,at$ )ara el re)$rte (e !c(e!tes 2. Base (e Dat$s (e C$!$c,e!t$ 1. C#est$!ar$> Gest%! (e Dese,)e$H. . S#)er@s%! a l$s )ar,etr$s (e &est%! (ese,)e$ (e la base (e (at$s. /. N$r,al*ac%! (e Bases (e Dat$s. 2. T0c!cas )ara la $)t,*ac%! (e bases (e (at$s 1. C#est$!ar$> C$!tr$l (e C$!c#rre!caH. . 5a!e$ (e tra!sacc$!es8 bl$'#e$s c$!tr$l (e c$!c#rre!ca eec#ta!($ la )rctca )r$)#esta. /. C$,)re!s%! (el ,a!e$ (e tra!sacc$!es8 bl$'#e$s c$!tr$l (e c$!c#rre!ca e! #! ,$t$r (e base (e (at$s es)ec+c$ 2. S$cal*ac%! e@al#ac%! (el ,$(el$ tra!sacc$!al e! #! ,$t$r (e Bases (e Dat$s es)ec+c$. 1. Caracterstcas F#!c$!es (e Se&#r(a( (el S5BD selecc$!a($ . I!"$r,e erra,e!tas (e ,$!t$re$ (e bases (e (at$s /. F$r$ Te,tc$ Pr#ebas (e Se&#r(a(H 1. C#est$!ar$ Sste,as (e Se&#r(a( (e la I!"$r,ac%!H . 5atr* A!lss (e Res&$ /. P$ltcas (e Se&#r(a( 2. F$r$ Te,tc$ E@al#ac%! (e las P$ltcas (e se&#r(a(H 1. Pla! (e &est%! (e res&$s KPGR . C$!@ersat$r$ s#ste!tac%! (e e@(e!cas s$bre la Pr$tecc%! (e l$s Dat$s
Feca e*t#e2a
1 "e J0*$ "e -415
1 "e J0*$ "e -415
-3 "e J0*$ "e -415
11 "e J0($ "e -415
-3 "e J0($ "e -415
-415
15 "e A2$st$ "e -415
-6 "e A2$st$ "e -415
7 "e Se)te&'#e "e -415
-1 "e Se)te&'#e "e -415
"e Oct0'#e "e -415
17 "e Oct0'#e "e -415
- "e N$!e&'#e "e -415
