Database materialised views - are you using them?

Moderators: chulett, rschirm

Post Reply
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Database materialised views - are you using them?

Post by vmcburney »

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.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

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,
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
Image
Post Reply