Characterization of optimal complements of database views defined by projection

  • Authors:
  • Stephen J. Hegner

  • Affiliations:
  • Umeå University, Department of Computing Science, Umeå, Sweden

  • Venue:
  • SDKB'10 Proceedings of the 4th international conference on Semantics in data and knowledge bases
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

A complement to a database view Γ is a second view Γ′ which provides the information necessary to reconstruct the entire state of the main schema. View complementation is central in situations in which a view is to be updated, since the complement Γ′ embodies the information not contained in Γ. In general, Γ may have many complements. In this work, an approach to identifying and constructing optimal relational complements for relational views defined by projections, including not only single projections but also sets of projections, is initiated. The approach is based upon the idea of identifying when the main schema has a governing join dependency; that is, a join dependency which implies all others. Four distinct classes of such governing dependencies are identified, corresponding to ordinary complements as well as three distinct types of dependency-preserving complements.