. : , .
. IMS IBM Corp., 60- . IMS . : MARK IV Control Pate Corporation, System 2000, SAS-Institute .
"" , (, : , , ..).
3.2.
60- CODASYL, CODASYL DTBG. . , , . . . - ; . . 10.
. : . . P PT :
Ø P C;
Ø PT .
, .. , , :
Ø ( );
Ø P ;
Ø P ;
Ø ; L1 L2 P C, , , ;
Ø X Y ;
Ø .
. 11.
:
|
|
Ø ( ..);
Ø ( 22 );
Ø ( .. ..);
Ø ( ..);
Ø ;
Ø ;
Ø ;
Ø ;
Ø ;
Ø ..
, ( ).
. IDMS Cullinana Corp. Cullinana Corp Computer Associates, IDMS , .
3.3.
70- . .. ( 1970 .) , , . .. . , . . :
Ø , . . .
Ø , .
Ø , .
IBM -, . , . 80- . IBM, Oracle Corp., Ingres Corp. . . . : dBaseIIIPlus, dBaseIV ( Ashton-Tate), DB2 (IBM), R:BASE (Microrim), FoxBase (Fox Software), Paradox (Borland), Access (Microsoft), Clarion (Clarion software), Oracle (Oracle) .
. 90- . - . . 6.
. , , , . , (. 1).
|
|
1
/ | ||
/ | ||
/ | ||
/ |
, .
. . .
, , uniVers, Bubba, Dasdb.
3.3.1.
: ( ), . , , : , , , , .
, .
( ).
. .
.
, .
:
Ø . , , .
Ø .
Ø .
Ø (), .. ( ).
.12 Internet.
Internet 4 . 1 , 2 , 3 , 4 Web-.
Web- | |||
44,0 | www.demos.ru | ||
38,0 | www.portal.ru | ||
46,0 | www.glasnet.ru |
Internet 3 , 4- , . .
( ) . , INTERNET( , , , Web-). () .
, . . , . . . , . , INTERNET . , .. . , .
|
|
:
Ø ( );
Ø . , ( , );
Ø ;
Ø .
. . R1 , R2. , R1 . .. , . , , . .
, ( , , ) ( , , ). , . , , "--". ( ), "--". , . "--" "--". 4.
, ( ) .
, . , , . , , . : .
. , , . . . , . , , . . , , . . . .
, . , , , . , , .
|
|
. . . , (, ). , :
Ø , ( , );
Ø , , ;
Ø , , ( ).
. ( , .).
, :
Ø , . . ;
Ø , ;
Ø , ;
Ø .
, , . , : , , , . ( " ").
3.3.2.
: . , , .. : .
. , .. . , , , , . , , . .
, , (, ) ( ), . , , . . , , .
. , ( ) .
, , : , (), , () ( ), (, ), , .
. . , : , , , , , . .
: (, , ) (, , ).
( ) ( ). , , . , -, . -, . -, . . , . , . .
|
|
, , . . [10].
. S () : , , , S#. M () : ; , , (MS), , . # ( ). SM () , , . , S1 M1, M2 ., S4 M4 .. , , . S##, . S# # SM S M . , . 24 , .
2
S# | _ | ||
S1 | "" | ||
S2 | "" | ||
S3 | " " | ||
S4 | .. | ||
S5 | "" |
3
# | MS | _M | ||
M1 | "" | / | ||
M2 | "" | / | ||
M3 | - "" | / | - | |
M4 | "" | / | ||
M5 | - "" | / | ||
M6 | "" | / |
4
S# | # | |
S1 | M1 | |
S1 | M2 | |
S1 | M3 | |
S1 | M4 | |
S1 | M5 | |
S1 | M6 | |
S2 | M1 | |
S2 | M2 | |
S3 | M2 | |
S4 | M2 | |
S4 | M4 | |
S4 | M5 |
R1 R2 (R1 UNION R2) R, , ( ).
3.1.
R1 , R2 , M1. R , , , M1, (. 13).
R1 R2 (R1 MINUS R2) , , R1, R2.
R1 R2 R , , M1 (. 14).
, . . R1 MINUS R2 R2 MINUS R1 .
R1 R2 (R1 INTERSECT R2) R , , .
R1 R2 R , M1. R (. 15).
R1 k1 ( ) R2 k2 (R1 IS R2), , R (k1+k2), R1 R2, , , k1 R1, k2 R2. . . , , , , .
, , RENAME.
3.2.
R1 {S1, S2, S3, S4, S5}, R2 {M1, M2, M3, M4, M5, M6}. "-", .. {(S1, M1), (S1, M2), (S1, M3)(S5, M6)}.
, .
, , . (R WHERE f) R f R , R, , f.
f , , (AND , OR , NOT ), .
3.3.
1. : M WHERE MS <400 (. 16). , , 400.
2. : SM WHERE S# = "S1" ND # = "M1" (. 17). SM, S1 M1.
, .
R X, ,..., Z (R [X, Y,..., Z]), (X, ,..., Z} R, X, Y,..., Z , R, . X, Y,..., Z .
.
1. ( );
2. R[ ] , ;
3. , .
3.4.
1. M , _ (M[, _]) . 18.
2. ((S WHERE _="")[S#, _]) (. 19).
( ), , , ( ) .
R1 R2 (R1 DIVIDEBY R2), , , ( ), R , r , R1 (r, s), s R2.
3.5.
R1 SM[S#, #], R2 # M2, M4. R S# S1, S4 (. 20).
, , . . .
( JOIN) , . .
R1 R2 {X1, X2,,XM, Y1,Y2,..,YN} {Y1,Y2,..,YN, Z1, Z2, ZP} ; .. Y1,Y2,..,YN . { X1, X2,,XM }, { Y1,Y2,..,YN }, { Z1, Z2, ZP } X, Y, Z . R1 R2 (R1 JOIN R2) {X, Y, Z} , , R1 X x, Y y, R2 Y y, Z z.
, _ _ : . . (S JOIN M) . 21.
f(R1, R2) R1 R2 , f (q ), R, R1 R2 f. f , .
, R1 R2 ( ) :
(R1 1S R2) WHERE Q ,
Q , ( ) .
3.6. q-
S P _ _ , "".
(S TIMES M) WHERE _ > _. q- . 5.
5
S# | _ | # | - | MS | _ | |||
S2 | "-" | - | M1 | "" | / | |||
S2 | "-" | - | M2 | "" | / | |||
S2 | "-" | - | M6 | "" | / | |||
S5 | "-" | M1 | "" | / | ||||
S5 | "-" | M6 | "" | / |
. . : , , , [10].
:
<> RENAME < >
S < >,
<> . .
, S RENAME _ AS
__
, . , :
<.> RENAME <__.1> S <__.1>,
<__.2> S <__.2>,...,
<__.N> S <__.N>.
, . :
EXTEND <> DD <>S<_>,
( DD) <_>, , <>. , . <>.
, EXTEND S ADD '' AS SNAME.
S SNAME, ''.
, , COUNT (), SUM (), AVG (), , IN.
:
EXTEND <> DD <_1> S <_1>,
<_2> S <_2>,...,
<_N>S <_N>.
SUMMARIZE "" :
SUMMARIZE <> Y (< >) DD <> S < 6>,
, < > 1, 2,..., N, <> , EXTEND, < > . .
SUMMARIZE R , , . R ( R1) 1, 2,..., N, (N+1)-. , , ( ), , : R1 ( ) . (N+1)- R .
3.7.
: