Abstract
The problem of supporting updates to views of a database schema has been the focus of a substantial amount of research over the years. Since the mapping from base schema to view schema is seldom injective, there is usually a choice of possibilities for the reflection of view updates to base-schema updates. This work presents a solution to this problem which augments the constant-complement strategy of Bancilhon and Spyratos with order-theoretic properties to guarantee unique reflection of view updates. Specifically, most database formalisms endow the database states with a natural order structure, under which update by insertion is an increasing operation, and update by deletion is decreasing. Upon augmenting the original constant-complement strategy with compatible order-based notions, the reflection to the base schema of any update to the view schema which is an insertion, a deletion, or a modification which is realizable as a sequence of insertions and deletions is shown to be unique and independent of the choice of complement.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Abiteboul, S., Hull, R., and Vianu, V., Foundations of Databases, Addison-Wesley, 1995.
Bancilhon, F. and Spyratos, N., “Update semantics of relational views,” ACM Transactions on Database Systems, 6(1981), pp. 557–575.
Bellahsène, Z., “Updates and object-generating views in ODBS,” Data & Knowledge Engr., 34(2000), pp. 125–163.
Bentayeb, F. and Laurent, D., “View updates translations in relational databases,” in: Proc. DEXA’ 98, Vienna, Sept. 24–28, 1998, pp. 322–331, 1998.
Davey, B. A. and Priestly, H. A., Introduction to Lattices and Order, Cambridge University Press, 1990.
Gottlob, G., Paolini, P., and Zicari, R., “Properties and update semantics of consistent views,” ACM Trans. Database Systems, 13(1988), pp. 486–524.
Hegner, S. J., “Foundations of canonical update support for closed database views,” in: Proc. ICDT’90, Paris, Dec. 1990, Springer-Verlag, 1990.
Hegner, S. J., “Characterization of desirable properties of general database decompositions,” Ann. Math. Art. Intell., 7(1993), pp. 129–195.
Hegner, S. J., “Unique complements and decompositions of database schemata,” J. Comput. System Sci., 48(1994), pp. 9–57.
Hull, R., “Finitely specifiable implicational dependency families,” Journal of the Association for Computing Machinery, 31(1984), pp. 210–226.
Mac Lane, S., Categories for the Working Mathematician, Springer-Verlag, second edition, 1998.
Mayol, E. and Teniente, E., “A survey of current methods for integrity constraint maintenance and view updating,” in: Proc. ER’ 99 Workshops, Paris, Nov. 15–18, 1999, Springer-Verlag, 1999.
Monk, J. D., Mathematical Logic, Springer-Verlag, 1976.
Thalheim, B., Entity-Relationship Modeling, Springer-Verlag, 2000.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Hegner, S.J. (2002). Uniqueness of Update Strategies for Database Views. In: Eiter, T., Schewe, KD. (eds) Foundations of Information and Knowledge Systems. FoIKS 2002. Lecture Notes in Computer Science, vol 2284. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45758-5_15
Download citation
DOI: https://doi.org/10.1007/3-540-45758-5_15
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-43220-3
Online ISBN: 978-3-540-45758-9
eBook Packages: Springer Book Archive