Oracle Distributed Systems

BUY THIS BOOK

Safari Books Online

What is this?

Tell a friend

Oracle Distributed Systems

By Charles Dye
April 1999
Pages: 548
ISBN 10: 1-56592-432-0 | ISBN 13: 9781565924321
(Average of 0 Customer Reviews)

This book is OUT OF PRINT, but is available on Safari Books Online.

Book description

This book describes how you can use multiple databases and both Oracle8 and Oracle7 distributed system features to best advantage. It covers design, configuration of SQL*Net/Net8, security, and Oracle's distributed options (advanced replication, snapshots, multi-master replication, updateable snapshots, procedural replication, and conflict resolution). Includes a complete API reference for built-in packages and a diskette with many helpful scripts and utilities.
Full Description

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 site may create multiple copies of the same database to attain horizontal scalability.
A copy of a production database may be created to serve as a development test bed.

In a distributed database environment, data in two or more databases is accessible as if it were in a single database. Usually, the different databases are on different servers, which may be located at the same site or a continent away. Communication between the servers takes place via SQL*Net (for Oracle7) or Net8 (for Oracle8). Distributed database environments offer a number of benefits over single- database systems, including:

Tunability
Platform autonomy
Fault tolerance
Scalability
Location transparency
Site autonomy

This book describes how you can use multiple databases and the distributed features of Oracle to best advantage. It covers: Table of contents: Part I: The Distributed System

Introduction to Distributed Database Systems
SQL*Net and Net8
Configuration and Administration
Distributed Database Security
Designing the Distributed System
Oracle's Distributed System Implementation
Sample Configurations 8. Engineering Considerations

Part II: Replication

Oracle Replication Architecture
Advanced Replication Option Installation
Basic Replication
Multi-Master Replication
Updateable Snapshots
Procedural Replication
Conflict Avoidance and Resolution Techniques

Part III: Appendixes Appendix A: Built-in Packages for Distributed Systems Appendix B: Scripts

Post-purchase benefits:

Browse within this book

Cover | Table of Contents | Index | Sample Chapter | Colophon

Book details

First Edition: April 1999
ISBN: 1-56592-432-0
Pages: 548
Average Customer Reviews: (Based on 0 Reviews)

Featured customer reviews

Oracle Distributed Systems Review, April 12 1999
Submitted by Teresa Shaw [Respond | View]

This is an awesome book. The section on how SQL*Net works is by itself worth the cover price.

Oracle Distributed Systems Review, March 17 1999
Submitted by Stephane Groux [Respond | View]

Excellent Book.
Helps me in my daily job.

Technical Analyst at Oracle Worldwide Support

Read all reviews

Media reviews

"The usefulness of theoretical books tends to wane when work has to be accomplished in a compressed time frame. Oracle Distributed Systems manages to combine a thorough explanation of key concepts with a plethora of lessons learned and best practices distilled. Based on his own experiences, Charles Dye has created a compendium that shows the complete picture -- ranging from Oracle network configuration to conflict resolution strategies to performance tuning. Let this book be your field guide to successfudesign, implementation, and maintenance of a distributed Oracle environment." --Jenny Tsai, Oracle8i Senior Product Manager, Oracle Corporation

Hide extended reviews

Got a Question?