' - , . () 1 . , : (, , ); ( ); ( , , ); ( , ); ( 30 ); , . . . , - , (, ) , - ( ). ( , , -, , ) . , , , . , , . , , . - , Data Warehouse - .
Data Warehouse (DW) , -, , , .
DW ( ), , (, , , , ). , , . DW -, -.
DW , . DW , , , , , ( 볺 5 ).
|
|
, DW , (). , , , , DW , , . , , , . , .
DW , , . , , . 1-5 . , , .
DW 㳿 ( DW , ), , ( ).
DW : , , , , , 볺.
DW ( 1).
1
³ DW
DW | |
- | |
, , | , , |
. , big-band, , . ' DW (data marts), , .
DW - Oracle Designer (Arbor), Platinum Technology (Businss Objects), Praxis (Carleton), Prism (Cognos), Pyramid (Hewlett-Packard), RedBrick (IBM), SAS Institute (Information Buler), Sybase(Microsoft), Microsoft OLAP Servicer.
, DW, , , ; , , . ( 3 . ) 2010 68% DW.
|
|
American Airlines DW 26 . 100 . . Celera.Genomics .
, DW, , , -, ( ) .
DW, , (OLAP On Line Analitical Processing), - , . OLAP ( ) . OLAP . D.Little 1980 - . OLAP, () , () ( ) ', . . OLAP , , .
OLAP- : , , , ; -. , : (, , , , ); (, , ); , (-, ); (, ).
L- : ; ( , , ); (drill-down), , ; (roll-up/drill-up), , ; (slice-and-dice). 㳿 OLAP , , , : MOLAP, ROLAP HOLAP.
MOLAP (Multidimensional OLAP) - OLAP-, , , . , OLAP-㳿, , . , '. , ( ) , .
ROLAP (Relational OLAP) , - , . , OLAP-.
|
|
OLAP-㳿 - HOLAP-, (hybrid) , , .
, OLAP-㳿 (Hyperion OLAP, Elite OLAP, Oracle Express, MS SQL Server, Sybase SQL Server, Informix, CA-Ingres, Gupta SQLBase, Cognos ). OLAP- . -, Hyperion OLAP ; ; ; ; ; ; ; ; ; .
, DW , , . DW - Data Mining (DM).
DM - , . . : , , , 䳿.
DM , - 㳿 , .
DM : , , ( - Discovery); ( Predictive Modeling); , (Deviation Detection).
DM :
1. (Data Retention); , , (Case-based Reasoning) Lasy-Learning - (NN), k- (k-NN), NGE; ;
2. Data Distillation, ; . ( ). 䳿, , .
|
|
, 㳿 , ( 2).
2
㳿
, ' , " - " | ; " - " | |
, , | " ": ; ' | |
; | , | |
³ | , | , |
, | ||
- | , | ', |
㳿 | , , . | ; ; 㳿 |
㳿 DM , ' : , ( ' ), 㳿 , , ; , , , ; .
, : - , ' ; , -, , 㳿 ; , , . .
DM . Microsoft, ( 50 -) DM.
DM, :
1. , ; , ;
2. , - (, , ); -, $1000 $10000, 10000.
- , DM . DM : , ; ; , , , , , , ; , .
(OLAP) DM . ֳ ' .
|
|
DM, , ' , . , , , .
DM , , ,