Library
Product
Oracle Rdb7(tm) Distributed Technology
Handbook
Begin
Contents (summary)
Chapter 1
Introduction
Chapter 2
Designing a Distributed Option Configuration
Chapter 3
Setting Up a Distributed Option Physical Database
Chapter 4
Setting Up a Distributed Option Logical Database
Chapter 5
Setting Up a Link Database
Chapter 6
Using Pass-Through Statement Execution
Chapter 7
Using a Distributed Option Logical Database
Chapter 8
Maintaining a Distributed Option Configuration
Chapter 9
Parallel Query Option for Rdb
Appendix A
SQL Language Reference
Appendix B
Starting the DECdtm Transaction Manager on an OpenVMS System
Appendix C
Converting Distributed Option Logical Databases from Version 1.0 to Version 3.1
Appendix D
Converting Oracle-Based Logical Databases from Distributed Option Version 3.1 to Version 7.0
Index
Figures
Tables
Contents
Preface
Send Us Your Comments
Preface
Preface
Chapter 1
Introduction
1.1
Distributed Option Overview
1.1.1
How Distributed Option Works
1.1.2
Overview of Distributed Option Configuration Design
1.2
Overview of Setting Up a Distributed Option Logical Database
1.2.1
Creating the Distributed Option Physical Database
1.2.2
Creating the Distributed Option Logical Database
1.2.3
Creating Links and Proxies
1.2.4
Creating Tables
1.2.5
Creating Views
1.2.6
Creating Horizontally Partitioned Views
1.3
Overview of Maintaining a Distributed Option Configuration
1.3.1
Managing Security in Distributed Option
1.3.2
Maintaining a Distributed Option Logical Database
Chapter 2
Designing a Distributed Option Configuration
2.1
Physical Database Manager Considerations
2.2
Distributed Option Software Resources
2.2.1
Choosing a Location for Distributed Option Software
2.2.2
Choosing a Location for Distributed Option 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 Distributed Option 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
Chapter 3
Setting Up a Distributed Option Physical Database
3.1
Creating the Distributed Option Physical Database Using Rdb
3.2
Creating the Distributed Option Physical Database Using Oracle
3.3
Attaching to the Distributed Option Physical Database
Chapter 4
Setting Up a Distributed Option Logical Database
4.1
Before Creating the Distributed Option Logical Database
4.2
Creating the Distributed Option Logical Database
4.2.1
Creating the Distributed Option Logical Database Using Rdb
4.2.2
Creating the Distributed Option Logical Database Using Oracle
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 Rdb Databases
4.4.4
Handling Multiple Versions of Rdb for OpenVMS
4.4.5
Creating Links to Rdb Transparent 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
Controlling Ordering in Views
4.6.5
Using Partitioning Predicates
4.6.6
Avoiding Nonstandard Data Type Comparisons
Chapter 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 Rdb Link Databases
5.3.1
Handling the Rdb Multiversion Option
5.3.2
Granting DISTRIBTRAN Privilege
5.4
Setting Up Distributed Option Link Databases
5.5
Restructuring a Link Database
Chapter 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
Chapter 7
Using a Distributed Option Logical Database
7.1
Setting Up Your Distributed Option User Environment
7.2
Attaching to a Distributed Option Logical Database
7.2.1
Rdb
7.2.2
Oracle
7.3
Using Remote Access Efficiently
7.4
Attaching to Link Databases
7.5
Using Temporary Proxies
7.6
Obtaining Schema Information
Chapter 8
Maintaining a Distributed Option Configuration
8.1
Managing Security in a Distributed Option Configuration
8.1.1
Managing Security in a Distributed Option Logical Database
8.1.1.1
Understanding the Distributed Option Privilege Model
8.1.1.2
Special Security Considerations
8.1.2
Managing Security in a Link Database
8.2
Maintaining a Distributed Option Logical Database
8.2.1
Altering the Distributed Option Logical Database
8.2.2
Deleting the Distributed Option 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 Distributed Option Logical Database
Chapter 9
Parallel Query Option for Rdb
9.1
When to Use the Parallel Query Option for Rdb
9.2
How the Parallel Query Option for Rdb Works
9.2.1
Catalog Contents
9.2.2
Example
9.3
Parallel Query Option for Rdb Database Environment Setup
9.4
Table and Link Design Considerations
9.4.1
Example
Appendix A
SQL Language Reference
A.1
User Authentication
A.1.1
Authentication on Digital UNIX
A.1.2
Authentication on OpenVMS
A.1.3
Authentication When Accessing Rdb Databases
A.2
SQL Language Overview
A.3
SQL Common Elements for Distributed Option
Command 1
Distributed Option Attach Specification
Command 2
Rdb Transparent Gateway Attach Specification
Command 3
Oracle Rdb Attach Specification
A.4
SQL Statements
Command 4
ALTER DATABASE Statement
Command 5
ALTER LINK Statement
Command 6
ALTER TABLE Statement
Command 7
ATTACH Statement
Command 8
CONNECT Statement
Command 9
CREATE DATABASE Statement
Command 10
CREATE DOMAIN Statement
Command 11
CREATE INDEX Statement, Pass-Through
Command 12
CREATE LINK Statement
Command 13
CREATE TABLE Statement
Command 14
CREATE TABLE Statement, Pass-Through
Command 15
CREATE VIEW Statement
Command 16
CREATE VIEW Statement, Partitioned
Command 17
DECLARE ALIAS Statement
Command 18
DROP DATABASE Statement
Command 19
DROP DOMAIN Statement
Command 20
DROP INDEX Statement, Pass-Through
Command 21
DROP LINK Statement
Command 22
DROP Routine Statement
Command 23
DROP TABLE Statement
Command 24
DROP VIEW Statement
Command 25
GRANT Statement
Command 26
GRANT Statement, Pass-Through
Command 27
INTEGRATE Statement
Command 28
REVOKE Statement
Command 29
REVOKE Statement, Pass-Through
Command 30
SET QUERY LIMIT Statement
Command 31
SHOW ALIASES Statement
Command 32
SHOW DATABASES Statement
Command 33
SHOW LINK Statement
Command 34
SHOW TABLES Statement
Command 35
SHOW VIEWS Statement
Appendix B
Starting the DECdtm Transaction Manager on an OpenVMS System
B.1
Starting the DECdtm Transaction Manager Manually
B.2
Troubleshooting DECdtm Services
Appendix C
Converting Distributed Option Logical Databases from Version 1.0 to Version 3.1
Appendix D
Converting Oracle-Based Logical Databases from Distributed Option Version 3.1 to Version 7.0
D.1
Before Running the Conversion
D.2
Running the Conversion
D.3
After Running the Conversion
Index
Figures
1-1
Distributed Option Logical Database
1-2
Content of a Link
1-3
How Proxies Work
1-4
Horizontally Partitioned View
2-1
Possible Distributed Option Configuration
2-2
Single Versus Multiple Distributed Option Logical Database Configurations
4-1
Statement Execution Using a Horizontally Partitioned View
8-1
Distributed Option Privilege Model
Tables
A-1
SQL Statements Used for Creating and Maintaining a Distributed Option Logical Database
A-2
SQL Statements Not Supported by Distributed Option
A-3
Gateway to DB2 Attach Specification Qualifiers
A-4
Nonrelational Gateways Attach Specification Qualifiers
A-5
Gateway to Oracle Attach Specification Qualifiers
A-6
PC Data Attach Specification Qualifiers
A-7
Gateway to Sybase Attach Specification Qualifiers
Next
