3 Review(s)

From smaller businesses through to huge enterprises – users all over the world often require access to data 24 hours a day. Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today's fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems. This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment. The book does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams. What you will learn from this book: Clear, concise explanations of Oracle Streams components and concepts Up-front design considerations and techniques – know what you need BEFORE you start building Configure both Source and Target databases to support Streams capture, propagation, and apply processes Set up a Single-Source Configuration using the Enterprise manager DB Console to divert flow in one direction and apply its concepts to a multi-master, or N-Way Replication environment configuration Solidify your Streams concepts through basic implementation examples that can then be applied to more complicated systems Learn about popular advanced features of Oracle Streams including Subsetting, Tags, Rules, and Rule based transformations Discover effective and efficient troubleshooting techniques and tools Who this book is written for This book is for users who have implemented, or are about to implement, a distributed database environment using Oracle Streams replication. The reader is expected to have an intermediate understanding of Oracle database technology. This book is mainly intended for use by: Oracle Database Administrators responsible for the implementation and maintenance of an Oracle Streamed environment System and Database Architects responsible for the design of distributed database environments using Oracle Streams Readers with limited knowledge of basic Oracle database technology can benefit from Chapters 1 and 2, which cover Oracle Streams Components and Design Considerations. About The Author Ann McKinnell is currently a Senior Principal Consultant with APG Technologies, LLC and has been an OCP since Oracle 7.3.4. She came to APG with over 8 years as a senior technical member of Oracle Global Support, specializing in Replication and Distributed System technologies. She was a recognized global technical expert for Oracle Distributed Systems; earning the internal nickname "The Replication Goddess". Eric Yen began working with Oracle Databases at version 7.3.4. Over the following 14 years, he obtained his Oracle DBA Certification starting with version 8, maintaining it up to the current release, and he has also earned the (ISC)2 CISSP certification. Eric began working with Oracle Streams with Oracle 9i Streams beta. As a Senior Principal Consultant with APG Technologies, LLC, Eric's work includes designing and implementing Streams solutions for Government clients using the more recent versions of Streams in Oracle 10 and Oracle 11. During his little spare time, you can find Eric exercising and tinkering around with Oracle products.