CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      Introduction
    1.1 DEC DB Integrator Overview
    1.2 How DBI Works
    1.3 Overview of DBI Configuration Design
    1.4 Overview of Setting Up a DBI Logical Database
      1.4.1      Creating the DBI Physical Database
      1.4.2      Creating the DBI Logical Database
      1.4.3      Creating Links and Proxies
      1.4.4      Creating Tables
      1.4.5      Creating Views
      1.4.6      Creating Horizontally Partitioned Views
      1.4.7      Executing Pass-Through Statements
    1.5 Overview of Maintaining a DBI Configuration
      1.5.1      Managing Security in DBI
      1.5.2      Maintaining a DBI Logical Database

  2      Designing a DBI Configuration
    2.1 Physical Database Manager Considerations
    2.2 DBI Software Resources
      2.2.1      Choosing a Location for DBI Software
      2.2.2      Choosing a Location for DBI Logical Databases
      2.2.3      Determining Disk Space Requirements
    2.3 Multiple Levels of Database Integration
      2.3.1      Using Modular Design
      2.3.2      Using Query Optimization
      2.3.3      Security Partitioning
        2.3.3.1      Partitioning Access to the DBI Configuration
        2.3.3.2      Partitioning Access to Data Stored in Link Databases
    2.4 Parallel Processing Considerations
      2.4.1      Partitioning Very Large Databases
      2.4.2      Partitioning Multiple Heterogeneous Databases

  3      Setting Up a DBI Physical Database
    3.1 Creating the DBI Physical Database Using DEC Rdb
    3.2 Creating the DBI Physical Database Using ORACLE
    3.3 Creating the DBI Physical Database Using SYBASE
    3.4 Attaching to the DBI Physical Database

  4      Setting Up a DBI Logical Database
    4.1 Before Creating the DBI Logical Database
    4.2 Creating the DBI Logical Database
      4.2.1      Creating the DBI Logical Database Using DEC Rdb
      4.2.2      Creating the DBI Logical Database Using ORACLE
      4.2.3      Creating the DBI Logical Database Using SYBASE
    4.3 Granting Privileges
    4.4 Creating Links
      4.4.1      Specifying Database Locations in Links
      4.4.2      Forcing a Login When Attaching
      4.4.3      Creating Links to DEC Rdb Databases
      4.4.4      Handling Multiple Versions of DEC Rdb for OpenVMS
      4.4.5      Creating Links to DBI Gateway Databases
      4.4.6      Creating Links to Databases That Do Not Support DECdtm Services
      4.4.7      Creating Proxies
      4.4.8      Using Logical Names in Links
      4.4.9      Using Configuration Files to Create Links
      4.4.10     Storing Security Information in Links and Proxies
      4.4.11     Using the SHOW LINK Statement
    4.5 Creating Tables by Importing Metadata
    4.6 Creating Views
      4.6.1      Creating Nonpartitioned Views
      4.6.2      Using Translation Tables in Views
      4.6.3      Creating Horizontally Partitioned Views
      4.6.4      Using Partitioning Predicates
      4.6.5      Avoiding Nonstandard Data Type Comparisons

  5      Setting Up a Link Database
    5.1 Ensuring That the DECdtm Transaction Manager Is Running
    5.2 Granting Privileges to Users
    5.3 Setting Up DEC Rdb Link Databases
      5.3.1      Handling the DEC Rdb Multiversion Option
      5.3.2      Granting DISTRIBTRAN Privilege
    5.4 Setting Up DBI Link Databases
    5.5 Restructuring a Link Database

  6      Using Pass-Through Statement Execution
    6.1 Setting the Default Link
    6.2 Making Pass-Through Object Distinctions
    6.3 Pass-Through Table Creation Using the TABLES Qualifier
    6.4 Performing Pass-Through Operations in Non-DECdtm Databases

  7      Using a DBI Logical Database
    7.1 Setting Up Your DBI User Environment
    7.2 Attaching to a DBI Logical Database
      7.2.1      DEC Rdb
      7.2.2      ORACLE
      7.2.3      SYBASE
    7.3 Using Remote Access Efficiently
    7.4 Attaching to Link Databases
    7.5 Using Temporary Proxies
    7.6 Obtaining Schema Information

  8      Maintaining a DBI Configuration
    8.1 Managing Security in a DBI Configuration
      8.1.1      Managing Security in a DBI Logical Database
        8.1.1.1      Understanding the DBI Privilege Model
        8.1.1.2      Special Security Considerations
      8.1.2      Managing Security in a Link Database
    8.2 Maintaining a DBI Logical Database
      8.2.1      Altering the DBI Logical Database
      8.2.2      Deleting the DBI Logical Database
      8.2.3      Maintaining Links
      8.2.4      Maintaining Proxies
      8.2.5      Maintaining Tables
      8.2.6      Maintaining Views
    8.3 Understanding the Effects of Using Data Definition Language
      8.3.1      Other Users Attempt Data Definition Operations
      8.3.2      Other Users Attempt Data Manipulation Operations
      8.3.3      When Data Definition Operations Fail
    8.4 Replicating a DBI Logical Database

  A SQL Language Reference
    A.1 User Authentication
      A.1.1      Authentication on DEC OSF/1
      A.1.2      Authentication on OpenVMS
      A.1.3      Authentication When Accessing DEC Rdb Databases
    A.2 SQL Language Overview
    A.3 SQL Common Elements for DBI

  DBI Attach Specification

  DBI Gateway Attach Specification

  DEC Rdb Attach Specification
    A.4 SQL Statements
    A.5 Viewing Extensions

  ALTER DATABASE Statement

  ALTER LINK Statement

  ALTER TABLE Statement

  ATTACH Statement

  CONNECT Statement

  CREATE DATABASE Statement

  CREATE DOMAIN Statement

  CREATE INDEX Statement, Pass-Through

  CREATE LINK Statement

  CREATE TABLE Statement

  CREATE TABLE Statement, Pass-Through

  CREATE VIEW Statement

  CREATE VIEW Statement, Partitioned

  DECLARE ALIAS Statement

  DROP DATABASE Statement

  DROP DOMAIN Statement

  DROP INDEX Statement, Pass-Through

  DROP LINK Statement

  DROP TABLE Statement

  DROP VIEW Statement

  GRANT Statement

  GRANT Statement, Pass-Through

  INTEGRATE Statement

  REVOKE Statement

  REVOKE Statement, Pass-Through

  SET QUERY LIMIT Statement

  SHOW ALIASES Statement

  SHOW DATABASES Statement

  SHOW LINK Statement

  SHOW TABLES Statement

  SHOW VIEWS Statement

  B Starting the DECdtm Transaction Manager on an OpenVMS System
    B.1 Starting the DECdtm Transaction Manager Manually
    B.2 Troubleshooting DECdtm Services

  C Converting DBI Logical Databases from Version 1.0 to Version 3.1