Database Software

Hi gang,

I am putting together a proposal to alleviate some of the performance issues we are experiencing, and part of that solution is an OLAP-type system that needs to maintain sync with the OLTP system, and consisting of 100s of millions of rows of mutable information.

I know this is a big deal, out of the norm, etc., but our business centers around this requirement.

Essentially, we send approximately 60 million messages a month, which are constructed from a small subset of constantly changing data. The current solution is a weekly ETL; however, that process takes anywhere from 2-4 days to complete, by which time, the information has gotten stale. Not to mention that any problem requires a restart of the job, and the processing time is lost, putting us further behind.

So, what I am thinking is a very simple single, denormalized table that would provide the data we need to do the mailings. We would take the hit on a single massive ETL to load the table, but then once it is done, synchronize with the TP side via some tool (or even at the application level with redundant writes to the database). An insert to the TP side would also insert to the AP side, and an update to the TP side would trigger an update in the AP system.

The question is, what does Oracle have to help with this? I have looked a Data Guard and Warehouse Builder, but neither seem to be the right solution. We are also investigating products like WisdomForce's Database Sync, but since we are sitting on 10g, we would rather keep it in the family.

Any input, insight, or comments greatly appreciated!

Cheers,

Chris