: IBM DB2, ORACLE, MS SQL Server, Informix. . |
- , . SQL. - Oracle8i, IBM DB2, Microsoft SQL Server Informix - .
Oracle8i. Oracle8i, Java , . , . ( -). Oracle , : . (large-database partition), ; ; ; ; ( ); . , . ., Oracle DB2 IBM. - Oracle. interMedia, , Jserver, Java, Java . Enterprise JavaBeans - Java. Oracle , , interMedia : ; ; ; ( Locator ). Oracle8i - , , , . , Oracle (multiversioning concurrency) Oracle ( InterBase InterBase Inprise). , , (.. Oracle ). Oracle8i , . WEB LINUX Oracle MySQL, .
Microsoft SQL Server - : , Web, , , . , . OLAP . , . , SQL Server : . Java, HTML SQL Server , DB2, Informix, Oracle Sybase. XXI LINUX, SQL Server Windows. SQL Server , ODBC, .
IBM DB2 IBM DB2 - 30- - IBM. (6.) , Windows 95 S/390, OS/390. DB2 : DB2 Workgroup DB2 Enterprise Edition. DB2 , , , , , - Java. , DB2 -, , - , . , IBM . Web, , . DB2 . Stored Procedure Builder - SQL Java . DB2 6.1 : Microsoft OLE DB, . DB2, Java Web, . () , LINUX. Index Smart-Guide , , . DB2- , . - , . DB2 6.1 . , , - ( Microsoft SQL Server).
Informix. - ( Oracle). Informix Centaur Informix Dynamic Server 7.3 - Informix Universal Data Option Dynamic Server Universal Data Option. . , , , , Web . Java , DataBlades, Informix
. Inforix, , DataBlades SPL, Informix . , Centaur ActiveX. , , Visual Basic; , , Centaur Windows NT. Centaur Informix Dynamic Server , , . , Centaur , Informix Universal Server . - , ; SQL. . , /, Linux, Oracle 8i.
2) SELECT SQL. .
SELECT column FROM table WHERE column LIKE pattern
SELECT * FROM Store_Information WHERE store_name LIKE '%AN%‘;
SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen';
SELECT * FROM Persons WHERE LastName NOT BETWEEN 'Hansen' AND 'Pettersen';
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( );
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC(.);
SELECT * FROM Persons WHERE FirstName='Tove' AND LastName='Svendson';
SELECT * FROM Persons WHERE firstname='Tove' OR lastname='Svendson' ;
SELECT * FROM Persons WHERE (FirstName='Tove' OR FirstName='Stephen') AND LastName='Svendson' ;
SELECT store_name FROM Store_Information WHERE Sales > 1000 OR (Sales < 500 AND Sales > 275);
SELECT function(column) FROM table AVG – ; COUNT – ; MAX – ; MIN – ; SUM –
: SELECT AVG(Age) FROM Persons; SELECT COUNT(store_name) FROM Store_Information; SELECT COUNT(DISTINCT store_name) FROM Store_Information; SELECT MAX(Age) FROM Persons SELECT SUM(Sales) FROM Store_Information;
3)C , . . , . . . C .
, . () , . - . , . , . , . . , . , , . : W-W - 2 , 1; R-W - 2 , 1; W-R - 2 , 1. .
- . . ( , "-") , . , T r T r ( ). : - S (Shared), ; - X (eXclusive), , . – , : , . , (, , - ). S X. – , (), . , . . ( ) : T1 T2, , T1 T2.
T t, T. r T ( ). r T1 : , T, . T , T1 r . T , T1 . , r , T1 . T1 T , t(T) > t(T1) (.. T "", T), T T1 . t(T) < t(T1) (T "" T1), T1 . , . , . , .
" ":
1 - . .
2 -
...
30 - OLTP. IBM CICS TPF
31 - . ,
32 - : IBM DB2, ORACLE, MS SQL Server, Informix. .
33 - ( ).
34 - . .
...
43 - .
44 - - . .
45 - .
: |