Skip to main content
SpringerLink
Log in

The rejuvenation of materialized views

Extended abstract

  • Invited Talk
  • Conference paper
  • First Online:
Information Systems and Data Management (CISMOD 1995)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1006))

Included in the following conference series:

Abstract

This is a short summary of a talk presented at the sixth International Conference on Information Systems and Management of Data (CISMOD 95) held in Bombay in November 1995.

The summary describes some of the applications that are causing a renewed interest in materialized views, the problems in supporting the applications, and sketches how the current work in this area is addressing some of the problems.

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.

References

  1. Peter O. Buneman and Eric K. Clemons. Efficiently monitoring relational databases. ACM Transactions on Database Systems, 4(3):368–382, September 1979.

    Article  Google Scholar 

  2. J. A. Blakeley, N. Coburn, and P. Larson. Updating derived relations: Detecting irrelevant and autonomously computable updates. ACM Transactions on Database Systems, 14(3):369–400, September 1989.

    Article  Google Scholar 

  3. J. A. Blakeley, P. Larson, and F. W. Tompa. Efficiently Updating Materialized Views. In [Sig86], pages 61–71.

    Google Scholar 

  4. Jose A. Blakeley and Nancy L. Martin. Join index, materialized view, and hybrid hash join: A performance analysis. In [DE90], pages 256–263.

    Google Scholar 

  5. Surajit Chaudhuri, Ravi Krishnamurthy, Spyros Potamianos, and Kyuseok Shim. Optimizing queries with materialized views. In Proceedings of the Eleventh IEEE International Conference on Data Engineering, Taipei, Taiwan, March 6–10 1995.

    Google Scholar 

  6. Proceedings of the Sixth IEEE International Conference on Data Engineering, Los Angeles, CA, February 5–9 1990.

    Google Scholar 

  7. Jennifer Widom, editor. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), June 1995.

    Google Scholar 

  8. Shaul Dar, H.V. Jagadish, Alon Y. Levy, and Divesh Srivastava. Answering SQL queries with aggregation using views. Technical Memorandum, AT&T Bell Laboratories, 1995.

    Google Scholar 

  9. Ashish Gupta, Venkatesh Harinarayan, and Dallan Quass. Generalized projections: A powerful approach to aggregation. In Umeshwar Dayal, Peter M.D. Gray, and Shojiro Nishio, editors, Proceedings of the 21 st International Conference on Very Large Databases, Zurich, Switzerland, September 11–15 1995.

    Google Scholar 

  10. Ashish Gupta, H. V. Jagadish, and Inderpal Singh Mumick. Data integration using self-maintainable views. Technical Memorandum, AT&T Bell Laboratories, November 1994.

    Google Scholar 

  11. Timothy Griffin and Leonid Libkin. Incremental maintenance of views with duplicates. In [Sig95].

    Google Scholar 

  12. Ashish Gupta and Inderpal Singh Mumick. Maintenance of Materialized Views: Problems, Techniques, and Applications. In [DEB95], pages 3–19.

    Google Scholar 

  13. Ashish Gupta, Inderpal Singh Mumick, and Kenneth A. Ross. Adapting materialized views after redefinitions. In [Sig95].

    Google Scholar 

  14. Ashish Gupta, Inderpal Singh Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In Proceedings of ACM SIGMOD 1993 International Conference on Management of Data, Washington, DC, May 26–28 1993.

    Google Scholar 

  15. Eric N. Hanson. A performance analysis of view materialization strategies. In Umeshwar Dayal and Irv Traiger, editors, Proceedings of ACM SIGMOD 1987 International Conference on Management of Data, pages 440–453, San Francisco, CA, May 27–29 1987.

    Google Scholar 

  16. Joachim Hammer, Hector Garcia-Molina, Jennifer Widom, Wilburt Labio, and Yue Zhuge. The Stanford Data Warehousing Project. In [DEB95], pages 41–48.

    Google Scholar 

  17. H. V. Jagadish, Inderpal Singh Mumick, and Avi Silberschatz. View maintenance issues in the chronicle data model. In [POD95], pages 113–124.

    Google Scholar 

  18. Bruce Lindsay, Laura Haas, C. Mohan, Hamid Pirahesh, and Paul Wilms. A snapshot differential refresh algorithm. In [Sig86], pages 53–60.

    Google Scholar 

  19. Alon Y. Levy, Alberto O. Mendelzon, Yehoshua Sagiv, and Divesh Srivastava. Answering queries using views. In [POD95], pages 95–104.

    Google Scholar 

  20. J. M. Nicolas and K. Yazdanian. An Outline of BDGEN: A Deductive DBMS. In Information Processing, pages 705–717, 1983.

    Google Scholar 

  21. New York Times. Bug in chemical bank's ATM software, February 18 1994. Front page article.

    Google Scholar 

  22. R. Paige. Applications of finite differencing to database integrity control and query/transaction optimization. In H. Gallaire, J. Minker, and J. Nicolas, editors, Advances in Database Theory, pages 170–209, New York, 1984. Plenum Press.

    Google Scholar 

  23. Proceedings of the Fourteenth Symposium on Principles of Database Systems (PODS), San Jose, CA, May 22–24 1995.

    Google Scholar 

  24. Xiaolei Qian and Gio Wiederhold. Incremental recomputation of active relational expressions. IEEE Transactions on Knowledge and Data Engineering, pages 337–341, 1991.

    Google Scholar 

  25. Nick Roussopoulos. The incremental access method of View Cache: Concept, algorithms, and cost analysis. ACM Transactions on Database Systems, 16(3):535–563, September 1991.

    Article  Google Scholar 

  26. Anand Rajaraman, Yehoshua Sagiv, and Jeffrey D. Ullman. Answering queries using templates with binding patterns. In [POD95], pages 105–112.

    Google Scholar 

  27. Arie Segev and Weiping Fang. Currency-based updates to distributed materialized views. In [DE90], pages 512–520.

    Google Scholar 

  28. Oded Shmueli and A. Itai. Maintenance of Views. In Proceedings of ACM SIGMOD 1984 International Conference on Management of Data, pages 240–255, 1984.

    Google Scholar 

  29. Carlo Zaniolo, editor. Proceedings of ACM SIGMOD 1986 International Conference on Management of Data, Washington, D.C., May 28–30 1986.

    Google Scholar 

  30. Michael Carey and Donovan Schneider, editors. Proceedings of ACM SIGMOD 1995 International Conference on Management of Data, San Jose, CA, May 23–25 1995.

    Google Scholar 

  31. Arie Segev and Jooseok Park. Updating distributed materialized views. IEEE Transactions on Knowledge and Data Engineering, 1(2):173–184, June 1989.

    Article  Google Scholar 

  32. Jaideep Srivastava and Doron Rotem. Analytical modeling of materialized view maintenance. In Proceedings of the Seventh Symposium on Principles of Database Systems (PODS), pages 126–134, Austin, TX, March 21–23 1988.

    Google Scholar 

  33. Yue Zhuge, Hector Garcia-Molina, Joachim Hammer, and Jennifer Widom. View maintenance in a warehousing environment. In [Sig95].

    Google Scholar 

  34. G. Zhou, R. Hull, R. King, and J-C. Franchitti. Using object matching and materialization to integrate heterogeneous databases. In Proc. of 3 rd International Conference on Cooperative Information Systems, pages 4–18, 1995.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. AT&T Bell Laboratories, 600 Mountain Avenue, 07974, Murray Hill, NJ, USA

    Inderpal Singh Mumick

Authors
  1. Inderpal Singh Mumick
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Subhash Bhalla

Rights and permissions

Reprints and permissions

Copyright information

© 1995 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Mumick, I.S. (1995). The rejuvenation of materialized views. In: Bhalla, S. (eds) Information Systems and Data Management. CISMOD 1995. Lecture Notes in Computer Science, vol 1006. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-60584-3_37

Download citation

  • DOI: https://doi.org/10.1007/3-540-60584-3_37

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-60584-3

  • Online ISBN: 978-3-540-47799-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation