Oracle Distributed Systems
by Dye, CharlesFormat: Paperback
Pub. Date: 1999-04-01
Publisher(s): Oreilly & Associates Inc
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $41.95
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
This book describes how you can use multiple databases and the distributed system features of Oracle to best advantage. It covers design, configuration of SQL*Net (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.
Author Biography
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 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 | p. ix |
| The Distributed System | p. 1 |
| Introduction to Distributed Systems | p. 3 |
| Terminology and Concepts | p. 4 |
| What Is a Distributed Database System? | p. 7 |
| Benefits of Distributed Databases | p. 8 |
| Multiple Schema Versus Multiple Databases | p. 10 |
| Options for Distributed Data | p. 12 |
| Perils of Distributed Databases | p. 19 |
| Differences Between Oracle7 and Oracle8 | p. 21 |
| SQL*Net and Net8 | p. 24 |
| Protocol Overview | p. 24 |
| Architecture | p. 25 |
| SQL*Net/Net8 Tuning | p. 36 |
| Load Balancing | p. 44 |
| Oracle8 Scalability Options | p. 48 |
| SQL*Net/Net8 Client Configuration | p. 53 |
| SNMP Support | p. 56 |
| Security | p. 57 |
| Configuration and Administration | p. 59 |
| Initialization Parameters | p. 59 |
| Database Links | p. 67 |
| Distributed Queries and Transactions | p. 80 |
| Distributed Backup and Recovery | p. 88 |
| Multiversion Interoperability | p. 89 |
| Distributed Database Security | p. 91 |
| Privilege Management | p. 91 |
| Authentication Methods | p. 100 |
| Designing a Distributed System | p. 111 |
| Characteristics of a Distributed System | p. 111 |
| The Global Data Dictionary | p. 119 |
| Replication-Specific Issues | p. 123 |
| Data Partitioning Methodologies | p. 126 |
| Application Partitioning Strategies | p. 136 |
| Procedural Replication | p. 142 |
| Oracle's Distributed System Implementation | p. 143 |
| Meeting the 12 Objectives with Oracle | p. 143 |
| Oracle's Global Data Dictionary | p. 152 |
| Sample Configurations | p. 155 |
| The High-Availability System | p. 155 |
| Geographic Data Distribution | p. 162 |
| Workflow Partitioning | p. 164 |
| Data Collection and Consolidation | p. 165 |
| Loosely Coupled Federation | p. 167 |
| Engineering Considerations | p. 169 |
| Schema Design and Integration | p. 169 |
| Application Tiering | p. 176 |
| Designing a Replicated System | p. 177 |
| Replication | p. 187 |
| Oracle Replication Architecture | p. 189 |
| What Is Oracle Replication? | p. 189 |
| Types of Replication | p. 190 |
| Architecture Components | p. 191 |
| Replication of DDL | p. 212 |
| Oracle8 Enhancements | p. 212 |
| Oracle8i Enhancements | p. 213 |
| Alternatives to Replication | p. 214 |
| Advanced Replication Installation | p. 216 |
| Initialization Parameters | p. 216 |
| Redo Logs and Rollback Segments | p. 218 |
| Size and Placement of Data Dictionary Objects | p. 219 |
| Administrative Accounts, Privileges, and Database Links | p. 220 |
| Basic Replication | p. 228 |
| About Read-Only Snapshots | p. 228 |
| Prerequisites and Restrictions | p. 229 |
| Snapshot Creation Basics | p. 231 |
| Simple Versus Complex Snapshots | p. 234 |
| Snapshots Logs | p. 235 |
| Subquery Subsetting | p. 236 |
| Refresh Groups | p. 240 |
| Management and Optimization | p. 243 |
| Scripts | p. 248 |
| Multi-Master Replication | p. 249 |
| Concepts and Terminology | p. 249 |
| Getting Started | p. 252 |
| Replication Groups | p. 255 |
| Master Site Maintenance and Propagation | p. 259 |
| Controlling Propagation | p. 264 |
| The Replication Catalog | p. 274 |
| Table Replication | p. 279 |
| Replicating DDL | p. 293 |
| Your Replicated Environment | p. 297 |
| Advanced Replication Limitations | p. 304 |
| Updateable Snapshots | p. 305 |
| About Updateable Snapshots | p. 305 |
| Creating Updateable Snapshots | p. 306 |
| Communication Flow | p. 310 |
| Controlling Propagation and Refreshes | p. 312 |
| Maintenance | p. 315 |
| Procedural Replication | p. 318 |
| When to Use Procedural Replication | p. 318 |
| How Procedural Replication Works | p. 319 |
| Creating a Replicated Package Procedure | p. 319 |
| Restrictions on Procedural Replication | p. 322 |
| An Example | p. 322 |
| Conflict Avoidance and Resolution Techniques | p. 333 |
| Data Integrity Versus Data Convergence | p. 333 |
| Applications That Avoid Conflicts | p. 334 |
| Types of Conflicts Detected | p. 337 |
| How Oracle Detects and Resolves Conflicts | p. 342 |
| Column Groups and Priority Groups | p. 346 |
| The Built-in Methods | p. 353 |
| Writing Your Own Conflict Resolution Handler | p. 355 |
| Appendixes | p. 357 |
| Built-in Packages for Distributed Systems | p. 359 |
| Scripts and Utilities | p. 484 |
| Index | p. 513 |
| Table of Contents provided by Syndetics. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.