: 5 7 10 . , , :
5
10
5
7
10
7
, , . , , , , 5 10 , 7 .
5. DDl & DL
Data Definition Language (DDL) ( ) , .
DDL SQL, , DDL, DML DCL.
DDL ( ), . SQL create (), alter (), drop (). () .
DDL . SQL, ISO/IEC (SQL-89,SQL-92, SQL:1999,SQL:2003, SQL:2008), , , .
, CREATE TABLE. , .
DML - Data Manipulation Language. , . .
Procedural
Non Procedural
. , . . , . , , , , . . SQL. , , , . SQL SELECT * FROM TABLE , . . QBE. SQL. , SQL , DDL, DML. ? . , , , . DDL ( SQL) . DML, , DML ( SQL).
|
|
2
1. . , : 1) -; 2) ; 3) .
.
, , : , , , , , , .
, . , , () .
.
.
, .
, .
, , .. .
, .
:
1. ;
2. ;
3. ( );
4. ;
5. ;
6. .
, . , , . . MS Access, , MS SQL Server, . Prod_class, : , , , . , Time, subscribers, products. 3.
3.
Time | subscribers | products |
Week | Name | Number |
Month | Post_index | Weight |
Quartal | City | Page_amount |
Year | Street | Volume |
Number | ||
Tel | ||
Fax | ||
Tel_code | ||
, . 6.1.
|
|
, . , Prod_class, Products, subscribers Time, Facts.
2. , , , , .
, - , .
.
: . . L P C :
P L;
C L.
:
;
;
;
;
;
;
;
;
;
. .
3. () , () .
, . ( ) ( ), , - , - . , , .
, , () (). .
, , (: ); , , (, ). , - .
, , .
. , . . . .
, , . , . pax .
|
|
, . .
() (). , , . .
:
;
-;
;
-;
.
, , , . , .
, , . , .
6. , , , . , . , , .
:
(. lost update) , ;
(. dirty read) , , ();
(. non-repeatable read) , ;
(. phantom reads) ( "" ), , .
, .
]
, , SQL-:
1 | 2 |
UPDATE tbl1 SET f2=f2+20 WHERE f1=1; | UPDATE tbl1 SET f2=f2+25 WHERE f1=1; |
, " 20" " 25" , . , , , , 45.
]
, , , SQL-:
|
|
1 | 2 |
SELECT f2 FROM tbl1 WHERE f1=1; | |
UPDATE tbl1 SET f2=f2+1 WHERE f1=1; | |
SELECT f2 FROM tbl1 WHERE f1=1; | |
ROLLBACK WORK; |
1 f2, 2 . 1. , , , .