Skip to content

Oracle Distributed Systems

Spend $50 to get a free DVD!

ISBN-10: 1565924320

ISBN-13: 9781565924321

Edition: 1999

Authors: Charles Dye, Debby Russell

List price: $39.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Any organization that uses the Oracle relational database management system (RDBMS) these days needs to use multiple databases. There are many reasons to use more than a single database in a distributed database system: Different databases may be associated with particular business functions, such as manufacturing or human resources. Databases may be aligned with geographical boundaries, such as a behemoth database at a headquarters site and smaller databases at regional offices. Two different databases may be required to access the same data in different ways, such as an order entry database whose transactions are aggregated and analyzed in a data warehouse. A busy Internet commerce…    
Customers also bought

Book details

List price: $39.95
Copyright year: 1999
Publisher: O'Reilly Media, Incorporated
Publication date: 4/11/1999
Binding: Paperback
Pages: 552
Size: 7.25" wide x 9.25" long x 1.25" tall
Weight: 1.980
Language: English

Charles Dye is the database architect for Excite, Inc. (www.excite.com), where he is responsible for the design and implementation of the databases theat supply content to some of the world's busiest Web sites. Prior to joining Excite, he was the senior database administrator for The Dialog Corporation. Charles also operates a small but growing consultancy with clients in the San Francisco Bay area and Hong Kong. Once upon a time, before fleeing the East Coast for California skies, Charles taught math and physics at the Georgetown Day School in Washington DC. Charles is a frequent speaker at regional and national Oracle events such as Oracle Open World and IOUG-A Live. His favorite topics…    

Preface
The Distributed System
Introduction to Distributed Systems
Terminology and Concepts
What Is a Distributed Database System?
Benefits of Distributed Databases
Multiple Schema Versus Multiple Databases
Options for Distributed Data
Perils of Distributed Databases
Differences Between Oracle7 and Oracle8
SQL*Net and Net8
Protocol Overview
Architecture
SQL*Net/Net8 Tuning
Load Balancing
Oracle8 Scalability Options
SQL*Net/Net8 Client Configuration
SNMP Support
Security
Configuration and Administration
Initialization Parameters
Database Links
Distributed Queries and Transactions
Distributed Backup and Recovery
Multiversion Interoperability
Distributed Database Security
Privilege Management
Authentication Methods
Designing a Distributed System
Characteristics of a Distributed System
The Global Data Dictionary
Replication-Specific Issues
Data Partitioning Methodologies
Application Partitioning Strategies
Procedural Replication
Oracle's Distributed System Implementation
Meeting the 12 Objectives with Oracle
Oracle's Global Data Dictionary
Sample Configurations
The High-Availability System
Geographic Data Distribution
Workflow Partitioning
Data Collection and Consolidation
Loosely Coupled Federation
Engineering Considerations
Schema Design and Integration
Application Tiering
Designing a Replicated System
Replication
Oracle Replication Architecture
What Is Oracle Replication?
Types of Replication
Architecture Components
Replication of DDL
Oracle8 Enhancements
Oracle8i Enhancements
Alternatives to Replication
Advanced Replication Installation
Initialization Parameters
Redo Logs and Rollback Segments
Size and Placement of Data Dictionary Objects
Administrative Accounts, Privileges, and Database Links
Basic Replication
About Read-Only Snapshots
Prerequisites and Restrictions
Snapshot Creation Basics
Simple Versus Complex Snapshots
Snapshots Logs
Subquery Subsetting
Refresh Groups
Management and Optimization
Scripts
Multi-Master Replication
Concepts and Terminology
Getting Started
Replication Groups
Master Site Maintenance and Propagation
Controlling Propagation
The Replication Catalog
Table Replication
Replicating DDL
Your Replicated Environment
Advanced Replication Limitations
Updateable Snapshots
About Updateable Snapshots
Creating Updateable Snapshots
Communication Flow
Controlling Propagation and Refreshes
Maintenance
Procedural Replication
When to Use Procedural Replication
How Procedural Replication Works
Creating a Replicated Package Procedure
Restrictions on Procedural Replication
An Example
Conflict Avoidance and Resolution Techniques
Data Integrity Versus Data Convergence
Applications That Avoid Conflicts
Types of Conflicts Detected
How Oracle Detects and Resolves Conflicts
Column Groups and Priority Groups
The Built-in Methods
Writing Your Own Conflict Resolution Handler
Appendixes
Built-in Packages for Distributed Systems
Scripts and Utilities
Index