Manuali utente per Fujitsu UDS/SQL V2.5

Sommario

• Contents

  3
• Preface

  9
  • Brief product description

    9
  • Target group

    10
  • Summary of contents

    11
  • Readme file

    16
  • Changes since the last version

    17
  • Notational conventions

    22
    • Warnings and notes

      22
    • Non-SDF notational conventions

      22
• General information

  25
  • Modern data organization

    25
  • Data models

    28
    • The CODASYL model

      28
    • Relational model

      31
    • Relative merits of the data models

      35
    • Coexistence of the CODASYL and relational models

      36
  • Universal Database System UDS/SQL

    41
• Designing the database

  43
  • Data modeling

    43
  • Distributing the data

    45
  • Technical implementation

    50
    • Defining the logical structure of a UDS/SQL database

      50
    • Defining the physical structure of a UDS/SQL database

      51
    • Views

      51
• Schema DDL

  53
  • Introduction

    53
  • Defining an item

    55
    • Defining an unpacked numeric item

      56
    • Defining a packed numeric item

      58
    • Defining a binary item

      59
    • Defining an alphanumeric item of fixed length

      60
    • Defining an alphanumeric item of variable length

      61
    • Defining a national item (UTF-16)

      63
    • Defining a database key item

      64
  • Defining a vector

    65
  • Defining a repeating group

    66
  • Grouping record elements to form a record type

    68
  • Linking the records of two record types to form a set

    70
    • Defining a set

      70
    • Defining the type of membership of records in a set

      79
  • Access paths and record sequences

    84
    • Direct and sequential access on record type level via database key value

      85
    • Generating additional access paths for direct access on record type level

      87
    • Determining the order of records within a set occurrence

      94
    • Generating additional paths for direct access on set level

      100
    • Determining set occurrence selection

      103
  • Special sets

    105
    • SYSTEM set

      105
    • Dynamic set

      106
  • Assigning names to hash areas and tables

    107
  • The realm concept

    108
    • Defining a realm

      109
    • Defining allocation of records to realms

      110
    • Temporary realms

      110
  • Assigning name and privacy to a schema

    111
  • Comprehensive example of DDL application

    112
  • Reserved words of the DDL compiler

    123
• SSL

  129
  • Introduction

    129
    • Methods of physical representation of the logical data structure

      130
    • DBTT (Database Key Translation Table)

      131
  • Declaring the population

    136
    • Specifying the number of records in one record type

      136
    • Specifying the size of the set occurrences of a set

      140
    • Overview of the initial sizes for storage space reservations

      143
  • Determining the linkage of records

    144
    • Determining the storage mode for set occurrences

      144
    • Assessing pointer array, list and chain

      153
    • Preventing redundancy in SEARCH key tables

      157
    • Adding a pointer to link a member to its owner

      159
  • Defining the placement of member records, tables and hash areas

    160
    • Defining the placement of member records, associated tables and hash areas for secondary keys

      160
      • Placement at realm level

        161
      • Placement within a realm

        163
    • Defining the placement of record SEARCH key table, DBTT and record hash areas

      168
    • Overview of placement statements

      170
  • Defining the extent of table reorganization desired

    172
  • Storing the records of a record type in compressed form

    176
  • Formulas for calculating the storage space requirements for records and tables

    177
  • Comprehensive example of SSL application

    179
  • Reserved words of the SSL compiler

    182
• Definition of the user interface to the database

  183
  • Subschema DDL

    183
    • Introduction

      183
    • Assigning name and privacy to a subschema

      184
    • Unlocking a schema for creating a subschema

      184
    • Copying entire record types from the schema into the subschema

      185
    • Copying part of a record type from the schema into the subschema

      185
    • Copying sets from the schema into the subschema

      193
    • Copying realms from the schema into the subschema

      194
    • Comprehensive example of subschema DDL

      195
  • Relational schema

    196
• Structure of pages

  197
  • Page container

    199
  • Act-key-0 and act-key-N page

    200
  • FPA page

    202
  • DBTT pages

    205
    • DBTT anchor page

      205
    • DBTT page

      207
  • Direct CALC page

    210
  • Indirect CALC page

    213
  • Data page

    215
• Structure of records and tables

  219
  • Structure of records

    219
  • Structure of tables

    224
• Reference section

  233
  • Schema DDL syntax

    236
    • Schema entry

      237
    • Realm entry

      237
    • Record entry

      238
    • Set entry

      243
  • SSL syntax

    248
    • Schema entry

      248
    • Record entry

      249
    • Set entry

      254
  • Subschema DDL syntax

    258
    • IDENTIFICATION DIVISION

      259
    • AREA SECTION

      259
    • RECORD SECTION

      260
    • SET SECTION

      261
• Glossary

  263
  • A

    263
  • B

    266
  • C

    266
  • D

    271
  • E

    277
  • F

    277
  • G

    278
  • H

    278
  • I

    279
  • K

    280
  • L

    281
  • M

    282
  • N

    284
  • O

    284
  • P

    285
  • R

    289
  • S

    292
  • T

    299
  • U

    301
  • V

    303
  • W

    303
• Abbreviations

  305
• Related publications

  309
• Index

  315
  • A

    315
  • B

    315
  • C

    315
  • D

    316
  • E

    318
  • F

    318
  • G

    318
  • H

    318
  • I

    318
  • K

    318
  • L

    319
  • M

    319
  • N

    319
  • O

    319
  • P

    320
  • R

    320
  • S

    321
  • T

    323
  • U

    323
  • V

    323
  • W

    324