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

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

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

. 2: # 2 : . / - # 8 8 OLTP-.

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

B # 8 . # -

#0 , # ! . 829 OLAP-

# ## #2 # (Data Mining).

4.4.3. ! / 7 6 + 1 > 5

. # 8 : / 9 " #0/ C A'. C # . .! Gartner, -

# - ! 8 C A' 0 8 .! 0 #0 0 Oracle. ! # ! - C A' Oracle 10g -

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

/. = C A' . ! ## #2 " "-

, . OLAP, # 0, ! " 0 , "-#, !-

0 . .

'#0 " 0 # 8

! ! Oracle Warehouse Builder, -

! #0 " 9 CASE- , -

9 : . /-#

.. C . ; ! . ! 2, -

2 . 2 # 8 ,

" 2 2 ! / # 0, ! "-

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

( . " !, " ! 98 !-

g # 8 , ! / 0 Oracle ! #

30

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

! 9 .. = . # 0 0

Data Warehouse Method (DWM) 0 #0 0 29 "8 !-

Oracle ! 9 # / # !-

.

G8 # C A' - .! 0 Teradata.

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

0 g # 8 # 1 . 1 . /-/ . , # 0 ; 1

0 8 , . . B -

C A' Teradata " . 21 / #2 ! /, . C A' , " #- # 29 ! / C A' " # ;::- . ! #2 . ; .

( .! 0 IBM C A' DB2. G

" - . # 0 -

. ! # 0 ! /, 0 ! " . = C A' ! g # 8

#9 ! g # 8 ! # 0 g # 8 .. @ C A' DB2 " ! ! #0/ .!# , . 2

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

! .0, ! # .-

0 " " . : / #2

..

Microsoft SQL Server, ! . 9 Gartner, !# 9 !- "# 0 # . C A', # " -

. ! # ! - SQL Server 2005.

./ # 0 , 1 09 .

! ! ! ! g # 8 -

. = , " 0 -

, ! ! . / !, ! ! . / ! ! " # . . #0.

, 1 . ! ! -

! g # 8 .

31

/ #0 # / ! / 0 # 8 -

Microsoft " # ! DataWarehousing Framework, . "H # #

(! ., ., ! " 0, ! -

! #2 #0 . .) / # ! 0 ! #2-

0 # 8 , ! # 0 .. K . Microsoft, . , " ! # ! .!-

Warehousing Network ! Microsoft Office, BackOffice Visual Studio. Microsoft

. : . . – ! #0. ! "

# 8 / #29 0 Data Warehousing Alliance. ; : . " 9 "8 #-

! #, " # # #0 Warehousing Framework. = ! #0 ! 2 . . 2 .-

2 . 0 # !.

: . Sybase Adaptive Server IQ - ; C A', ! . 0 #0 # :

. #2 0 IQ ! #0 " " 2

!# # ! 0-

", . / C A'. ; . . - " 0 # 8 ! .

C A' Sybase Adaptive Server IQ ! / #2 "

#0 # . A# 0 ! #2-

9 ! # " " !, #2

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

# . ! " # . 100 ! -

9 / . CA' ! 2 !- #2 2, . 0 # # ! #2 #

. ! ! . ! " "-

. # # / C A', Adaptive Server IQ " ! # 9 ! #2 2 " -

.

@ # Sybase Adaptive Server IQ Multiplex " !-

9 ! 9 . 1 " . 2 ! ! . 0 " # 0.

32

@ Sybase "# . . #2 . -

. #0 ! 0 # 8 - Sybase Warehouse Studio. ' #2 ! 8 ! / "

" # 0 # 8. .!# 0: Warehouse Architect - CASE- ! 0 # 8, Warehouse Control Center - ! # 0 . .

. 0 # 8, Infomaker - -

!.

'#0 ! # 0 ! / . .!, ! " 0

Warehouse Studio ;:: 0

# . Sybase PowerStage. : . / 0 PowerStage

. ! " 0 . .! 2 0 !-

. Warehouse Control Center.

C 8 9 1 0 #0 ! 0 g-

# 8 , ! ., Silverrun (CSA Research), Platinum, MSP . .

* * *

#2 . ! 1 9 / !/ g # 8

! " . : . 0 #0 !-

0 #0 0 #2 , ! 98 0 ! # " #

C '. ; . ! . .-

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

9 0 8 9 0 ! #2 #9.

! " "# 0 . 8 : .0 "- " ! #2 " #21, " 0 ! 0 0 0 2 , " #21 "H . A', . . 2 :-

. , , . " 2 #-

.!. # . . # ! 2 !-

9 . 2 " # #2 ! #-

#2, " ! : . / #2

# 8 ! #2 , . . ! 2 #2 " .

33

4.5. OLAP-5 1 K

OLAP (On-Line Analitycal Processing - -

) - ! #0 " -

. #0 # " #21 "H . . #2-

.. . 0 OLAP-., ! #2 #2

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

. ! . "#.

/ !/ OLAP # . . !-

# . @ . OLAP # E. F. Codd 1993 .

(, . . / ! #2 ! # (multidimensional conceptual view) 0 #0 0 " # .

#0 . ! #098 ! # "H ! # 0.

! #0 " . 9 ! !, 08 9

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

. # ! #2 . . 0.

! #0 0 . . #. ( . #9 ! # 0 # / , 08

! # #2 " "8 0, - 1 08 2 " #21 ! /

! 98 . . 9. ; . #

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

@ # LAP ! #2 9 ! " — ! / #2

( LAP-").

! " # 9:

. — # ! # ( -

0), ! #2 . #0 : . 0

;

. 0 — ! #2 ( - !), # 9 0 ..

34

< . 2 ! " ! #0 0 # . . #0 .. B ! ., ! " CA€@ . 2

# 98 :

. 0: ! " #, ! /, !!

, . #, . : /, !, #,

!#, , :, #9, /, ! # 0, , # ! # 0,

, ;

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

* * *

C . OLAP- . . # 2

.

Application OLAP (5 " OLAP). #

OLAP, ! #, . . " , - ! . ! ! #, #,

., . ! #. 8 -

"# . ! # 9 # #0 "

. (# . " 2 ! . . ! .-, " # . 8 . ! #..

8 . 0 #09 0: Oracle, Hyperion Solutions, Comshare, Adaytum, Crystal Decisions, Pilot Software ( Accrue), Gentia Software, SAS Institute, WhiteLight, Sagent, Speedware, Kenan and Information Builders.

MOLAP (Multidimensional OLAP, OLAP).

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

- . . 0 0 .-

. A' # . . . # #2 . ". ; . # ! # 0 " #21 0 " 2, . .

! # 29 #0/ . @ !- " 0 " ! 9 2 ! # 0

OLAP-! /. 8: Hyperion (Essbase), Applix (iTM1), Oracle, Gentia, Microsoft.

35

DOLAP (Desktop OLAP, & OLAP). = -

, ! ! #2 OLAP-., !-

#0 # #2 # ! # 0 ,

9 0 #0/ # . . A'

. 1 #. # 0 " " .

! 0 . # . ! " ., . 2 " #2- 1 0, ! " ., #0 # "- " (.

8: Cognos, Business Objects, Brio Technology, Crystal Decisions Hummingbird.

ROLAP (< #0/ OLAP). B #0/-

! # " ", #-

OLAP-. 0 : . / 9 ! / #2

. . A', ! #09 ! #2 2 #0 ; / #

9 #0/ 9 C A' . . 0.,

. ! #, 8

, ! . .

. 8 . ROLAP ! # :- / #2 ., 0 29, . 1 "-

. 29 ! #2 29, 0 #09 0 #- #2 . . 8 . #0/ A'.

. .: Axsys .! Information Advantage, DSS/Server : . MicroStrategy, ProdeaBeacon Server Prodea MetaCube ! Informix.

C # 2 ! " .

HOLAP (Hybrid OLAP, OLAP). < " /-

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

9 0 #0/ A', . 8 9 0 . . A'.

OLAP-" ! # 0 0 ! ! OLAP-

#0/ . . . @ ! ! #0 " 2 . ;. . 2

! . #2 . ! # 0 # !.

! # .0 / 0 ; "# #. ( .! Oracle Microsoft ! # / 9 A'

36

OLAP 1 ! 2 ! #2 9

OLAP " 2". C # ! #-

. . # Business Intelligence Ltd (www.olapreport.com), "H . OLAP 0 ! 1 3 . ## ## , ! ! ., " #21.

< CB # . 100 ! ! . . OLAP (; . . #2 0 /, "- # 0 0 / : - 200-300 !). : . / 0 " ; . ! "# 0. . . -

2 !, # , < G=C, B( k-

#, C "B :, . @ . . ( . <K, C C 0.

" 1 4 4.1 U1 / = 0 OLAP 5 />

37

< . " # ! " " # 1 0. Oracle Express OLAP. C . " 0

. . "H- " Oracle Express Server, . " 2 # " #21-

. !# :.. Express Server .

0 . ! # 0 " " . .

Express Language (4GL), " ! !

# #9" # - ! -

# . / . #.

Personal Express - : / #2 ! # -

. . ", ! (. . .

Express Server ! "H ., . . A', " !

. 1 " . 2 " . . ( .- : ..

Windows-! # 0 Express Administrator Relational Access Administrator # . ", 0

! 0 . . A'. ! 9 - # 9 : ! (drag & drop) #0 .-

/ ! ! .. .! #0/ A' Oracle ODBC- , : # MS Excel

38

: #. # Express Spreadsheet Add-In ! #0 - ! #2 2 ;# "# / MS Excel 7.0 1

" «#» OLAP-! #. Express Objects - ! : #2 0 . #2 0

#0 #2 "H- "

OLAP-! # #0 #- ! MS Windows. Express Objects ! "H .-

.: ! #0/ 9, # ! # . :.. ! #2 Web-# Oracle Express #

! # #2 . ! . ! "

C < ( 08 .0 0 # 0 ! 0 # . OLAP-! #0.). . Web-

# " ! ! 1 ! "# .

/ # !# : . : . / ..

08 .0 ! #0 !# : . Web- " ! 09 0 # " !#. Oracle WebServer 0 #0 0 . -., !-

! # HTTP " ! ! " . .

! Oracle Express #9 Java-!#, !- #098 : . , . -

VRML-/, " 98 . 9 :

.! Silicon Graphics.

Arbor Software Corporation - ; # ! Oracle.

G ! . 0 #0 0 Essbase. 2 ! ! #0 Arbor #0 # OLAP-!, ., .-

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

Arbor (# !), . 2 -

: " . ! . . !

Comshare Web-.! #0 Arbor - CrystalInfo, !-

. 9 Seagate Software. ! # .0 Arbor #9 #

! # 1 IBM.

! # "# / . Essbase Spreadsheet Add-in,

" ! 98 ! #2 # . 0. OLAP .-

"# /, Arbor ! # WIRED for OLAP (

# ! /), Crystal Info for Essbase (

39