Oracle Distributed Systems

Oracle Distributed Systems

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. Tunability Platform autonomy Fault tolerance Scalability Location transparency Site autonomy 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 Oracle Replication Architecture Advanced Replication Option Installation Basic Replication Multi-Master Replication Updateable Snapshots Procedural Replication Conflict Avoidance and Resolution Techniques 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: 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 Part II: Replication Part III: Appendixes Appendix A: Built-in Packages for Distributed Systems Appendix B: Scripts.


Author
Publisher
Release Date
ISBN 9780596152222
Pages 552 pages
Rating 4/5 (21 users)
Read More

More Books:

Oracle Distributed Systems
Language: en
Pages: 552
Authors: Charles Dye
Categories: Electronic data processing
Type: BOOK - Published: 1999 - Publisher:

Any organization that uses the Oracle relational database management system (RDBMS) these days needs to use multiple databases. There are many reasons to use mo
Oracle Distributed Systems
Language: en
Pages: 530
Authors: Charles Dye
Categories: Computers
Type: BOOK - Published: 1999 - Publisher: Oreilly & Associates Incorporated

A practical handbook on the effective usage of multiple databases and Oracle8 and Oracle7 distributed system features, encompassing information on design, confi
Applying Integration Techniques and Methods in Distributed Systems and Technologies
Language: en
Pages: 351
Authors: Kecskemeti, Gabor
Categories: Computers
Type: BOOK - Published: 2019-04-12 - Publisher: IGI Global

Distributed systems intertwine with our everyday lives. The benefits and current shortcomings of the underpinning technologies are experienced by a wide range o
Stabilization, Safety, and Security of Distributed Systems
Language: en
Pages: 432
Authors: Borzoo Bonakdarpour
Categories: Computers
Type: BOOK - Published: 2016-11-01 - Publisher: Springer

This book constitutes the refereed proceedings of the 18th International Symposium on Stabilization, Safety, and Security of Distributed Systems, SSS 2016, held
Cooperative Environments for Distributed Systems Engineering
Language: en
Pages: 286
Authors: Khalil Drira
Categories: Computers
Type: BOOK - Published: 2003-06-30 - Publisher: Springer

The engineering life cycle for complex systems design and development, where partners are dispersed in different locations, requires the set-up of adequate and
Oracle PL/SQL CD Bookshelf
Language: en
Pages: 285
Authors: O'Reilly & Associates
Categories: Computers
Type: BOOK - Published: 2000 - Publisher: "O'Reilly Media, Inc."

Readers get the complete text of the following books on CD-ROM: "Oracle PL/SQL Programming, Advanced PL/SQL Programming, Oracle Web Applications, Oracle Built-i
Oracle PL/SQL Programming
Language: en
Pages: 248
Authors: Steven Feuerstein
Categories: Computers
Type: BOOK - Published: 1999 - Publisher: "O'Reilly Media, Inc."

Introducing the latest PL/SQL features of Oracle8i, this detailed manual discusses autonomous transactions, invoker rights, native dynamic SQL, system-level dat
Oracle Essentials
Language: en
Pages: 408
Authors: Rick Greenwald
Categories: Computers
Type: BOOK - Published: 2007-11-01 - Publisher: "O'Reilly Media, Inc."

Oracle is an enormous system, with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it diff
Principles of Distributed Systems
Language: en
Pages: 281
Authors: Roberto Baldoni
Categories: Computers
Type: BOOK - Published: 2013-12-13 - Publisher: Springer

This book constitutes the refereed proceedings of the 17th International Conference on Principles of Distributed Systems, OPODIS 2013, held in Nice, France, in
Oracle Distributed Systems
Language: en
Pages:
Authors: Kenneth Webb
Categories:
Type: BOOK - Published: 1991-04 - Publisher: