Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Luo, Q., Naughton, J.F., Krishnamurthy, R., Cao, P., Li, Y.: Active query caching for database web servers. In: Suciu, D., Vossen, G. (eds.) WebDB 2000. LNCS, vol. 1997, pp. 29–34. Springer, Heidelberg (2001)
Labrinidis, A., Roussopoulos, N.: WebView Materialization. In: Proc. of the ACM SIGMOD Conference, May 2000, pp. 367–378 (2000)
Labrinidis, A., Roussopoulos, N.: On the Materialization of Webviews. In: ACM SIGMOD Workshop on the Web and Databases, June 1999, pp. 79–84 (1999)
Kotidis, Y., Roussopoulos, N.: DynaMat: A Dynamic View Management system of Data Warehouses. In: Proc. of the ACM SIGMOD Conference, Philadelphia, pp. 371–382 (1999)
Budzik, J., Bradshaw, S., Fu, X., Hammond, K.J.: Watson: Anticipating and Contextualizing Information Needs. In: Proc. of the 62 Annual Meeting of the American Society for IS (1999)
Zhuge, Y., Garcia-Molina, H., Wiener, J.L.: The Strobe Algorithms for Multi-Source Warehouse Consistency. In: Proc. the International Conference on Parallel and Distributed Information system, pp. 146–157 (1997)
Rundensteiner, E.A.: DyDa: DW Maintenance in fully concurrent Environments. In: Proc. ACM SIGMOD, pp. 94–103 (2001)
Kimball, R., Merz, R.: The Data Webhouse Toolkit. John Wiley & Sons, Chichester (2000)
Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Data Warehouses from ER Schemes. In: Proc. the Hawaii International Conference (1998)
Chatziantoniou, D., Ross, K.A.: Querying Multiple Features of Groups in Relational Databases. In: Proc. the 22nd VLDB Conference, pp. 295–306 (1996)
Cabibbo, L., Torlone, R.: From a Procedural to a Visual Query Language for OLAP. In: Proc. 10th International Conference on Scientific and Statistical Database Management, July 1998, pp. 77–83 (1998)
Li, C., Wang, X.S.: A Data Model for Supporting On-line Analytical Processing. In: Pro. the Fifth International Conference on Information and Knowledge Management, November 1996, pp. 81–88 (1996)
Theodoratos, D., Sellis, T.: Dynamic Data Warehouse Design. In: Proc. 1st International Conference on Data Warehousing and Knowledge Discovery, August 1999, pp. 1–10 (1999)
Labio, W.J., Terneni, R., Garcia-Molina, H.: Shrinking the Warehouse Update Window. In: Proc. ACM SIGMOD International Conference on Management of Data, June 1999, pp. 383–394 (1999)
Zhuge, Y., Garcia-Molina, H., Hammer, J., Widom, J.: View Maintenance in a Warehousing Environment. In: SIGMOD 1995 (1995)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lee, HM., Kim, KC. (2005). A Strategy for Maintaining Client-Based Web Warehouse. In: Shimojo, S., Ichii, S., Ling, TW., Song, KH. (eds) Web and Communication Technologies and Internet-Related Social Issues - HSI 2005. HSI 2005. Lecture Notes in Computer Science, vol 3597. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11527725_16
Download citation
DOI: https://doi.org/10.1007/11527725_16
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-27830-6
Online ISBN: 978-3-540-31808-8
eBook Packages: Computer ScienceComputer Science (R0)