Case Study A Time Variant Multi-Source Datawarehouse案例研究时变的多源数据仓库.pptVIP

AMulti-Source Time-Variant DatawarehouseCase Study Objectives Exploring DW Techniques in Oracle Case Study Oracle 10G Additions A Real Life Case Claims Datawarehouse Several Customers/Sources Several Quarters Data Volume Was High Irregular Frequency Data Comes Often Late Near Real Time Requirements Problems Incoming Data Irregular Summary Tables Need Refreshing Quarters Added Continuously Archival Requirements Vary Across Customers Quick Retrieval of Archival Needed Problems contd. Summary on Summary Tables as Materialized Views Need Refresh Whenever New Data Arrives Or When Data is Purged/