Advertisement

A Strategy for Maintaining Client-Based Web Warehouse

  • Hyuk-Min Lee
  • Kyung-Chang Kim
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3597)

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.

Keywords

Source System Query Processing Time View Maintenance Transaction Queue Maintain Data Consistency 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    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)CrossRefGoogle Scholar
  2. 2.
    Labrinidis, A., Roussopoulos, N.: WebView Materialization. In: Proc. of the ACM SIGMOD Conference, May 2000, pp. 367–378 (2000)Google Scholar
  3. 3.
    Labrinidis, A., Roussopoulos, N.: On the Materialization of Webviews. In: ACM SIGMOD Workshop on the Web and Databases, June 1999, pp. 79–84 (1999)Google Scholar
  4. 4.
    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)Google Scholar
  5. 5.
    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)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    Rundensteiner, E.A.: DyDa: DW Maintenance in fully concurrent Environments. In: Proc. ACM SIGMOD, pp. 94–103 (2001)Google Scholar
  8. 8.
    Kimball, R., Merz, R.: The Data Webhouse Toolkit. John Wiley & Sons, Chichester (2000)Google Scholar
  9. 9.
    Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Data Warehouses from ER Schemes. In: Proc. the Hawaii International Conference (1998)Google Scholar
  10. 10.
    Chatziantoniou, D., Ross, K.A.: Querying Multiple Features of Groups in Relational Databases. In: Proc. the 22nd VLDB Conference, pp. 295–306 (1996)Google Scholar
  11. 11.
    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)Google Scholar
  12. 12.
    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)Google Scholar
  13. 13.
    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)Google Scholar
  14. 14.
    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)Google Scholar
  15. 15.
    Zhuge, Y., Garcia-Molina, H., Hammer, J., Widom, J.: View Maintenance in a Warehousing Environment. In: SIGMOD 1995 (1995)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2005

Authors and Affiliations

  • Hyuk-Min Lee
    • 1
  • Kyung-Chang Kim
    • 1
  1. 1.Dept of Computer EngineeringHongik UniversitySeoulKorea

Personalised recommendations