. 71 , .
. 71. IDEF1X-
, SQL- Borland InterBase.
InterBase . InterBase . , (Jim Starkey), , , . InterBase Multi-Generational Architecture (MGA, ), , , , , .
Repeatable Read ( ), , , . , , , .
( , versioning) , .
, MGA , , SQL- .
InterBase , , Ericsson, , .
, InterBase, :
( InterBase 10 , )
( 32‑ Windows, Solaris Linux) ,
InterBase 15 ,
SQL
, , , , ,
|
|
CREATE { DATABASE | SHEMA } <_>
{ USER _ [PASSWORD ] ]
[ PAGE_SIZE [=] ]
[ LENGTH [=] [PAGE [S] ] ]
[ DEFAULT CHARASTER SET _ ]
[ <_> ];
< > = FILE <_> [<_>] [< >]
<_> = LENGTH [ = ] [ PAGE [S] ] | STARTING
[AT [PAGE]] <_>
----------------------------------------------------------
<_> , .
USER _
PASSWORD
PAGE_SIZE [=]
DEFAULT CHARASTER SET _
FILE <_> ,
STARTING [AT [PAGE]] ,
LENGTH [ = ] [ PAGE [S] ] . 50. 50.
:
CREATE DATABASE D:\BD\SKLAD.GDB
FILE D:\BD\SKLAD.GD1 STARTING AT PAGE 1001
LENGTH 500
FILE D:\BD\SKLAD.GD\2
D:\BD\SKLAD.GDB, 3 : 1000 , 500 .
:
(CHAR, VARCHAR)
(INTEGER, SMALLINT)
(FLOAT, DOUBLE PRECISION)
- (DECIMAL, NUMERIC)
(DATE)
(BLOB)
:
CREATE DOMAIN [AS] < >
[DEFAULT {} | NULL | USER]
[NOT NULL] [CHECK (< >) ]
:
CREATE DOMAIN ID_TYPE AS INTEGER
CHECK (VALUE >= 100);
< >= {
VALUE <> <>
| VALUE [NOT] BETWEEN <1> AND <2>
| VALUE [NOT] LIKE <1> [ESCAPE <2>]
| VALUE [NOT] IN <1> [, <2> ])
| VALUE IS [NOT] NULL
| VALUE [NOT] CONTAINING <>
| < >
| NOT < >
| < > OR | < >
| < > AND < >
};
<> = { = | < | > | <= | >= |!= |!< |!> | <> }