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.
Preview
Unable to display preview. Download preview PDF.
References
Peter O. Buneman and Eric K. Clemons. Efficiently monitoring relational databases. ACM Transactions on Database Systems, 4(3):368–382, September 1979.
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.
J. A. Blakeley, P. Larson, and F. W. Tompa. Efficiently Updating Materialized Views. In [Sig86], pages 61–71.
Jose A. Blakeley and Nancy L. Martin. Join index, materialized view, and hybrid hash join: A performance analysis. In [DE90], pages 256–263.
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.
Proceedings of the Sixth IEEE International Conference on Data Engineering, Los Angeles, CA, February 5–9 1990.
Jennifer Widom, editor. IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), June 1995.
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.
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.
Ashish Gupta, H. V. Jagadish, and Inderpal Singh Mumick. Data integration using self-maintainable views. Technical Memorandum, AT&T Bell Laboratories, November 1994.
Timothy Griffin and Leonid Libkin. Incremental maintenance of views with duplicates. In [Sig95].
Ashish Gupta and Inderpal Singh Mumick. Maintenance of Materialized Views: Problems, Techniques, and Applications. In [DEB95], pages 3–19.
Ashish Gupta, Inderpal Singh Mumick, and Kenneth A. Ross. Adapting materialized views after redefinitions. In [Sig95].
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.
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.
Joachim Hammer, Hector Garcia-Molina, Jennifer Widom, Wilburt Labio, and Yue Zhuge. The Stanford Data Warehousing Project. In [DEB95], pages 41–48.
H. V. Jagadish, Inderpal Singh Mumick, and Avi Silberschatz. View maintenance issues in the chronicle data model. In [POD95], pages 113–124.
Bruce Lindsay, Laura Haas, C. Mohan, Hamid Pirahesh, and Paul Wilms. A snapshot differential refresh algorithm. In [Sig86], pages 53–60.
Alon Y. Levy, Alberto O. Mendelzon, Yehoshua Sagiv, and Divesh Srivastava. Answering queries using views. In [POD95], pages 95–104.
J. M. Nicolas and K. Yazdanian. An Outline of BDGEN: A Deductive DBMS. In Information Processing, pages 705–717, 1983.
New York Times. Bug in chemical bank's ATM software, February 18 1994. Front page article.
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.
Proceedings of the Fourteenth Symposium on Principles of Database Systems (PODS), San Jose, CA, May 22–24 1995.
Xiaolei Qian and Gio Wiederhold. Incremental recomputation of active relational expressions. IEEE Transactions on Knowledge and Data Engineering, pages 337–341, 1991.
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.
Anand Rajaraman, Yehoshua Sagiv, and Jeffrey D. Ullman. Answering queries using templates with binding patterns. In [POD95], pages 105–112.
Arie Segev and Weiping Fang. Currency-based updates to distributed materialized views. In [DE90], pages 512–520.
Oded Shmueli and A. Itai. Maintenance of Views. In Proceedings of ACM SIGMOD 1984 International Conference on Management of Data, pages 240–255, 1984.
Carlo Zaniolo, editor. Proceedings of ACM SIGMOD 1986 International Conference on Management of Data, Washington, D.C., May 28–30 1986.
Michael Carey and Donovan Schneider, editors. Proceedings of ACM SIGMOD 1995 International Conference on Management of Data, San Jose, CA, May 23–25 1995.
Arie Segev and Jooseok Park. Updating distributed materialized views. IEEE Transactions on Knowledge and Data Engineering, 1(2):173–184, June 1989.
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.
Yue Zhuge, Hector Garcia-Molina, Joachim Hammer, and Jennifer Widom. View maintenance in a warehousing environment. In [Sig95].
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.
Author information
Authors and Affiliations
Editor information
Rights 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