Oracle Distributed Systems

Download or read book Oracle Distributed Systems written by Charles Dye and published by O'Reilly Media. This book was released on 1999 with total page 562 pages. Available in PDF, EPUB and Kindle. Book excerpt: Any organization that uses the Oracle RDBMS these days probably runs multiple databases. Different databases may be associated with particular business functions, may be aligned with geographical boundaries, or may access the same data in different ways (e.g., an order entry database hose transactions are aggregated and analyzed in a data warehouse). Usually, these databases are on different servers, which may be located at the same site or a continent away. Oracle provides many tools for designing, developing, administering, and securing distributed database systems. With these tools, data in multiple databases is accessible just as if it were stored in a single database. If your organization uses (or is contemplating using) distributed databases, you need this book. Aimed at both database administrators and developers, Oracle Distributed Systems describes : Benefits (e.g., scalability, tunability, fault tolerance) and tradeoffs of distributed database systems. How to install and configure a distributed system. How to use Oracle's networking products, SQL*Net and Net8, for distributed processing. How classic database design concepts extend to distributed systems and particularly to Oracle Security considerations for distributed systems. How to configure and administer Oracle's distributed database features-read-only snapshots, multimaster replication, updateable snapshots, procedural replication, and conflict resolution. How to maximize performance (distributed databases can have a huge impact on performance, so it's imperative that you implement such systems in the most efficient and effective way). The book covers both Oracle8 and Oracle 7 syntax, includes a complete API reference for Oracle's built-in distributed system packages (e.g., DBMS_REPCAT, DBMS_SNAPSHOT), and comes with a diskette containing a wealth of helpful scripts and utilities.