Oracle distributed systems
著者
書誌事項
Oracle distributed systems
O'Reilly, 1999
大学図書館所蔵 全1件
  青森
  岩手
  宮城
  秋田
  山形
  福島
  茨城
  栃木
  群馬
  埼玉
  千葉
  東京
  神奈川
  新潟
  富山
  石川
  福井
  山梨
  長野
  岐阜
  静岡
  愛知
  三重
  滋賀
  京都
  大阪
  兵庫
  奈良
  和歌山
  鳥取
  島根
  岡山
  広島
  山口
  徳島
  香川
  愛媛
  高知
  福岡
  佐賀
  長崎
  熊本
  大分
  宮崎
  鹿児島
  沖縄
  韓国
  中国
  タイ
  イギリス
  ドイツ
  スイス
  フランス
  ベルギー
  オランダ
  スウェーデン
  ノルウェー
  アメリカ
注記
"Includes advanced replication in Oracle7 & Oracle8"
Includes index
One 3 1/2" computer disk in pocket attached to inside back cover
内容説明・目次
内容説明
Most organizations that use the Oracle relational database management system (RDBMS) nees to use multiple databases. There are many reasons to use more than a single database in a distributed database syste,s: different databases may be associated with particular business functions, such as manufacturing or human resources; databases may be aligned with geographical boundaries, such as 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; and a copy of a production database may be created to serve as a development test bed. This book describes how you can use multiple databases and the distributed features of Oracle to best advantage. Distributed database environments offer a number of benefits over single-database systems, including tunability, platform autonomy, and location transparency.
This book describes the benefits and tradeoffs of distributed database systems.
目次
Preface. I. The Distributed System. 1. 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. 2. SQL*Net and Net8 Protocol Overview Architecture SQL*Net/Net8 Tuning Load Balancing Oracle8 Scalability Options SQL*Net/Net8 Client Configuration SNMP Support Security. 3. Configuration and Administration Initialization Parameters Database Links Distributed Queries and Transactions Distributed Backup and Recovery Multiversion Interoperability. 4. Distributed Database Security Privilege Management Authentication Methods. 5. Designing a Distributed System Characteristics of a Distributed System The Global Data Dictionary Replication-Specific Issues Data Partitioning Methodologies Application Partitioning Strategies Procedural Replication. 6. Oracle's Distributed System Implementation Meeting the 12 Objectives with Oracle Oracle's Global Data Dictionary 7. Sample Configurations The High-Availability System Geographic Data Distribution Workflow Partitioning Data Collection and Consolidation Loosely Coupled Federation./ 8. Engineering Considerations Schema Design and Integration Application Tiering Designing a Replicated System. II. Replication. 9. Oracle Replication Architecture What Is Oracle Replication? Types of Replication Architecture Components Replication of DDL Oracle8 Enhancements Oracle8i Enhancements Alternatives to Replication. 10. Advanced Replication Installation Initialization Parameters Redo Logs and Rollback Segments Size and Placement of Data Dictionary Objects Administrative Accounts, Privileges, and Database Links. 11. Basic Replication About Read-Only Snapshots Prerequisites and Restrictions Snapshot Creation Basics Simple Versus Complex Snapshots Snapshot Logs Subquery Subsetting Refresh Groups Management and Optimization Scripts. 12. 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. 13. Updateable Snapshots About Updateable Snapshots Creating Updateable Snapshots Communication Flow Controlling Propagation and Refreshes Maintenance. 14. Procedural Replication When to Use Procedural Replication How Procedural Replication Works Creating a Replicated Package Procedure Restrictions on Procedural Replication An Example. 15. 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. III. Appendixes. A. Built-in Packages for Distributed Systems. B. Scripts and Utilities
「Nielsen BookData」 より