Concurrency control and recovery in database systems
Concurrency control and recovery in database systems
View maintenance in a warehousing environment
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
Efficient view maintenance at data warehouses
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Distributed and parallel computing issues in data warehousing (abstract)
PODC '98 Proceedings of the seventeenth annual ACM symposium on Principles of distributed computing
How to roll a join: asynchronous incremental view maintenance
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
DyDa: data warehouse maintenance in fully concurrent environments
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
The EVE Approach: View Synchronization in Dynamic Distributed Environments
IEEE Transactions on Knowledge and Data Engineering
PVM: Parallel View Maintenance under Concurrent Data Updates of Distributed Sources
DaWaK '01 Proceedings of the Third International Conference on Data Warehousing and Knowledge Discovery
Batch data warehouse maintenance in dynamic environments
Proceedings of the eleventh international conference on Information and knowledge management
A Transactional Model for Data Warehouse Maintenance
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
Detection and Correction of Conflicting Source Updates for View Maintenance
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Multiversion-based view maintenance over distributed data sources
ACM Transactions on Database Systems (TODS)
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Managing evolution of data warehouses by means of nested transactions
ADVIS'06 Proceedings of the 4th international conference on Advances in Information Systems
Hi-index | 0.00 |
Data Warehousing is becoming an increasingly important technology for information integration and data analysis. Given the dynamic nature of modern distributed environments, both source data and schema changes are likely to occur autonomously and even concurrently in different sources. We have thus developed a comprehensive solution approach, called TxnWrap, that successfully maintains the warehouse views under any type of concurrent source updates. In this work, we now overcome TxnWrap's restriction that the maintenance is processed one by one for each source update, since that limits the performance. To overcome this limitation, we exploit the transactional approach of TxnWrap to achieve parallel data warehouse maintenance. For this, we first identify the read/write conflicts among the different warehouse maintenance processes. We then propose a parallel maintenance scheduler (PMS) that generates legal schedules that resolve these conflicts. PMS has been implemented and incorporated into our TxnWrap system. The experimental results confirm that our parallel maintenance scheduler significantly improves the performance of data warehouse maintenance.