Учебное пособие ч.2 - 2008
.pdf! # "-# . . . ! ; !# / : . 0 #9" -
: . , . 0. # " #- / / ! # :-0 0- #2 ! ! 0 0 8 . ! "- 0. ";
! 1 : . / /
: . / ! ! 0 0;
1 !# 0 ! # 0 . !# : ! # 0 #2 ! ! 0 0 (:, 1
:, :, /);
. 2 0 # 0 #, ! # 0
/ ; #, ! ! #
#2 - . 2 ! 0.
. 2 ! #0 2 : ! ! ! 0 0
: . # 2 ! 0;
" ! ! ". : . /;
! 1 " # 0 #;
" ! . 1 " . . -
! " 0. ".
4.2. + !$$&
< . . ! ..
! # C <.
4 & 3556. , . #-
0 0, . # . 0 ! # 0 2 # #2 ! /, #- . .. C " . #0 - # 0 ! "# . /, .0 !
! 0 ! # C <.
4 & 3556. " ! .-
. 2 . #2 ! # 0 .
. "8 0 ! #2 #0. ! / ! ! 0 0 1.
10
$& 3556. ! " 2 . -
2 . !.
7 & 3556. = ! " 2 " ! 2 -
! ! #2 #0 : . - " . .0.
2 & 3556. g . 2 .
! 2 0 . 0. ! " /. 8 & 3556. ! " 2 . -
! # 0 2 : / ! 0 !
..
6 & (robustness) 3556. = ! 2 ! "-
. # 2 0 # 0 1- " / 1, !-
0. B ! ., " . ! 9 0 1 "
: . / # ! !! . g 0 . 29 " 29 . 8 2 ! # 9 0 2, ; . :
., 0 " " #0 2 0 #
!# 0 1 " /, . " 2 , " ", . . . ",
0 . # 2 0 ! # 2 " .-
1 " / 0, . " 2 . . - 0 , ! #2 ! " ! #-
2 " . # " ! / ! ! 0.
& 3556. , ! #2 #2 .-
# 2 0 ., . 1 0 2 - 1 0 .
' ! # #2 ; . " 0. : . /
# ! ! 0 0 1 . 2 8 0 & ! !:
-! #2 " #21 "H . ;
-/ 0 1 !#
(: . #) ;
-/ . ! " " .!29 . 0. . . . - # . . 1 0 ;
11
-" # . ! -
#2 ! . "# . (! ., #
9 0 ! . #2 !);
-, " # ., "
#09 0;
-! ! 0 # ! /-
« », 0 ., . . !-
! 2 . , . 98 #
: . ! # 0 #0 ! 0,
. " 2 , 1 ";
-! # 2 ! : #2 ! #2 #0 .!29;
-" #21 # ! #2 # (#);
-0 ! 2, 98 0 . 2 ! !- "# 2 0 " 0. . 98 0 !-
.. " ! 0, " 0. ! #2 #0;
-! 0 " #0 # /, . 9 - #2 ! "8 0 =. C . 0 #09 0 -
. #0 ! #2 #, ! " 9 # "
# #2 " ! 9 !
. .. . 9 "-
0 ! " ! .. : .;
-! ! ! / ! 1 0 -
. #2 #2 . . 2 ! 2 #
C < " ! . ., 2 0 .
#2 . ! # 98 . . #2;
-" 2 ! 2 ! !- "# . . 0. # ! 1 9 -
, ! #0 ! #2 #2. < #2 . ! ! " 2 0 . 0 . . # 0. .
! 2 .. B ; #9/ 0 ! / 0 .
# " 2 "H . / # .;
-# 0 2 ! #2 #9 ! # ! / ! 0 0 1. #2 #2 # . 2 - " ., " " 2 - # . 0 #2 — #0 «" . . #».
12
4.3. (1 9 4 0 3 3 !$$&
'#0 C < ! 98 0 # : / 0. < ! # 9 # : /.
B ! #2 #0 Haettenschwiler (1999) # C < !, ! C <. -
C < 0 ., 0 ! . ! / ! 0 0 1 0, . ! #,
1 ! 0 2. 0 C < . # 2 ! #-
, 1 # " 2. ( ! 0 ! #0 k < . 0 2, ! ! # 0 2 # # 1 2 1 0, ! #-
. ., ! # 0 . ; . 0 . #0 !. C . . 0, ! ! # 0 # # 1 ; - 1 0 ! # !0 2 ! #2 #9. / ! #-
0 ! # 0 # 1 0.
B / ! #2 . Power (2003) #:
C <, ! #0 . "8 0. (CommunicationDriven DSS);
C <, ! #0 . . (Data-Driven DSS);
C <, ! #0 . . . (Document-Driven
DSS);
C <, ! #0 . 0. (Knowledge-Driven
DSS);
C <, ! #0 . . #0. (Model-Driven DSS). C <, ! #0 . . #0., 9 0 -
. ! . ! #0/ . . . .#0.
(., : ., ! . / ., .- / .).
! #0 . 0 "8 0. (Communication-Driven DSS) ( !! 0 C < - GDSS) C < ! !!
! #2 #, " 98 ! # . "8 . C <, ! #0 . . (Data-Driven DSS) # C <,
" . (Data-oriented DSS)
. 9 0 ! . ! #0/ -
.. C <, ! #0 . . . (Document-Driven DSS), ! #09, 8 #09 ! . ! # 9 -
13
: . /, # : .. B /, C <, ! #0 . 0. (Knowledge-Driven DSS) " ! 9 1 :, ! #, !- /.
B . Power (1997) # C <
! ! 0 0 #2 9 C <. C < ! !- 0 0 ! #9 " #21 . # 8 . : . / "- # . . ! ! 0 0. B #2 0 C < – ; . # 0 ., " # 98 0 # 12 .- !29 ! #2 #0.
. , . ; . "- 9, C < # . # 2 ! -
.
. : / #2 ! # 0 - : . , . " 9, C <
. # 2 ! ( . 4.2). C 8 9 # : / (Alter, Holsapple
Whinston, Golden, Hevner Power).
&. 4.2. (1 9 4 0 !$$&
14
EIS-. (! # C C <, : . / C . <, ! # #2 : . / .) ! #-
! #2 #, . 9 ! 8 :, " " ! # . ., : : . ! # 0 : . /. EIS-. 9 "8 9 - #0 9 8 0 0 "-! # - " .! / 0, . 29 - # "# 0 . . : . / 0 !
"H .!. EIS–. – , 9
.! 0 # C <. DSS-. (C # ' . C <)
– ! # : / #2 . # # 0
, ! # ! #2 #, . 98 0 ! . "# #- 0, .!29 ..
@ # . ! , !-
C < ! ! # # / 9 #2 -
; !. EIS DSS . : / 2 ! #- # #2, #00 "8 /# , ! #00
9 : / #2 2 1 . , !- / # . # # .!.
( ! #, . ! C <, / !/ 0 - . #9 / # 0 , "H "8 /- #29 — ! " 2 ! 0 9 / #2 ;::-
! # 1.
C < #0 .!# . 0 .- # 98 : . / ! - # 0, ; ! ## #2 ., #9- 98 ! 1 0 ! # 0 " ! 98
## ; ! ! / " /- #2 1.
B . 4.3 ! #9 .! C <.
15
&. 4.3. " 4 0 3 3
7 0 0 3 /1 5 = 6
#2 : . / 0 0 ! "-
OLTP- .. ( . , ! ! 0 0 8-
" #21 "H . # . : . /,
9 " . ! 2 #. = : .- / 0, 0 ! 08 # 98 -
! ! " ! ! 0 0, - : . / 0, ! # . 0 , #9" 8-
#0 " . g # 8 (g', WD – Data Warehouse) ! #0 " 2 ; : . / 9 !-
2 s #2 1 #.
( .! 9 0 g # 8 ',
! 9 0 ! " ", " ! 9- 8 ;:: 2 ! # 98 #: ! 0 -
, ! ., , : #2 / 0 0 ! /. 0 : .- / 0 0 . . # 8 Data Warehouse. F . ! #2 0 ! / . .-
# OLAP #0 ## #2 #
Data Mining (DM, ').
C / #29 ! # 0 . . #2 ;:: ! #2-
0 C < . 0 # ! .,
/ 0 "8 9 : . / 9 . (C) ! !- 0 0. = 0 # 98 . : .:
16
" C < #2 . 0 #0 0
" #0 ! #2 #, ! #0 -
2 "8 9 , " ! #9 0 .
. ., . 21 ! #2 . , #-
, ;:: ! #2 0;
C < # ! # 2 #2 . ., ! #2 #2 # . . #2 2 #2 "-, " " " #21 . ! 0 2 ! #2 1;
. , . ! #2 #2 0 / !/ 0 C < ! ! # ! # ! .- #2 : . / 08 . ., .
#2 ! ! # / C < C.
! . C < C !-
# 9 ;::, " ! #2 0 ! ; . . 21 0. ; . # " .
C # : . 2 ! # : . #0 #2 1 ! C <.
@ . " ., ! #2 C < :-
. / . ! ! 0 0 . ! . -
! . 8, ! 1 2 ! !- 0 0, . 21 ( ! 2, - ! # #2 # ! #), ! #0 " # 8 #0 2 !# .!.,. . 8 # ;:: 2 : /- 0 ! ! 0 0 # 0.
4.4. + 1 > 5 Data Warehouse
0 1 # 2 0 #2
" "H ! # 0. @ 0 : . / 0 "
0 ! " OLTP- .. B ; ! ! 0 #0 / # #,
#0 # ! 0 0 1 .
0 : . / 0. @, #0 / # #
" . . 2 . 2 " . ! # 2
17
: . /, ! #0 2 # !, !-
2 # # . ! , -
#2 # 2 ! ! "-
0. ! #2 # #. < 1 . ! "# . ( # 2 1)
0 #0 0 #2 # 8 , 8-
9 : . / 9 " . . t #29 !-
0 # 8 0 #0 0 / 0, #- / 0 # ! -
#0 : . 0 !
#0 "H ! # 0 / #..
4.4.1. $0 / 5 + 1 >
5
#20. . . (William H. Inmon), 98 0 -
# . ! # 0 0 # " -
, # # ! # g # 8 .
# ! / #2 . " . .-
. 9 A', 0 , "# 98 !-
. .:
5- . g' # "-
2 0 . ! / : ! . "#, ! #-
"# 0 #2. # A' /
OLTP-., ! " -
. ! # 0., : . / 0 g' ! #0 1 0 ! ! 0 0 1. '#0 C <
" 9 0 « » - : ! #
# .. g 1 !
g' 9 ! # "- ! / .! ..
4 . -
#2 g' ! ! 9 (OLTP-
., , 1 ),
. . 2 ., ", / . 0
! " , " . ! . :-
.. C ; . . ! #09 0 ! #2 #9
18
: . / !. ! /
# 8 # " 2 " !, #-
2 .
7 ( ).
OLTP-. 2 #2
. . 0, ! #2 # 98 .
. . 2 0 #2 /. .
# . g' OLTP-. 0 #0 0 ,
09 9 2 #9" . . ! / 0,
! . . " #09 0 (! !-
0 "), # 12 #0 !- ! # 09 0 OLTP-. ! / !#.
5$ ! (& & -
A %). OLTP-. ! . #0 "- #0 2 0, #0 2 0 2 0. g'-., #-
" 0 . , -
. 09 0. - 1 9 . . #2 ! /: #2 0 -
(!). = ! #0 ! / : !-
0 A' #0 g'.
5 & ! ! ! (.-
. / 0 " : . /) - " , -
/ #29 ! ! # 0», ! - ! 2 # « », " ! 98 . # - : . /, " . #0 ! # !-
! 0 0 1.
< #2: ( ." ## (Ralph Kimball), - / !/ g # 8 , ! # # 8 «.,
#9 . ! # 2 ! . .».
: . # # " 0 # 8 . :
! ! # 0
# 8;
! ! ;
. 2 ! # 0 0 .
(slice and dice);
19