Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: automatic refresh of delta data for materialized views
<<Ferenc,
This has just crossed my mind and perhaps that after I think harder I'll find it a foolish idea, but would it be possible to have snapshot logs (or their home-made equivalents) on all the tables in the view and building a 'delta view' on top of those logs ?>>
FM : Stephane, thanks for replying, as I am still not coming up with any good ideas myself on this. The whole snapshot idea has not crossed my mind until you mentioned it, but even with the snapshot logs, I would still need to calculate the summaries and aggregates on the entire set of tables in the join, which is essentially what I wanted the materialized view for in the first place. for small to normal size DW, this is not too much of a problem, but for the very large (1 TB size) DW, where they would want to load incrementally almost daily, this would pose an extremely long running process, and even if the various MV's are refreshed in parallel, if loaded daily, I doubt there would be enough time between the ETL loads and when the DSS users come in to work, that the processes would get finished. Of course without summarized tables or MV, the whole idea of available aggregations is preposterous to begin with.
Thanks for thinking of this. I will probably try it to see what I can conjure up.
Ferenc
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ferenc Mantfeld
INET: fmantfeld_at_siebel.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 06 2002 - 03:38:20 CDT