Datawarehouse roles and responsibilities

Views:
 
Category: Entertainment
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Slide1:

Data Warehouse Organizational Roles and Responsibilities Mohan Gadde Ph : 302 983 8001

Slide2:

1 N u m er o u s r o les a n d res po n si b ilities w ill n eed to b e acce d ed to in o r d er to m a k e d ata w are h o u s e e ff o rts su cce ssfu l a n d g e n era t e re t u rn o n inv e st m e nt . F o r t h e t ec hni cal p er s o nn el (a pp li ca ti o n p r o g ra mm er, s y stem a d m i n i strat o r, d ata b ase a d m i n i strat o r, d ata a d m i n i strat o r), it is rec o mm e n d ed t h at t h e f o ll o w i n g r o les b e per f or m ed fu ll - ti m e by dedicated per s o nn el as m u ch as po ssi ble a n d t h at each re s po n si ble per s on recei v e s p eci f i c Data Ware h o u s e trai n i ng . T h e data w are h o u s e team n eeds to lead t h e or g a n i zation i n to a ss u m i n g t h e i r r o l es a n d t h ere b y b r i ng i n g a bo u t a p ar t n er s h i p w it h t h e b us i n e ss . Ma n a g e m e n t a l s o n ee d s t o m a ke actio n able pla n s o u t of t h e s e directi v es a n d m a k e s u re t h e st a f f e x ec u tes on t h e m . T h e f o ll o w in g are team a n d e x t e n d ed team m e m b er c o m po siti o n a n d r o l es a n d re s po n si b iliti es sugg e sti o ns. M a n a ger/ Di rec tor T h e res po n si b ilities o f t h e Ma n a g er o r Direct o r o f t h e Data Ware h o u s e team s h o u ld b e t o : E n s u re s u pport f o r t h e da t a w are h o u s e pro g ram at t h e h i gh e s t l e v e l s of t h e or g a n i za ti o n U n d ersta n d h i g h le v el re q u ire m e n ts o f t h e b u si n ess P re s e n t th e b u sin e s s w it h th e po ssi b iliti es a v a il a b l e t o them th r o ug h d a t a w are h o using Sta f f t h e team Es tabli s h a n d e n s u re ad h ere n ce to a s et of gu i di n g pri n ciples f o r data w are h o u s i n g C o mm un i ca ti o n o f k ey m il e s t o n e s t a t u s t o IT m a n a g e m e nt E n s u ri n g t h e re m ai n d er o f t h e team acce d e to t h eir res po n si b ilities as e nu m erated b el o w L i aise w ith strate g i c v e n do rs Es tabli s h i n g part n er s h i ps w ith k ey IT part n ers in s u pport of data w are h o u s i n g i n itiati v es Pr oj ec t M a n a g e r T h e p ercei v ed stre ng t h o f d ata w are h o u s i n g w it h in an o r g a n i zati o n w ill b e t h e s u m o f t h e stre ng t h o f t h e P r o j ect Ma n a g ers. P r o j ect Ma n a g ers m u st d eli v er c o mm it m e n ts a n d m u st d eli v er o n ti m e. T h ey w ill d o t h is by c u lli n g re s o u rces f rom w it h in t h e data w are h o u s e team a n d f rom co n s u lta n cy as n ece ss ary a n d e st ab lis h i n g par t n er s h i ps w it h o t h er i n t er n al s u pport or g a n i za ti o n s req u i red t o s u pport a da t a w are h o u s e iterati o n . A P r o j ect Ma n a g er d eli v ers b y : Mai n tai n i n g a h i gh l y d etailed p l an a n d ob s essi v ely cari n g a bo u t t h e p r o g ress o n it. A pp l y i n g p ers o n al s k ill a n d j u d g m e n t to e v er y t h i n g o n t h e p r o j ect. T h is is a real v al u e - a d d o f t h e P ro j ect Ma n a g er. It is t h e P ro j ect Ma n a g er ’ s j ob to e x erci s e rele v a n t di s cretio n . Matc h i n g team m e m b er ’ s s k ills a n d as p i rati o n s as cl o s ely as po ssi b l e to tas k s o n t h e p l a n . T rac k i n g all rele v a n t m etrics f o r each iteratio n : P ro j ect P l an m ile st o n es Iss u e s list A d h ere n ce to c h a ng e co n t rol practices A d h ere n ce to s o u rce code co n t rol practices D o c u m e n t a ti o n f i t f o r u s ers a n d s u pport per s o nn el A rc h itect u ral co m po n e n ts ad h ere n ce to f it f o r p u rpo s e a n d st a n dards R e g re ssi on t e sti n g per f or m ed a n d t e st s u pda t ed ba s ed on c h a ng es T eam m e m b ers f it f o r ta s k s a n d career - e nh a n ced

Slide3:

Mohan Gadde Ph ; 302 983 8001 2 C hief A rchi t ect T h e Ma n a g er/Direct o r w ill n eed to rely o n a C h ief A rc h itect ( o r si m ilar title) po s iti o n , as o n e o f h i s/ h er direct report s , to w o rk on co m p lex i ss u es of arc h itect u re, m odeli ng , a n d tool s . T h e p ers o n s h o u ld b e a b le to q u ic k l y q u ali f y as an a u t h o rity in d ata w are h o u s i n g w it h in t h e o r g a n i zati o n a n d h a v e m a s t ery o f t h e d a t a w are h o us i n g p ara d i g m , bo t h c u rre n t a n d e m er g i n g t ec hn o l o g i e s . Hi s / h er kn o w le d g e o f t h e b u si n e s s n ee d s t o b e j u s t a s g r eat . A b u si n e s s tec hn o l o g ist , s/ h e w il l m ee t b u si n e ss ob j ecti v es w ith e x i s ti n g or e m er g i n g tec hn o lo g i es a n d w o rk on i ss u es w ith broad tec hn i cal or st rate g i c i m plicatio n s . T h is per s on w o u l d h a v e si gn i f i ca n t i n ter f ace w ith t h e i n ter n al clie n t s a n d i n crea s e t h eir co nf ide n ce in t h e data w are h o u s e or g a n i zatio n . Da ta S t e w ard ( i n u s e r c o mm unit y - b y s ub j e c t a r ea) Dat a St e w ard s h i p appo i n t m e n t s h o u l d be m ade at t h e s u b j ect area t o m a n a g e m e n t - l e v el per s o nn el i n t h e b u si n ess areas m o st i m p acted b y t h e s u b j ect area. F o r t h e c o re s u b j ect areas, t h is w ill b e t h e p ers o n o n t h e w o r k i n g team by appo i n t m e n t of t h e e x ec u ti v e s po n s o r. Data st e w ard s , un li k e ot h er u s er s , h a v e read a n d w rite acce s s to t h eir area of st e w ard s h i p. Ot h er u s ers h a v e read - o n l y acce s s to t h e Data Ware h o u s e areas t h at t h ey h a v e been appro v ed to read by t h e data st e w ard s . T h e res po n si b ilities o f a Data Ste w ard i n cl u d e: A r b itrati n g t h e tra n s f o r m ati o n r u les E n t er i n g da t a or de t er m i n i n g da t a pop u l a ti o n m e t h od Veri f y i n g t h e d ata a f ter l o ad C o n t r i b u ti o n of t h e b u si n e s s m e t ada t a A ppro v i n g n ew u s ers Su ppor ti n g t h e u s er co mm un it y on t h e da t a P articipation on a deci si on s u pport st eeri n g co mm ittee Data Q u ality A b rief d escri p ti o n o f each o f t h ese res po n si b ilities f o ll o w s . T h e Data Ste w ard is re s po n si ble f o r t h e tra n s f or m ation r u les u s ed in t h e proce s s of m o v i n g data f rom s o u rce to tar g et f o r s o u rced data. T h e s p eci f i c ta s k s are: A ss u ri n g tra n s f o r m ati o n r u les k eep t h e d ata m ea n i ngfu l a n d c o n s iste n t A r b itrate d i ff ere n ces o f op i n i o n an d i ff ere n t i n ter p retati o n s o f v al u e as to h o w t h e d ata w ill b e re p rese n ted in t h e Data Ware h o u s e Ma k e t h e call o n t h e i n itial r u les a n d all s u b s e q u e n t c h a ng es T h e Data St e w ard is re s po n si ble f o r t h e ti m ely a n d acc u rate pop u lation of data in t h e area of st e w ard s h i p. T h i s i s p er h a p s t h e m o s t i m po r t a n t o f t h e Dat a St e w ar d ' s t a sks . T h i s c o ul d m ean m a nu al e n t ry t h r o ug h t h e d e v el op ed u s er i n ter f ace o r t h e selecti o n o f t h e s y stem t h at w ill p r o v i d e t h e d ata (ie. T h e " s o u rce " ). T h e s p eci f i c ta s k s are: Deter m i n e t h e s y ste m s t h at w ill f eed t h e d ata to t h e d ata w are h o u s e E n s u re f ee d s are d e v el op ed to f eed to t h e d ata i n to t h e d ata w are h o u s e as s oo n as it is p ractical to d o so on a re gu l ar ba si s

Slide4:

3 T h e Data Ste w ar d , as t h e res po n si b l e p arty f o r t h e q u ality o f t h e d ata, w i ll v eri f y t h e d ata a f ter it is l o a d ed f rom t h e operatio n al s o u rce s . T h e s p eci f i c ta s k s are: C o nf irm t h e d ata w as l o a d ed a n d t h at t h e tra n s f o r m ati o n al r u les w ere p r op erly a pp lied For m ally g i v e t h e appro v al to t h e g reater u s er co mm un ity f o r q u ery a n d a n al y s is of t h e data T h e Data Ste w ard w ill c o n t ri b u te t h e b u si n ess m eta d ata to t h e m eta d ata re po s it o r y . T h e b u si n ess m eta d ata c o n s ists o f t h e b u si n ess d e f i n iti o n w ritten in ter m s t h e b u si n ess can un d ersta n d . T h e Data Ste w ard w ill b r o k er re q u ests f o r n ew u s a g e o f t h e Data Ware h o u s e. T h e s p eci f i c tas k s are: K n o w led g e of t h e data s o u rce s , tra n s f or m ation r u le s , a n d u s es of t h e data f o r t h e area of st e w ard s h i p K n o w led g e of t h e w o r k load li m itatio n s of t h e Data Ware h o u s e s y stem f o r t h e area of st e w ard s h i p A pp r o v e n ew u s ers a n d t h eir a u t h o rity le v els ( u s u ally read o n l y ) It s h o u ld b e a re q u ire m e n t f o r n ew u s ers o f t h e Data Ware h o u s e to un d er g o trai n i n g i n ter n ally o n bo t h t h e d ata m od el a n d t h e d ata access t oo l . T h e Data Ste w ard w ill b e res po n si b l e f o r t h e trai n i n g a n d o ng o i n g s u pport of t h e u s er co mm un it y on t h e da t a m odel a n d t h e da t a its e l f . T h e s p ec i f i c t a s k s f o r t h e da t a st e w ard f o r t h is is: P ar ti c i p a ti n g i n t h e re gu l ar t ra i n i n g s e ss i o n s g i v en t o n ew us ers Hel p - d e s k st y l e s u pport of t h e u s er co mm un it y on a re gu l ar ba si s Meeti ng s of t h e deci si on s u pport st eeri n g co mm ittee s h o u ld be s c h ed u led re gu l arly to m a k e st rate g i c d i scer n m e n t a n d p ri o ritizati o n o v er t h e m a j o r a dd iti o n s o f u s a g e, s u b j ect areas, a n d d ata s o u rces to t h e Data Ware h o u s e. T h e s p eci f i c ta s k s f o r t h e Data Ste w ard f o r t h e co mm ittee i s : Meeti n g atte n d a n ce a n d leader s h ip J u d g m e n t on t h e i ss u es pre s e n ted T h e c o n s iste n c y , acc u rac y , a n d ti m eli n ess o f t h e d ata are t h e res po n si b ility o f t h e d ata ste w ar d . T h e d ata ste w ar d ’ s area o f ste w ar d s h i p m u st recei v e d ata acc o r d i n g to rec o gn i ze d , s y ste m ic m et h od s . Data q u ality i ss u es m u s t be addre ss ed i mm ediatel y . U n atte n d ed perceptio n s of un clea n li n e s s q u ic k l y tear do w n t h e v al u e o f t h e Data Ware h o u s e. E nd U se r T h e Data Ware h o u s e is b ei n g b u ilt f o r E n d User q u ery a n d re po rti ng . N o n et h eless, t h ere are res po n si b ilities t h at an e n d u s er m u st m eet to g et m a x i m u m b e n e f it f r o m t h e Data Ware h o u s e. T h e res po n si b ilities o f an E n d User i n cl u d e: A tte n d i n g trai n i n g be f o re recei v i n g an ID a n d pa ss w ord on t h e Data Ware h o u s e s y stem Br o w si n g t h e tec hn i cal a n d b u si n ess m eta d ata f o r i nf o r m ati o n o n d ata s o u rci n g a n d d ata d e f i n iti o n s P ro v idi n g f eedback to t h e Data Ware h o u s e team T h e E n d User m u st atte n d trai n i n g to f a m iliarize h i m s elf o r h erself w ith t h e Data Ware h o u s e e nv i r o n m e n t es p ecially t h e m eta d ata, t h e q u ery t oo l , a n d t h e d ata m od el. T h e m eta d ata w ill c o n s ist o f ta b l es c o n t ai n i n g da t a abo u t t h e u s er da t a. T h e E n d Us er s h o u l d f i n d m o s t of h i s or h er da t a- re l a t ed q u e sti o n s a n s w ered i n t h e m eta d ata.

Slide5:

4 T h e Data Ware h o u s e w ill po t e n tially d i sr u p t b u t s h o u ld u lti m ately i n crease t h e o r g a n i zati o n’ s a b ility to g e n erate sales a n d l o w er c o sts. T o g et to t h at po i n t , h o w e v er, re q u ires t h at t h e u s ers acti v ely u s e t h e Data Ware h o u s e as i n st r u cted a n d, si n ce it s h o u ld be a u s er - ce n tric Data Ware h o u s e, acti v ely pro v ide f eedback to t h e Data Ware h o u s e team on i ss u es o f : P er f or m a n ce Fun c ti o n a lity Data q u ality a n d c o m p lete n ess Data s o u rces Meta d ata q u ality a n d c o m p lete n ess E xecuti v e Sponsor ( b y data w a r ehou s e ite r ation) T h e Data Ware h o u s e m u s t h a v e h i gh- l e v el a n d s u st ai n able s po n s o r s h i p. T h e E x ec u ti v e Spo n s o r m u s t be po litically v i a b le a n d b e a b le to g ar n er a n d retain a d e q u ate res o u rces f o r t h e c o n s tr u cti o n a n d m ai n te n a n ce o f t h e Data Ware h o u s e. T h e res po n si b ilities o f t h e E x ec u ti v e S po n s o r i n cl u d e: K n o w l ed g e of Dat a Ware h o u s e s y st e m s L eader s h ip in t h e Deci si on s u pport st eeri n g co mm ittee m eeti ng s K n o w l e d g e o f t h e o r g a n i za ti o n’ s Dat a Ware h o us e e nv i r o n m e n t Kee p i n g t h e Data Ware h o u s e o u t o f i n ter n al cr o s s -f i re T h e E x ec u ti v e Spo n s o r, as t h e re s po n si ble e x ec u ti v e f o r t h e s u cce s s or f ail u re of t h e iteration of t h e Data Ware h o u s e, s h o u ld be able to artic u l ate a n d q u a n ti f y t h e v al u e of Data Ware h o u s e pro j ect a n d its m a n y ele m e n t s . T h e Deci si on s u pport st eeri n g co mm ittee is de si gn ed as a f o r u m f o r data st e w ard s , IS, a n d t h e E x ec u ti v e S po n s o r to m a k e strate g i c d i scer n m e n t a n d p ri o ritizati o n o v er t h e m a j o r a dd iti o n s o f u s a g e, s u b j ect area s , a n d data s o u rces to t h e Data Ware h o u s e. It is i m perati v e to t h e s u cce s s of t h e Data Ware h o u s e t h at t h e E x ec u ti v e Spo n s o r ta k es leader s h ip a n d pro v ides v isi on to t h e co mm ittee. T h e E x ec u ti v e Spo n s o r, as t h e re s po n si ble e x ec u ti v e f o r t h e s u cce s s or f ail u re of t h e Data Ware h o u s e, s h o u ld be able to artic u l ate a n d q u a n ti f y t h e v al u e of t h e Data Ware h o u s e pro g ra m . Speci f i c areas of f o c u s : Data So u rces S u b j ect A reas Data Ste w ard s h i p Hi gh- l e v el A rc h it ec t u re P ro j ect P l an a n d B u d g et T h e Data Ware h o u s e, to b e s u ccess fu l , m u st n o t f all v i ctim to i nf i gh ti ng . T o m ai n tain t h is c o un t e n a n ce, t h e e x ec u ti v e s po n s o r m u st k eep t h e f o c u s at t h e po s iti v e ret u r n- o n- i nv est m e n t po t e n tial a n d realizati o n o f t h e Data Ware h o u s e. Freq u e n t st at u s s h o u ld be deli v ered to u pper le v el e x ec u ti v e s . Da t a base A d mi nis t ra tor A k ey de si g n poi n t f o r a data w are h o u s e g ro u p is t h e place m e n t of t h e databa s e ad m i n ist ration fun ction a n d t h e di v isi on of roles a n d re s po n si bilities bet w een t h e s u pport g ro u p a n d t h e u s er co mm un it y . T h e res po n si b ilities o f a Data b ase A d m i n i strat o r i n cl u d e:

Slide6:

5 P h y si cal da t aba s e de si g n Data b ase m ai n te n a n ce Bac ku p a n d reco v ery P articipation on t h e Deci si on s u pport st eeri n g co mm ittee Data Re p licati o n R e po sit o ry Ma n a g e m e nt Sec u rity a d m i n i strati o n Data b ase l o a d i n g P er f or m a n ce Mo n itori n g a n d S u mm ary table creation A d -h oc da t a m a n i p u l a ti o n A b rief d escri p ti o n o f each o f t h ese res po n si b ilities f o ll o w s . T h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill tra n slate t h e l o g i cal d ata b ase d esi g n i n to a p h y s ically i m ple m e n table de si gn . T h e s p eci f i c ta s k s are: De n o r m alizi n g t h e m od els b ased o n po t e n tial q u eries, re po rti ng , a n d s y stem f ee d s t h at w ill b e g e n erated f r o m t h e ta b l es I m p l e m e n t, as n ecessar y , s o m e o f t h e e n tities as do m ai n s rat h er t h an ta b l es T h e a dd iti o n o f ti m esta m p a n d u s er ID c o l u m n s to m o st ta b l es to i d e n ti f y t h e p ers o n a n d t h e ti m e o f t h e r o w a dd iti o n o r c h a ng e T h e u s e of st a n dard abbre v iatio n s in t h e table a n d col u m n n a m es A ssi gn m e n t o f d ata t y p es, nu lla b ilit y , a n d d e f a u lts f o r each c o l u m n C reati n g t h e databa s es a n d databa s e ob j ects s u ch as t h e table s , table s pace s , s y n o n y m s , v i e w s , tri gg er s , st ored proced u re s , de f a u lts , do m a i n s , a n d i n de x es T h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill m ai n tain t h e ta b l es as n ecessary f o r op ti m izati o n . T h e s p eci f i c ta s k s m ay i n cl u d e: Per i od i c t ab l e reor g a n i za ti o n Str u ct u re u pdate w ith c h a ng e co n t rol T h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill e n s u re rec o v era b ility o f t h e Data Ware h o u s e w ith m i n i m al l o s s o f i nf o r m ati o n . S p eci f i c tas k s i n cl u d e: E x te n s i v e te s ti n g of t h e bac ku p a n d reco v ery proce ss es A b ility to rec o v er d ata b ases w it h in t h e ser v ice le v el a g ree m e n t A b ility to artic u l ate a n y d ata l o ss e n c o un t ered E n s u re l o gg i n g a n d rec o v era b ility o f d ata b ase u pd ates si n ce t h e last b ac ku p T a k e f req u e n t bac ku p s – fu ll a n d i n cre m e n tal as n eeded Fre q u e n t o ff s ite st o ra g e o f t h e latest fu ll b ac ku p in t h e e v e n t o f a n at u ral d i saster Re p rese n tati o n f r o m t h e Data Ware h o u s e Data b ase A d m i n i strati o n sta f f w ill p artici p ate o n t h e Decisi o n s u pport st eeri n g co mm ittee. If t h e Data Ware h o u s e beco m es as a di st rib u ted s y st e m , a s y n c h ro n ization e ff o rt m ay be n eeded. T h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill b e res po n si b l e f o r t h e s y n c h r o n izati o n , o r re p licati o n , p r o cess. Speci f i c ta s k s i n cl u d e: E n s u ri n g acc u rate a n d co m p lete replication of applicable data d u ri n g t h e a v ailable w i n do w s Set u p a n d a d m i n i strati o n o f Oracle Re p licati o n Ser v ices o r o t h er rele v a n t re p licati o n t oo l C o llisi o n d e tecti o n t o a v o i d l o s s o f d a ta I n p u t to t h e W o rl d w i d e Data A rc h itect u re p r o cess b ased o n re p licati o n fun cti o n ality

Slide7:

6 T h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill b e res po n si b l e f o r t h e m eta d ata m a n a g e m e n t i nf rastr u ct u re. T as k s w ill i n cl u d e: Data b ase m ai n te n a n ce f o r t h e d ata b ase(s) I n stallati o n o f t h e re po s it o ry s o f t w are, if a pp lica b le F ro n t - e n d de v e l op m e n t Us er t ra i n i ng O n ly u s ers a pp r o v ed b y t h e d ata ste w ar d s w ill b e g ra n ted sec u rity p ri v ile g es o n t h e Data Ware h o u s e. T h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill e x ec u te t h e g ra n ts o r p r o v i d e t h e a b ility f o r a ce n tral sec u rity g r o u p to d o t h is. S p eci f i c tas k s i n cl u d e: Creati n g sec u rity p r o f iles A ss u ri n g n ew u s ers are appro v ed by t h e data st e w ard( s ) A ssu r i n g n ew us ers h a v e t a k en t ra i n i ng Gra n ti n g p ri v ile g es to t h e d ata ste w ar d s F o r d ata t h at is s o u rced f o r t h e Data Ware h o u s e, t h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill, if n ecessar y , c od e a n d i n stall t h e p r o g ra m s to l o ad t h e d ata i n to t h e Data Ware h o u s e. T h e Data Ware h o u s e Data b ase A d m i n i strat o r is t h e po i n t p ers o n f o r iss u es o f p er f o r m a n ce w it h in t h e Data Ware h o u s e e nv i ro n m e n t. Speci f i c ta s k s f o llo w : Bei n g f i r s t on call f o r per f or m a n ce i ss u es f rom t h e u s er co mm un ity S e tti n g u p t h e g o v er n ors on t h e da t aba s e s y st e m s t o st op r un a w ay q u er i es A ssist t h e u s er c o mm un ity in w riti n g w ell - p er f o r m i n g SQL R o u t e s y stem a n d n et w ork per f or m a n ce i ss u es to t h e re s po n si ble party S po tti n g tre n d s in q u eries a n d creati n g a n d m ai n tai n i n g s u mm ary ta b l es f o r l o w - p er f o r m i n g q u eries w h ere po ssi ble Ma k i n g t h e e n d u s er q u ery tool a w are of t h e s u mm ary tables Occas io n all y , t h e m o s t e x pedie n t w ay to create or re st ore co n s i s te n cy to t h e data in t h e Data Ware h o u s e is to w rite i n sert, u pd ate, o r d elete state m e n ts a g ai n s t t h e d ata b ase. A s t h e i n-h o u se SQL e x p ert, t h e Data Ware h o u s e Data b ase A d m i n i strat o r w ill p er f o rm t h ese q u eries. S p eci f i call y , f o ll o w i n g t h e d ata ste w ard re v iew o f t h e d ata l o a d , t h ere m ay b e rec o n ciliati o n q u eries to b e r u n to b ri n g t h e d ata to a le v el o f c o n s iste n c y . D a ta A dmini s t ra tor A k ey de si g n poi n t f o r a data w are h o u s e g ro u p is t h e place m e n t of t h e data ad m i n ist ration fun ction a n d t h e d i v i si o n o f r o les a n d res po n si b ilities b et w een t h e D B A s a n d t h e d ata a d m i n i strat o rs. T h e Data Ware h o u s e Data A d m i n i strat o r w ill tra n slate t h e u s er re q u ire m e n ts i n to a l o g i cal d ata b ase d esi gn . T h e res po n si b ilities o f a Data A d m i n i strat o r i n cl u d e: L o g i cal d ata m od eli n g f o r t h e d ata w are h o u s e (sa n s t h e d ata m arts) Gat h eri n g b u si n ess d ata re q u ire m e n ts P articipation on t h e Deci si on s u pport st eeri n g co mm ittee

Slide8:

7 A ppli ca tion Programm e r – E T L S pecia li s t T h e res po n si b ilities o f an A pp licati o n P r o g ra mm er – E T L S p ecialist i n cl u d e: S o u rci n g t h e d ata f r o m t h e op erati o n al s y ste m s A pp l y i n g t h e b u si n e s s t ra n s f or m a ti o n r u l es Prepar i n g a da t aba s e - l oadab l e f il e f o r t h e Dat a Ware h o u s e Ma n a g e m e n t o f t h e d e p l o y m e n t o f t h e d ata ac q u i siti o n t oo l (s) C o n t ri b u ti n g t h e tec hn i cal m eta d ata to t h e m eta d ata re po s it o ry A b rief d escri p ti o n o f each o f t h ese res po n si b ilities f o ll o w s . T h e Data Ware h o u s e A pp licati o n P r o g ra mm er w ill e x tract d ata d esti n ed f o r t h e Data Ware h o u s e f r o m t h e operatio n al s y st e m s t h at st ore t h e data. T h e s p eci f i c ta s k s are: W o rk w ith t h e s o u rce s y stem a n al y s ts to un d er st a n d t h e w i n do w s a v ailable f o r data e x traction P r o g ra m , test, i m p l e m e n t a n d m ai n tain a n y d ata e x tracti o n p r o g ra m s n ecessary to e x tract t h e d ata f r o m t h e op erati o n al s y ste m s n ee d ed to b e m o v ed to t h e Data Ware h o u s e T h e Data Ware h o u s e A pp licati o n P r o g ra mm er is res po n si b l e f o r a pp l y i n g tra n s f o r m ati o n r u les as n ecessary to k eep t h e data clean a n d co n s i s te n t a n d t h ere f ore u s able by t h e u s er co mm un it y . Speci f i c ta s k s i n cl u d e: Par ti c i p a ti o n i n de si g n s e ssi o n s c h a i red by da t a st e w ards a n d / or IT per s o nn el w h ere dec isi o n s are m ade i nv o l v i n g t h e tra n s f o r m ati o n f r o m s o u rce to tar g et P r o g ra mm i n g t h e d ata ac q u i siti o n t oo l w ith t h e r u les to b e a pp lied to t h e d ata E n su r in g t h e c o rrect a pp li ca ti o n o f t h e b u sin e s s r u l es t h r o ug h d a t a q u ery a f t er t h e d a t a i s l o a d ed i n t o t h e Data Ware h o u s e F o ll o w i n g t h e d ata e x tracti o n a n d r u les a pp licati o n , t h e f ile(s) w ill n eed to b e m a d e rea d y f o r l o a d i n g i n to t h e Data Ware h o u s e. T h is is t h e res po n si b ility o f t h e Data Ware h o u s e A pp licati o n P r o g ra mm er. S p eci f i c d u tie s i n cl u d e: O b tai n i n g c o m p lete kn o w l e d g e o f t h e p h y s ical d ata b ase sc h e m a P repari n g t h e f iles n eeded to load each table t h at h as been de si gn ated to recei v e f iles f rom operatio n al s y st e m s rat h er t h an direct i n p u t f rom data st e w ards P r o g ra mm i n g t h e d ata ac q u i siti o n t oo l (s) w ith t h e ta b l es to l o ad t h e f iles i n to W o r k i n g w ith t h e Data Ware h o u s e Data b ase A d m i n i strat o r to e n s u re t h e f ile l o a d s p r op erly i n to t h e Da t a Ware h o use T h e m eta d ata re po s it o ry w ill c o n t ain tec hn i cal m eta d ata s u ch as d ata s o u rces a n d tra n s f o r m ati o n r u les a pp lie d . T h e A pp licati o n P r o g ra mm er w ill b e res po n si b l e f o r t h e e n try a n d m ai n te n a n ce o f t h is i nf o r m ati o n . O L A P Specialist T h e res po n si b ilities o f an O L A P S p ecialist i n cl u d e: Ma n a g e m e n t of t h e deplo y m e n t , m ai n te n a n ce, a n d u s er s u pport of t h e data acce s s tool( s ) Ide n ti f ication a n d e n able m e n t of t h e u s er co mm un ity to acce s s t h e data in a m a nn er co n s i s te n t w ith th e i r b u sin e s s g o a l s

Slide9:

8 A b rief d escri p ti o n o f each o f t h ese res po n si b ilities f o ll o w s . T h e O L A P S p ec i a lis t i s re s po n si b l e f o r t h e m a n a g e m e n t of t h e dep l o ym e n t , m a i n t e n a n ce, a n d u s er s u pport of t h e data acce s s tool s . Speci f i c d u ties i n cl u d e: W o r k i n g w ith t h e S y stem A d m i n ist ration st a f f to m o s t e ff ecti v ely place s er v er co m po n e n ts in t h e arc h itect u re. Keepi n g a v er si o n of t h e O L A P T ool i n prod u c ti o n t h at i s un d er s u pport by t h e t ool v e n dor I n st allation of a n y clie n t - s ide s o f t w are n eeded on appro v ed u s ers de s k tops (t h i s co u l d al s o be t h e P C s u ppor t g r o u p) Mai n tai n i n g a h i gh- l e v el v iew of t h e O L A P e nv i ro n m e n t a n d e n s u ri n g f i t -f o r - p u rpo s e tool u s a g e at t h e o r g a n i za ti o n E n s u ri n g acce s s to b u si n e s s a n d tec hn i cal m etadata f rom w it h in t h e O L A P tool T h e O L A P Speciali s t is re s po n si ble f o r t h e ide n ti f ication a n d e n able m e n t of t h e u s er co mm un ity to acce s s t h e d ata in a m a nn er c o n s iste n t w ith t h eir b u si n ess g o als. S p eci f i c d u ties i n cl u d e: P r o f ili n g t h e u s er c o mm un ity early in t h e d ata w are h o u s e iterati o n O b tai n i n g c o m p lete kn o w l e d g e o f t h e p h y s ical d ata b ase sc h e m a T ra i n i n g a n d s u ppor ti n g u s ers on t ool u s a g e I d e n ti f icati o n a n d sc h e d u li n g o f f re q u e n tly n ee d ed re po rts S y s t em A d mi nis t ra tor ( u s uall y b y SL A w i th the S y s tem Ad m i ni s t r ation g r oup) T h e res po n si b ilities o f a S y stem A d m i n i strat o r i n cl u d e: I n stalli n g a n d m ai n tai n i n g t h e Data b ase Ma n a g e m e n t S y stem (D B MS) Data w are h o u s e arc h itect u re (in part n er s h i p w ith t h e Ch ief A rc h itect) M o n it o r i n g n e t w o rk p er f o r m a n ce M o n it o ri n g D A SD u tilizati o n A b rief d escri p ti o n o f each o f t h ese res po n si b ilities f o ll o w s . T h e Data Ware h o u s e S y stem A d m i n i strat o r w ill b e res po n si b l e f o r d ata d esti n ed f o r t h e Data Ware h o u s e f rom t h e operatio n al s y st e m s t h at st ore t h e data. T h e s p eci f i c ta s k s are: T un i n g t h e op era ti n g s y s tem f o r D B MS f i t I ns t a lli n g a n d c o nf i gu r i n g t h e D B MS Mai n t a i n i n g t h e D B MS l e v e l s s u ppor t ed by t h e D B MS v e n dor T h e Data Ware h o u s e S y stem A d m i n ist rator is re s po n si ble f o r arc h itecti ng , w ith t h e Ch ief A rc h itect, t h e p l ace m e n t o f t h e Data Ware h o u s e a n d d ata m arts a n d t h e a d j o i n i n g d ata ac q u i siti o n a n d re p licati o n st rate g i e s . Speci f i c ta s k s i n cl u d e: P articipation on a deci si on s u pport st eeri n g co mm ittee in deci si o n s on arc h itecti n g a w o rld - w i de data i nf rastr u ct u re t h at w ill acc o mm od ate t h e d ata e n try a n d retrie v al n ee d s o f t h e do m estic a n d i n ter n ati o n al u s er c o n s tit u e n cies K n o w le d g e o f t h e n et w o rk ca p a b ilities Data arc h itect u re co m p ri si n g deci si on poi n t s aro un d nu m ber of data st ores a n d t h e a m o un t a n d ti m i n g o f re p li ca ti o n a n d s y n c h r o n i za ti o n n ee d ed t o ac h i e v e t h e ob j ec ti v es o f h a v i n g a s i ng l e v er si o n o f t h e tr u t h f o r each Data Ware h o u s e ele m e n t

Slide10:

T h e Data Ware h o u s e S y stem A d m i n ist rator is re s po n si ble f o r t h e per f or m a n ce of data tra n s f er s , eit h er in re s po n s e t o a q u ery or as part of a da t a rep li ca ti o n or s y n c h ro n i za ti o n e ff o rt acro s s t h e W A Ns a n d L A Ns . Speci f i c ta s k s i n cl u d e: P roacti v e n et w ork m o n itori n g f o r per f or m a n ce a n d acc u racy R eco mm e n d i n g a n d e x pa n d i n g capacity as n eeded to m eet per f or m a n ce s er v ice le v els T h e Dat a Ware h o us e S y stem A d m inist ra t o r i s re s po n si b l e f o r e n su r in g e n o ug h D A S D i s a v a il a b l e a n d e ff i cie n tly m a n a g ed to acco mm odate e x i s ti n g a n d u p co m i n g data n eed s . Speci f i c ta s k s i n cl u d e: P r o acti v e D A SD m o n it o ri n g Rec o mm e n d i n g a n d e x p a n d i n g ca p acity as n ee d ed to ass u re a v aila b ility 9

authorStream Live Help