. . . . . , SQL Server 2000, , :
- (OLAP, Online Analytical Processing);
- (OLTP, Online Transaction Processing).
, , , . SQL Server 2000 . OLAP OLTP , .
(OLAP), (DSS, Decision Support System), . . , . , . , . . , . , , .
. . . , . , , . , , , . , , , . , , . , , . . , .
|
|
. , , . , , . (OLAP) 2.
OLAP, Microsoft OLAP Microsoft Decision Support System (MS DSS). DSS :
1. , . OLAP Services, . SQL Server 2000 . OLAP Service SQL Server 2000, , .
2. , , . PivotTable Service, . , .
DSS - . . Microsoft . , , Microsoft .
(OLTP, Online Transaction Processing) OLAP , , , . .
, , . . . , . - , . , , . .
|
|
. , , . . , 100000 . . , - - . , , , , 90000 ., .. . , , 100000 ., . , , , . , .
. , . , , , . OLTP , OLAP.
SQL SERVER 2000