Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | October 21, 2014

    Katha Pollitt: IMG My Bookstore Fantasy — No Customers Necessary



    "Let's open a bookstore," I say to my husband every now and then. "A used bookstore. With a few new books we really like." I'm picturing an... Continue »

    spacer
Qualifying orders ship free.
$5.95
Used Mass Market
Usually ships in 5 to 7 business days
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
1 Remote Warehouse Software Engineering- Programming and Languages

Oracle Distributed Systems with 3.5 Disk

by

Oracle Distributed Systems with 3.5 Disk Cover

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

This book describes how you can use multiple databases and the distributed system features of Oracle to best advantage. It covers design, configuration of SQLxNet (or Net8 for Oracle8), security, and the details of Oracle's distributed options (advanced replication, snapshots, multi-master replication, updatable snapshots, procedural replication, and conflict resolution). Comes with a complete API reference for built-in packages and a diskette containing many scripts for database administrators.

Synopsis:

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 SQLNet (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: AppendixesAppendix A: Built-in Packages for Distributed Systems Appendix B: Scripts

    About the Author

    tion. 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 are distributed databases in general and advanced replication in particular. He also writes for the Northern California Oracle Users Group newsletter and is an active contributor to the Oracle Internet list server. Look for Charles' upcoming O'Reilly book, Oracle Distributed Systems, available later in 1998. Charles lives in Los Altos, California, with his wife Kathy, daughter Natalie, and labrador Jed. You can email him at cdye@excite.com.

    Table of Contents

    Preface; Audience for This Book; About Replication; About Oracle Versions and Platforms; Structure of This Book; Conventions Used in This Book; About the Scripts; Comments and Questions; Acknowledgments; The Distributed System; Chapter 1: Introduction to Distributed Systems; 1.1 Terminology and Concepts; 1.2 What Is a Distributed Database System?; 1.3 Benefits of Distributed Databases; 1.4 Multiple Schema Versus Multiple Databases; 1.5 Options for Distributed Data; 1.6 Perils of Distributed Databases; 1.7 Differences Between Oracle7 and Oracle8; Chapter 2: SQL*Net and Net8; 2.1 Protocol Overview; 2.2 Architecture; 2.3 SQL*Net/Net8 Tuning; 2.4 Load Balancing; 2.5 Oracle8 Scalability Options; 2.6 SQL*Net/Net8 Client Configuration; 2.7 SNMP Support; 2.8 Security; Chapter 3: Configuration and Administration; 3.1 Initialization Parameters; 3.2 Database Links; 3.3 Distributed Queries and Transactions; 3.4 Distributed Backup and Recovery; 3.5 Multiversion Interoperability; Chapter 4: Distributed Database Security; 4.1 Privilege Management; 4.2 Authentication Methods; Chapter 5: Designing a Distributed System; 5.1 Characteristics of a Distributed System; 5.2 The Global Data Dictionary; 5.3 Replication-Specific Issues; 5.4 Data Partitioning Methodologies; 5.5 Application Partitioning Strategies; 5.6 Procedural Replication; Chapter 6: Oracle's Distributed System Implementation; 6.1 Meeting the 12 Objectives with Oracle; 6.2 Oracle's Global Data Dictionary; Chapter 7: Sample Configurations; 7.1 The High-Availability System; 7.2 Geographic Data Distribution; 7.3 Workflow Partitioning; 7.4 Data Collection and Consolidation; 7.5 Loosely Coupled Federation; Chapter 8: Engineering Considerations; 8.1 Schema Design and Integration; 8.2 Application Tiering; 8.3 Designing a Replicated System; Replication; Chapter 9: Oracle Replication Architecture; 9.1 What Is Oracle Replication?; 9.2 Types of Replication; 9.3 Architecture Components; 9.4 Replication of DDL; 9.5 Oracle8 Enhancements; 9.6 Oracle8i Enhancements; 9.7 Alternatives to Replication; Chapter 10: Advanced Replication Installation; 10.1 Initialization Parameters; 10.2 Redo Logs and Rollback Segments; 10.3 Size and Placement of Data Dictionary Objects; 10.4 Administrative Accounts, Privileges, and Database Links; Chapter 11: Basic Replication; 11.1 About Read-Only Snapshots; 11.2 Prerequisites and Restrictions; 11.3 Snapshot Creation Basics; 11.4 Simple Versus Complex Snapshots; 11.5 Snapshot Logs; 11.6 Subquery Subsetting; 11.7 Refresh Groups; 11.8 Management and Optimization; 11.9 Scripts; Chapter 12: Multi-Master Replication; 12.1 Concepts and Terminology; 12.2 Getting Started; 12.3 Replication Groups; 12.4 Master Site Maintenance and Propagation; 12.5 Controlling Propagation; 12.6 The Replication Catalog; 12.7 Table Replication; 12.8 Replicating DDL; 12.9 Your Replicated Environment; 12.10 Advanced Replication Limitations; Chapter 13: Updateable Snapshots; 13.1 About Updateable Snapshots; 13.2 Creating Updateable Snapshots; 13.3 Communication Flow; 13.4 Controlling Propagation and Refreshes; 13.5 Maintenance; Chapter 14: Procedural Replication; 14.1 When to Use Procedural Replication; 14.2 How Procedural Replication Works; 14.3 Creating a Replicated Package Procedure; 14.4 Restrictions on Procedural Replication; 14.5 An Example; Chapter 15: Conflict Avoidance and Resolution Techniques; 15.1 Data Integrity Versus Data Convergence; 15.2 Applications That Avoid Conflicts; 15.3 Types of Conflicts Detected; 15.4 How Oracle Detects and Resolves Conflicts; 15.5 Column Groups and Priority Groups; 15.6 The Built-in Methods; 15.7 Writing Your Own Conflict Resolution Handler; Appendixes; Built-in Packages for Distributed Systems; DBMS_DEFER: Building Deferred Calls; DBMS_DEFER_QUERY: Performing Diagnostics and Maintenance; DBMS_DEFER_SYS: Managing Deferred Transactions; DBMS_OFFLINE_OG: Performing Site Instantiation; DBMS_OFFLINE_SNAPSHOT: Performing Offline Snapshot Instantiation; DBMS_RECTIFIER_DIFF: Comparing Replicated Tables; DBMS_REFRESH: Managing Snapshot Groups; DBMS_REPCAT: Performing Replication Administration; DBMS_REPCAT_ADMIN: Setting Up Administrative Accounts; DBMS_REPCAT_AUTH: Setting Up More Administrative Accounts; DBMS_REPUTIL: Enabling and Disabling Replication; DBMS_SNAPSHOT: Managing Snapshots; Scripts and Utilities; busycirc.sql; busydisp.sql; busyq.sql; checklatency; colgroups.sql; confstats.sql; cr_regions.sql; defcall.sql; defcalldest.sql; defcallinfo.sql; defdest.sql; deferror.sql; deferror8.sql; deforigin.sql; defschedule.sql; deftran.sql; deftrandest.sql; disprate.sql; errorinfo.sql; fixdefer.sql; gendelerrtran.sql; gendeltran.sql; gengensup.sql; groupedcols.sql; invalids.sql; jobs.sql; keycols.sql; lastsnap.sql; latent.sql; links.sql; mastersnapinfo.sql; mlogs.sql; needsgen.sql; nonrepobjects.sql; pk_regions.sql; prioritygroups.sql; prioritysites.sql; propmode.sql; refgroups.sql; regsnaps.sql; repcaterr.sql; repcatlog.sql; repconflict.sql; repgroup.sql; repobjects.sql; repres.sql; repsites.sql; resconfs.sql; snaps.sql; snaps7.sql; trg_regions.sql; UserAdmin; Colophon;

    Product Details

    ISBN:
    9781565924321
    Editor:
    Russell, Deorah
    Editor:
    Russell, Deborah
    Author:
    Dye, Charles
    Author:
    Russell, Deborah
    Publisher:
    O'Reilly Media
    Location:
    Beijing
    Subject:
    Programming - General
    Subject:
    Data processing
    Subject:
    Computers
    Subject:
    Database Management - General
    Subject:
    Electronic data processing
    Subject:
    Relational databases
    Subject:
    Computer software
    Subject:
    Database Management - Oracle
    Subject:
    Oracle (computer system)
    Subject:
    Distributed processing
    Subject:
    Distributed databases
    Subject:
    Oracle (Computer file)
    Subject:
    Oracle
    Subject:
    SQL/ORACLE
    Subject:
    Microcomputer Programming
    Subject:
    Computer Books: Database
    Subject:
    PL/SQL (Computer program langu
    Subject:
    Database Engineering
    Subject:
    Books; Computers & Internet; Networking & OS; Data in the Enterprise; Client-Server Systems
    Subject:
    Books; Computers & Internet; Networking & OS; Data in the Enterprise; Distributed Computing
    Subject:
    Books; Computers & Internet; Networking & OS; Data in the Enterprise; Distributed Databases
    Subject:
    Net8;Oracle;SQL
    Edition Number:
    1st ed.
    Edition Description:
    Print PDF
    Series:
    O'Reilly Oracle
    Publication Date:
    19990411
    Binding:
    Paperback
    Language:
    English
    Illustrations:
    Yes
    Pages:
    552
    Dimensions:
    25 cm. +

    Other books you might like

    1. Oracle8i Internal Services for... Used Trade Paper $1.00
    2. Oracle Performance Tuning, 2nd... New Trade Paper $79.99

    Related Subjects

    Computers and Internet » Database » Applications
    Computers and Internet » Software Engineering » Programming and Languages

    Oracle Distributed Systems with 3.5 Disk Used Mass Market
    0 stars - 0 reviews
    $5.95 In Stock
    Product details 552 pages O'Reilly & Associates Inc. - English 9781565924321 Reviews:
    "Synopsis" by , This book describes how you can use multiple databases and the distributed system features of Oracle to best advantage. It covers design, configuration of SQLxNet (or Net8 for Oracle8), security, and the details of Oracle's distributed options (advanced replication, snapshots, multi-master replication, updatable snapshots, procedural replication, and conflict resolution). Comes with a complete API reference for built-in packages and a diskette containing many scripts for database administrators.
    "Synopsis" by ,

    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 SQLNet (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: AppendixesAppendix A: Built-in Packages for Distributed Systems Appendix B: Scripts

    spacer
    spacer
    • back to top

    FOLLOW US ON...

         
    Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.