Oracle Distributed Systems

Name: Oracle Distributed Systems
Price: 5.3 USD
Availability: InStock
ISBN: 9781565924321

ISBN-10: 1565924320

ISBN-13: 9781565924321

Edition: 1999

Authors: Charles Dye, Debby Russell

List price: $39.95

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $5.30

what's this?

Rush Rewards U
Members Receive:

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…

Book details

List price: $39.95
Copyright year: 1999
Publisher: O'Reilly Media, Incorporated
Publication date: 4/20/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