Учебное пособие ч.2 - 2008

# " # ! . -

# 8;

! # 2 . ;

! ! / ! ! # 0 -

.

@ . " ., ! , g # 8 , !-

#0 " /, " 0 0 " . 0

: . / 0 # ! # ! ! 0 0 (.

, # 8 . ! ! # 0 2 0 1 -

, ! . ). . ! ! 2

# 8, # " 2 98 . " . " ". 1 ! , 0 #0 0

, ! . : . #- / 0. B " . 0 2 / : . 0 - : . / # , ! 9 -

! # 0 ! # "# /, ! 2 !# . 0-

: . /, 1 2, 0 : . / 0 -

/ " " " . #0 #2 1 ! #2-

0 # 8. v . . g # 8 8-

#0 0 #2 ! ! 98 , - : . ! 0 0 .

( .!, 08 ! g', ! #

. 4.4.

&. 4.4. " 0 3 3 + 1 > 5

20

. g # 8 # !

/ ., " # 9 !- 9 9 0 #2 2 .!. B " . 2 #9- 0 # / . -

! #0 0 "-" 0. C <. 0

; ", , . " 2 . 1 ., . # .

' #2 . # " ! 0. 9 ! ! 2 # 8, # " ! #2 8 2 0, -

2 0 2 0 " . 0 " "8- 0.

; . #0 ! . 0 ! #2 0 ! # (ODS - Operational Data Store). # 8 9 ! # 0 ; # -

. ! ! . # . . ! . 2 # ;# . 0

C <, # " :. . / . -

. # 8.. ( " # . -

, , ! . ! ! 2 # 8, # " 2 ! " : ., 8, "H

. B ! ., , " . #0 !-

! 0 0 1 0, . 8 2 /-

. " # .0 ( , ), . ! ! ! # 0 # 8 ( , #). # .-

! ! 9 / .

.0. ; . # ! # #-

. #0 . , ! ! 98 , !-

# 8. # # 8 -

: . / 0 # . . 0 2 0 .- . . 0., ! 08 . -

.

( / 0 ! # # - / # 8 . 2 ! #

# 8 ! . -

#2 . # # 8

., ! # :

21

. . 0 . .;

#2 #2 ( !-

1 ., ! 1 0 ! / 0. " "8 0, ..0, . . , . 1

.);

8 0 .

' ! # #0 " #09 0. ( , . 09 0 ! -

. 1 , 98 .

! # # " 2 .. 6 " # 0 ! # "-

# 0 , # .

#.

', 08 0 / A' !- . # , ! #0 # ! ! . 8

# ! 0 . F . (! #- 29 # ) ! # 9 0 #0 OLAP-#.

. " 2 ! / #2 9 A' OLAP # #-

g'.

1 . ;# . . g' 0 #09 0 ., . . : . / 0 , . 8 : . / -

. A# 0 . " ! 0 ;:: .-

# .! # 8.

"8 . # . # 2 ! .

! ., # ! 2 -

..

1. C 0 ! #2 #:

. #0 "-#;

. #0 .;

. #0 ".

2. C 0 ! . "#:

# 8;

. # "-! /;

! 0 ! #2 #;

# !.

22

3. C 0 : / #2 .:

. ! / : . /;

. ! . 9 .;

. ! # 0;

. ! # ! #2 #0..

08 .0 0 ! . 1# 0

# 0 ! 0, 0 ! 0 .-

. ; . !, 0 ! #. . - ., . 9 0 #2, ! . #2 .

. !.

* * *

B 0 " #21 . ! . # 8 . -

1 ! . 0

(Data Mart). ! . 0 " #21 ! / # # 8 #0 !-

. "#, , 0-

"-.. ; - 0 9 7 5. -

. . 2 . # 2 # 8,

9 0 / #29 : . / " ! 0 #-

! # ! #.

( ! #, #2 . 21

, #2 ! . "# . " # 9 9. . !-

2 # # : # !-

. # 8 . " 0 0 #0 " #-

0 ! # !! ! #2 #.

. #0 # - # 8, , ! #, 9 0 # 9 0

! # . 0. . ' #2 .

! . 8 2 0 # ! 2

# # 8.

< # ."- / " # - # 8. , ! ! 9 / #2-

# 8 - « ».

23

4.4.2. (7 1 K 0) 0 + 1 >

5

C 8 9 # ! ! 0

! # 8 : ! ;

; . 0 / 0 . C 0, " # ;:: . ! . 0 #0-

0 !, ! . ! / " 0

# 8 8 #0 0 ! 1 8-

. # : "8 -! 0 – ! #2 0 . #2 ! /

" ( . 4.5.).

&. 4.5. ! 1 0 7 1 2

B . 1 0 8 #0 0 #- / 0 # # ! #- 98 . # . / # ( . 4.6):

! ;

!;

# / 0;

.

24

C 0 ! 1 8 0 ! #0 ! - 1 / # 1 ! . 1- # 9 ; !# / 9 9 ., ! #

: / #2 29. B " #21 . 1 " -

! / # 8 . 21 9 ! !

. ! 1 " ! 9 ! # .- 1 " . ! . . . / #.. ( . , ! #2 . / # ! . 09 0

. # # !,

", .0 # / -

" 8 2 0 ! 1 0 ! !

!! ! ! # . . . 0

. . " . ..

&. 4.6. O 2 0 + 1 > 5

25

< . . " # ! " ; ! ! 0 g # 8 .

C g # 8 98 :-

0 8 #2 !# 0 !- # 0 ". - ! # 2 / # -

# / . ' # " 2 ! # -

2 .!. t # " " 2 2 "0- #2 9 (! #0 . 9 # 98 )

! 9. ' # # ! . ( -

0, . 0 0, #2 0 . .). !-

0 : . / 0 #0 0 ! # . (!- # 0.) #0 0 . ; . ; ! -

0 2 " 2 0 ! . "# 0 -

.

# # 8 #0 2 0 . .-

1 0 ". C , # .

# 8 , 0 0 !# 0 - 8 . 0 . : . / . .! .-

2 #2 # 2 0. . . # " ! -

9 # 8 " 2 ; !. ( ; ! # -

1 2 0 ., ! . ! 9

: . / # 8, ! # " .

! . 829 # 8, #

; ! . #2 ". @ 0 # " 2 ! # " 8 #2 29, " 0 2

1 ", . # " 2 # 0

".

B ! ! # 8 #0 ! 8 0

. 2 ! 0 #0

# .!, 2 0 «"#-

» ! ! # 8, : # 0 - 1 # ! # ! # 0. ' . # ., : . / 9 . . " 2

- "H . - , 1 2

, " 2 # 9.

26

' ! 2 - ; 2 ! 0 .,

. 98 0 , " 2 . 0 2 ;

. ! ! 2 9 # 8. = !- / " # #, ! #0 "0 "H

#0 . / #.. F 2, . # 0, - 1 ! / ! «# ». B ! ., 2 !-

0 # 8 #0 ! # !-, .- . . , 0 .

# ! ! 0

B .-! . (BC) .!. k9" -

. ! # . !, . 0 "H-

. # # 2 . 0

. # 0 0 . / # ., ! . # 2

; #2 ! /, #2 . ! #.. @ . " ., " # . " - " 2 1 ! #2 2 ; 1

#2 1 . #0 ! 0 "8 # 8

#0 ! #.

#2 # 2 " . 2 ! / ! 0 ! / # 0, ! " 0 (ETL - extract, transform and load). B ; . ; ! 1 9 0 ! "#-

. . . , , .

" . " 8 # ! /, ! . 829

. B 0 # . / :-

. / ; . . ; !,

" # ! ..

6 0 1 0 " ; !# / 9,

; . ; ! ! / 0 0, !-

9 ! 0 0, ! #2 " -

0, . 09 0 # " 0 :-

. / ., # 1 9 0 # ! / - " ! .

" # 98 ! . - # 2 ! # 0 ! ", "- " : . / # ! - : . / - / " , 2

27

" . " #0 2 # 8. ; ,

! 2 98 ! /, - " 0 ! H0 #0 2 # . ! ,

! #0 2 . 6 0 ! / ETL, 8-

/ # 0 . 8 . # !-

8, ! #2 9 0 . ; ! - . ! /, "# 0 ., " 0 " #21 , . # 2 ! .

! /.

G8 0 - ; " ! " !. ( . " . ! # 2 ! # 8, -

2 8 " (; # 0, A', -

!) - !, "0 #2 -!# 2 1 2. v ! ! " ! # 0 ! # . ! #2 - # 8 # , ! #2 #9 # !! ! #2-

# 0 ! # 0 #2, #

! #0 0 . 2 ! ! # . !! .

, ! . . # / ! #0 . -

. 2. " 2 2.

2 . ! . ! # 8

; !# / 0 #0 0 / 0 #2

.. = / 8 #0 0 ! . 829 !-

# . 0. ! # -

. #0 .! ! .. C" # - : . / 0 #0 0 H .# . 29 ;:: "

# 8.. < #2 # " !- #09 1 2, 2 ! . !,

! . 2 9 2, # # 2 !-

#2 2, . 2 2 # " !#-! #2.

C # # 9 META Group, 90 – 95 % .!-

, ! . 098 # 8 , . !- # # 400-! / / C <-

.. # . # ! . 8 # 8 -

:

28

: . /: .! 0 ! #

9 9 : . / 9 , "-

2 0 !-# ! # 0

! . "#, ! ! # 8. =

" "# 2 . : ., : /-

. . 0, "8 . ! . .

! . ., "# !-

# .. @, ! ! : . / # 8 " . - #09 : . /, 0 ! ! - # 8;

! #2 2: : #- 8 ! / #2 . " . ! . #0 ! #-

0 " #9 ! #2 ", ! #0 - 2 #2 " . !;

" ": ! / : 0 # 0 -

/ 0 # 8 8 98 ! / #

! #09 2 # . . . #2 .

. ! .. ;

2: / 0 -

#, ! ; . !-

2 #0 ! " 98 : .- / 9 #2 . / ! . 0

#2 . : ,

! ., # "H;

! : .; "#9 # "-

. .;

2 " #2 2: OLTP-. !- 9 #2 . ., ! . 0 0

" ! 1 # 8 "- ! (! #- ), .0 : . / - # 8 / # # . :-

. / (" . . , 08 0 - # 8, # ! # 15- . 0/ !0 #. '-

" #21 , ! #, ! 0 0 ). C " #2 2 , : 0 : . / 0

29