| Is Stream Replication is good for dynamic databases. [message #426017] |
Tue, 13 October 2009 14:15 |
varshasantosh2004
Messages: 7
Registered: October 2009
|
Junior Member |
|
|
Hi,
We have a master database which is updated daily using batch processes.
We have a application specific DB which is exactly same as above master DB + some application specific tables.
We want to update this application DB from the master DB once a day, only for the updations that happened on that master DB.
The tables have about 35 M records. (atleast 6-8 tables)
The application DB has various Materialized Views those needs to be refreshed immideately after the DB refresh from main DB.
Our Cache needs to be refreshed with about 35 M rows, if there are any changes to the application DB.
So considering these scenerios, what is the best way for us to keep the above two DBs in Sync.?
To summarize -> Our requirement is to keep master DB and application DB in sync and also update the Materialized Views, Cache etc immideately after the refresh, and many table have about 35 M records and Materialized View refresh itslef takes about 5-6 hrs.
Pleae advise different ways.
Thanks in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
