|
| OverviewThis book describes how you can use multiple databases and
both Oracle8 and Oracle7 distributed system features to best
advantage. It covers design, configuration of SQL*Net/Net8,
security, and Oracle's distributed options (advanced
replication, snapshots, multi-master replication, updateable
snapshots, procedural replication, and conflict resolution).
Includes a complete API reference for built-in packages and
a diskette with many helpful scripts and utilities. Editorial ReviewsProduct DescriptionAny 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 |
Top Sellers in This Category | Browse Similar Topics | | Top Level Categories:Sub-Categories: | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 9 reviews. Oracle Distributed Systems, 2002-11-06 Reviewer rating: Very good book. Good Structure, well writtern and full of information. Author gave very clear explanation on Oracle Distributed Systems. I hope new edition will cover more on addressing common problems that faced during replication, how to detect and solve it, performance tuning and other hands on topics. | well written, but badly out of date, 2002-08-23 Reviewer rating: Well written and useful, but badly out of date. In spite of the claim that is updated for 8 and 8i, it's not there. | Great book, 2000-10-31 Reviewer rating: Very good book. Author gives clear and detailed explanation to Oracle distributed systems. The essential guide for advanced DBA/Developers. Anxious to see new release with 8i or 9i tips. | Useful for Replication, 2000-02-01 Reviewer rating: It would have been better if the author has addressed the common problems faced during replication, how to detect them and solve them. Otherwise a good book. Many packages have changed in Oracle 8i. Better wait till the next release covering 8i is out in the market. | adequate coverage, 1999-10-30 Reviewer rating: This book does a reasonable job covering both distributed databases and replication. More coverage on maintenance and problem-solving would be helpful (i.e. What to look at when replication fails dd views etc.) |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
