Skip to main content
Log in

XPath and XQuery Full Text Standard and Its Support in RDBMSs

  • Fachbeitrag
  • Published:
Datenbank-Spektrum Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1

Similar content being viewed by others

References

  1. W3C (2011) XQuery and XPath full-text 1.0 recommendation. http://www.w3.org/TR/xpath-full-text-10/

  2. http://basex.org/

  3. http://mxquery.org/

  4. http://www.xmlmind.com/qizx/

  5. Melton J, Buxton S (2006) In: Querying XML. Morgan Kaufman, San Mateo, pp 439–479

    Chapter  Google Scholar 

  6. Oracle XML DB. Searching XML data with Oracle text. http://docs.oracle.com/cd/E11882_01/appdev.112/e16659/xdb01int.htm#i1047845

  7. Oracle text reference. Oracle text CONTAINS query operators. http://docs.oracle.com/cd/B28359_01/text.111/b28304/cqoper.htm

  8. Seubert H, Perathoner-Tschaffler S (2006) XML full-text search in DB2. http://www.ibm.com/developerworks/data/library/techarticle/dm-0606seubert/

  9. Behnen M (2010) Understanding linguistic processing for full-text search in DB2. http://www.ibm.com/developerworks/data/library/techarticle/dm-1006db2textsearch/index.html

  10. 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

  11. Shettar P et al (2010) Full-text search with DB2 text search. http://www.ibm.com/developerworks/data/tutorials/dm-0810shettar/index.html

  12. Petkovic D (2012) In: SQL server 2012. A beginner’s guide. McGraw-Hill, New York, pp 755–780

    Google Scholar 

  13. Full text index on XML columns. http://msdn.microsoft.com/en-us/library/bb522491.aspx

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Dušan Petković.

Rights and permissions

Reprints 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

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s13222-012-0097-3

Keywords

Navigation