SISTEMAS DE INFORMAÇÃO SÃO PAULO 2014 ATIVIDADES PRÁTICAS SUPERVISIONADAS (APS)
“DESENVOLVIMENTO DE UMA APLICAÇÃO DE BUSINESS INTELLIGENCE”
BRUNO DOS SANTOS SILVA RA: B21!"! CLE#TON OLIVEIRA MOTA RA: B00!$"2 FRANC#ELLI ROBERTA DOS SANTOS RA: B%$1&G"4 &ONAT'A 'ERCULANO RA: T2BD"2 TANCREDO FERNANDO ARAU&O RA: B%D&A"!
INDICE 1* OB&E OB&ETI TIVO VO DO TRA TRABA BAL' L'O O 2* INT INTRODU RODUÇÃ ÇÃO O !* CONC CONCEI EITO TOS S GERA GERAIS IS BUSSINESS INTELLIGENCE (BI) 3.1.1.1.1. OBJETOS 4* T+CNICAS T+CNICAS DE BUSSI BUSSINESS NESS INTELLI INTELLIGENC GENCE E E SOLUÇ,ES SOLUÇ,ES UTILI-A UTILI-ADAS DAS 4.1.1 .1.1..
EST ESTRUT RUTURA URAÇÃO ÇÃO, CO CONCEIT CEITO OS E FUNDA UNDAM MENT ENTAÇÃO ÇÃO
4.1. 4.1.2. 2.
DIFE DIFERE RENÇ NÇAS AS ENTR ENTRE E OLA OLAP P E DAT DATAMINI MINING NG E SUA SUA EXPL EXPLOR ORAÇ AÇÃO ÃO DO DOS S
DADOS 4.1.3.
BENEFÍCIOS DAS TÉCNICAS EMPREGADAS
4.1.4 .1.4..
APLI APLICA CAÇÕ ÇÕE ES UE UE FA!EM"F EM"FI! I!E ERAM RAM USO USO DA TÉCNIC CNICA A
4.1. 4.1.#. #.
DISC DISCUS USSÃ SÃO O SOB SOBRE RE O CUST CUSTO" O"BE BENE NEFÍ FÍCI CIO O DA DA IMPL IMPLAN ANT TAÇÃO ÇÃO DE UMA UMA
SOLUÇÃO DE BI
* DISS DISSER ERT TAÇÃO ÇÃO %* LIN' LIN'A AS DE C.D C.DIG IGOS OS $* PRINTS PRINTS DO PROGRA PROGRAMA MA EM FUNCI FUNCIONA ONAMENT MENTO O * BIB BIBLIOG LIOGRA RAFI FIA A * FIC'A DE ATIV ATIVIDADES IDADES SUPERVISI SUPERVISIONADA ONADAS S
INDICE 1* OB&E OB&ETI TIVO VO DO TRA TRABA BAL' L'O O 2* INT INTRODU RODUÇÃ ÇÃO O !* CONC CONCEI EITO TOS S GERA GERAIS IS BUSSINESS INTELLIGENCE (BI) 3.1.1.1.1. OBJETOS 4* T+CNICAS T+CNICAS DE BUSSI BUSSINESS NESS INTELLI INTELLIGENC GENCE E E SOLUÇ,ES SOLUÇ,ES UTILI-A UTILI-ADAS DAS 4.1.1 .1.1..
EST ESTRUT RUTURA URAÇÃO ÇÃO, CO CONCEIT CEITO OS E FUNDA UNDAM MENT ENTAÇÃO ÇÃO
4.1. 4.1.2. 2.
DIFE DIFERE RENÇ NÇAS AS ENTR ENTRE E OLA OLAP P E DAT DATAMINI MINING NG E SUA SUA EXPL EXPLOR ORAÇ AÇÃO ÃO DO DOS S
DADOS 4.1.3.
BENEFÍCIOS DAS TÉCNICAS EMPREGADAS
4.1.4 .1.4..
APLI APLICA CAÇÕ ÇÕE ES UE UE FA!EM"F EM"FI! I!E ERAM RAM USO USO DA TÉCNIC CNICA A
4.1. 4.1.#. #.
DISC DISCUS USSÃ SÃO O SOB SOBRE RE O CUST CUSTO" O"BE BENE NEFÍ FÍCI CIO O DA DA IMPL IMPLAN ANT TAÇÃO ÇÃO DE UMA UMA
SOLUÇÃO DE BI
* DISS DISSER ERT TAÇÃO ÇÃO %* LIN' LIN'A AS DE C.D C.DIG IGOS OS $* PRINTS PRINTS DO PROGRA PROGRAMA MA EM FUNCI FUNCIONA ONAMENT MENTO O * BIB BIBLIOG LIOGRA RAFI FIA A * FIC'A DE ATIV ATIVIDADES IDADES SUPERVISI SUPERVISIONADA ONADAS S
OB&ETIVO DO TRABAL'O O O$%&'()* +* -/* 0 *&&-, *&&-, /5(- & /-&6&'- &7 8*-7 +& 7 /5(9:* * *&('* +& ;BI;
)&5, +&6'& 7*+* 8*-7 '(5(?+*6 '*+*6 '*+*6 *6 *&('*6 /&6@(6+*6 /&6@(6+*6 /&5* -/* *7* 7 '*+*, +()(+* /&5* 7&67* 7&-* +& *7/*&'&6 +* -/*, * 6&% ; APS; 8*( +()(+(+ &7 # <(*= /-'&6 A /&6@(6 6*$-& * *&('* & * (6'-(* +& /5(9&6 &7 B66(&66 B66(&66 I'&55(&&, -(9:* +* 7*+&5* &7 $* $* +& ++*6 %'* *7 ('&-9:* * * 6(6'&7 JA JAA <&6'-'- +* /-*-7=, )&-(8(9:* +*6 &--*6, * '-'7&'* & -&8(7&'* + /5(9:*, /5(9:*, -(9:* + /-'& &6-(' & 8(5(?9:* +* '-$5* /- &'-&. O -/* *6(+&- @& * *$%&'()* 8*( 59+*, * &68*-9* 8*( -&5(?+* /- @& '*+*6 @& '(7 +(8(5++&6 *6&(66&7 &'&+&- * *&('* +& B6(&66 I'&55(&& & * 8*( -&*7/&6+*, '*+*6 &'&+&-7 * *&('* & * '-$5* +& '()(++&6 /->'(6 6/&-)(6(*+6 8*( -&5(?+* *7 6&66*.
INTRODUÇÃO G-+&6 *-(?9&6 '7 '(5(?+* *6 ++*6 & (8*-79&6 +& 66 $6&6 */&-(*(6 *7 * *$%&'()* +& '&+&- 6 66 &&66(++&6 +& (8*-79&6 > 7('* '&7/*. D&6'& 7*+*, +()&-66 )&?&6, ++*6 (*6(6'&'&6 6:* 6+*6 *7* /-7&'-* /- '*7+ +& +&(6&6 (7/*-''&6. O &-&(7&'* & *-(?9:* +& -+&6 )*57&6 +& ++*6 &- +& -+& +(8(5++& /- 6 &7/-&66. G-+&6 $6&6 +& ++*6 6:* -(+6 /&5* 75* +& (8*-79&6 -&65''&6 +& */&-9&6 '-6(*(6, /** /-*)&('+6 /&5*6 -&6/*6>)&(6. A ('&5(( +& &(* -&6 +* &(* +& 7 +&'&-7(+ *-(?9:*, /*+&+* (85&(- * 7&'* +& 5-* + -&&(', -&'&9:* +& 6'*6, (*)9:*, 507 +& *8&-&&- *'(7(?9&6 (7/-&6(+H)&(6. C*7 * 7&-+* + )&? 7(6 *7/&'('()*, 6 &7/-&66 6& 6&'&7 *$-(+6 &6'- 7 8-&'& +6 *'-6 *--(+ /*- 7&5*-&6 /*6(9&6 >-& *7&-(5 +& &(*6. A'-)06 + ('&5(( +& &(*, 6 *-(?9&6 /*+&7 '&- 7 8>(5 &66* (8*-79&6 /- '*7+ +& +&(6:*, '-68*-7+* ++*6 6('&'(?+*6 &7 (8*-79&6 6((8('()7&'& '&(6, 507 +& +(6'-($(- &66&6 ++*6 &'-& '*+*6 @& &&66('7 '&- *&(7&'* 6*$-& &6'&6. A576 +6 /*66($(5(++&6 +& BI, &'-& *'-6, 6:* T-$5- *7 (/'&6&6
A5(6& +& ++*6 U'(5(?- &K/&-((6 '&-(*-&6 I7/*-'- (8*-79&6 +6 7(6 +()&-66 8*'&6 +& ++*6.
D('& +&6'& *'&K'* +* *&(7&'* +@(-(+* '-)06 +* -7?&7&'* & &66* &8((&'& + (8*-79:* @& 6-& * *&('* B6(&66 I'&55(&&, % /5(9:* 0 %6'(8(+ /&5 *$6&-)9:* +& A'-& & M*66 <23= N*6 *7/&'('()*6 +(6 '(6 & * 7&'* + (&-'&? 7+(5, @5(++& & *)&(( + *-(?9:* +& 7 /5(9:* +&B6(&66 I'&55(&&
N* &''*, * BI :* )( '-$5- 6*7&'& -&59:* + &7/-&6 *7 6& *67(+*-. U7 +6 -'&-H6'(6 (7/*-''&6 +* BI 0 %6'7&'& ('&-9:* +& (8*-79&6 /-*)&(&'&6 +& '*+6 6 >-&6 + &7/-&6, &-+* 6*59&6 & 8&--7&'6 /- >5(6&6 */&-(*(6 & 8(&(-6, $&7 *7* * &-&(7&'* + +&( +& 8*-&&+*-&6, 5(&'&6 & +*6 /-/-(*6 8(*>-(*6.
CONCEITOS GERAIS
BUSINESS INTELLIGENCE (BI) B6(&66 I'&55(&& (5 &66* 6 (8*-79&6 +* &(*. 5(6&6 *7/&'('()6. O-(?9&6 *7/&'('()6 757 ;('&5((; 7&+(+ @& 7 66'&'9:* 6 )'&7 *7/&'('(), /*+&+* *6(+&-- '5 ('&5(( *7* * 6/&'* &'-5 /- *7/&'(- &7 56 7&-+*6. G&-57&'&, *6 *5&'*-&6 +& BI *$'7 6 8*'&6 /-(7>-(6 +& (8*-79:* +&'-* +6 66 &7/-&66. C+ 8*'& %+ @&7 '&7 @& +&(+(- &'&+&- *7* *
/*+&-> 8?&- + 8*-7 7(6 *--&' /*66H)&5. A6 8*'&6 6&+>-(6 +& (8*-79&6 (5&7 6 &&66(++&6 +* *67(+*-, /-*&66* +& +&(6:* +* 5(&'&, /-&66&6 *7/&'('()6, *+(9&6 (+6'-((6 -&5&)'&6, 6/&'*6 &*7(*6 & '&*5(*6 & '&+(6 5'-(6. C+ 6(6'&7 +& BI +&'&-7( 7 7&' &6/&H8(, '&+* /*- $6& * *$%&'()* *-(?(*5 * )(6:* + &7/-&6, &K(6'(+* &7 7$*6 *$%&'()*6, 6&%7 &5&6 +& 5** * -'* /-?*. B6(&66 I'&55(&& 7 8*-'& '&+( +& @& *6 /-*+'*6 @& *7/&7 * 6(6'&7 +& BI +& 7 &7/-&6 /66&7, (6*5+7&'&, /-*)&- 89&6 &K'-6 @& K(5(&7 '*7+ +& +&(6&6. P*- &K&7/5*, '*+*6 *6 6(6'&76 @& 8(*7 7 /&-6/&'() +& *-(?9:* + (8*-79:*. A 7&'*+*5*( +& BI /*+& 6&- '(5(?+ /- '((- 7('*6 *$%&'()*6 *7* D&'&-7(- /&-8(6 +& *67* M*+&5&7 +& *)*6 /-*+'*6 & 6&-)(9*6 A'&(/- 7+96 * 7&-+* P*66($(5('- 7 7+9 7(6 +&'5+ 6*$-& *6 6&6 5(&'&6 A'&(/- 6 9&6 +*6 *7/&'(+*-&6 D&6*$-(- *)*6 * /*'&((6 *7/&'(+*-&6 G&-- 7 /-&+(?+* /-'(- +*6 6&66*6 & +6 856 C-(- *)6 */*-'(++&6 +& &(*6 R&)&- 66 /-/-(6 /->'(6 +& &(*6 AK(5(- (7/5&7&'9:* +& *)6 8&--7&'6 &-&((6. S&+* * G-/* G-'&-, 7(*- 7&9 +6 &7/-&66 + '5(++& 0 * +&6*&(7&'*... O B6(&66 I'&55(&& 6& &7/& &7 &5(7(- 6 +)(+6 & (*-( +6 &7/-&66 6*$-& 66 (8*-79&6, /-*)&('+* *6 &*-7&6 )*57&6 +& ++*6 *5&'+*6 /&56 &7/-&66. T&7 *7* /-((/5 *$%&'()*
('&-9:* +*6 /5('()*6 & '&*5*(6 /- &K'-(- & 5(6- *6 ++*6 *-/*-'()*6 +& 7&(- 6(7/5&6, * 8*-7'* *--&'* & * '&7/* &-'*, /- @& &7/-&6 /*66 '*7- +&(6&6 7&5*-&6 & 7(6 ->/(+6, K(5(+* *6 &K&'()*6 &7 6&6 &(*6. B-$(&-( &'&+& B6(&66 ('&55(&& *7* 7 -+) *&('5 @& &)*5)& I'&5(( C*7/&'('() 5(6& +& 7&-+*6, &'. )&5 /&5 *5&' +6 (8*-79&6 6 7(6 +()&-66 8*'&6, +&6+& 6(6'&76 */&-(*(6 '0 -@()*6 '&K'* * /5(56. D' M-' 5(6&6 /*6'&-(*-&6. F&--7&'6 BI -(* +& 7 /-*%&'* +& BI. A6 /5(9&6 /*+&7 6&- &7 8*-7 +& (+(+*-&6 ->8(*6, -&5'-(*6 /+-*(?+*6 & +* <* /-/-(* 6>-(* &- 6 *65'6 +& *-+* *7 66 &&66(++&6 +& -?- 6 (8*-79&6 +& 7 8*-7 '&6 )(6'=, /*-'5 +& ('-&' " ('&-&' " &K'-&', >5(6& OLAP /(+6 *65'6 5H'(6 +& '-&? '(/(7&'& +(7&6(*5= & *'-6 89&6, *7* D' M(( -(*6 8'-*6.
T+CNICAS DE BI E SOLUÇ,ES UTILI-ADAS*
CONCEITOS/APLICAÇ,ES UE FA-EM USO DA T+CNICA DATA ARE'OUSE 0 7 *%'* +& ++*6 /-*+?(+* /- 8*-&&- 6/*-'& '*7+ +& +&(6:*. U7 -&/*6('-(* +& ++*6 '(6 & (6'-(*6 +& /*66H)&5 ('&-&66& *6 &-&'&6 +& '*+ *-(?9:*. É 7 /-*&66* @& 6& /-&*/ &7 &K'-(-, ('&-- & 5(7/- 6 (8*-79&6 ''* +*6 6(6'&76 ' -6(*(6 '* 6 (8*-79&6 &K'&-6. A507 +(66* * DQ +(7&6(* & *6*5(+ &66&6 ++*6, *-(?+**6 +& 8*-7 @& 7&5*-& /&-8*-7& +6 *65'6.
D3 M3 6$*%'* +& 7 DQ @& '&+& /&6 7 >-& +* &(*. EK&7/5*6 DQ +* $6'&(7&'* <)-&%*= *7/*6'* /*- &+6, P-&). +& D&7+, S*-'(7&'* &'-& *'-*6.
C56 67 A87973;<= 67 66=9 (F=3 E6): ('&-8& @& /-&6&' *6 ++*6 +(6/*H)&(6 * 6>-(*
F7573 67 7>3?@=9 86=@6=9: /*66($(5('7 -(9:* +& -&5'-(*6"+6$*-+6 /-0+&8((+*6 Y 6>-(*6 8((6. EK&7/5*6 SSRS
F75739 OLAP: 6 *65'6 OLAP /*66($(5('7 -(9:* +& -&5'-(*6"+&7*6'-'()*6 /&-6*5(?+*6 <)(6&6 " &>-(*6=. EK&7/5*6 SSAS
D35@@: '0( /- +&6*$-(- /+-&6 & -&59&6 &'-& ++*6, *6 @(6 :* 6& *6&& *$'&- +& 8*-7 ('('() & *7 *'-6 8&--7&'6"'0(6. EK C6& + &-)&% & +6 8-5+6
DIFERENÇAS ENTRE OLAP E DATAMINING E SUA EPLORAÇÃO DOS DADOS
" OLAP: >5(6& /*- )&-(8(9:* <* 5(6' *&& @&6':*, &5$*- (/'&6& & )&-(8( *7 8&--7&'=.
" DATAMINING: @&6':* 0 '*'5 * /-(57&'& +&6*&(+ & 8&--7&' 0 '(5(?+ /- $6 +& *&(7&'* <*&('*6 +& IA= P-*/-(&++&6 +& 7 $*7 DQ I.
F>(5 &66* *6 ++*6
II.
A (8*-79:* &-+ +&)& 6&- 5'7&'& *8(>)&5
III.
D&)& 6&- +/'>)&5 7+96 <&&66(++&6 +*6 6>-(*6, &(*6, '&*5*(=.
I.
A7$(&'& 6&-* <7('*6 ++*6 *8(+&((6=
EK(6'&7 3= /-*/-(&++&6 $>6(6 O-(&'+* 66'* S 7*+&5&7 0 *-(?+ &7 '*-* +& 66'*6 &6/&H8(*6, &K5(+* ++*6 :* -&5(*+*6. I'&-+* É ('&-9:* +& +(8&-&'&6 8*'&6 +& ++*6, '-)06 +& '-'7&'*6 & /+-*(?9:* *6 -&5(*7&'*6. N:* )*5>'(5 A6 (8*-79&6 :* 6:* '5(?+6, 8( -++ &7 7 (6'-(* *8(>)&5 & -&5(*+* *7 6 (8*-79&6 @& 5&6 6:* *6(6'&'&6. -(>)&5 *7 * '&7/* P*66($(5(' -&5(?- >5(6&6 +& '&+(6 * 5** +* '&7/* *7 66 (8*-79&6.
MODELAGEM DIMENSIONAL S:* ++*6 /?&6 +& 6&- *-(?+*6 +& )>-(6 7&(-6 +& *-+* *7 +&'&-7(+* 66'* &6/&(8(*, )(65(?+* &7 )>-(6 /*6(9&6. É '0( +& /-*%&'* 7(6 8-&@&'& '(5(?+ *6'-9:* +& 7 DQ. O *$%&'()* 0 $6- 7 /+-:* +& /-&6&'9:* +& ++*6 @& 6&% 8(57&'& )(65(?+* /&5* 6>-(* 8(5.
CUBO DE DADOS MULTIDIMENSIONAL E SUAS ANALISES U7 $* -&/-&6&' 7 *%'* +& 7&+(+6 @& 6:* -/+6 & *-(?+6 (&--@(7&'& /*- +(7&6&6 /-'(- +& 7 $6& +& ++*6. E7$*-
6&% 7+* +& $*, /*+& 6&- $(+(7&6(*5, '-(+(7&6(*5 * *7 +(7&6:* 6/&-(*-. S&-)& /- 7*+(8(- /*6(9:* +& 7 (8*-79:*, 5'&-- 5(6 /*- *5. O 7*+&5* +(7&6(*5 0 *7/*6'* $6(7&'& /*- '-6 '(/*6 +& '$&56 F'* A '$&5 8'* 6:* 6 '$&56 &'-(6, *7 -+& )*57& +& ++*6, A-7?& 6 7&+(+6 70-(6 +* &(* & )&6 +6 +(7&6&6 )&5 70-( @& -&/-&6&' 7 8'*. C+ '$&5 +& +(7&6:* /*66( 7 ( )& /-(7>-(, & * *%'* +&666 )&6 /-(7>-(6 8*-7 )& *7/*6' + '$&5 +& F'*. C+ &(* * 66'* /*66( 6 '$&5 +& F'* & 66 -&6/&'()6 '$&56 +& D(7&6:*.
MODELO ESTRELA: N* 7*+&5* &6'-&5 '*+6 6 '$&56 -&5(*76& +(-&'7&'& *7 '$&5 +& 8'*6, 6&+* 66(7 6 '$&56 +(7&6(*(6 +&)&7 *'&- '*+6 6 +&6-(9&6 @& 6:* &&66>-(6 /- +&8((- 7 566&. E6'& 7*+&5* 0 7+* +& &6'-&5 /*-@& '$&5 +& 8'*6 8( * &'-* &-+* +6 '$&56 +(7&6(*(6 6&7&5'& 7 &6'-&5. O+& 0 /*66H)&5 *$'&- )>-(6 (8*-79&6 6*$-& 5*% & * /-*+'* +@(-(+*. É 7 7*+&5* 6(7/5&6 & &8((&'&, -'&-(?+* /*- /*66(- 7 ( '$&5 +& 8'*6 & )&6 6(7/5&6 6 '$&56 +& +(7&6&6. C+ +(7&6:* 0 -&/-&6&'+ /*- 7 ( '$&5.
BENEFCIOS DAS T+CNICAS EMPREGADAS:
O6 /*'*6 /*6('()*6 +&6'& 7*+&5* 6:* &8(((, ++ /&5* -&+?(+* 7&-* +& %9&6 6 /&6@(66 & /&56 )&6 6(7/5&6, & 8(5(++& +& +&8(((&--@(6.
CUSTO BENEFCIO DA IMPLANTAÇÃO DE UMA SOLUÇÃO BI A6 *-(?9&6 )7 $6+* (*)9&6 +& '*+6 6 8*-76, 57&%+* :* 6 '&+&-, 76 6-/-&&+&- 6&6 5(&'&6, 8*-&&+*-&6, & 56 6*6, '0 7&67* 6&6 *5$*-+*-&6. U7 +6 8*-76 +& (*)- 0 '&- &66* & *&(7&'* ->/(+* +6 (8*-79&6 -&6/&('* + 6('9:* -&5 + &7/-&6. U7 6(6'&7 +& BI V B6(&66 I'&55(&& V /&-7('& @& *-(?9:* '& (8*-79&6 +& 8*-7 >(5 & /-&6&'+6 +& +()&-66 7&(-6 /- >5(6&6 &7 )>-(6 +(7&6&6, )*5'+* /- * /5&%7&'* &6'-'0(* &7/-&6-(5. T&+* &7 )(6' &66 &&66(++&, 576 &7/-&66 &6':* (7/5'+* * %> (7/5'-7 7 6(6'&7 +&
Business
I'&55(&&
(7/5'-7 7 6(6'&7 +& B6(&66 I'&55(&& *7 &-'&? 6 '7 -. É 5-* @& *7* '*+ & @5@&- 7+9, (7/5'9:* +& 7 BI /*+& 5&)- -&6(6'( +& 7('*6 *5$*-+*-&6, * &''*, 7 -'* &6/9* +& '&7/*, '*+*6 6&6 6>-(*6 +(-&'*6 * (+(-&'*6, /&-&$&7 *6 -+&6 $&&8H(*6 @& * 7&67* '-? /- &7/-&6. E'-&''*, +&/*(6 +&66 86& (((5, *6 -&'*-*6 6:* ':* $&08(*6 @& 6/&-7 6 +(8(5++&6 &8-&'+6 * (H(* + (7/5'9:*. D&'-& *6 /-((/(6 $&&8H(*6 @& 7 6*59:* +& B6(&66 I'&55(&& '-? /- 6 *-(?9&6, +&6'76& •
R&+9:* +& /-*&66*6
•
S$6'('( *'-6 8&--7&'6, *7* /*- &K&7/5*, EK&5, * 6&'(+* +& +&6&)*5)&- 8-756 * 7&67* /- $6 +& (8*-79&6, $&7 *7* +& *'-*6 6(6'&76 7(6 &&66+*6 &7 '&-7*6 +& &-- (8*-79&6 & -&5'-(*6
•
A(5(++& *$'&9:* +& (8*-79&6 & -&5'-(*6
•
F5&K($(5(++& & /&-6*5(?9:* +& (8*-79&6 & -&5'-(*6, 8(5('+* 6 >5(6&6 6&-&7 -&5(?+6
•
F(5(++& +& 7*+(8(9:*"7&5*-( *6 -&5'-(*6, *7* /*- &K&7/5*, 5'&- 8*-7 +& /-&6&'- *6 ++*6 & -&6&'- *)6 (8*-79&6 *'-($(+* 66(7 /- &)*59:* *'H +6 >5(6&6 +& (8*-79&6 *7* '7$07 + '&*5*(
•
A6 (8*-79&6 6:* +(6/*($(5(?+6 '&5 +* 6*8'[-& &7 /**6 6&+*6 +&/&+&+* +*6 8(5'-*6
•
F(5(' * /5&%7&'* + &7/-&6 *6 +()&-6*6 H)&(6, :* 6 * H)&5 &6'-'0(*, *7* '7$07 * '>'(* & */&-(*5
•
A&66* 6 (8*-79&6 /-'(7&'& *5(&. O '&7/* & * )5*- +* ()&6'(7&'* +* 6(6'&7 +&/&+&7 +& )>-(*6 8'*-&6, '(6 *7* + @'(++& +& 7+5*6 6&-&7 (7/5'+*6, $&7 *7* +* - +& (8*-79&6 6&-&7 +(6/*($(5(?+6 &7 + 7+5* +*6 -&-6*6 & +6 &6'-'-6 '&*5(*6 @& &7/-&65(&'& /*66( +* 6&7&'* @& *-(?9:* ' + 5'- *-(?(*5, * 6&%, 6& 0 7(6 '-+((*5 * 7(6 (*)+*- + +(6/*($(5(++& +*6 8(*>-(*6 + &7/-&6 @& *7/-:* *6 /-*&66*6 +& (7/5'9:* +* BI & + )5(+9:* +6 (8*-79&6.
DISSERTAÇÃO
A6 *-(?9&6 '(/(7&'& -&*5&7 (8*-79&6 *7 8(5(++& +& )5(- * 7$(&'& &7/-&6-(5, *7/5&'+* &6'6 (8*-79&6 *7 /&6@(66 +& 7-&'(, (+6'-((6 & +& 7&-+*, 507 +& >5(6&6 *7/&'('()6. O-(?9&6 *7/&'('()6 757 ;('&5((; 7&+(+ @& 7 66'&'9:* 6 )'&7 *7/&'('(), /*+&+* *6(+&-- '5 ('&5(( *7* * 6/&'* &'-5 /- *7/&'(- &7 56 7&-+*6. G&-57&'&, *6 *5&'*-&6 +& BI *$'7 6 8*'&6 /-(7>-(6 +& (8*-79:* +&'-* +6 66 &7/-&66. C+ 8*'& %+ @&7 '&7 @& +&(+(- &'&+&- *7* * /*+&-> 8?&- + 8*-7 7(6 *--&' /*66H)&5. A6 8*'&6 6&+>-(6 +& (8*-79&6 (5&7 6 &&66(++&6 +* *67(+*-, /-*&66* +& +&(6:* +* 5(&'&, /-&66&6 *7/&'('()6, *+(9&6 (+6'-((6 - &5&)'&6, 6/&'*6 &*7(*6 & '&*5(*6 & '&+(6 5'-(6. C+ 6(6'&7 +& BI +&'&-7( 7 7&' &6/&H8(, '&+* /*- $6& * *$%&'()* *-(?(*5 * )(6:* + &7/-&6, &K(6'(+* &7 7$*6 *$%&'()*6, 6&%7 &5&6 +& 5** * -'* /-?*. B6(&66 I'&55(&& 7 8*-'& '&+( +& @& *6 /-*+'*6 @& *7/&7 * 6(6'&7 +& BI +& 7 &7/-&6 /66&7, (6*5+7&'&, /-*)&- 89&6 &K'-6 @& K(5(&7 '*7+ +& +&(6&6. P*- &K&7/5*, '*+*6 *6 6(6'&76 @& 8(*7 7 /&-6/&'() +& *-(?9:* + (8*-79:*. T&7*6
ERP V E'&-/-(6& R&6*-& P5( CRM V C6'*7&- R&5'(*6(/ M&-. S&+* B-&' F-&(, 8++*- + OK S*8'[-&, C6'*7&- R&5'(*6(/ M&7&' 56 *6 :* &- /*66H)&5. A6 TI /&-7('&7 *8&-&&- @5(++& 7 /-&9* *7/&'('()* +H * CRM 6&- 8+7&'5 * &6'$&5&(7&'* +6 -&59&6 & 8(+&5(?9:* +*6 5(&'&6. *%&, 0 (7/*-''& -&'$(5(?- 7>K(7 LT -(* +&6&)*5)&- &66&6 5(&'&6 '-)06 +& (&'()*6. O (7/*-''& 0 '-68*-7- &6'&6 5(&'&6 &7 CM. E*'-- &6'-'0(6 /- *6 $('- '-$5- *7 *6 *66*6 /-*+'*6 *-(?9:* C5(&'&6 I'&-70+(*6 76 @& 6:* 5-'()*6, /*-07 6&7 -+& &K/-&66:*. O /*'&(5 +& 7 8&--7&' +& CRM -&)&56& &6@&7'(?9:* +*6 +()&-6*6 ++*6 +(6/*H)&(6 +& 8*-7 -(- (8*-79:* )5(*6 /- '(5(?-6& &7 /-*5 + &7/-&6 & +6 66 -&59&6 *7&-((6. T&-&7*6 7 B! 8(5('- :* 6 (+&'(8(9:* +*6 5(&'&6 V -(+* $6&6 +& (8*-79&6 -&5'()6 *6 5(&'&6 +& *-+* *7 * 6& /&-8(5 V *7* (-> 8(5('- 6&7&'9:* +*6 7&67*6 *'-($(+* /- *
+&6&)*5)(7&'* +*6 +()&-6*6 /-*&66*6 +& 8(+&5(?9:*"-&'&9:* +& 5(&'&6. +* 0 (7/5&7&'+* 7 /-*-7 +& BI +&)&6& -&5(*- 6 @&6'&6 & 66 /*66H)&(6 +&(6&6, '(6 *7* &6'&6 +& 5(7&'* +& 7&'6 0 * /-(7&(-* /66* /- +&'&-7(- /-*/*6'6 +& -'* & 70+(* /-?*6 +* /-*-7. &6'&6 +& $6& *5&' +& (8*-79&6 +& *7/&'( '5 & 66 &&66(++&6. C6'*6 & R(6*6 6 *6&@(6 8(&(-6 + *) ((('() +& BI +&)&7 6&&6'(7+6. C5(&'& & ;6'&*5+&-; +&'&-7( @&7 6&-:* *6 $&&8((+*6 + ((('() & @&7 /-> /*- &5. M0'-(6 -&5(*+6 &6'&6 -&@&-(7&'*6 +& (8*-79&6 +&)&7 6&*/&-(*5(?+*6 *7 5-&? & +&8((+6 /*- /-7&'-*6 70'-(*6 . M&6-9:* M&'*+*5( +&)& 6&- &6'$&5&(+* 7 70'*+* * /-*&+(7&'* /- +&'&-7(- 7&5*- * &('>)&5 7&(- +& 7&+(- *6 -&@&-(7&'*6 70'-(*6. B6(&66 I'&55(&& /*+& 6&- 6+ 6 6&('&6 >-&6 +& 7 &7/-&6 /- 7&'- * 6& )5*- *7/&'('()* M&+(9&6 V F9&6 '*7'(?+6 /- -(7 (&--@( +& ++*6 +& +&6&7/&* @+* 6& @&- 59- +&'&-7(+6 7&'6. A5H'(*6 V F9&6 '*7'(?+6 @& -(7 /-*&66*6 @'(''()*6 /- /&-7('(- @& &7/-&66 '*7& +&(6&6 *'(7(?+6. •
•
R&5'-(*6 V F9&6 '*7'(?+6 @& 8*-&&7 -&5'-(*6 &6'-'0(*6 /- &-&( +* &(*. P5'8*-7 +& C*5$*-9:* F9&6 '*7'(?+6 /- /&-7('(- @& >-&6 ('&-6 & &K'&-6 + &7/-&6 /*667 /-'(5- '-)06 +& D' 6-( & E5&'-*( D' I'&-&. G&-&( +* C*&(7&'* V F9&6 '*7'(?+6 /- '*-- 6 9&6
+ &7/-&6 $6&+6 &7 ++*6 '-)06 +& &6'-'0(6 & /->'(6 @& (+&'(8(7, -(7, -&/-&6&'7, +(6'-($&7, & /&-7('&7 +*9:* +& )(6&6 & &K/&-((6 @& 6:* $6& +* &(* I'&-&66'& *7* 56 '&-7*6 6+*6 &7 *66* +(+( 6:* 7(6 8>&(6 +& 6& &'&+&-&7 /-'(+* '-+9:* * /0 + 5&'-\ C*7 * BI, (66* 8( -&57&'& 7('* 6(7/5&6. B6(&66 I'&55(&&, &7 *66* (+(*7 '/((@(7, + 7(6
6((8( +* @& I'&5(( +* N&(*. M6 * @& )7 6&- &66 &K/-&66:*\ É *7/5(+* +&6-&)&- &7 /*6 /5)-6, * &''*, +> /- +(?&-7*6 @& 6& *6 6(6'&76 +& BI 8*-&7 (7/5'+*6 +& 8*-7 *--&', 0 7 7( +& *-* /- 6 &7/-&66 & (66* 0 7 +*6 /*'*6 /-((/(6 & 8+7&'(6 /- )(+ +& 7 /&66* %-H+(\ S&% &5 /$5( * /-()+. E6'&6 '(6 /-*-76 6:* 7 KH5(* 8+7&'5 * /-*&66* +& '*7+ +& +&(6:* &-&(5. C*'+*, /- @& -&57&'& % 7 I'&5(( +& &(* )*5'+* -&57&'& * /-*&66* + &7/-&6, 0 +& 8+7&'5 & (7/-&6(+H)&5 (7/*-'( +& @& 6&%7 5(6+*6 56 /*'*6 <5(&-&6= *6 @(6 6&-:* 8-'*6 +& *666 *)&-66 8'-6. F( 6(7/5&6 & '&+&-7*6 * /*-@ &K/-&66&6 *7 @5(++& & *7/&'('()(++& &7/-&6-(5 8?&7 /-'& +* +(>-(* +& @5@&- &7/-&6. A6 &7/-&66 @& :* 7&+&7 &68*-9*6 /- *@(6'>56 & '56 *7* 6& 5(&'&\ 7(6 8(&5, *7 &-'&?, &6'-:* 8++6 * 8&7&'* +& 66 /*-'6. ]'(7* /- + 7 +& 6, 5(&'&6 & *67(+*-&6 O '&-7* B6(&66 I'&55(&& :* 0 -&&'& *7* +&)&7*6 (7(- * /-(7&(-* (7/'*. O 6& *&('* /->'(* %> &- 6+* /&5* /*)* '(*. A6 6*(&++&6 +* O-(&'& M0+(* '(* '(5(?)7 *6 /-(H/(*6 $>6(*6 +* BI @+* -?)7 (8*-79&6 *$'(+6 %'* '-&? &7 $&&8H(* +& 66 5+&(6. A5(6- * *7/*-'7&'* +6 7-06, *6 /&-H*+*6 )*6*6 & +& 6&, /*6(9:* +*6 6'-*6, &'-& *'-6, &-7 8*-76 +& *$'&- (8*-79&6 @& &-7 6+6 /- '*7+&(6&6 (7/*-''&6 @& /&-7('(66&7 7&5*-( +& )(+ +& 66 -&6/&'()6 *7(++&6. É &)(+&'& @& * M+* &7 @& )()&7*6 7+* +&6+& &':*, /*-07 * *&('* /&-7&& (5'&-+*. A &&66(++& +& -?- (8*-79&6 /- -&5(?9:* +& 7 &6':* &7/-&6-(5 &8(? 0 '57&'& 7 -&5(++& ':* &-)+ &7 *66 6*(&++& @'* * /66+*. O '5 ('&-&66& /&5* BI )&7 -&6&+* 666'+*-7&'& 7&+(+ &7 @& 6& &7/-&* /*66($(5(' 6 *-(?9&6 -&5(?- 7 60-(& +& >5(6&6 & /-*%&9&6, +& 8*-7 (5(?- *6 /-*&66*6 -&5(*+*6 6 '*7+6 +& +&(6:*. É * @& +&8&+& *[-+ D-&6&-, )(&/-&6(+&'& + &7/-&6 G-'&- & +&'&'*- + /'&-(++& +* '&-7*. P&5 /&-&/9:* '&*5(, &- @& /*+&7*6 7- +& ;/-0BI; &6'> 7
/66+* :* 7('* +(6''& &'-& '-(' & @-&' *6 '->6 @+* *6 *7/'+*-&6 +&(K-7 +& */- 656&*-7&6, 7&+(+ &7 @& +(7(H-7 +& '7* &, * 7&67* '&7/*, 6 &7/-&66 /66-7 /&-&$&- *6 ++*6 *7* 7 /*66H)&5 & (7/*-''& 8*'& &-+*- +& (8*-79&6 +&(6-(6 & @& -&+&-(7 &)&'(6 5-*6. E7 &-5, I'&5(( *6 N&(*6 0 )& /- %'- (8*-79:*, /&66*6 & '&*5*( /- +(-((- *7 6&66* 7 *-(?9:*. A/&6- +& *6 )9*6 * /*+&- +& )5(- '&*5*(6 $-, '&*5*( :* -&6*5)&, 6*?(, /-*$5&76 *6 &(*6. T&+* &7 )(6' @& I'&5(( *6 N&(*6 5* /-'(- +& '-6 +(8&-&'&6 /&-6/&'()6 T*7+* 7&5*-&6 +&(6&6 7(6 ->/(+* E7 -&67*, IN $(5(' 6 *-(?9&6 '*7- 7&5*-&6 +&(6&6 7(6 -/(+7&'&. F-&@^&'&7&'& 6 &K/&-((6, &'&+(7&'*6 & &6'-'0(6 @& 5&)7 '*7- +&(6&6 6:* *6(+&-)&57&'& &6'>'(*6, @& /-*-(+&7 7('* 5&'7&'&. C*'+*, (8*-79:* 0 6&7/-& *), & 6& 7*+(8( -/(+7&'& & +& 7 8*-7 &'+. A &&66(++& +& )&5*(++& '7$07 &5&) * * +& -&6/*6'6 +&'-* +& 7 *-(?9:*. S& * ->/(+* &66* & (-* +& (8*-79&6 :* &K(6'&7, +&(6:* 0 8&(' 6&7 -&5 (8*-79:* * (8*-79&6 5'-/66+6. A6 *6&@^(6 +(6'* /*+&7 6&- 7('* (7&66, ''* @'* /&-+ +& 7 *67(+*-)& * /-*+9:* +& 7 /-*+'* @& *6 *67(+*-&6 :* +&6&%7 7(6, &'. E 0 @( @& I'&5(( +*6 &(*6 6& &8*. IN K(5( '*77&5*-&6 +&(6&6 /&5 >5(6& +& @(6 9&6 &6':* -&65'+* * /-*-&66* &7 +(-&9:* *6 *$%&'()*6 + *7/(. I'&5(( *6 N&(*6 :* +&)&-( 7&-7&'& 6&- 6+ *7* 7 8&--7&' /- 6*7&'& -&&$&- /5*6 %> '*7+*6 & 6>5*6 /- -+- * 7&+(- @5(++& +6 +&(6&6. I'&5(( *6 N&(*6 &)*5)& /-((/57&'& * //&5 -(9:* +& '(/*6 +& &6'-'0(6 & /5*6. A'&-(*-7&'&, /- * (H(* + E- + I8*-79:*, *(H(* +* 605* 2, &7/-&6>-(*6 '(7 @& *5&'- ++*6 /-'(- +& 7 /&6@(6+*- :* '*7'(?+*. O6 &7/-&6>-(*6 6&'(-7 85' +& 7 -&-6* *7/'+*-(?+* /- 5(6+&)(+7&'& *6 ++*6, & *7* -&65'+*, *7/(6 8-&@^&'&7&'& '*7-7 +&(6&6 *6 &(*6 /-(7&(-7&'& $6& + ('(9:*. P&5* 8'* +*6 &7/-&6>-(*6 '*7'(?-&7 + )&? 7 7&-* 7(*- +& 6(6'&76, 7(6 & 7(6 ++*6 6& '*--7 +(6/*H)&(6. C*'+*, 6*7*6& *'(9:* +& 7 +&68(* +&)(+* 85' +& (8-&6'-'- /- 7+9 +& ++*6 * /&56
(*7/'($(5(++&6 &'-& 6(6'&76. A>5(6&6 +& ++*6 @& &-7 *5&'+*6 & -&/*-'+*6 +*6 -@()*6 576 )&?&6 5&))7 7&6&6 /- 6&-&7 &-+6. A56 -&5'-(*6 5&)-7 (8*-79&6 +& &6'-'0( 5** /-?* '*7+ +& +&(6:*. C*'+*, '*7+ +& +&(6:* &6'-'0( -'* /-?* *'(* /-&)5&&- *7 ('(9:*. C*)&-6:* +& ++*6 &7 (8*-79:* P- '*7- 7&5*-&6 +&(6&6 7(6 -/(+7&'&, *6 &K&'()*6 +& &(* & +7((6'-+*-&6 /-&(67 +& (8*-79&6 -&5&)'&6 & 6(6. M6 6&7/-& > 7 -+& $-& &'-& (8*-79:* @& *6 '*7+*-&6 +& +&(6:* -&@&-&7 & 6 7*'6 +& ++*6 -&'(-+*6 +*6 &(*6 '*+*6 *6 +(6. I6'* 0 7+* +& $-& +& >5(6&. I'&5(( *6 N&(*6 &66 &*-7&6 )*57&6 +& ++*6 & -&)&5 -&5&)'&6 6$*%'*6 (6''&7&'& /- *6 '*7+*-&6 +& +&(6:* +& 7 8*-7 /&5 @5 6 /&66*6 /*+&7 8(57&'& -&5(*-. A56 77 (66* +& >5(6& )&5*(++& +* /&67&'*, /*- &K&7/5*, 6&- >$(5 -&6/*+&- 7 @&6':* ':* -/(+7&'& @'* &5 8*( 8*-75+. A /-'& 7(6 +(8H(5 + I'&5(( *6 N&(*6 0 '&- $(5(++& +& 6$&- @5 (8*-79:* -&57&'& 6&-( -&@&-(+ /*- 7 *-(?9:* & @5 -&57&'& :* '&7 -&5&)(. U6+* 7 7(* -(*5 +7((6'-9:* S& I'&5(( *6 N&(*6 0 (*-/*-+, (6'* '--> +& 8'* *-&65'+* @& 8*-7 /&5 @5 0 7+ /-*/&, $6(7&'& 7 7(* -(*5 <('&5(&'&= '*7+ +& +&(6&6. U7 '('+& +& I'&5(( *6 N&(*6 6&-> -&85&'(+ /&5 *-(?9:*. O @& 0 '('+& +& I'&5(( *6 N&(*6\ U6- 70'*+*6 *-(?+*6 & '&*5*(6 /- 5(6- 8'*6. O &K/&-(7&'* +& 7(*6 5'&-'()*6 & 7*('*-9:* +& -&6/*6'6 ('&-6 *6 -&65'+*6. L(+- *7 * 6& &(* $6&+* &7 '*+6 6 -'&-H6'(6 7&(*+6 (7. A ('&5(( *7/&'('() /*+& 6&- )(6' *7* *6 5+*6 +& 7 /(-7(+& P&66*6 -&8&-&6& 6&5&9:*, '-&(7&'*, 5*9:* & &6':* +6 &@(/&6 P-*&66*6 -&8&-&6& /-*&66*6 & '()(++&6 -&5(*+*6 ('&5(( *7/&'('() + *-(?9:* I8*-79&6 '*+6 @&56 @& 6:* +& ('&-&66& + &7/-&6, 6 @(6 6&-:* 7(/5+6 & 5(6+6. T&*5*( R&8&-&6& (8-&6'-'- /- 6/*-'- *6 /-*&66*6 +& ('&5(( *7/&'('() *-(?9:*.
RELAT.RIO COM LIN'AS DE C.DIGO
USE _76'&-` GO "aaaaaa O$%&' D'$6& _L*%` S-(/' D'& 2"11"214 233#1b aaaaaa" CREATE DATABASE _L*%` CONTAINMENT c NONE ON PRIMARd < NAME c NeL*%e, FILENAME c NeCfP-*-7 F(5&6fM(-*6*8' SL S&-)&-fMSSL11.MSSLSERERfMSSLfDATAfL*%.7+8e , SI!E c #12WB , MAXSI!E c UNLIMITED, FILEGROQT c 124WB = LOG ON < NAME c NeL*%g5*e, FILENAME c NeCfP-*-7 F(5&6fM(-*6*8' SL S&-)&-fMSSL11.MSSLSERERfMSSLfDATAfL*%g5*.5+8e , SI!E c 124WB , MAXSI!E c 24GB , FILEGROQT c 1h= GO ALTER DATABASE _L*%` SET COMPATIBILITdgLEEL c 11 GO IF <1 c FULLTEXTSERICEPROPERTd
ALTER DATABASE _L*%` SET ANSIgNULLgDEFAULT OFF GO ALTER DATABASE _L*%` SET ANSIgNULLS OFF GO ALTER DATABASE _L*%` SET ANSIgPADDING OFF GO ALTER DATABASE _L*%` SET ANSIgQARNINGS OFF GO ALTER DATABASE _L*%` SET ARITABORT OFF GO ALTER DATABASE _L*%` SET AUTOgCLOSE OFF GO ALTER DATABASE _L*%` SET AUTOgCREATEgSTATISTICS ON GO ALTER DATABASE _L*%` SET AUTOgSRINW OFF GO ALTER DATABASE _L*%` SET AUTOgUPDATEgSTATISTICS ON GO ALTER DATABASE _L*%` SET CURSORgCLOSEgONgCOMMIT OFF GO ALTER DATABASE _L*%` SET CURSORgDEFAULT GLOBAL GO ALTER DATABASE _L*%` SET CONCATgNULLgdIELDSgNULL OFF GO ALTER DATABASE _L*%` SET NUMERICgROUNDABORT OFF GO ALTER DATABASE _L*%` SET UOTEDgIDENTIFIER OFF GO ALTER DATABASE _L*%` SET RECURSIEgTRIGGERS OFF GO ALTER DATABASE _L*%` SET DISABLEgBROWER
GO ALTER DATABASE _L*%` SET AUTOgUPDATEgSTATISTICSgASdNC OFF GO ALTER DATABASE _L*%` SET DATEgCORRELATIONgOPTIMI!ATION OFF GO ALTER DATABASE _L*%` SET TRUSTQORTd OFF GO ALTER DATABASE _L*%` SET ALLOQgSNAPSOTgISOLATION OFF GO ALTER DATABASE _L*%` SET PARAMETERI!ATION SIMPLE GO ALTER DATABASE _L*%` SET READgCOMMITTEDgSNAPSOT OFF GO ALTER DATABASE _L*%` SET ONORgBROWERgPRIORITd OFF GO ALTER DATABASE _L*%` SET RECOERd FULL GO ALTER DATABASE _L*%` SET MULTIgUSER GO ALTER DATABASE _L*%` SET PAGEgERIFd CECWSUM GO ALTER DATABASE _L*%` SET DBgCAINING OFF GO ALTER DATABASE _L*%` SET FILESTREAM< NONgTRANSACTEDgACCESS c OFF = GO ALTER DATABASE _L*%` SET TARGETgRECOERdgTIME c SECONDS GO EXEC 66.6/g+$g)-+&(75g6'*-&g8*-7' NeL*%e, NeONe GO USE _L*%`
GO "aaaaaa O$%&' T$5& _+$*`._(K`
S-(/' D'& 2"11"214 233#2 aaaaaa"
SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._(K`< _C*+g(K` _('` NOT NULL, _C*+g5*%` _('` NOT NULL, _+(&(-*` _7*&` NULL, _&@&` _7*&` NULL, CONSTRAINT _PWg(K` PRIMARd WEd CLUSTERED < _C*+g(K` ASC, _C*+g5*%` ASC =QIT
S-(/' D'& 2"11"214 233#2 aaaaaa"
SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._C5(&'&6`< _C*+gC5(&'&` _('` IDENTITd<1,1= NOT NULL, _N*7&gC5(&'&` _)--`<#= NULL, _T&5&8*&g&5gC5(&'&` _-`<1#= NULL, _T&5&8*&g5-gC5(&'&` _-`<1#= NULL, _E+&-&9*g5(&'&` _)--`<#= NULL,
_C*7/5&7&'*gC5(&'&` _-`<1= NULL, _B(--*` _)--`<2= NULL, _(++&` _)--`<3= NULL, _E6'+*` _-`<2= NULL, _C&/` _-`
S-(/' D'& 2"11"214
233#2 aaaaaa" SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._E+gF*-&&+*-&6`< _C*+g8*-` _('` NOT NULL, _C*+gE+gF*-` _('` IDENTITd<1,1= NOT NULL, _E+&-&9*` _)--`<#= NULL, _*7/5&7&'*` _)--`<#= NULL, _$(--*` _-`<1#= NULL, _(++&` _-`<2= NULL, _&6'+*` _-`<2= NULL, _&/` _-`
CONSTRAINT _PWgE+gF*-&&+*-&6` PRIMARd WEd CLUSTERED < _C*+gE+gF*-` ASC =QIT
S-(/' D'& 2"11"214 233#2 aaaaaa"
SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._F(57&6`< _C*+g8(57&` _('` IDENTITd<1,1= NOT NULL, _'('5*g8(7&` _)--`<#= NULL, _+(-&'*-` _)--`<#= NULL, _'*-1` _)--`<#= NULL, _'*-2` _)--`<#= NULL, _P-*+'*-` _)--`<#= NULL, _C*+g&&-*` _('` NULL, _S(*/6&` _)--`<7K= NULL, _C*+gF*-` _('` NULL, CONSTRAINT _PWgF(57&6` PRIMARd WEd CLUSTERED < _C*+g8(57&` ASC =QIT
GO "aaaaaa O$%&' T$5& _+$*`._F*-&&+*-&6`
S-(/' D'& 2"11"214 233#2
aaaaaa" SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._F*-&&+*-&6`< _C*+gF*-` _('` IDENTITd<1,1= NOT NULL, _N*7&g8*-` _)--`<#= NULL, _6(5g8*-` _-`<#= NULL, _RE6/*6)&5g8*-` _)--`<#= NULL, _'&5&8*&gFO-` _-`<1= NULL, _E7(5` _)--`<#= NULL, CONSTRAINT _PWgF*-&&+*-&6` PRIMARd WEd CLUSTERED < _C*+gF*-` ASC =QIT
S-(/' D'& 2"11"214 233#2
_C*+g5*%` _('` IDENTITd<1,1= NOT NULL, _S5-(*` _7*&` NULL, _-*` _)--`<3= NULL, _*--(*` _-`<1#= NULL, CONSTRAINT _PWgF(*-(*6` PRIMARd WEd CLUSTERED < _C*+g8` ASC =QIT
S-(/' D'& 2"11"214 233#2 aaaaaa"
SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._L**`< _C*+g5*9:*` _('` IDENTITd<1,1= NOT NULL, _*+g8(57&` _('` NULL, _C*+g(K` _('` NULL, _C*+g8` _('` NULL, _*+g5(&'&6` _('` NULL, _+'` _+'&'(7&` NULL, CONSTRAINT _PWgL**` PRIMARd WEd CLUSTERED < _C*+g5*9:*` ASC =QIT
GO "aaaaaa O$%&' T$5& _+$*`._L*%6`
S-(/' D'& 2"11"214 233#2 aaaaaa"
SET ANSIgNULLS ON GO SET UOTEDgIDENTIFIER ON GO CREATE TABLE _+$*`._L*%6`< _C*+gL*%` _('` IDENTITd<1,1= NOT NULL, _N*7&g5*%` _)--`<#= NULL, _6(5g5*%` _-`<#= NULL, _E+&-&9*` _)--`<#= NULL, _*7/5&7&'*` _)--`<#= NULL, _$(-*` _-`<1#= NULL, _(++&` _-`<1#= NULL, _&6'+*` _-`<2= NULL, CONSTRAINT _PWgL*%6` PRIMARd WEd CLUSTERED < _C*+gL*%` ASC =QIT
ALTER TABLE _+$*`._(K` QIT CECW ADD CONSTRAINT _FWg(KgL*%6` FOREIGN WEd<_C*+g5*%`= REFERENCES _+$*`._L*%6` <_C*+gL*%`= GO ALTER TABLE _+$*`._(K` CECW CONSTRAINT _FWg(KgL*%6` GO ALTER TABLE _+$*`._E+gF*-&&+*-&6` QIT CECW ADD CONSTRAINT _FWgE+gF*-&&+*-&6gF*-&&+*-&6` FOREIGN WEd<_C*+g8*-`= REFERENCES _+$*`._F*-&&+*-&6` <_C*+gF*-`= GO ALTER TABLE _+$*`._E+gF*-&&+*-&6` CECW CONSTRAINT _FWgE+gF*-&&+*-&6gF*-&&+*-&6` GO ALTER TABLE _+$*`._F(57&6` QIT CECW ADD CONSTRAINT _FWgF(57&6gF*-&&+*-&6` FOREIGN WEd<_C*+gF*-`= REFERENCES _+$*`._F*-&&+*-&6` <_C*+gF*-`= GO ALTER TABLE _+$*`._F(57&6` CECW CONSTRAINT _FWgF(57&6gF*-&&+*-&6` GO ALTER TABLE _+$*`._F(*-(*6` QIT CECW ADD CONSTRAINT _FWgF(*-(*6gL*%61` FOREIGN WEd<_C*+g5*%`= REFERENCES _+$*`._L*%6` <_C*+gL*%`= GO ALTER TABLE _+$*`._F(*-(*6` CECW CONSTRAINT _FWgF(*-(*6gL*%61` GO ALTER TABLE _+$*`._L**` QIT CECW ADD CONSTRAINT _FWgL**gC5(&'&6` FOREIGN WEd<_*+g5(&'&6`= REFERENCES _+$*`._C5(&'&6` <_C*+gC5(&'&`= GO ALTER TABLE _+$*`._L**` CECW CONSTRAINT _FWgL**gC5(&'&6`
GO ALTER TABLE _+$*`._L**` QIT CECW ADD CONSTRAINT _FWgL**gF(57&6` FOREIGN WEd<_*+g8(57&`= REFERENCES _+$*`._F(57&6` <_C*+g8(57&`= GO ALTER TABLE _+$*`._L**` CECW CONSTRAINT _FWgL**gF(57&6` GO ALTER TABLE _+$*`._L**` QIT CECW ADD CONSTRAINT _FWgL**gF(*-(*6` FOREIGN WEd<_C*+g8`= REFERENCES _+$*`._F(*-(*6` <_C*+g8`= GO ALTER TABLE _+$*`._L**` CECW CONSTRAINT _FWgL**gF(*-(*6` GO EXEC 66.6/g++&K'&+&+/-*/&-' i7&cNeMSgD&6-(/'(*e, i)5&cNe*+& &5& '-$5e , i5&)&5'/&cNeSCEMAe,i5&)&57&cNe+$*e, i5&)&51'/&cNeTABLEe,i5&)&517&cNeF(*-(*6e, i5&)&52'/&cNeCOLUMNe,i5&)&527&cNeC*+g5*%e GO USE _76'&-` GO ALTER DATABASE _L*%` SET READgQRITE GO
PROGRAMA EM FUNCIONAMENTO (PRINTS)
BIBLIOGRAFIA
TTP""QQQ.SENIOR.COM.BR"BI" TTP""QQQ.PROFISSIONAISDETECNOLOGIA.COM.BR"BLOG"\Pc11 TTP""QQQ.OFICINADANET.COM.BR"AREA""BUSINESSgINTELLIGENCE TTP""MSDN.MICROSOFT.COM"PTBR"LIBRARd"CC#131.ASPX
FIC'AS
