Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Contents
U929-J-Z125-9-76
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. October 2007 Stand 09:57.43 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.ivz
4.11 Assigning name and privacy to a schema . . . . . . . . . . . . . . . . . . . . . 111
4.12 Comprehensive example of DDL application . . . . . . . . . . . . . . . . . . . . 112
4.13 Reserved words of the DDL compiler . . . . . . . . . . . . . . . . . . . . . . . . 123
5 SSL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129
5.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .129
5.1.1 Methods of physical representation of the logical data structure . . . . . . . . . . . 130
5.1.2 DBTT (Database Key Translation Table) . . . . . . . . . . . . . . . . . . . . . . . . 131
5.2 Declaring the population . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136
5.2.1 Specifying the number of records in one record type . . . . . . . . . . . . . . . . . 136
5.2.2 Specifying the size of the set occurrences of a set . . . . . . . . . . . . . . . . . . 140
5.2.3 Overview of the initial sizes for storage space reservations . . . . . . . . . . . . . . 143
5.3 Determining the linkage of records . . . . . . . . . . . . . . . . . . . . . . . . . 144
5.3.1 Determining the storage mode for set occurrences . . . . . . . . . . . . . . . . . . 144
5.3.2 Assessing pointer array, list and chain . . . . . . . . . . . . . . . . . . . . . . . . . 153
5.3.3 Preventing redundancy in SEARCH key tables . . . . . . . . . . . . . . . . . . . . 157
5.3.4 Adding a pointer to link a member to its owner . . . . . . . . . . . . . . . . . . . . 159
5.4 Defining the placement of member records, tables and hash areas . . . . . . . 160
5.4.1 Defining the placement of member records, associated tables and hash areas for
secondary keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160
5.4.1.1 Placement at realm level . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161
5.4.1.2 Placement within a realm . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163
5.4.2 Defining the placement of record SEARCH key table, DBTT and record hash areas . 168
5.4.3 Overview of placement statements . . . . . . . . . . . . . . . . . . . . . . . . . . . 170
5.5 Defining the extent of table reorganization desired . . . . . . . . . . . . . . . . 172
5.6 Storing the records of a record type in compressed form . . . . . . . . . . . . 176
5.7 Formulas for calculating the storage space requirements for records and
tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .177
5.8 Comprehensive example of SSL application . . . . . . . . . . . . . . . . . . . . 179
5.9 Reserved words of the SSL compiler . . . . . . . . . . . . . . . . . . . . . . . . 182