Fujitsu UDS/SQL V2.5 사용자 설명서
U929-J-Z125-9-76
53
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
24
. Ok
tobe
r 20
07
S
ta
nd
0
9:
30
.2
3
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
4
4 Schema DDL
4.1 Introduction
Before you start designing a UDS/SQL schema, it is first necessary to thoroughly analyze
the intended database applications and the information which is to processed by them. The
analysis must yield not only all the information required, but the relationships between the
information as well.
the intended database applications and the information which is to processed by them. The
analysis must yield not only all the information required, but the relationships between the
information as well.
The data structure thus derived is translated into a UDS/SQL schema by means of the
schema DDL.
schema DDL.
The UDS/SQL schema must define all data required for the tasks to be performed using the
database. However, the UDS/SQL schema has no direct user interface; user-friendly editing
of the data need not be provided for when designing the UDS/SQL schema.
database. However, the UDS/SQL schema has no direct user interface; user-friendly editing
of the data need not be provided for when designing the UDS/SQL schema.
The CODASYL model provides the following units for defining the logical data structure:
Item
The smallest unit of named data within a record type. It is defined by item type, item
length and item name.
length and item name.
Vector Item with repetition factor. The repetition factor must be greater than 1. It defines
how many duplicates of the item the vector comprises.
Group item
Named grouping of record elements within a record type. A record element can in
this case be either an item, a vector or a group item. Group items that are not
repeating groups may only be defined for subschemas.
this case be either an item, a vector or a group item. Group items that are not
repeating groups may only be defined for subschemas.
Repeating group
Group item with repetition factor. The repetition factor must be greater than 1. It
defines how many duplicates of the group item the repeating group comprises.
defines how many duplicates of the group item the repeating group comprises.
Record type
Named collection of record elements and the smallest unit of data which is recog-
nized by UDS/SQL via a unique identifier.
A record element may be an item, a vector or a repeating group.
nized by UDS/SQL via a unique identifier.
A record element may be an item, a vector or a repeating group.
Set
Named relationship between two record types.