Oracle Distributed Systems

eBook Information

Oracle Distributed Systems ISBN  1565924320 Release Date  01 April 1999 Category  Oracle Tags  oracle,   distributed,   oracle streams,   This book @Amazon  View Tools Google Search Web flazx.com

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 Other books on Oracle Oracle Web Services Manager Troubleshooting Oracle Performance OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) (Osborne Oracle Press) Professional Oracle 8i Application Programming with Java, PL/SQL and XML Oracle Database 11g PL/SQL Programming (Oracle Press) Oracle Database 11g DBA Handbook (Osborne Oracle Press) Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle) Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide (Oracle) Oracle Database 11g New Features Oracle Database 11g SQL Oracle Essentials: Oracle Database 11g (Essentials) Pro Oracle Spatial for Oracle Database 11g (Expert's Voice in Oracle) RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle) Oracle Database 10g Performance Tuning Tips & Techniques Oracle Application Server Portal Handbook (Osborne Oracle Press)