CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Introduction

  1.1     Understanding Database Management Systems

  1.2     Understanding the VAX DBMS Data Model
    1.2.1      Database Records
    1.2.2      Database Sets

  1.3     Defining a Database
    1.3.1      Schema
    1.3.2      Storage Schema
    1.3.3      Subschema
    1.3.4      Security Schema

  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     VAX 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.2     Loading the Database

  2.3     Creating the Sample 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

  A   Using LSE with VAX DBMS

  A.1     Using LSE

  A.2     Entering Source Code Using Tokens and Placeholders

  A.3     Examples
    A.3.1      Writing DDL Files
    A.3.2      Writing LFL Files
    A.3.3      Writing LSL Files
    A.3.4      Writing DBQ Files

  A.4     Compiling DDL Source Code Within LSE

  Glossary

  EXAMPLES

  1-1        Data Items in a Record Occurrence

  1-2        Second VENDOR Record Occurrence

  3-1        LIST_PARTS Pascal Module

  3-2        DISPLAY_PART Pascal Module

  4-1        Monitor Log File Entry

  4-2        SHOW SYSTEM Example

  4-3        SHOW USERS Example

  4-4        I/O Statistics Example

  FIGURES

  1-1        Data Items in a Record Type

  1-2        Relationships Among Owner and Members in a Set Type

  1-3        The FAMILY_INFORMATION Set Occurrence

  1-4        VAX DBMS Version 4.1 Documentation Map

  2-1        Creating a Database

  TABLES

  A-1        LSEDIT Commands

  A-2        LSE Commands