(2).
, , (. . 7.8).
. , - . , . ( , , . .) , . , (, ), .
. .
Y R X R, X R Y ( X Y) [ 2 ].
. , . , . ( ) (. 7.9 7.10):
7.9
, . | ||||
10 000 | / | |||
5 000 | / | |||
4 000 | / | |||
5 000 | / | |||
4 000 | / |
7.10
10.12.05 | ||
10.12.05 | ||
11.12.05 | ||
11.12.05 | ||
12.12.05 | ||
12.12.05 | ||
12.12.05 |
. . , . , , , , . , , . , 200, 5 000 ( ).
|
|
. .
.
, , (. . ) .
(3)
. . , , . . , , , .
, : (. . 7.9). ().
, (. 7.11 7.12):
7.11
, . | |||
10 000 | |||
5 000 | |||
4 000 | |||
5 000 | |||
4 000 |
7.12
/ | |
/ | |
/ |
. . , , (. . 7.12).
.
, ( ) .
[ 12 ], (, 4, 5), , [ 4 ]. [ 1, 2, 4 6, 11, 14 ].
. ( ) , . .
|
|
7.5.
, , ( CASE- Oracle 1989 .) [ 3 ].
CASE (Computer Aided Software Engineering) . CASE- , , , , , ..
CASE-, , . ODBC. S-Designor (PowerDesignor) ( SDP, Powersoft), Erwin (LogicWorks), Silverrun (Computer Systems Advisers Inc.) [ 15 ]. CASE- , . Designer/2000 ( Oracle ) [ 15 ].
CASE-.
S-Designor (PowerDesigner). . Oracle, MS Access, Ingress, Informix, Sybase, MS SQL Server . .
ER- (. . 15). ( , . .).
( ) . , . , , (. . 7.3).
. ODBC. () SQL- . [ 15 ].
PowerDesigner 6.0 (. ) [ 3 ].
Erwin. S-Designor (PowerDesigner), . ( 500 1500 ) [ 3 ].
Silverrun. Oracle, Informix, Ingress, MS SQL Server . . : ( ) ( , ).
, , [ 15 ].
Designer/2000. Oracle.
, ( ) , [ 15 ].
, , [ 15 ]. . , , , .
|
|
( ), .
CASE- [ 3 ]:
1. CASE- , .
2. CASE- .
3. CASE- , .
4. CASE- . .
. . : , , . , [ 3 ].
, , , . , .
1. (Data Warehouse), ().
, , . ( ) () .
- , . , . ; , ; , -. .
, (On-line Analytical Processing, OLAP).
OLAP- :
1. , , () . , .
2. , .
OLAP , , , , , . , , . , .
|
|
:
1. . , , , , . .
2. . , , , , . .
3. . , , , , .
OLAP , , .
.
MOLAP (Multidimensional OLAP) , , . , OLAP-. Essbase ( Arbor Software) Oracle Express (Oracle).
ROLAP (Relational OLAP) , . , OLAP-. MetaCube ( Informix) Discoverer 3.0 (Oracle).
OLAP- .
, , . (Data Mart).
, , , . , . : PowerMart Suite ( Informatica), Data Mart Solution (Sagent Technology), DataMart Suite (Oracle).
(), , , , .
2. [ 4 ]. . . [ 4 ].
3. .
[ 7 ]:
1. , Web-.
2. ( -).
3. (, HTTP), , .
Web- .
Web- Web- . . .
, , -, . . Web- . : ASP, PHP IDC/HTX- , (Java-, CORBA-, ISAPI- . .) [ 7 ].
|
|
, . . .
1. - . . : . . / . -, . , . . .: , 2003. 1088 .
2. . . : . . / . . . 6- . .: , 2000. 848 .
3. . . : : / . . . .: , 2005. 592 .
4. . . : , , : / . . . .: , 2001. 304 .
5. . . 9- . .: , 2005. 859 .
6. . . . : / . . , . . . .: , 2004. 512 .
7. . . / . . , . . . .: -, 2001. 560 .
8. . .: , 1982. 158 .
9. . : . . / . . .: , 1981. 286 .
10. . . Internet Java: . . / . . .: , 2001. 480 .
11. ., . : , : . . / . , . . 5- ., . . .: -, 2004. 1040 .
12. . . : . . / . . . .: , 2002. 256 .
13. / . . .: . .: , 1990. 560 .
14. . : . . / . . .: , 2005. 272 .
15. . . : / . . , . . , . . . .: , 2002. 672 .
* . , , .