AnQL: A Query Language for Annotation Documents

Authors: Neerja Bhatnagar, Ben A. Juliano, Renee S. Renner

Abstract:

This paper presents data annotation models at five levels of granularity (database, relation, column, tuple, and cell) of relational data to address the problem of unsuitability of most relational databases to express annotations. These models do not require any structural and schematic changes to the underlying database. These models are also flexible, extensible, customizable, database-neutral, and platform-independent. This paper also presents an SQL-like query language, named Annotation Query Language (AnQL), to query annotation documents. AnQL is simple to understand and exploits the already-existent wide knowledge and skill set of SQL.

Keywords: Annotation query language, data annotations, data annotation models, semantic data annotations.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1332502

References:

[1] M. Gertz, K.-U. Sattler, F. Gorin, M. Hogarth, and J. Stone, "Annotating scientific images: A concept-based approach," in SSDBM -02: Proceedings of the 14th International Conference on Scientific and Statistical Database Management, (Washington, DC, USA), pp. 59-68, IEEE Computer Society, 2002.
[2] D. Chamberlin, XQuery from the Experts A Guide to the W3C XML Query Language. Boston, MA: Addison-Wesley, 2004.
[3] "XML path language 1.0," 1999.
[4] C. M. Saracco, "Query DB2 XML data with SQL," 2006.
[5] J. Kahan and M.-R. Koivunen, "Annotea: an open RDF infrastructure for shared web annotations," in WWW -01: Proceedings of the 10th international conference on World Wide Web, (New York, NY, USA), pp. 623-632, ACM Press, 2001.
[6] L. Chiticariu, W.-C. Tan, and G. Vijayvargiya, "DBNotes: a PostIt system for relational databases based on provenance," in SIGMOD -05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data, (New York, NY, USA), pp. 942-944, ACM Press, 2005.
[7] F. Geerts, A. Kementsietsidis, and D. Milano, "Mondrian: Annotating and querying databases through colors and blocks," in ICDE -06: Proceedings of the 22nd International Conference on Data Engineering (ICDE-06), (Washington, DC, USA), p. 82, IEEE Computer Society, 2006.
[8] L. Delcambre, D. Maier, S. Bowers, L. Deng, M. Weaver, P. Gorman, J. Ash, M. Lavelle, and J. A. Lyman, "Bundles in captivity: An application of superimposed information," tech. rep., 2000.
[9] E. Egyed-Szigmond, Y. Pri, A. Mille, and J. Pinon, "A graph-based audiovisual document annotation and browsing system," in RIAO (CAIR), April 2000.
[10] D. Bhagwat, L. Chiticariu, W.-C. Tan, and G. Vijayvargiya, "An annotation management system for relational databases," VLDB, 2004.
[11] IBM, "DB2 9 for Linux UNIX and Windows."
[12] Oracle, "Oracle Database."
[13] Microsoft, "Microsoft SQL Server."
[14] K. B. Sall, XML Family of Specifications A Practical Guide. Boston MA: Addison Wesley, 2002.
[15] M. Bhadkamkar, V. Hristidis, and R. Rangaswami, "Efficient native XML storage," tech. rep., Florida International University, April 2005.
[16] A. H. Al-Azzawe, "IBM video online for e-business - DB2 inbound XML data fragments," http://www- 106.ibm.com/developerworks/db2/library, June 2004.
[17] N. Bhatnagar, "Data annotation models and annotation query language," Master-s thesis, California State University, Chico, May 2006.
[18] "Recommendation, XML linking language 1.0," 2001.
[19] "Working draft, XML inclusions (XInclude) 1.0," 2003.