CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Introduction
    1.1 Understanding Database Management Systems
    1.2 Defining a Database
      1.2.1      Schema
      1.2.2      Storage Schema
      1.2.3      Subschema
      1.2.4      Security Schema
    1.3 Understanding the DEC DBMS Data Model
      1.3.1      Database Records
      1.3.2      Database Sets
    1.4 Using a Database
      1.4.1      Database Administration
      1.4.2      Application Programming
      1.4.3      System Management and Operations
      1.4.4      Database Security
    1.5 Full Development and Run-Time Only Functionality
    1.6 DEC DBMS Documentation Set

  2      Developing a Database
    2.1 Setting Up a Database
      2.1.1      Writing the Schema
        2.1.1.1      Schema Definitions
        2.1.1.2      Area Definitions
        2.1.1.3      Record Definitions
        2.1.1.4      Set Definitions
      2.1.2      Compiling the Schema
      2.1.3      Creating the Database
      2.1.4      Loading the Database
    2.2 Creating the PARTS Database

  3      Accessing a Database
    3.1 Understanding Data Structures and Access Methods
      3.1.1      Data Structures
      3.1.2      Access Methods
    3.2 Using Data Manipulation Language Statements
    3.3 Accessing a Database Interactively
    3.4 Accessing a Database Through a Program

  4      Maintaining a Database
    4.1 Monitoring a Database
    4.2 Maintaining a Database
    4.3 Enhancing Database Performance
    4.4 Modifying an Existing Database
      4.4.1      Data-Independent Changes
      4.4.2      Physical Changes to the Database Characteristics
      4.4.3      Data-Dependent Changes

  5      Using LSE with DEC DBMS
    5.1 Using LSE
    5.2 Entering Source Code Using Tokens and Placeholders
    5.3 Examples
      5.3.1      Writing DDL Files
      5.3.2      Writing LFL Files
      5.3.3      Writing LSL Files
      5.3.4      Writing DBQ Files
    5.4 Compiling DDL Source Code Within LSE

  Glossary
    access control list (ACL) . . . audit reporting
      AUTOMATIC member . . . CDO dictionary
      character string . . . consistency
      currency indicators . . . Database Query (DBQ) utility
      database recovery (DBR) process . . . DBMS
      DBO Commands . . . dictionary directory
      dictionary object . . . file specification
      file type . . . INSERTION class
      Installation Verification Procedure (IVP) . . . line index
      linker . . . member record
      metadata . . . PLACEMENT mode
      pointer . . . record stream
      record type . . . Run-Time User Process Block (RTUPB)
      run unit . . . set type
      shadow clustering . . . stream
      subdirectory . . . unload sequence language (USL)
      usage mode . . . VMScluster

  A DEC DBMS Master Index