Oracle7 Server Distributed Systems Manual, Vol. 1

Library

Product

---

• Oracle7(tm) Server Distributed Systems, Volume I: Distributed Data

• Preface
  • How Oracle7 Server Distributed Systems, Volume I is Organized
  • Your Comments Are Welcome

• Understanding Distributed Systems
  • Introduction
  • The Client-Server Model and Distributed Systems
  • The Components of the Client-Server Model
  • What is the Client-Server Model?
  • Benefits of the Client-Server Model
  • Server-to-Server Communication
  • Oracle7 Server and the Client-Server Model
  • Server Configurations
  • The Database Server
  • Front-End Client Applications
  • Back-End Services
  • Network Issues in a Client-Server System
  • Introduction to Distributed Systems
  • Concepts and Terminology
  • SQL Statement Execution in a Distributed System

• Network Administration
  • Oracle's Network Products
  • Oracle Network Products and Distributed Systems
  • SQL*Net and Network Environment Independence
  • The MultiProtocol Interchange
  • SQL*Net Version 2 Architecture
  • SQL*Net Operations
  • How SQL*Net Establishes Connections to a Prespawned Dedicated Server
  • How SQL*Net Establishes Connections to a Multi-Threaded Server
  • Global Naming Issues
  • Database Links
  • Network Issues to Consider When Implementing a Distributed Database System

• Network Administration Utilities
  • SQL*Net's Administration Utilities
  • Network Manager
  • Using Network Manager to Configure Your Network
  • Distributing Configuration Files
  • Testing your Configuration
  • Initiating a SQL*Net Connection

• Database Administration
  • Implementing Databases in a Distributed System
  • Views and Location Transparency
  • Synonyms
  • Replication Transparency
  • Procedures and Location Transparency
  • Query and Update Transparency
  • Transaction Transparency and Distributed Transaction Management
  • Failure Resolution Transparency and the RECO Background Process
  • Performance Transparency
  • Object Resolution and Location Transparency
  • Schema Object Names and Data Access
  • Balancing Location Transparency and Security
  • Public and Private Database Links
  • Database Links and Oracle Transparent Gateways
  • Tools for Managing and Monitoring the Database
  • Connecting Between Oracle Server Versions

• Distributed Updates
  • Updates in a Distributed Environment
  • The Distributed Transaction Management Mechanism
  • The Prepare and Commit Phases
  • The Session Tree
  • A Case Study
  • Coordination of System Change Numbers
  • Read-Only Distributed Transactions
  • Limiting the Number of Distributed Transactions Per Node
  • Troubleshooting Distributed Update Problems
  • Manually Overriding In-Doubt Transactions
  • Manually Committing In-Doubt Transactions
  • Changing Connection Hold Time
  • Setting a Limit on Distributed Transactions
  • Testing Distributed Transaction Recovery Features

• Security Issues
  • Some Terms Related to Network Security
  • Introduction to Network Security
  • Security During Connection Establishment
  • Password Protection and Encryption
  • Oracle Secure Network Services
  • Transparent Gateway Security
  • Authentication Services Provide Enhanced Security
  • Database Security in a Distributed System

• Application Development
  • Development Tools
  • Factors Affecting the Distribution of an Application's Data
  • Naming Objects
  • Controlling Connections Established by Database Links
  • Referential Integrity in a Distributed System
  • Distributed Queries
  • Handling Errors in Remote Procedures
  • XA Library-Related Information
  • Developing and Installing Applications that Use the XA Libraries
  • Defining the Open String
  • Interfacing to Precompilers and OCIs
  • Transaction Control
  • Migrating Precompiler or OCI Applications to TPM Applications
  • XA Library Thread Safety
  • Troubleshooting
  • Restrictions

• Operating System Dependencies
  • General
  • Networking
  • Database Administration
  • Transaction Recovery Management
  • XA Library

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product