Bazy_dannykh_Uchebnoe_posobie
.pdf«[] ,
(),
.
,
.»
«[]
, ,
. ,
.
; .
,
».
|
|
|
: |
, |
|
. |
|
, |
|
, |
|
|
Null |
. |
|
|
|
|
. |
|
|
. |
|
|
, |
. |
- |
, |
, |
, |
|
|
. |
|
|
. .
(),
.
.
, . ,
,
.
61
.
,
.
.
, - () ,
.
(Null) .
, .
.
:
.
:
<>IS NULL
<> IS NOT NULL.
|
|
( |
) |
|
|
, |
|
IS NULL |
TRUE( |
), |
IS NOT |
NULL |
FALSE ( |
), |
IS NULL |
|
|
FALSE, |
IS NOT NULL |
TRUE. |
|
|
|
|
Null |
|
|
|
|
|
|
|
. |
|
, |
,
.
11.
Not A A & B A
TRUE TRUE FALSE TRUE TRUE
TRUE FALSE FALSE FALSE TRUE
TRUE Null FALSE Null TRUE
FALSE TRUE TRUE FALSE TRUE
62
FALSE |
FALSE |
TRUE |
FALSE |
FALSE |
|
|
|
|
|
FALSE |
Null |
TRUE |
FALSE |
Null |
|
|
|
|
|
Null |
TRUE |
Null |
Null |
TRUE |
|
|
|
|
|
Null |
FALSE |
Null |
FALSE |
Null |
|
|
|
|
|
Null |
Null |
Null |
Null |
Null |
|
|
|
|
|
- ,
|
|
( |
) |
|
|
|
. |
|
|
, |
: |
( |
) |
. |
- |
|
|
, |
. |
( |
) |
. |
|
() ()
. .
() . (, ).
() . ,
|
, |
. |
|
|
, |
. |
- |
, |
. |
|
- |
, |
, |
|
. |
.
, ,
- ,
, ,
. |
. |
, |
.
. .
63
, «».
.
OLAP OLTP
,
(Online Analytical Processing,
OLAP)
(Online Transaction Processing,
OLTP)
OLAP OLAP - Online Analytical Processing -
.
OLAP
.
.
OLAP-:
- ,
;
.
- () ( SQL )
, .
- |
, |
.
OLAP-.
, , ,
; SQL-, . OLAP-
, |
, |
|
|
|
, OLAP- |
( |
, Pivot Tables Excel 2000 |
Microsoft |
ProClarity |
Knosys), |
|
, OLAP- |
( |
, Oracle |
Express Server |
Microsoft OLAP Services). |
|
|
|
|
|
|
|
64 |
OLAP-/ OLAP-, , ,
, Pivot Table Service Microsoft.
OLTP - ,
,
- |
, |
, |
.
.
.
,
.
,
10 000 . (. Data Warehouse)
-
,
, -
.
-,
. , ,
. OLTP-
, OLAP-
.
,
OLTP-.
,
.
,
, ,
.
«».
65
7.
, ,
, ,
.
.
.
, , ,
. : (), (), ()
(*). |
, |
, .
: , , .
.
.
. , , , , ..
.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
: |
||
|
|
|
|
|
|
|
|
A |
|
|
|
|
|
|
|
|
|
|
B |
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
1000 |
|
|
1 |
|
|
|
|
|
|
1000 |
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
2500 |
|
2 |
|
|
|
|
2000 |
|
|
|
|
|
|
|
|
|
|||||||
3 |
|
|
|
|
3000 |
|
|
4 |
|
|
|
|
|
|
3000 |
|
|||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||
|
UNION. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A |
B |
||
|
|
|
|
|
|
|
|
|
|
, |
|
|
|
|
|
|
|
A B, |
, |
|
|
, |
|
|
|
|
|
|
|
|
A, |
B, |
. |
|
|||||||||
14: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13. |
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A UNION B: |
|
|
|
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
|
1000 |
|
|
|
|||
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
2000 |
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
67 |
3 |
|
|
|
|
3000 |
|
|
|
|
|
|||
|
|
|||||
2 |
|
|
|
|
2500 |
|
|
|
|||||
4 |
|
|
|
|
3000 |
|
|
|
|||||
|
|
|
|
|
|
|
INTERSECT. |
|
|
|
A |
B |
, |
A B, |
, |
, |
|
A B |
15:
14.
A INTERSECT B:
.
1 |
|
1000 |
|
|
|
MINUS.
A B
, A B, , , A
B.
16:
15.
A MINUS B:
|
. |
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
2000 |
|
|
|
|
|
|||||
3 |
|
|
|
|
|
|
3000 |
|
|
|
|
|
|||||
|
|
|
|
|
|
|
|
|
*, TIMES.
, ,
,
.
17:
A B :
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
1 |
|
|
2 |
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
68
3 |
|
|
3 |
|
|
||
|
|
||
|
|
|
|
16.
A * B (A TIMES B) :
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
( |
, |
|
) |
|
|
|
|
|
|
A |
|
|
c |
|||||
|
|
|
|
|
|
|
|
, |
|
|
|
|
A, |
, |
||||
|
|
, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
c |
|
|
|
|
; |
|
|
|
c |
|
|
|
|
|
||||
, |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A |
( |
) |
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
A WHERE c. |
|
|
|
|
|
|
|
|
c |
X~Y, |
~ |
|||||
|
|
( |
|
. |
.), X Y - |
|
|
|
A |
|
||||||||
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
18: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
17. |
|
|
|
|
|
|
|
|
|
|
|
|
|
A WHERE |
|
< 3000 |
|||
|
|
|
. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
1 |
|
|
|
|
|
|
|
1000 |
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
2000 |
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A |
|
|
|
|
|
Z,Y,Z, |
|
|
|
|
|
|||
|
|
|
|
A, |
|
|
|
|
|
|
|
|
|
|
|
(X,Y,Z) |
||
, |
|
|
|
|
|
|
|
|
|
|
|
(x,y,z), |
, |
|
|
|
|
|
|
A |
|
|
|
|
|
|
|
|
|
|
|
|
X |
x, |
|
|
|
Y |
|
y, , |
|
|
|
|
|
|
Z |
z. |
|
|
|
|||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
69 |
A[X,Y,Z].
19:
,
:
18.
.
1
2
3
4
19.
A []:
, ,
.
:
- (-)
-
.
.
A B c
(A TIMES B) WHERE c
,
A B () .
70