View maintenance in a warehousing environment
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
A data model for supporting on-line analytical processing
CIKM '96 Proceedings of the fifth international conference on Information and knowledge management
DynaMat: a dynamic view management system for data warehouses
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Shrinking the warehouse update Window
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
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 Strobe algorithms for multi-source warehouse consistency
DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
Querying Multiple Features of Groups in Relational Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery
From a Procedural to a Visual Query Language for OLAP
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Active Query Caching for Database Web Servers
Selected papers from the Third International Workshop WebDB 2000 on The World Wide Web and Databases
Conceptual Design of Data Warehouses from E/R Schema
HICSS '98 Proceedings of the Thirty-First Annual Hawaii International Conference on System Sciences-Volume 7 - Volume 7
| Hi-index | 0.00 |
Currently there is a common problem of real-time data inconsistency between source transactional systems and data warehouse. ECA, a well-known algorithm, is quite effective in addressing the view maintenance anomaly by making use of compensation queries. However, ECA does not maintain information about the data warehouse, and has to send compensating queries to the source system resulting in performance degradation. This paper proposes a new strategy for maintaining data warehouse in a Web environment without sending update queries to the source system. To maintain consistency in real-time, automatically installed web client program create modify queries for each update query to source system. Modify queries associated with each update query are processed at the web warehouse level without connecting to the source system. Hence the problem of a single modify query having to access multiple source systems disappears and the system performance improves. Through simulation, the performance of the proposed strategy is compared with previous solutions.