Relational Completeness of Query Languages for Annotated Databases

  • Floris Geerts
  • Jan Van den Bussche
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4797)


Annotated relational databases can be queried either by simply making 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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Abiteboul, S., Hull, R., Vianu, V.: Foundations of Databases. Addison-Wesley, Reading (1995)MATHGoogle Scholar
  2. 2.
    Bhagwat, D., Chiticariu, L., Tan, W.-C., Vijayvargiya, G.: An annotation management system for relational databases. The VLDB Journal 14(4), 373–396 (2005)CrossRefGoogle Scholar
  3. 3.
    Buneman, P., Cheney, J., Vansummeren, S.: On the expressiveness of implicit provenance in query and update languages. In: Schwentick, T., Suciu, D. (eds.) ICDT 2007. LNCS, vol. 4353, pp. 209–223. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  4. 4.
    Buneman, P., Khanna, S., Tan, W.-C.: On propagation of deletions and annotations through views. In: Proceedings 21st ACM Symposium on Principles of Database Systems, pp. 150–158. ACM Press, New York (2002)Google Scholar
  5. 5.
    Chiticariu, L., Tan, W.-C., Vijayvargiya, G.: DBNotes: A post-it system for relational databases based on provenance. In: Proceedings 2005 ACM SIGMOD International Conference on Management of Data, pp. 942–944. ACM Press, New York (2005)CrossRefGoogle Scholar
  6. 6.
    Cong, G., Fan, W., Geerts, F.: Annotation propagation revisited for key preserving views. In: Proceedings 15th ACM International Conference on Information and Knowledge Management, pp. 632–641. ACM Press, New York (2006)CrossRefGoogle Scholar
  7. 7.
    Geerts, F., Kementsietsidis, A., Milano, D.: iMONDRIAN: A visual tool to annotate and query scientific databases. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Boehm, K., Kemper, A., Grust, T., Boehm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 1168–1171. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  8. 8.
    Geerts, F., Kementsietsidis, A., Milano, D.: MONDRIAN: Annotating and querying databases through colors and blocks. In: Proceedings 22th International Conference on Data Engineering, p. 82. IEEE Computer Society Press, Los Alamitos (2006)Google Scholar
  9. 9.
    Van den Bussche, J., Cabibbo, L.: Converting untyped formulas into typed ones. Acta Informatica 35(8), 637–643 (1998)MATHCrossRefMathSciNetGoogle Scholar
  10. 10.
    Wang, Y.R., Madnick, S.E.: A polygen model for heterogeneous database systems: the source taging perspective. In: McLeod, D., Sacks-Davis, R., Schek, H. (eds.) Proceedings of the 16th International Conference on Very Large Data Bases, pp. 518–538. Morgan Kaufmann, San Francisco (1990)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • Floris Geerts
    • 1
    • 2
  • Jan Van den Bussche
    • 1
  1. 1.Hasselt University/Transnational University Limburg 
  2. 2.University of Edinburgh 

Personalised recommendations