:


---------------------------------------------------------------
 Email: visor@olma.co.ru
---------------------------------------------------------------
1. . *
1.1 . *
1.1.1 *
1.1.2 *
1.2 -. *
2. Informix OnLine v.7.X *
2.1 Informix. *
2.2 Informix OnLine v.7.X *
2.2.1 . *
2.2.1.1 *
2.2.1.2 *
2.2.1.3 *
2.2.1.4 . *
2.2.1.5 *
2.2.2 *
2.2.3 *
2.2.3.1 *
2.2.3.2 - *
2.2.3.3 *
2.2.4 *
2.2.5 *
2.2.5.1 PDQ *
2.2.5.2 *
2.2.5.3 *
2.2.5.4 OLTP DSS- *
2.2.6 *
2.2.7 *
2.2.7.1 . *
2.2.7.2 *
2.2.7.3 *
2.2.7.4 *
2.2.8 *
2.2.8.1 *
2.2.8.2 DB/Cockpit *
2.2.8.3 OnPerf *
2.2.8.4 *
2.2.9 *
2.2.9.1 - *
2.2.9.2 *
2.2.9.3 *
2.2.10 *
2.2.11 2 *
2.3 Informix . *
2.3.1 Informix-Enterprise Gateway 7.1 *
2.3.2 EDA/SQL *
2.3.2.1 EDA API/SQL *
2.3.2.2 EDA/Link *
2.3.2.3 EDA/SQL Server *
2.3.2.4 EDA/Data Drivers *
2.3.3 Enterprise Gateway *
2.3.3.1 *
2.3.3.2 *
2.3.3.3 Enterprise Gateway *
2.3.3.4 *
2.3.4 Informix-OnLine DS : Informix-TP/XA Informix-TP/TOOLKIT *
2.4 *
2.5 *
1. .
1.1 .
. : ; ; ; . , . (). ( ) .
1.1.1
:
1.
, , , , ( ). , . , , , , . , ( , ).
. , , .
2.
; . , , . . ( UNIX), , . . , . , , . , , . .
3.
- , . , (COMMIT) , , , . . , . , - (, , ). . , , . ( , , ).
. , . - , . , , , , ( ).
. , . . ( , ) . , ( ) .
4.
- . , . : , (, ), , . (- ) , . ; .
. , , , , . - .
- , ( , ), . : (, ), . .
"" ( Write Ahead Log - WAL). , , , . , WAL, .
- . , . , , , . , , , ( ).
, , , , , ( , ). WAL , . , . , (undo), (redo) , . , . .
. , - ( ). , , . , . , , . . , .
5.
, . . - (SDL - Schema Definition Language) (DML - Data Manipulation Language). SDL , .. , . DML , .. , , , . .
, , . SQL (Structured Query Language). SQL , , "" (.. , SQL).
SQL SDL DML, .. . ( - ) , SQL -. () .
SQL . -, , .. SQL .
SQL , ( ) . , , , . .
, SQL. , SQL . , , . , . -, .
1.1.2
, .
- ( Data Base Engine), ( SQL), , . , - , .
, , . ( , , ), , , . , , . , , SQL ( ), . . "-" .
- .
, ( , , SQL) , .. , , ( ). , , . , . , , - . , , , .
, , , , , , .. , .
1.2 -.
.
. , . "-". ( "-" ) , , . , . : - .
"-".
:
- , . , , .
- , , .
- - , . , .
( , Clipper, DBase, FoxPro, Paradox, Clarion , , . . . .
, - , :
  • , ;
  • - , ;
  • , , , , , ;
  • , .
2. Informix OnLine v.7.X
2.1 Informix.
Informix 1980 . Informix , UNIX. . Informix , UNIX.
Informix UNIX-. . : Sequent, HP, SUN, IBM, Siemens Nixdorf, NCR. . , Informix.
UNIX Informix NetWare, Windows, Windows NT DOS.
Informix InSync. . , , UNIX-.
2.1.1 Informix
Informix , , . Informix , .
4.0 Informix OnLine, ( OLTP - on-line transaction processing), - .
, Informix-OnLine - (BLOB - binary large objects). ( ).
2.1.2
, Informix, "-". - , () . , , (-).
(database engine), - , . . , . "-" Informix-SE, Informix-Online Informix OnLine-Dynamic Server.
Informix-SE , .
, .
, , . . "-" Informix-NET.
Informix-OnLine - , (OLTP - on-line transaction processing). , . Informix-SE Informix-OnLine - (BLOB - Binary Large Objects), , , , , ( 2-4 ).
Informix-Star . InformixStar .
Informix (SQLEXEC Informix-SE SQLTURBO Informix-OnLine), SQL-. , . , , , , .
OnLine Dynamic Server, 6.0. (Dynamically Scalable Architecture - DSA), . OnLine Dynamic Server , . OnLine Dynamic Server . , .
" " - , Informix. "" (thread), . , , "" .
, . , .
6.0 . OnLine Dynamic Server Informix-Net Informix-Star .
2.2 Informix OnLine v.7.X
, , . :
, , INFORMIX-OnLine DS, . , , .
2.2.1 .
INFORMIX-OnLine DS " " (DSA). , ( ), . INFORMIX, (. 1), :
:
. 1. " - ".
, , .
DSA SMP (Symmetric Multiprocessing systems), . , (MPP). DSA , , .
2.2.1.1
INFORMIX-OnLine DS . , (thread). - , .
. - -, , . , , (. 2).
.2. . () , .
INFORMIX-OnLine DS , . , , , , .
2.2.1.2
. . , , .
() - , . :
CPU - , . .
AIO - .
ADM - , , .
TLI - TLI (Transport Layer Interface).
, , .
, INFORMIX-OnLine DS, . , . , , . , CPU-, . , , , , . CPU.
, OnLine DS (processor affinity), CPU- . CPU- , . , , .
2.2.1.3
. , - :
, , , , .
, , .
, . :
2.2.1.4 .
, :
, , . , OnLine DS , . , , , .
2.2.1.5
, (, , ) , . . , , , , , .
, , , . , , () , , . , , 20 . .
2.2.2
- , . :
, , . . , , .
, . , . , , . .
- . (system catalog), , , , . , , . , / .
2.2.3
-, , . . - INFORMIX-OnLine DS :
2.2.3.1
INFORMIX-OnLine DS , UNIX. :
, , .
2.2.3.2 -
- - (AIO) - (KAIO), . - , CPU , .
2.2.3.3
OnLine DS , , . , , .
2.2.4
INFORMIX-OnLine DS . , , . :
.3. - , .
:
SQL-
CREATE TABLE ( ), ALTER TABLE ( ). :
CREATE TABLE account ...
FRAGMENT BY EXPRESSION
id_num > 0 AND id_num <= 20 IN dbsp1
id_num >20 AND id_num <= 40 IN dbsp2
REMAINDER IN dbsp3
dbsp1, dbsp2, dbsp3 - , .
INFORMIX-OnLine DS . - ( ) . . , , , .
, , . . , , ( , ) .
INFORMIX-OnLine DS , :
, , , .
, , . - ( ) .
2.2.5
(Parallel Data Query, PDQ) - , , , . , PDQ:
, , , ( ), . , (, ) - , . , , , , , , . , , PDQ.
, ; , , .
2.2.5.1 PDQ
- , , . . , . . PDQ :
2.2.5.2
- , () . , (. 4). ( ) (data flow), , , . - , , . . , INFORMIX-OnLine DS:
. 4. . , .
SCAN - .
NESTED LOOP JOIN - ( , , . .).
MERGE JOIN - .
HASH JOIN - . -, . , .
GROUP - (GROUP BY) .
SORT - .
MERGE - UNION UNION ALL ( UNION MERGE SORT).
REMOTE - SELECT.
. ( ), . (, , ), .
CREATE() - . , , (open(), next(), close(), free()), .. , . create() -, , , . . , create() .
OPEN() - . , , . , , , , ( ),
MGM (MGM - , , PDQ; . , . " OLTP DSS-") . open() , .. , open() .
NEXT() - . , next() , next() . ., . - , , . next() , .
CLOSE() - . , . , next(), , , , . , . close() , .
close() , , .
FREE() - . , . free() , , .
, (. 5). , , . , , , . , , . - , .
. 5. , , .
- - , (, ) . - (EXCHANGE). , , , . EXCHANGE. EXCHANGE , . , .
. , , , , , , , . .
, PDQ INFORMIX-OnLine DS .
2.2.5.3
- , , , , ; .
, . .
. PDQ- .
, , , , , . PDQ . , , . OnLine DS - , .
, . , , , . , , ; . , , , - , , . , , - , .
2.2.5.4 OLTP DSS-
, , . OLTP, DSS .
OLTP-: - 8- ?
DSS-: X Y ? ?
, , , , .
, , OLTP- DSS- .
PDQ DSS- . , OLTP-, . , PDQ-, INFORMIX-OnLine DS , . , , .
( PDQ) PDQ-. , , PDQ-, , PDQ-. , , .
, INFORMIX-OnLine DS . OLTP DSS ( CPU) . , , OLTP , PDQ.
OnLine DS - (Memory Grant Manager - MGM). , PDQ-, :
2.2.6
. , , . , , , MGM. , .
, , , , , , ( , ). , . . / .
, , . , , , , . , , , - .
- . , , . , , "" . , , - .
2.2.7
INFORMIX-OnLine DS :
2.2.7.1 .
INFORMIX-OnLine DS - , , . , - . , - .
, , , off-line. - ( , ). .
. , , , . , .
. , , . , , off-line. - . .
(split read). , , , - . , .
2.2.7.2
- . INFORMIX-OnLine DS ( ) , . , , .
INFORMIX-OnLine DS - (High Availability Data Replication - HDR). , (. 6, . 7). , .
. 6. . , - .
. 7. , .
, , :
( ) , . , . - , , , . , .
, , INFORMIX-OnLine DS . , .
, :
2.2.7.3
, . , , , , . , , .
2.2.7.4
INFORMIX-OnLine DS , , . . . - , .
INFORMIX-OnLine DS OnArchive, , . :
2.2.8
, , , , . , , -, DSS, , . . - , , , .
, , , ON-Monitor. (MGM) OnArchive, INFORMIX-OnLine DS : , DB/Cockpit OnPerf, / .
2.2.8.1
OnLine DS SMI (System Monitoring Interface). , :
SMI . , SQL- SELECT.
2.2.8.2 DB/Cockpit
DB/Cockpit - , . :
, , .
DB/Cockpit /, . - (probe) . , INFORMIX-OnLine DS; SMI . , , . , , , , INFORMIX-OnLine DS, , , .
DB/Cockpit . , , "" INFORMIX-OnLine DS.
2.2.8.3 OnPerf
OnPerf - , INFORMIX-OnLine tbstat. :
OnPerf - OnPerf . INFORMIX-OnLine DS . OnPerf, .
OnPerf , . , . OnPerf.
, , - , , , , , .
2.2.8.4
, . :
. , , - , , - , , .
2.2.9
2.2.9.1 -
INFORMIX /. , INFORMIX-OnLine DS , , . SQL-, . , , , . , , MS Windows. , .
INFORMIX-OnLine DS , .
5.0 4.1 INFORMIX-OnLine DS 7.1 (Relay Module 7.1). , . 6.0 INFORMIX-OnLine DS 7.1 INFORMIX-NET 5.0 INFORMIX-STAR 5.0, , , PC.
TCP/IP SPX/IPX. TCP/IP UNIX TLI, SPX/IPX - TLI. INFORMIX-OnLine DS . , , . .
, . , , , . .
2.2.9.2
, , , . , INFORMIX-OnLine DS, .
2.2.9.3
INFORMIX-OnLine DS , , :
CONNECT TO stores@italy
BEGIN WORK
UPDATE stores:manufact SET manu_code = 'SHM'
WHERE manu_name = 'Shimara'
INSERT INTO stores@france:manufact
VALUES ('SHM', 'Shimara', 30)
INSERT INTO stores@australia:manufact
VALUES ('SHM', 'Shimara', 30)
COMMIT WORK
BEGIN WORK, COMMIT WORK - , , stores - , italy, france, australia - .
. , , . , . , .
, , , . . italy, CONNECT.
, , COMMIT WORK, , . , , .
, , , . , , . , , .
, . INFORMIX-OnLine DS , , . , - .
INFORMIX-OnLine DS , (presumed abort optimization). , , , , . , , .
. -, . - , - " ", " ". , , , , . -, , . , , , , .
, , , , . , , , . , INFORMIX-OnLine DS . DEADLOCK_TIMEOUT - , INFORMIX-OnLine DS . .
2.2.10
(native language support - NLS) INFORMIX X/Open XPG3. NLS INFORMIX-OnLine DS 8- NLS. , , , . X/Open NLS , , .
2.2.11 2
INFORMIX-OnLine DS . 2, . INFORMIX-OnLine/Secure, .
, . , . onaudit . onshowaudit SQL.
2.3 Informix .
2.3.1 Informix-Enterprise Gateway 7.1
INFORMIX-Enterprise Gateway , UNIX Microsoft Windows, , . Enterprise Data Access SQL (EDA/SQL) Information Builders, Inc.
INFORMIX-Enterprise Gateway:
, , , , , (proprietary), . - , . INFORMIX-Enterprise Gateway , .
2.3.2 EDA/SQL
EDA/SQL Information Builders, Inc. SQL , , (record-oriented files), . , , . EDA/SQL .
EDA/SQL /. , Enterprise Gateway.
2.3.2.1 EDA API/SQL
Enterprise Gateway.
EDA API/SQL - , , Information Builders, Inc. SQL .
2.3.2.2 EDA/Link
Enterprise Gateway.
EDA/Link - EDA. EDA/Link , , , .
2.3.2.3 EDA/SQL Server
, Information Builders, Inc.
EDA/SQL Server - , . EDA/SQL Server . , , , , .
Enterprise Gateway EDA/SQL Server 2.2 .
2.3.2.4 EDA/Data Drivers
, Information Builders, Inc.
EDA/Data Drivers SQL RPC, , , . , SQL- IMS IMS DL/L, .
2.3.3 Enterprise Gateway
Enterprise Gateway INFORMIX, INFORMIX EDA/SQL.
SQL , Enterprise Gateway, EDA/SQL Server, . , EDA/SQL Server, Enterprise Gateway .
2.3.3.1
Enterprise Gateway , . Enterprise Gateway , INFORMIX. SQL (RPC - Remote Procedure Call).
SQL - ANSI-92 SQL ANSI-89 SQL; EDA/SQL ANSI-89 SQL.
RPC INFORMIX, . EDA/SQL , . RPC .
, RPC SQL, Enterprise Gateway (scroll cursors), .
2.3.3.2
Enterprise Gateway , INFORMIX. INFORMIX / .
2.3.3.3 Enterprise Gateway
Enterprise Gateway . Enterprise Gateway , INFORMIX INFORMIX-OnLine DS INFORMIX-SE. , MS Windows, INFORMIX-NewEra, , , INFORMIX Enterprise Gateway.
Enterprise Gateway UNIX EDA/SQL Server TCP/IP. Enterprise Gateway EDA/SQL Server TCP/IP EDA/Link.
2.3.3.4
Enterprise Gateway (ID) , INFORMIX EDA/SQL. EDA/SQL Server . , MVS RACF, ACF2 CA-Top Secret.
2.3.4 Informix-OnLine DS : Informix-TP/XA Informix-TP/TOOLKIT
INFORMIX-ESQL/C C- INFORMIX-TP/XA. , INFORMIX-ESQL/C, INFORMIX-OnLine DS , X/Open-XA, , TUXEDO System/T. 4GL- INFORMIX-TP/Toolkit INFORMIX-4GL. INFORMIX , X/Open-XA, , :
2.4
() , :
INFORMIX-Enterprise Gateway.
INFORMIX . .
INFORMIX-OnLine DS:
OLTP, DSS, TPC (Transaction processing Performamce Council), .
, ( , ) . , ,
, :
OLTP, DSS , , .
, , , OLTP.
, , . INFORMIX-OnLine DS , :
ANSI-92 SQL , , :
INFORMIX-OnLine DS C2.
, . , , , , , . , , . , INFORMIX:
, , - INFORMIX-NewEra, , . INFORMIX .
, , . . :
- , " " , . . . INFORMIX - 20%, .
INFORMIX , .
2.5
1. . . . . Jet Info, . 1, 1995.
2. INFORMIX-OnLine Dynamic Server. Administrator's Guide, Vol. 1,2. Version 7.1. 1994, INFORMIX SoftWare Inc.
3. INFORMIX-OnLine Dynamic Server 6.0, 7.1. Training Course, 1993, 1994, INFORMIX SoftWare Inc.
4. INFORMIX-OnLine Enterprise Gateway Version 7.1. Technical Brief. 1994, INFORMIX SoftWare Inc.

Last-modified: Tue, 15 Sep 1998 12:44:51 GMT
: