Abstract
In this paper we define the concept of self-maintainable views — these are views that can be maintained using only the contents of the view and the database modifications, without accessing any of the underlying databases. We derive tight conditions under which several types of select-project-join are self-maintainable upon insertions, deletions and updates. Self-Maintainability is a desirable property for efficiently maintaining large views in applications where fast response and high availability are important. One example of such an environment is data warehousing wherein views are used for integrating data from multiple databases.
Keywords
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.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
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, 1989.
J. A. Blakeley, P. Larson, and F. W. Tompa. Efficiently Updating Materialized Views. SIGMOD 1986.
A. Gupta, H. V. Jagadish, and I. S. Mumick. Data integration using self-maintainable views. Technical memorandum, AT&T Bell Laboratories, November 1994.
A. Gupta and I. S. Mumick. Maintenance of Materialized Views: Problems, Techniques, and Applications. In IEEE Data Engineering Bulletin, Special Issue on Materialized Views and Data Warehousing, 18(2), June 1995.
A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining Views Incrementally. In Proceedings of ACM SIGMOD 1993 International Conference on Management of Data, pages 157–167.
J. Lu, G. Moerkotte, J. Schu, and V. Subrahmanian. Efficient maintenance of materialized mediated views. In SIGMOD, 1995.
R. Ramakrishnan, Y. Sagiv, J. D. Ullman, and M. Vardi. Proof-tree Transformation Theorems and Their Applications. In PODS, 1989.
Y. Zhuge, H.G arcia-Molina, J. Hammer, and J. Widom. View Maintenance in a Warehousing Environment. In SIGMOD 1995.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gupta, A., Jagadish, H.V., Singh Mumick, I. (1996). Data integration using self-maintainable views. In: Apers, P., Bouzeghoub, M., Gardarin, G. (eds) Advances in Database Technology — EDBT '96. EDBT 1996. Lecture Notes in Computer Science, vol 1057. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0014149
Download citation
DOI: https://doi.org/10.1007/BFb0014149
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-61057-1
Online ISBN: 978-3-540-49943-5
eBook Packages: Springer Book Archive