Relational completeness of query languages for annotated databases

  • Authors:
  • Floris Geerts;Jan Van Den Bussche

  • Affiliations:
  • Hasselt University and Transnational University Limburg and University of Edinburgh;Hasselt University and Transnational University Limburg

  • Venue:
  • DBPL'07 Proceedings of the 11th international conference on Database programming languages
  • Year:
  • 2007

Quantified Score

Hi-index 0.01

Visualization

Abstract

Annotated relational databases can be queried either by simply xmaking the annotations explicitly available along the ordinary data, or by adapting the standard query operators so that they have an implicit effect also on the annotations. We compare the expressive power of these two approaches. As a formal model for the implicit approach we propose the color algebra, an adaptation of the relational algebra to deal with the annotations. We show that the color algebra is relationally complete: it is equivalent to the relational algebra on the explicit annotations. Our result extends a similar completeness result established for the query algebra of the MONDRIAN annotation system, from unions of conjunctive queries to the full relational algebra.