, , , - . . , , (). - (DSS, DecisionSupportSystem).
(. 1).
1 -
:
1) . , OLTP (linetransactionprocessing), () . ().
2) . .
3) . :
- SQL (StructuredQueryLanguage);
. OLAP (On-lineanalyticalprocessing), ;
. DataMining (" ").
, . , .
, , , . 1993. .. - - , ", , . . ".
- . , "" , "" , , .
. , .
, (multi-dimensionalconceptualview) - , , . .
|
|
. , ''" : " - ". , . , "" : " - - - " " - ".
(Dimensions) , , - (Measures). , , , ..
2
, (. 2). , - .
:
- (Slice) (. 3) - , , .
. 3.
- (Rotate) (. 4) - , . , , .
4
- (DrillUp) (DrillDow) (.4) - , (down) (up) , .
4
, L-.
OLAP (On-LineAnalyticalProcessing) , , .
L- - , ( ad-hoc) -. L- - .
OLAP . . 1993 . "OLAP -: ". 12 , , .
OLAP :
MicrosoftAccess;
Northwing, MicrosoftAccess;
OLAP- MicrosoftExcel.
, .
|
|
1. Northwing MicrosoftAccess. . OLAP . , ( , ..) OLAP, .
2. SQL .
3. SQL, . ( OLAPNorthwing)
4. OLAPNorthwing Excel . , , . . ( ).
5. : , , . , ? ( ?). .
6. Northwing 15 , . ( : -> -> ).
7. .
, , .
1. Northwing. 8 , , . 5.
5 Northwing
Northwing ,
Northwing, , , ( ).
Northwing , : 1); 2); 3).
( Northwing) : 1); 2); 3) OLAP-.
, ( , ..) OLAP, :
- Customers
SuppliersID | , .. |
CompanyName | -. (.. ? , ? ..) |
ContactName | , .. - Northwings |
ContactTitle | , Northwings |
- Categories
- Shippers
2. SQL :
SELECT
INTO
FROM
, :
3. SQL . Northwing. SQL ( ). ( 6)
|
|
6
__ __ , 7.
7
Northwing. OLAPNorthwing. Northwing, , , OLAPNorthwing, . , .
4. Excel. OLAP-. . Access ( 8).
8
. (OLAP-). .
9
, ( 2). (Northwing).
-, Northwing ( ). : 1) ; 2); 3) . . Northwing, , . 10.
10
11 Excel .
) |
) |
11 : - , .
Excel , , 12.
12
, . . 13. , Northwing (, ). , , , Northwing ().
13
Northwing , , . USA ( 14).
|
|
14
, .
( 15). , .
, . ( 16).
15
16
, :
1) Northwing.
2) .
. , , Northwing ( ) (, , ). 17 ( 10).
|
17
, , ( 18). 1988 .
18 Excel
19.
19
. , :
1) Northwing 1998 .
2) 1998 .
20.
20
, Excel :
1) ( 11 );
2) ( 21).
21 .
5. , - . : - - Excel. Excel. - , , , , , , .
. , Excel : , , . - , , -
.
. , - : - - Excel. Excel. - , , , , , , .
|
|
. , Excel : , , . - , , -
.
6. Northwing 15 , (, , , , ..):
6.1. : - :
6.2.
6.3.
6.4.
6.5.
6.6.
6.7.
6.15.
7. :
... - OLAP (OnlineA. P.) . OLAP .