cronograma_total_2016 ficha 1181680 a01

7/26/2019 Cronograma_Total_2016 Ficha 1181680 A01

1/8

Fase

Fase 1: ANLISIS

CR

Act!"a" "eP#$%ect$

N$&'#e "e (a act!"a" "ea)#e*"+a,e

1. ANALIZAR LAINFRAESTRUCTURA

TECNOLGICA DE BASEDE DATOS REQUERIDA

POR LA ORGANIZACIN.

AA1 - Establecer la!"raestr#ct#ra tec!$l%&ca

re'#er(a )$r la$r&a!*ac%!

Fase -:PLANEACIN

Pla!+car lac$!+rac%!

(el sste,a ,a!ea($r(e

base (e (at$s.

AA -Establecer l$ssste,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$sre'#er,e!t$s (e la

$r&a!*ac%!

Desarr$llar la base (e(at$s c$! s#s $bet$s

c$!+rac%! (eac#er($

al )la! re'#er,e!t$s

(ela $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%!.

2. ESTABLECER LOSNI3ELES DE SER3ICIO

DE ACUERDO CON LOS REQUERI5IENTOSDE LA ORGANIZACIN

AA7 REALIZAR ACTI3IDADES DERESGUARDO8 RESTAURACIN 4


2/8

Fase 3: EJECUCIN

Fase .: E/ALUACIN

ESTANDARES 4REQUERI5IENTOS DE LA

ORGANIZACIN

CONTINGENCIAS DE ACUERDO A LOSPLANES ESTABLECIDOS

AA9 REALIZAR ACTI3IDADES DESINCRONIZACIN DE ACUERDO A LOS

REQUERI5IENTOS DE LA ORGANIZACIN

6. DESARROLLAR5ANTENI5IENTO

PRE3ENTI3O8CORRECTI3O O

PROACTI3O PARAGARANTIZAR NI3ELES

DE SER3ICIOREQUERIDOS POR LA

ORGANIZACIN

AA: -ESTABLECER NI3ELES DE SER3ICIODE ACUERDO CON LOS REQUERI5IENTOS

DE LA ORGANIZACIN

AA; APLICAR T EFECTUAR ACCIONESDE PROTECCIN A LA

BASE DE DATOS

AA11 CONFIR5AR EL CU5PLI5IENTOPOL?TICAS DE SEGURIDAD

AA1 APLICAR ACCIONES DE PROTECCINA LA BASE DE DATOS

AA1/ PRODUCIR DOCU5ENTACINT


3/8

Res0(ta"$ "e a)#e*"+a,e c$&)ete*ca

ONOGRAMA ESPECIALIZACIN TECNOLGICA EN GESTIN Y SEGURIDAD DE B

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 ser(a( (e la!"$r,ac%!.

Da&!%stc$ (el !@el (eser(a( (e la !"$r,ac%!(e ac#er($ c$! las !$r,as!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 larec#)erac%! a!te

(esastres !"$r,tc$s(e ac#er($ c$! el

)r$ce(,e!t$ s#&er($ )$rel "abrca!te8 las )$ltcas las !eces(a(es es)ec+cas

(e la $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$sc$! 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%!8s!cr$!*ac%!8 res)al($ (e las bases (e A(,!strac%! (e las bases (e (at$s


4/8

(at$s e !tel&e!ca (e !e&$c$s (eac#er($ c$! las !eces(a(es (e la

$r&a!*ac%!

&ara!t*a!($ la !te&r(a(8 (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

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.

O)t,*ar el "#!c$!a,e!t$ (e las bases(e (at$s #sa!($ t0c!cas $re!ta(as a

,e$rar el (ese,)e$ (el ser@c$

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 (eaccess$s c$!c#rre!ca a tra@0s (e lalect#ra (e !(ca($res ,etrcas8 )ara&ara!t*ar 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 (ec$!t!&e!cas establec($s

Da&!%stc$ (el !@el (e ser(a( (e la!"$r,ac%! (e ac#er($ c$! las !$r,as!ter!ac$!ales el $bet$ (e !e&$c$.

C$,)r$bar el c#,)l,e!t$ (e las)$ltcas (e ser(a( se!($ l$s

)r$t$c$les establec($s

Elab$rar ($c#,e!tac%! t0c!ca (e laser(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.


5/8

E!"e*cas

2. Establecer #! )la! (e c$,)ras )ara a('#rr S$"tare e! la $r&a!*ac%!

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%! &est%! (el S5BD6. I!"$r,e s$bre la eec#c%! (el Pla! (e c$!+rac%!

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

ASES DE DATOS

1. Real*ar la "#!(a,e!tac%! s$bre l$s c$!ce)t$s relac$!a($s c$! la !"raestr#ct#ratec!$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%! (eac#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.

6. 3er+car la a)lcac%! (e la !$r,a ISO 9==18 a tra@0s (e #tl*ac%! (e #!a )la!tllaa)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$.

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. Pla! (e res)al($ )ara las secretaras (e G$ber!$ Jace!(a (e Sa! A!t$!$ (elSENA


6/8

/. 3(e$ t#t$ral es)e$s (e bases (e (at$s1. 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.. 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$s1. C#est$!ar$> C$!tr$l (e C$!c#rre!caH.

1. Caracterstcas F#!c$!es (e Ser(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 Ser(a(H

1. C#est$!ar$ Sste,as (e Ser(a( (e la I!"$r,ac%!H. 5atr* A!lss (e Res&$/. P$ltcas (e Ser(a(2. F$r$ Te,tc$ E@al#ac%! (e las P$ltcas (e ser(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

. C$)as (e Ser(a( (e las Secretaras (e G$ber!$ Jace!(a (e la Alcal(a (eSa! A!t$!$ (el SENA

. 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 (eDat$s es)ec+c$.


7/8

Fecae*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


8/8

-415

15 "e A2$st$"e -415

-6 "e A2$st$"e -415

7 "eSe)te&'#e "e

-415

-1 "eSe)te&'#e "e

-415

"e Oct0'#e"e -415

17 "e Oct0'#e"e -415

- "eN$!e&'#e "e

-415

cronograma_total_2016 ficha 1181680 a01

Documents