Fujitsu UDS/SQL V2.5 사용자 설명서
SSL
Calculation formulas
U929-J-Z125-9-76
177
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.7 Formulas for calculating the storage space requirements for
records and tables
The storage space requirement for records varies depending on whether they are stored in
a direct hash area, whether an indirect hash area is set up for them and which type of
connection has been specified for them.
a direct hash area, whether an indirect hash area is set up for them and which type of
connection has been specified for them.
contain formulas to calculate
the storage space requirement. These formulas differ, depending on whether the page
length of the database is 2048 bytes, 4000 bytes or 8096 bytes.
length of the database is 2048 bytes, 4000 bytes or 8096 bytes.
Calculation formulas for a database with a 2048-byte page length
Number of records
in the data page
2028
LRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLR
record length
record length
1
+8
in the direct CALC page
2018
LRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLRLR
record length+key length+15
record length+key length+15
Number of entries in the indirect CALC page
2018
LRLRLRLRLRLRLRLRLRLRLRLR
key length+7
key length+7
Number of table
entries per page in a:
entries per page in a:
List
2002
LRLRLRLRLRLRLRLRLRLRLRLR
key length+8
key length+8
pointer array
2
sort key table
3
SEARCH key table
(TYPE IS REPEATED-KEY)
(TYPE IS REPEATED-KEY)
2002
LRLRLRLRLRLRLRLRLRLRLRLR
key length+7
key length+7
Table 10: Calculation formulas for a database with a 2048-byte page length