Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to main content
Springer Nature Link
Log in

A Strategy for Maintaining Client-Based Web Warehouse

  • Conference paper
Web and Communication Technologies and Internet-Related Social Issues - HSI 2005 (HSI 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3597))

Included in the following conference series:

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

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  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)

    Chapter  Google Scholar 

  2. Labrinidis, A., Roussopoulos, N.: WebView Materialization. In: Proc. of the ACM SIGMOD Conference, May 2000, pp. 367–378 (2000)

    Google Scholar 

  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. 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. 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. 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. Rundensteiner, E.A.: DyDa: DW Maintenance in fully concurrent Environments. In: Proc. ACM SIGMOD, pp. 94–103 (2001)

    Google Scholar 

  8. Kimball, R., Merz, R.: The Data Webhouse Toolkit. John Wiley & Sons, Chichester (2000)

    Google Scholar 

  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. 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. 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. 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. 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. 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. Zhuge, Y., Garcia-Molina, H., Hammer, J., Widom, J.: View Maintenance in a Warehousing Environment. In: SIGMOD 1995 (1995)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept of Computer Engineering, Hongik University, Seoul, Korea

    Hyuk-Min Lee & Kyung-Chang Kim

Authors
  1. Hyuk-Min Lee
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Kyung-Chang Kim
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Osaka University, Cybermedia Center, 5-1 Mihogaoka, Ibaraki, 567-0047, Osaka, Japan

    Shinji Shimojo

  2. Graduate School of Mathematical Sciences, University of Tokyo, 3-8-1 Komaba, Meguro-ku, 153-8914, Tokyo, Japan

    Shingo Ichii

  3. School of Computing, National University of Singapore,  

    Tok-Wang Ling

  4. National Internet Development Agency of Korea, 3F, 1321-11 Secho-2 Dong, Secho-Gu, 135-875, Seoul, Korea

    Kwan-Ho Song

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation