, , , . , , , , . , , , .
, . OLAP , OLAP-. OLAP- (, Microsoft OLAP Service) , .
, OLAP- (, ), , . , , , ( ).
: 0%, , , 100%, .
OLAP
OLAP : ( ). , , . SQL, , . 9 , 6, ( 10). , .
10. OLAP
SQL | - Cartesis Magnitude - MicroStrategy | ||
- Crystal Holos (ROLAP mode) - IBM DB2 OLAP Server - CA EUREKA:Strategy - Longview Khalix - Informix MetaCube - Speedware Media/MR - Microsoft Analysis Services - Oracle Express (ROLAP mode) - Pilot Analysis Server - Sagent - Applix iTM1 - WhiteLight | - SAS CFO Vision - Crystal Holos - Comshare Decision - Hyperion Essbase - Oracle Express - Gentia - Speedware Media/M - Microsoft Analysis Services - PowerPlay Enterprise Server - Pilot Analysis Server - Applix iTM1 | ||
- Oracle Discoverer - Informix MetaCube | - Comshare FDC - Dimensional Insight - Hyperion Enterprise - Hyperion Pillar - PwC CLIME | - Brio.Enterprise - BusinessObjects - Cognos PowerPlay - Personal Express - iTM1 Perspectives |
OLAP : MOLAP (Multidimensional OLAP), ROLAP (Relational OLAP), HOLAP (Hybrid OLAP), DOLAP (Desktop OLAP). :
|
|
ROLAP 1, 2, 3.
MOLAP 4, 5.
Desktop OLAP 6.
Hybrid OLAP , .
, , .