Fujitsu UDS/SQL V2.5 Network Router User Manual


 
SSL Introduction
U929-J-Z125-9-76 135
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 08:58.55 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k05
If the placement of records changes, updating of the page addresses can be limited to the
DBTT.
In addition to the page addresses of the owner records, the DBTT of an owner record type
contains the page addresses of all tables pertaining to the set occurrences of the owner
records. To identify these tables, the database key value of the corresponding owner record
is combined with the DBTT column number, forming a unique identifier which never
changes.
Figure 31: Complete example of a DBTT
General conclusions:
Page address updating for records and tables can be limited to the DBTT.
All page addresses listed in the DBTT are current.
0 4 0 0 0 0 8 3 0 4 0 0 0 0 9 0 0 4 0 0 0 0 9 0
0 6 0 0 0 0 1 4 0 6 0 0 0 0 2 8 0 6 0 0 0 0 2 8
Act key: owner record Act key: pointer array
4 bytes 4 bytes
Act key:
set SEARCH key table
4 bytes
Column 0 Column 1 Column 2