Data Warehouse with high data availability
Page 1 of 1
Data Warehouse with high data availability
When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between updates. In my experience, The relevant technologies that I could think of are MS Snapshot and Data Replication. For platform neutral techniques, using backup/restore and views/ synonyms could somehow switch underlying data dynamically without obvious data outage. What's the best practice in resolving the data availability issues, especially when the DW is big and near real time (eg. hourly frequency).
hang- Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia
Similar topics
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» difference between data mart and data warehouse at logical/physical level
» Data warehouse / data retention strategy - ERP upgrade and consolidation
» Senior Data Architect /Data Warehouse / Business Intelligence
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» difference between data mart and data warehouse at logical/physical level
» Data warehouse / data retention strategy - ERP upgrade and consolidation
» Senior Data Architect /Data Warehouse / Business Intelligence
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|