Abstract
TAILOR is a tool for updating views. It interacts with the database administrator at view definition time to capture syntactic knowledge, structural constraints, and application semantics. It also interacts with the database user and consults the database at view update time to capture additional application semantics and database semantics, respectively. TAILOR uses this information to select from among several alternative update translations against the base relations when the user updates a view. This paper describes an overview of the algorithms used by TAILOR and its implementation using a comprehensive example of a view update and how TAILOR performs it.
This work was partially supported by NSF grant DMC-84-12085 and Honeywell CSDD and was performed at Honeywell CSDD.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
7. References
F. Bancilhon, "Supporting View Updates in Relational Databases," in Data Base Architecture, Bracci and Nijssen, eds., North Holland, June 1979.
F. Bancilhon and N. Spyratos, "Update Semantics and Relational Views," ACM Trans. on Database Systems, 6:4, December 1981.
S. Cosmadakis and C. Papadimitriou, "Updates of Relational Views," Journal of ACM, 31:4, October 1984.
C. J. Date, "Updating Views," Chapter 17 in Relational Database: Selected Writings, Addison-Wesley, 1986.
U. Dayal and P. A. Bernstein, "On the Updatability of Relational Views," Proc. of the Fourth VLDB Conference, Berlin, West Germany, October 1978.
U. Dayal and P. A. Bernstein, "On the Correct Translation of Update Operations on Relational Views," ACM Trans. on Database Systems, 7:3, September 1982.
A. L. Furtado and M. A. Casanova, "Updating Relational Views," in Query Processing in Database Systems, W. Kim, D. S. Reiner, and D. S. Batory, eds., Springer-Verlag, 1985.
S. J. Hegner, "Canonical View Update Support through Boolean Algebra of Components," Proc. of the Third ACM SIGACT-SIGMOD Symp. on Principles of Database Systems, April 1984.
A. M. Keller, "Updates to Relational Databases Through Views Involving Joins," in Improving Database Usability and Responsiveness, Peter Scheuermann, ed., Academic Press, New York, 1982.
Arthur M. Keller, "Algorithms for Translating View Updates to Database Updates for Views Involving Selections, Projections, and Joins," Proc. of the Fourth ACM SIGACT-SIGMOD Symp. on Principles of Database Systems, March 1985.
Arthur M. Keller, "Choosing Translator at the view definition time," Proc. of the 12th VLDB, Kyoto, Japan, August 1986.
J. Larson and A. Sheth, "Updating Relational Views Using Knowledge at View Definition and View Update Time," Honeywell Technical Report, 1000 Boone Ave No., Golden Valley, MN 55427.
Y. Masunaga, "A Relational Database View Update Translation Mechanism," Proc. of the 10th VLDB, Singapore, August 1986.
I. M. Osman, "Updating Defined Relations," Proc. of NCC 48, 1979.
M. Stonebraker, "Implementation of Integrity Constraints and Views by Query Modification," Proc. of the ACM SIGMOD International Conference on Management of Data, San Jose, June 1975.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1988 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Sheth, A.P., Larson, J.A., Watkins, E. (1988). TAILOR, a tool for updating views. In: Schmidt, J.W., Ceri, S., Missikoff, M. (eds) Advances in Database Technology—EDBT '88. EDBT 1988. Lecture Notes in Computer Science, vol 303. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-19074-0_54
Download citation
DOI: https://doi.org/10.1007/3-540-19074-0_54
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-19074-5
Online ISBN: 978-3-540-39095-4
eBook Packages: Springer Book Archive