Abstract
Full-text queries search information in documents using words and several special operators. Therefore, the search process operates on documents, and returning results are again documents. XQuery Full Text search provides a narrower form of full-text queries, while the search process operates on parts of XML documents, such as elements and attributes.
In this paper, we discuss first XPath and XQuery Full Text specified in the W3C standard. Features, described in the standard, are separated in several groups and described using examples. After that, we show to what extent these features are supported in RDBMSs. The summary of the paper lists semantic similarities and differences of Full Text features described in the standard on one side and features, which are supported in the recent versions of IBM DB2, Oracle and MS SQL Server on the other. This part of the paper shows also that the syntax of the features described in the standard has not been supported by any of the considered systems.
Similar content being viewed by others
References
W3C (2011) XQuery and XPath full-text 1.0 recommendation. http://www.w3.org/TR/xpath-full-text-10/
Melton J, Buxton S (2006) In: Querying XML. Morgan Kaufman, San Mateo, pp 439–479
Oracle XML DB. Searching XML data with Oracle text. http://docs.oracle.com/cd/E11882_01/appdev.112/e16659/xdb01int.htm#i1047845
Oracle text reference. Oracle text CONTAINS query operators. http://docs.oracle.com/cd/B28359_01/text.111/b28304/cqoper.htm
Seubert H, Perathoner-Tschaffler S (2006) XML full-text search in DB2. http://www.ibm.com/developerworks/data/library/techarticle/dm-0606seubert/
Behnen M (2010) Understanding linguistic processing for full-text search in DB2. http://www.ibm.com/developerworks/data/library/techarticle/dm-1006db2textsearch/index.html
DB2 text search and net search extender: comparison. http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.ts.doc%2Fdoc%2Fc0052757.html
Shettar P et al (2010) Full-text search with DB2 text search. http://www.ibm.com/developerworks/data/tutorials/dm-0810shettar/index.html
Petkovic D (2012) In: SQL server 2012. A beginner’s guide. McGraw-Hill, New York, pp 755–780
Full text index on XML columns. http://msdn.microsoft.com/en-us/library/bb522491.aspx
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Petković, D. XPath and XQuery Full Text Standard and Its Support in RDBMSs. Datenbank Spektrum 12, 205–213 (2012). https://doi.org/10.1007/s13222-012-0097-3
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s13222-012-0097-3