Archival databases

From: <rachitm_at_gmail.com>
Date: 29 Jan 2007 15:31:46 -0800
Message-ID: <1170113506.431629.130590_at_k78g2000cwa.googlegroups.com>

Can anyone direct me to the latest database archival strategies that are used in the market these days? I have a db which is underperforming bcz of huge data, and I want to build up an archival db to keep old data. I want the communication between these dbs to be one way - transfer of data and communication only directed from operational db to the archive db and not the other way.

Now, the old data which is going to be in the archival db might have some connections to data that I still want to kept in the operational db. Also, I need to create reports from the archival database about different things. When these reports are created the archival db will need that info from the operational db. But as I said, the communication cannot be from archival db to operational db, but only the other way round.

I hope I am communicating the issue properly. Please let me know what you think about this?

Any thoughts? Received on Tue Jan 30 2007 - 00:31:46 CET