.
, 8 , :
1. - , , .
2. , , ,
-
.
R=f(R1, R2.. Rn)
, .
R=f(f1(R11, R21.. Rn1), f2(R21, R22.. R2n).)
.
, , :
1. , .. .
2. .
, .
R rename A1,A2, as new A1, new A2,
:
R rename student as starosta
, R1 R2, , , .
R1 union R2
R1
R2
.
R1 R2 , R1 R2, , , R1 R2.
R1 intersect R2
R1 R2, , R1 R2, , , R1 R2.
R1 minus R2
R1(R11, R12, R13) R2(R21,R22,R23,) , R1 R2:
|
|
(R11, R12, R13 R21,R22,R23,), , R1 R2
(r11, r12, r13 r21, r22, r23.), (r11, r12, r13) R1, (r21, r22, r23.) R2/
R1 times R2
. R1 R2 , . .
R1
R2
R1 times R2
(, )
.
R , R, , , .
R11Q R12, Q {=<>¹³£}, R11 R12 R . Q - .
R where C R where R11Q R12
R where >250
R R1, R2, R3Rn, R, (R1, R2, R3Rn) , (r1,r2,r3,rn). .
.
R[R1, R2, R3Rn]
R[]
.
Q-
-
. .
:
R1 R2
(R1 times R2) where C, , R1 R2 / . , , . R1 R2 , .
|
|
Q-
(R1 times R2) where R11QR21 - Q- R1 R11 R2 R21.
R1 [R11QR21] R2
R1
R2
, R1[ <=2*]R2
, Q .
R1(R11,R12,R13,..R1n,Z1,Z2,Zn) R2(Z1,Z2,Zn, R21,R22,R23,..,R2m). R1 R2 (R11,R12,R13,..R1n,Z1,Z2,Zn, R21,R22,R23,..,R2m) , (r11,r12,r13,r1n,z1,z2,z3,zn, r21, r22,r2m), (r11,r12,r13,r1n,z1,z2,z3,zn) R1, (z1,z2,z3,zn, r21, r22,r2m) R2
R1 join R2
.
R1
R2
R3
R1 join R2 join R3
. , -, -.
R1 divideby R2
R1
R2
R1 divideby R2
, SQL. ( , , ). .
1989 (ANSI). 1992 SQL92, 1999 SQL3. , .
:
-
- , , (, , , ).
.
DDl-
|
|
CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE VIEW, ALTER VIEW, DROP VIEW, CREATE INDEX, DROP INDEX
DML
INSERT, UPDATE, DELETE
DQL
SELECT
DCL ,
CREATE DATABASE, ALTER DATABASE, DROP DATABASE, GRANT ( ), REVOKE ( ) .
- . .
START AUDIT, STOP AUDIT
,
COMMIT, ROLLBACK, SAVE POINT, SET TRANSACTION ( )
DECLARE, OPEN, FETCH, CLOSE, EXECUTE .
25. . .
. - , . , . . , , , .
, - () .
,
(5.6)
(5.6) ai, i =0, 1,..., , .
(5.6), ,
(5.7)
(5.6),
(5.8)
(t) , , . . , .
. ,
(5.9)
.
. , , ( ).
, ()=0 m n-m .
, (() +()=0; i - ).
,
2π , f(jω) . :
, CAP W(jω), ( ), ω 0 ∞
(-1,j0) , - .
Wp(jω) , 1, (-1,j0) 1 , .. , m= 2.
|
|
2 , . - (-1, j0) (. 2) Wp(jω)
(-1, j0) . . 3. , .
- CAP Wp(jω) (-;-1j0] (+), - (-).
: , , - .
. 2 , ,
.. 2(+) 1(-) = 1 = , , , 2 ( !), . , (-∞;-1j0] .
2 (. 3).
, 1 1 . : 1(+) - 1(-) = 0 = . , , , .. =0 .
, .
, , , :
(IV. 3.7) ( )
2 , f(jω) .
(IV.3. 9) :
, CAP Wp(jω), , ω 0 ∞ (-1, j0) /2 , - .
Wp(jω) , . IV.1.6, (-1,j0) 1 , .., m=2.
2 , . Wp(jω), . IV.16, 2, .
- (-1,j0) (. IV.17).
Wp(jω) (-1, j0) . . 3. , .
- CAP Wp(jω) (-∞;-1]
(+), - (-).
: , , - .
. IV.17 , , ..
, , 2 ( !), . , (-∞;-1] .
IV. 3. 3. 2 . , IV.3. 3. 1, . . (. IV. 18).
|
|
, 1 1 .
, , , .. =0 , IV. 3.3.1.
. . .
. , , .. , . . , , , ().
? , , . , , . . - .
- , .
:
1) ;
2) ,
, - ;
3) ,
;
4) ,
.
, (), :
1) ;
2) ;
;
3) .
- . , .
, , . . , , , - . , - .
.
:
X2 Y2
Xn m
.1
. . . . , ( ). . , : , - .
, . . , , .
. , . . , - .
- , , .. .
, , , , . .
, . , . . .
.2. - , . , . . , .., . , . , - . 0 100%. , , - , .
.2
- . . , , ( ). .. - : 2 , 5 .. .. . - .., () . .. :
1) ;
2) ;
3) ;
4) ( );
5) , ;
6) .
.., , . - , . , , . 15, .
:
- - , . , . : . - . .
- , .
- . , , , , , .. .
- :
.
. - - . . . - . , .
, . , , . - , . , . , , , . , - , . . , , , .. - .
2 . :
:
: