Fujitsu UDS/SQL V2.5 用户手册
General information
CODASYL model
U929-J-Z125-9-76
29
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
18
. Ok
tobe
r 20
07
S
ta
nd
1
1:
29
.4
8
P
fa
d:
G
:\
v
og
t\
fs
c
\ud
s
\M
anu
al
e
\e
n\
ud
s
e
nt
_e\
u
ds
ent
.k
0
2
The set between the SUPPLIER and ARTICLE record types has the name SUPPLIES. In
the SUPPLIES set, SUPPLIER is the owner record type, and ARTICLE the member record
type. As a rule, two or more records of the member record type are assigned to a given
record of the owner record type. In this example, the supplier Schmidt supplies the articles
gingerbread cookies and marzipan.
the SUPPLIES set, SUPPLIER is the owner record type, and ARTICLE the member record
type. As a rule, two or more records of the member record type are assigned to a given
record of the owner record type. In this example, the supplier Schmidt supplies the articles
gingerbread cookies and marzipan.
Figure 2: Network-like structure of data
In a network structure, a record type may be a member in two or more different set relation-
ships and thus may also have more than one owner. A record can have only one owner per
set relationship.
ships and thus may also have more than one owner. A record can have only one owner per
set relationship.
PURCHASE
CONTAINED-IN
ORDERED-IN
CONTAINS
SUBSET
PURCH-ORDER
NAME
CITY
Mueller
Schmidt
Schmidt
Munich
Nuremberg
Nuremberg
DESIGNATION
PRICE
Milk
Yoghurt
Curd cheese
Gingerbread
Marzipan
Yoghurt
Curd cheese
Gingerbread
Marzipan
1,49
0,99
1,29
4,39
2,99
0,99
1,29
4,39
2,99
SUPPLIER
ARTICLE
SUPPLIES
Record element
Record elem.
name
name
Record
SUPPLIES
ARTICLE
RECEIVES
SUPPLIER
ORDER
ITEM