, , ,
.
" " (),
DBMS (DataBase Managment System) ,
, .
,
,
,
.
(). ,
,
.. ,
.
"-". ,
, .
.
, "-" :
1. - , ,
.
,
-.
2. - (database engine),
. ,
.
. ,
,
.
,
? .
, ,
,
. :
- (, ,
),
, - ,
, .
.
:
, (.. -) ,
,
-
(
). ,
,
, ,
, , .
INFORMIX , ,
- .
. , ,
.. ,
.
(DATABASE) :
.
.
(TABLE)
, .
- , .
DBase - , DBase
, INFORMIX .
(ROW)
, - .
, NULL - "".
.
.
(COLUMN)
.
INFORMIX :
INTEGER SERIAL -
SMALLINT CHAR(n) DATE
FLOAT DECIMAL(m,n) DATETIME qualif1 TO qualif2
REAL MONEY(m,n) INTERVAL qualif1 TO qualif2
qualif \in {YEAR,MONTH,DAY,HOUR,MINUTE,SECOND,FRACTION(n)}
, .
- -
"
,
, ."
" " .
,
.
, .
()
.
. -
,
, ,
,
.
. .
. .
, ""
.
, , , ..,
, .
, ,
"" .
: ""
, ,
,
. , ,
"", :
"" " ".
, ,
" " (
, ).
,
, .
.
"" ,
"",
, "" ,
.
, ,
.
- ,
,
.
( ) .
{ ,
}
.
. ,
,
,
.
,
.
.
1. ,
, , ,
.
2. ,
.
3. ,
,
, .
, .
.
,
,
.
.
.
,
, , "". ,
.
,
.
(logfile), .
, .
.
.
.
.
.
-
.
ANSI.
backup .
(locking), .
.
(). ,
.
.
.
, .
: /
SET LOCK MODE.
, .
:
-
-
-
( )
:
-
-
-
-
- .
ANSI (American National Standart Institute)
(SQL) - Structured Query Language
, . 4
.
SQL :
:
CREATE, DROP, ALTER
:
INSERT, DELETE, SELECT, UPDATE
:
GRANT / REVOKE , LOCK / UNLOCK , SET LOCK MODE
, :
Transaction, Audit trail, Logfile
:
3- .
.
.
. SQL.
, .
.
. .
.
. .
, , .
.
.
.
Informix :
I. :
Informix-SE.
INFORMIX,
,
INFORMIX.
Informix-NET.
INFORMIX-SE.
.
TCP/IP.
Informix-OnLine.
OLTP (On-Line-Transaction-Processing)
. SE
, ()
. 2-4
SE,
, OnLine
.
SE,
Binary Large Objects, ,
, , ,
,
, backup.
Informix-STAR.
INFORMIX-OnLine.
.
INFORMIX-STAR .
TCP/IP. , MS-DOS .
II.
.
Informix-SQL.
. 5 :
- SQL.
- .
- .
- .
- .
III.
.
Informix-4GL.
4GL.
:
- 4GL , .
- 4GL.
-
( make).
-
, .
4GL :
. SQL - .
. - IF, CASE, CALL, FUNCTION, FOR,
WHILE, GOTO, DEFINE ..
. - , , -
.
.
Informix-4GL-RDS+ID.
Rapid Development Sistem and Interactive Debugger
, ,
, ""-,
runner'. 4GL ""-.
Informix-ESQL/C.
EmbeddedSQL/C ( SQL)
,
SQL.
- -,
, ESQL/C ( SQL),
,
. -.
C-ISAM.
-
, INFORMIX-SE.
IV. INFORMIX
Informix-RunTime.
Informix, ,
,
Informix.
(SQL, ESQL, 4GL -
RunTime).
, ,
4GL-RDS, ,
Informix-SQL. Informix-RunTime
SE OnLine,
.
V.
Wingz.
(32.768 ,
). 140
HiperScript .
,
.
,
INFORMIX.
, , ,
.
SmartWareII.
, ,
,
.
. QBE
. 100
.
140.000 ,
.
UNIX DOS.
INFORMIX-SQL.
VI. .
Informix-QuickStep.
.
, .
, 4GL,
.
Informix-FORMS.
4GL
. Informix-4GL.
Informix-Menu.
,
Shell-.
Informix-Optical.
, Informix-Online (
, , .. BLOB)
, ,
"" WORM (Write
Once Read Many).
VII. - .
Informix-GX.
,
4GL-. -
- , -
MSWindows 3.1 X-Window OSF/Motif.
SPARC- - . In
formix-4GL Compiler ,
curses .
Informix-4GL for Windows.
4GL 4.12, MS Windows.
4GL -
MS-Windows - .
Informix-NET/PC.
PC
, Unix :
SE+NET, OnLine+Star. Informix for MS
Windows (Hyperscript, 4GL, NewEra) .
Informix-HyperScript.
, SQL
Informix.
(, , )
.
/ .
( Visual Basic).
Unix/X-Windows, NeXT, MS/Windows, Macintosh.
- Wingz. Wingz
HyperScript
Informix-ViewPoint/DBA.
ISQL MS Windows. (, )
Informix.
(, , .)
. -
. DBA - ,
ViewPoint, DBA ,
SuperView - -
,
. ViewPoint ,
DBA .
Informix-NewEra.
- Informix-4GL++. -
.
Informix.
4GL ( ).
- Informix
. Motif X-Windows
MS-Windows.
Last-modified: Tue, 25 Nov 1997 07:10:21 GMT