Are you using materialised views? What do you like about them?
Our project is considering using DB2 materialised views for reports instead of queries against tables. One particular features looks very useful, the ability to freeze the view to a snapshot even when the underlying tables are being updated, and then refreshing the view with a command when the loads are complete. Might also be good for rollback of failed ETL jobs.
Database materialised views - are you using them?
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Database materialised views - are you using them?
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Hi Vincent,
I don't see any real benefit regarding the rollback if etl job failed since it's not different then using a staging area and switching between tables/partitions.
Many a time the configuration best suted for loading your target DB is not the best one to extract reports from and if this doesn't support having source and target being partitioned differently or having diffrent indexes then you might have a problem tuning for better performance.
IHTH,
I don't see any real benefit regarding the rollback if etl job failed since it's not different then using a staging area and switching between tables/partitions.
Many a time the configuration best suted for loading your target DB is not the best one to extract reports from and if this doesn't support having source and target being partitioned differently or having diffrent indexes then you might have a problem tuning for better performance.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org