ITaaS , IT- : (SaaS). SaaS . : Web 2.0, - (Mashup), -.
AJAX Web 2.0 - , -, - . , - , , .
SOA (- ) , , -. - , . .
31. SQL - ,
́ ́ ́ ́ () ,
SQL (Structured Query Language ) , , . SQL .
32. SQL
(), .
SQL :
(database);
(table);
(column);
(index);
(view);
(synonym).
- . - .. , . (owner-name) : moshkow.table1 . " 4GL" (. ), " Informix-4GL".
*.
. (SELECT) ( ), (DELETE) , (INSERT) , (UPDATE) .
DELETE.
SELECT.
|
|
kadry , tabnum=345. . ceh, .
SELECT fio, dolvn, zarplata FROM kadry WHERE tabnom=345
SELECT * FROM ceh
SELECT kadry.fio, ceh.nameceh WHERE kadry.nomerceh=ceh.nomerceh
, , , ceh.
INSERT.
,
INSERT INTO... VALUES, , SELECT .
INSERT INTO kadry VALUES (4,0,"",num,"10/25/1939",NULL)
INSERT INTO customer VALUES (ps_customer.*)
INSERT INTO kadry (tabnom, fio, nomerceh, dolvnostx)
SELECT 0, fio, 4, dolvnostx FROM kadryold
WHERE nomerceh=3 AND fio IS NOT NULL
, SERIAL , 0. ( ), NULL. DELETE, UPDATE, SELECT WHERE , , ( , ). WHERE .
UPDATE.
, , WHERE .
UPDATE kadry SET fio="" WHERE fio=""
UPDATE ceh SET kod_ceha[1,4]=nameceh[5,8] WHERE
nomerceh BETWEEN 3 AND 5 OR nameceh IN ("","")