Fujitsu UDS/SQL V2.5 사용자 설명서
SSL
Linkage methods
U929-J-Z125-9-76
157
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
8:
58
.5
5
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
5
5.3.3
Preventing redundancy in SEARCH key tables
TYPE IS DATABASE-KEY-LIST
In the description of the logical data structure drawn up using the schema DDL, the user
decides if UDS/SQL is to set up a SEARCH key table (SEARCH KEY IS... USING INDEX).
The form of this table can be influenced by means of the TYPE clause.
decides if UDS/SQL is to set up a SEARCH key table (SEARCH KEY IS... USING INDEX).
The form of this table can be influenced by means of the TYPE clause.
The UDS/SQL standard form of SEARCH key table is that of a multi-level pointer array: It
consists of one line for every record of the associated record type or for each member
record of the associated set occurrence. This line contains the key value of the record and
the pointer to the record.
(This standard form corresponds to the specification: TYPE IS REPEATED-KEY.)
consists of one line for every record of the associated record type or for each member
record of the associated set occurrence. This line contains the key value of the record and
the pointer to the record.
(This standard form corresponds to the specification: TYPE IS REPEATED-KEY.)
Different records can often have the same key values (DUPLICATES ARE ALLOWED). In
such cases, TYPE IS DATABASE-KEY-LIST can be specified; this ensures that a key value
with duplicates is stored only once.
such cases, TYPE IS DATABASE-KEY-LIST can be specified; this ensures that a key value
with duplicates is stored only once.
This type of SEARCH key table is referred to as a duplicates table. Duplicates tables are
useful
useful
–
in the case of long keys,
–
if several key values have between 5 and 2000 duplicates,
–
when processing large numbers of records (see the "
"
manual, FIND 7).
A third overflow page must be generated by UDS/SQL in the following cases:
–
if there are more than approximately 2000 duplicates in a 2-Kbyte or 4-Kbyte database
–
if there are more than approximately 4000 duplicates in an 8-Kbyte database.
This has an adverse effect on the access behavior (one additional access per overflow
page), which should be weighed against the saving in space achieved.
Duplicates tables are set up by UDS/SQL on the lowest level only. Higher table levels are
comparable to those of a standard SEARCH key table.
page), which should be weighed against the saving in space achieved.
Duplicates tables are set up by UDS/SQL on the lowest level only. Higher table levels are
comparable to those of a standard SEARCH key table.