() . : , , . :
, . , .
_ | |||
AB 2358955 | |||
DB 2456886 | |||
MA 8654212 |
_ | |||
2 | |||
3 |
, , , . _ _ . . _ _. , , .
, .
, .
_ | |||
AB 2358955 | |||
DB 2456886 | |||
MA 8654212 |
_ | _ | ||
05.03.06 | |||
15.04.06 | |||
21.04.06 | |||
02.10.06 | |||
12.12.06 |
, . , . _. _. , , . , , .
, :
|
|
- ,
- .
. , . , , .
_ | |||
AB 2358955 | |||
DB 2456886 | |||
MA 8654212 |
_ | ||
_ | _ | _ | |
05.03.2006 | |||
15.04.2006 | |||
21.04.2006 | |||
02.10.2006 | |||
12.12.2006 | |||
30.12.2006 | |||
31.12.2006 |
, . , . , .
1 2
. . | 1 |
.. | 2 |
.. | 1 |
.. | |
. . | 2 |
. . | 1 |
. . | 2 |
.. | 2 |
.. |
1 2. 1 2. :N , .
, , .
05.03.2000 | ||||
15.04.2000 | ||||
21.04.2000 | ||||
BOSCH | 02.10.2000 | |||
12.12.2000 | ||||
30.12.2000 | ||||
31.12.2000 |
. . , .. , . , , . 10 25, 10 25 . 25, , . , , .
|
|
, . . , . , . . , , ( ). ( ). Null , Nullify, Null .
:
(domain constraints), , . (, , );
(key constraints), ( );
(entity constraints), Null , .
. :
a) - , , , , ;
b) , , , - , , , .
() . , :
(. . , ), .
R S:
R | (A | B | C) | S | (D | E | F) | ||||||
p | 1 | a | p | 2 | b | ||||||||
p | 2 | b | p | 3 | a | ||||||||
p | 2 | c |
. R S =R S, , R S . , .
|
|
2.8.
R S | p | 1 | a |
p | 2 | b | |
q | 2 | c | |
q | 3 | a |
R S, , =R-S, , R, S. R S .
2.9: :
R - S | p | 1 | a |
q | 2 | c |
R S, 1 2, =R×S, 1+2, 1 , R, 2- , S. , R S.
2.10.
R S | (A | B | C | D | E | F) | |||
p | 1 | a | p | 2 | b | ||||
p | 1 | a | q | 3 | a | ||||
p | 2 | b | p | 2 | p | ||||
p | 2 | b | q | 3 | a | ||||
q | 2 | c | p | 2 | b | ||||
q | 2 | c | q | 3 | a |
t - R(X) , t[] - - t. , Y - , t[Y] - ( ׀ Y ׀), t, Y.
R Y R[Y], R:
R[Y]={t[Y]|t R}
, R[Y]- Y, , , Y, ( ) , .
π(R).
2.11.
R[A C] (A C) S[E F] (E F)
p a 2 b
p b 3 a
q c
R, . Θ - <, ≤, >, ≥, =, ≠, () t. R[AΘt] - , - Θ t. t , . R[AΘB] - , - Θ -.
2.12.
R[≠b] | (A | B | C) | R[A≠q ^ B>1] | (A | B | C) | |
p | 1 | a | p | 2 | b | |||
q | 2 | c |
σAΘt (R).
R S T=R∩S, , R, S. , R∩S=R-(R-S).
2.13.
R∩S p 2 b
R(X, Y) S(Y, Z) , X, Y, Z Y - , R S.
R S (X, Y, Z), (X, Y, Z)={(, y, z,)| (, y) S}. , - R S, .
|
|
R S. R(A, B1) S(B2, C), B1 B2 ; Θ - <, ≤, >, ≥, =, ≠, B1 B2. R B1 S B2 ( R[B1ΘB2] S) R S, Θ.
2.14.
R[A=D] S | (A | B | C | D | E | F) |
p | a | p | b | |||
p | b | p | b | |||
q | c | q | a | |||
R[B≤E C=F] S | (A | B | C | D | E | F) |
p | a | q | a | |||
p | b | p | b | |||
, R S , . , R(A, B) S(A, B), , :
(D, E, F, G)=R(A,B) [B>B] S(A, B).
D T R. E, F, G T B R, A S.
( ) , , = ; . 8.
2.15.
R[A*D] S | (A | B | C | E | F) |
p | a | b | |||
p | b | b | |||
q | c | a |
R S.
. R(A, B) P(C), B C . R[B÷C] P R[A] (), S (), .. R P r p, r>p; p ≠0. R÷ P - t r p , p, P, t R. , R[] [] R.
2.16. :
( )
1 a
2 c
R÷()
q
, . , .
, , . , , (Non-First Normal Form - NFNF NF2) . . , . (Nested) . , , . .
ID | ||||||||||
. | ||||||||||
. | . | |||||||||
. | ||||||||||
. | ||||||||||
(029)6257533 | . | |||||||||
. | ||||||||||
. |
, . ( ). . . . . . , . , . , .
|
|
. . . . Oracle 8. , (Nested Tables). Oracle 8 OBJECT. :
CREATE TYPE Tel_Type AS OBJECT(Tel_Number CHAR(10), Tel_Descr CHAR(5));
VARRAY, , : (1) Count (2) Limit ( ). , , :
CREATE TYPE Tel_Type AS OBJECT(Tel_Number CHAR(10), Tel_Descr CHAR(5));
CREATE TYPE Tel_List_Type AS VARRAY(5) OF Tel_Type;
(Nested Tables).
CREATE TYPE Tel_List_Type AS TABLE OF Tel_Type;
VARRAY TABLE , . , VARRAY , TABLE . , , VARRAY.
, () . 90- OLAP (On Line Analytical Processing ), Data Warehousing Data Mining ( , , ) . OLAP , , , , (, ). Data Warehousing () , , , , . , , - , . .
Data Mining ( ) , , . , , , . . Data Mining :
(, , );
( , );
;
( ).
, . , . , . , , , . . , , , , . . , , , .
, . ( 1) ( 2) :
1.
1000,00 | 02.02.2005 | |||
400,00 | 02.02.2005 | |||
750,00 | 06.02.2005 | |||
1000,00 | 22.02.2005 | |||
400,00 | 03.03.2005 | |||
1000,00 | 02.03.2005 | |||
1500,00 | 12.03.2005 | |||
500,00 | 05.04.2005 | |||
800,00 | 14.04.2005 | |||
1200,00 | 28.04.2005 |
2.
2005 | 2005 | 2005 | |
. 2.13. , )
, , ;
(Slice) , . , ( 2), . , . . 2.13 , . , - (n - ), , . , , . , .
, , , , :
(Dimension) , . , ;
(Cell) , . , , ( ) (, , .
(Rotate) .
(Drill Up) (Drill Down) . , . , , . , . . .
, , Essbase (Arbor Software), Media Multi-matrix (Speedware), Oracle Express Server (Oracle), Cache (Inter Systems). , , : ( ), .