OLTP. IBM CICS TPF |
, OLTP, - ( ) . OLTP . , , . , . .
: , , . , , .
– , , . ( , ). OLAP-.
2) SELECT SQL. (ORDER BY). (GROUP BY, GROUP BY … HAVING).
ORDER BY
SELECT Company, OrderNumber FROM Orders ORDER BY Company;
SELECT Company, OrderNumber FROM Orders ORDER BY Company, OrderNumber
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC;
(DESC )
SELECT store_name, Sales, Date FROM Store_Information ORDER BY 2 DESC –
- GROUP BY
SELECT column, SUM(column) FROM table GROUP BY column
SELECT Company,SUM(Amount) FROM Sales GROUP BY Company;
SELECT column,SUM(column) FROM table GROUP BY column HAVING SUM(column) condition value
SELECT Company,SUM(Amount) FROM Sales GROUP BY Company HAVING SUM(Amount)>10000;
3) SQL – . .
SQL , , . SQL - (Structured Query Language). SQL . , . SQL - .
: . SQL , . . SQL . . SQL , .. , . . SQL . . SQL , , . . SQL , - .
SQL — FORTRAN . SQL IF , GOTO DO FOR . SQL , , . SQL , FORTRAN , . , , , SQL , .
, SQL — , , Pascal. SQL . SQL — . SQL ( ), . (stored procedures) -"". . , Oracle — PL/SQL, Ada; Sybase SQL Server MS SQL Server — Transact-SQL. Transact-SQL Transact-SQL (T-SQL) — SQL Microsoft ( Microsoft SQL Server) Sybase ( Adaptive Server Enterprise). , SQL : - ; - ; - ( , , .); - Microsoft Windows. Transact-SQL : BEGIN END, BREAK, CONTINUE, GOTO, IF ELSE, RETURN, WAITFOR WHILE.
" ":
1 - . .
2 -
...
28 - . : IBM DB2 Parallel Edition, MS SQL Server Oracle.
29 - IBM IMS DL1. (Sysplex).
30 - OLTP. IBM CICS TPF
31 - . ,
32 - : IBM DB2, ORACLE, MS SQL Server, Informix. .
...
43 - .
44 - - . .
45 - .
| : |
