Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted Jan 7, 2004

Database management: Tuning with Oracle replication

By DatabaseJournal.com Staff

[From Builder.com]

Oracle replication has been around for quite some time and has become a mature, feature-rich environment to satisfy widely dispersed processing requirements. Replication was first introduced as a way to allow Oracle tables or subsets of tables to be available locally on widely separated database servers. This was accomplished via the use of snapshots (point-in-time copies) of required tables that were copied from a master server to one or more remote slave servers. The snapshot technique was particularly effective for relatively static tables that did not require frequent refresh operations to be kept in sync with the master tables. Read-only applications benefited from the use of snapshots since wide-area network transmission time was eliminated, significantly improving performance.

Snapshots are now more commonly known as materialized views, and while the creation of remote materialized views of master tables is still a common use of replication, the technology has matured significantly, supporting a much broader spectrum of database objects. I'll discuss the snapshot method and then explore more advanced techniques.

The article continues at http://builder.com.com/5100-6388_14-5121411.html



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date