Data Annotation Models and Annotation Query Language

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.

Authors:

• Neerja Bhatnagar
• Benjoe A. Juliano
• Renee S. Renner

Keywords:

• annotation query language
• data annotations
• data annotation models
• semantic data annotations

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] 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.
[3] 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.
[4] 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.
[5] D. Lois, M. David, B. Shawn, D. Longxing, W. Mathew, G. Paul,
A. Joan, L. Mary, and L. J. A., "Bundles in captivity: An
application of superimposed information," tech. rep., 2000.
[6] E. Egyed-Szigmond, Y. Pri, A. Mille, and J. Pinon, "A graphbased
audiovisual document annotation and browsing system," in
RIAO (CAIR), April 2000.
[7] K. B.Sall, XML Family of Specifications A Practical Guide.
Boston MA: Addison Wesley, 2002.
[8] M. Bhadkamkar, V. Hristidis, and R. Rangaswami, "Efficient
native XML storage," tech. rep., Florida International University,
April 2005.
[9] 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.
[10] D. Chamberlin, XQuery from the Experts A Guide to the W3C
XML Query Language. Boston, MA: Addison-Wesley, 2004.
[11] N. Bhatnagar, "Data annotation models and annotation query
language," Master-s thesis, California State University, Chico,
May 2006.