TAILOR, a tool for updating views

  • Amit P. Sheth
  • James A. Larson
  • Evan Watkins
Database Administration
Part of the Lecture Notes in Computer Science book series (LNCS, volume 303)

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.

Key Words

view update relational views semantic knowledge database semantics application semantics semantic integrity constraints translations semantic ambiguity problem rule based approach 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

7. References

  1. [Bancilhon 79]
    F. Bancilhon, "Supporting View Updates in Relational Databases," in Data Base Architecture, Bracci and Nijssen, eds., North Holland, June 1979.Google Scholar
  2. [Bancilhon 81]
    F. Bancilhon and N. Spyratos, "Update Semantics and Relational Views," ACM Trans. on Database Systems, 6:4, December 1981.Google Scholar
  3. [Cosmadakis 84]
    S. Cosmadakis and C. Papadimitriou, "Updates of Relational Views," Journal of ACM, 31:4, October 1984.Google Scholar
  4. [Date 86]
    C. J. Date, "Updating Views," Chapter 17 in Relational Database: Selected Writings, Addison-Wesley, 1986.Google Scholar
  5. [Dayal 78]
    U. Dayal and P. A. Bernstein, "On the Updatability of Relational Views," Proc. of the Fourth VLDB Conference, Berlin, West Germany, October 1978.Google Scholar
  6. [Dayal 82]
    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.Google Scholar
  7. [Furtado 85]
    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.Google Scholar
  8. [Hegner 84]
    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.Google Scholar
  9. [Keller 82]
    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.Google Scholar
  10. [Keller 85]
    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.Google Scholar
  11. [Keller 86]
    Arthur M. Keller, "Choosing Translator at the view definition time," Proc. of the 12th VLDB, Kyoto, Japan, August 1986.Google Scholar
  12. [Larson 87]
    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.Google Scholar
  13. [Masunaga 84]
    Y. Masunaga, "A Relational Database View Update Translation Mechanism," Proc. of the 10th VLDB, Singapore, August 1986.Google Scholar
  14. [Osman 79]
    I. M. Osman, "Updating Defined Relations," Proc. of NCC 48, 1979.Google Scholar
  15. [Stonebraker 75]
    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.Google Scholar

Copyright information

© Springer-Verlag 1988

Authors and Affiliations

  • Amit P. Sheth
    • 1
  • James A. Larson
    • 2
  • Evan Watkins
    • 2
  1. 1.UNISYS West Coast Research CenterSanta MonicaUSA
  2. 2.Honeywell CSDDGolden ValleyUSA

Personalised recommendations