CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      DEC Rdb Overview
    1.1 Understanding Relational Database Concepts
      1.1.1      Tables, Rows, and Columns
      1.1.2      Domains
      1.1.3      Primary Keys
      1.1.4      Foreign Keys
      1.1.5      Combining Data from Different Tables
      1.1.6      Views
      1.1.7      Storage of Metadata
      1.1.8      Schemas
      1.1.9      Transactions
      1.1.10     Indexes
    1.2 DEC Rdb Features
      1.2.1      Ease of Use
      1.2.2      Data Integrity and Consistency
      1.2.3      Data Security
      1.2.4      High Availability and Multiuser Access
      1.2.5      Flexibility in Location of Data
      1.2.6      Speedy Access to Data
      1.2.7      Centralized Database Management
    1.3 Files in a DEC Rdb Database
    1.4 Accessing DEC Rdb Using SQL
      1.4.1      Interactive SQL
      1.4.2      SQL Module Language
      1.4.3      Precompiled SQL
      1.4.4      Dynamic SQL
        1.4.4.1      Sample Programs
    1.5 Accessing DEC Rdb Using RDO, RDML, and RDBPRE
    1.6 Accessing DEC Rdb from Platforms Other Than OpenVMS Using SQL/Services
    1.7 Maintaining and Tuning DEC Rdb Databases with RMU
    1.8 DEC Rdb Product Licenses
    1.9 Using DEC Rdb with Other Digital Products
      1.9.1      Products That Provide Access to DEC Rdb Databases
      1.9.2      Products That Improve the Performance of DEC Rdb Databases
      1.9.3      Products That Provide Access to Other Databases and Files
      1.9.4      Products That Provide Database Integration
      1.9.5      Other Products Related to DEC Rdb

  2      Getting Started with SQL
    2.1 Invoking and Exiting Interactive SQL
    2.2 Using Online Help for DEC Rdb
    2.3 Creating the Sample Database
    2.4 Using Interactive SQL
      2.4.1      Attaching to the Sample Database
      2.4.2      Displaying Information About the Sample Database
      2.4.3      Ending Interactive SQL Statements
      2.4.4      Retrieving Data Using SQL SELECT Statements
      2.4.5      Joining Data from Multiple Tables
      2.4.6      Isolating Unique Values
      2.4.7      Inserting Data into the Sample Database
      2.4.8      Updating Data in the Sample Database
      2.4.9      Using Cursors
      2.4.10     Deleting Data from the Sample Database
      2.4.11     Committing or Rolling Back Changes to the Database
    2.5 Using SQL Statements in Programs
      2.5.1      Using SQL Module Language
      2.5.2      Using Precompiled SQL
      2.5.3      Using Dynamic SQL
    2.6 Using the SQL Online Program Examples

  3      Creating, Loading, and Maintaining DEC Rdb Databases
    3.1 Designing a Relational Database
      3.1.1      Analyzing Requirements for the Database
      3.1.2      Developing the Conceptual Design
      3.1.3      Developing the Logical Design
      3.1.4      Developing the Physical Design
      3.1.5      Implementing the Database
    3.2 Creating a Database Using SQL
      3.2.1      Creating a Data Dictionary and Directories
      3.2.2      Defining Logical Names for the Database Files
      3.2.3      Creating the Physical Database
      3.2.4      Creating Domains
      3.2.5      Creating Tables
      3.2.6      Assigning Tables and Indexes to Storage Areas
      3.2.7      Creating More Sorted Indexes
      3.2.8      Creating Triggers
    3.3 Journaling Database Updates
    3.4 Loading Data into a Database
      3.4.1      Loading Data Using the SQL Module Processor
      3.4.2      Loading Data Using the RMU/LOAD Command
    3.5 Modifying DEC Rdb Databases
    3.6 Maintaining DEC Rdb Databases
      3.6.1      Saving Copies of Your Database
      3.6.2      Restoring Your Database
      3.6.3      Moving Databases and Database Files
      3.6.4      Copying a Database

  A Summary of DEC Rdb Documentation
    A.1 Documentation Descriptions
      A.1.1      General Interest to DEC Rdb Users
      A.1.2      Database Administration
      A.1.3      System Administration
      A.1.4      Database Development and Programming
      A.1.5      Client/Server Application Programming
      A.1.6      Release Notes
      A.1.7      Other Books Available
    A.2 Ordering DEC Rdb Documentation
    A.3 How to Order Additional Documentation