, , , SQL-:
1 | 2 |
SELECT f2 FROM tbl1 WHERE f1=1; | SELECT f2 FROM tbl1 WHERE f1=1; |
UPDATE tbl1 SET f2=f2+1 WHERE f1=1; | |
COMMIT; | |
SELECT f2 FROM tbl1 WHERE f1=1; |
2 f2, 1 f2. f2 2 . , .
]
, , , SQL-:
1 | 2 |
SELECT SUM(f2) FROM tbl1; | |
INSERT INTO tbl1 (f1,f2) VALUES (15,20); | |
COMMIT; | |
SELECT SUM(f2) FROM tbl1; |
2 SQL-, f2. 1 , , SQL- 2 . . , - / , - () .
:
Serializable ()
; . ( - ).
Repeatable read ( )
, . ( , .)
Read committed ( )
Microsoft SQL Server. , , "" .(.. , COMMIT) . . .
Oracle , , .
Informix , USELASTCOMMITTED ( 11.1), [1]
Read uncommitted ( )
, 0. [2]. , , .
|
|
3
1. SQL (ˈɛsˈkjuˈɛl; . Structured Query Language ) , , . SQL .
SQL
;
;
.
SQL : . Data Definition Language Data Manipulation Language
- , , , , , ..
, , .
3. RDBMS Relational DataBase Management System( )
, , . - ? , , , Big Data.
, , Web 2.0 , , , Twitter, Wiki-. , all Data Records (CDR) , , .. -, , , .
, . , , , . , , , , , NoSQL- .
. 1. rDBMS-
NoSQL Not Only SQL ( SQL). , , , :
: , JSON1;
;
.
RDBMS (Relational Database Management System, ) NoSQL-. RDBMS . , , SQL-. , ( ), (. . 1).
|
|
. 2. noSqL-
NoSQL : , , (. . 2).
4. - - , . , - , - , , , ftp, Web, ( ). , , .
. : , , , .
: , , , , .
, - Eudora Microsoft Outlook . , . Internet Explorer - , Web-.
- MS SQL , , Query Analyzer, SQL Server Enterprise Manager, Profiler, SQL Agent Data Transformation Services. . , . .
- , . , , ( ) .
-.
- :
- . -, , .
- - . - . .
(relational database management system RDBMS) , -. RDBMS . RDBMS . RDBMS . (Structured Query Language SQL) RDBMS.
- , - . PC -. RDBMS . - , , - .
|
|