Manuals / Brands / Computer Equipment / Network Router / Fujitsu / Computer Equipment / Network Router

Fujitsu UDS/SQL V2.5 manual

1 324

Download 324 pages, 1.82 Mb

Edition September 2007

© Siemens Nixdorf Informationssysteme AG 1995 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.vor

UDS/SQL V2.5

Design and Definition

Contents

Main Page Contents Page Page Page Page Page 1 Preface 1.1 Brief product description 1.2 Target group 1.3 Summary of contents Page Preface Summary of contents Summary of contents Preface 14 Preface Summary of contents 1.4 Readme file 1.5 Changes since the last version Changes since the last version Preface 18 Preface Changes since the last version Changes since the last version Preface 20 Preface Changes since the last version Notational conventions Preface ! 22 1.6 No tational conventions This section provides an explanation of the notational conventions used to describe syntax rules. 1.6.2 Non-SDF notational conventions Preface Notational conventions Page 2 General information 2.1 Modern data organization Page Page 2.2 Data models 2.2.1 The CODASYL model Page Page General information Relational model 2.2.2 Relational model Page Page Page 2.2.3 Relative merits of the data models 2.2.4 Coexistence of the CODASYL and relational models Page Page Page Page 2.3 Universal Database System UDS/SQL Page 3 Designing the database 3.1 Data modeling Page 3.2 Distributing the data Page Page Page Page 3.3 Technical implementation 3.3.1 Defining the logical structure of a UDS/SQL database 3.3.2 Defining the physical structure of a UDS/SQL database 3.3.3 Views Page 4 Schema DDL 4.1 Introduction Page 4.2 Defining an item 4.2.1 Defining an unpacked numeric item Page 4.2.2 Defining a packed numeric item 4.2.3 Defining a binary item 4.2.4 Defining an alphanumeric item of fixed length 4.2.5 Defining an alphanumeric item of variable length Page 4.2.6 Defining a national item (UTF-16) 4.2.7 Defining a database key item 4.3 Defining a vector 4.4 Defining a repeating group Page 4.5 Grouping record elements to form a record type Schema DDL Grouping to form a record type 4.6 L inking the records of two record types to form a set 4.6.1 Defining a set Page Page Page 74 Page 76 Page Page 4.6.2 Defining the type of membership of records in a set Page Page Page Page 4.7 Access paths and record sequences 4.7.1 Direct and sequential access on record type level via database key value Page 4.7.2 Generating additional access paths for direct access on record type level Page Page Page Page Page Page 4.7.3 Determining the order of records within a set occurrence Page Page Page Page Page 4.7.4 Generating additional paths for direct access on set level Page Page 4.7.5 Determining set occurrence selection Page 4.8 Special sets 4.8.1 SYSTEM set 4.8.2 Dynamic set 4.9 Assigning names to hash areas and tables 4.10 The realm concept 4.10.1 Defining a realm 4.10.2 Defining allocat ion of records to realms 4.10.3 Temporary realms 4.11 Assigning name and privacy to a schema 4.12 Co mprehensive example of DDL application Realms: INSTALLMENT ARTICLE Page Page Page Page Page Page Page Page Page 4.13 Reserved words of the DDL compiler Page Page Page Page Page 5 SSL 5.1 Introduction 5.1.1 Methods of physical representation of the logical data structure 5.1.2 DBTT (Database Key Translation Table) Page Page Introduction SSL Line 3 Line 9 0 5 0 0 0 0 0 9 Figure 30: Linkage between the database key value and the record address via the DBTT Page 5.2 Declaring the population 5.2.1 Specifying the number of records in one record type Page Page Page 5.2.2 Specifying the size of the set occurrences of a set Page Page 5.2.3 Overview of the initial sizes for storage space reservations 5.3 Determining the linkage of records 5.3.1 Determining the storage mode for set occurrences Page Page Page Page Page Page Page Page 5.3.2 Assessing pointer array, list and chain Page Page Page 5.3.3 Preventing redundancy in SEARCH key tables Linkage methods SSL 158 5.3.4 Adding a pointer to link a member to its owner 5.4 Defining the placement of member records, tables and hash areas Page Page Page Page Page Page Page 5.4.2 Defining the placement of record SEARCH key table, DBTT and record hash areas SSL Placement In this example, UDS/SQL would arrange the records and table of the set as follows: Placement SSL 170 5.4.3 Overview of placement statements SSL Placement first realm in WITHIN clause for member record type 5.5 Defining the extent of table reorganization desired Page Page Page 5.6 Storing the records of a record type in compressed form 5.7 Formulas for calculating the storage space requirements for records and tables Page SSL SSL example 5.8 Comprehensive example of SSL application SSL example SSL 180 SSL SSL example Reserved words of the SSL compiler SSL 182 5.9 Reser ved words of the SSL compiler 6 Definition of the user interface to the database 6.1 Subschema DDL 6.1.1 Introduction 6.1.2 Assigning name and privacy to a subschema 6.1.3 Unlocking a schema for creating a subschema 6.1.4 Copying entire record types from the schema into the subschema 6.1.5 Copying part of a record type from the schema into the subschema Page User interface Subschema DDL Page Page Page Page Page 6.1.6 Copying sets from the schema into the subschema 6.1.7 Copying realms from the schema into the subschema User interface Subschema DDL (example) 6.1.8 Comprehensive example of subschema DDL 6.2 Relational schema 7 Structure of pages Page 7.1 Page container Act-key-0 page / act-key-N page St ructure of pages 200 7.2 Act-key-0 and act-key-N page Page 7.3 FPA page Page Page 7.4 DBTT pages 7.4.1 DBTT anchor page DBTT pages Structure of pages 206 7.4.2 DBTT pag e DBTT pages Structure of pages 208 Structure of a DBTT page with a length of 2048 bytes Figure 51: Structure of a DBTT page with a length of 2048 bytes Structure of pages DBTT pages Structure of a DBTT page with a length of 4000 or 8096 bytes 7.5 Direct CALC p age Structure of pages Direct CALC page Page 7.6 Indirect CALC page Indirect CALC page Structure of pages 214 7.7 Data page Data page Structure of pages 216 Page Page 8 Structure of records and tables 8.1 Structure of records Page Page Page Structure of records and tables Record structure 8.2 Stru cture of tables Table header Page 226 Page DBTT of owner record type Structure of records and tables Table structure Duplicates table Page Page Page Page Page Page Schema DDL Reference section 236 9.1 Schema DDL syntax 9.1.1 Schema entry 9.1.2 Realm entry 9.1.3 Record entry Page Page Page Page Reference section Schema DDL 9.1.4 Set entry Page Page Page Page 9.2 SSL syntax 9.2.1 Schema entry 9.2.2 Record entry Page Page Page Page 9.2.3 Set entry Page Page Page 9.3 Sub schema DDL syntax 9.3.1 IDENTIFICATION DIVISION 9.3.2 AREA SECTION 9.3.3 RECORD SECTION 9.3.4 SET SECTION Page Glossary A Page Page B C Page Page Page Page D Page Page Page Page Page E F G H I K L M Page N O P Page Page Page R Page Page S Page Page Page Page Page Page T Page U Page V W Page Abbreviations Page Page Page Related publications Page Page Page Page Page Index