Jump to navigation Jump to search
311 bytes removed ,  11:51, 12 December 2010
==Fuzzy Querying==
In addition to the W3C XQFT Recommendation, BaseX supports fuzzy querying.
By default, the standard full-text index already supports the efficient
execution of fuzzy searches.
<blockquote><b>'''Document 'doc.xml'</b>''':
<pre> &lt;doc&gt;
&lt;a&gt;foo bar&lt;/a&gt;
<p><b>'''Command:</b> ''' <code>create db doc.xml; create index fullext</code> </p> <p><b>'''Query:</b> ''' <code>xquery //a[text() contains text 'foo' using fuzzy]</code> </p> <p><b>'''Result:</b> ''' <code>&lt;a&gt;foo bar&lt;/a&gt; &lt;a&gt;foa bar&lt;/a&gt;</code> </p> </blockquote>
Fuzzy search is based on the Levenshtein distance. The maximum number of allowed
The query above yields two results as there is no error between the query term
&quot;foo&quot; and the text node &quot;foo bar&quot;, and one error between
&quot;foo&quot; and &quot;foa bar&quot;.<br/>
==Query Evaluation==
possible and useful. Three evaluation strategies are available: the standard sequential
database scan, a full-text index based evaluation and a hybrid one, combining both strategies
(see our <a target='_top' href='publications'>publications</a> for details).<br/><br/>
Query optimization and selection of the most efficient evaluation strategy is done
in a full-fledged automatic manner. The output of the query optimizer indicates which
indicates that the index does not yield any results for the specified term and
is thus skipped. If index optimizations are missing, it sometimes helps to give
the compiler a second chance and try different rewritings of the same query.<br/>
<p>To support a wide variety of scenarios, the available full-text index can
handle different combinations of the match options in XQuery Full Text.
By default, most indexing options are disabled. The GUI dialog for creating new databases
allows to choose the available options. On the command-line, the <code>SET</code>
command has to be used before the full-text index is created, either by</p>
<code> create index fulltext </code> or
<code> set ftindex on; create db FILENAME.xml</code>.
<p>The following options are available:</p> <ul> <li>* Support Wildcards: a trie-based index can be applied to support wildcard searches (<code>SET WILDCARDS ON</code>)</li> <li>* Stemming: tokens are stemmed with the Porter Stemmer before being indexed (<code>SET STEMMING ON</code>)</li> <li>* Case Sensitive: tokens are indexed in case-sensitive mode (<code>SET CASESEND ON</code>)</li> <li>* Diacritics: diacritics are indexed as well (<code>SET DIACRITICS ON</code>)</li> <li>* TF/IDF Scoring: TF/IDF-based scoring values are calculated and stored in the index (<code>SET SCORING 1/2</code>; details see below)</li> <li> * Stopwords: a stop word list can be defined to reduce the number of indexed tokens (<code>SET STOPWORDS FILENAME</code>)</li> </ul>
<p><b>Caution:</b> The index will only be applied if the activated options
are also specified in the query:</p>
<blockquote> '''Caution:''' The index will only be applied if the activated optionsare also specified in the query: <p><b>'''Index Options:</b> ''' Case Sensitive, Stemming ON</p> <p><b>'''Query 1 (wrong):</b> '''
<pre>//*[text() contains text 'inform']
</p> <p><b>'''Query 2 (correct):</b> '''
<pre>//*[text() contains text 'inform' using case sensitive using stemming]
</p> <p><b>'''Query 3 (correct):</b> '''
<pre>declare ft-option using case sensitive using stemming;
//*[text() contains text 'inform']
</p> </blockquote>
<p>The XQuery Full Text Recommendation allows for the usage of scoring models
and values within queries, with scoring being completely implementation defined.
BaseX offers an efficient internal scoring model which can be easily extended to
values within the full-text index structure. Three scoring types are currently
available, which can be adjusted with the <code>SCORING</code> property
(Default: <code>SET SCORING 0</code>):</p> <ul> <li>*<code>0:</code> A standard algorithm is applied, which considers the length of a term and its frequency in a single text node. This algorithm is always applied if no index exists, or if the index cannot be applied in a query.</li> <li>*<code>1:</code> Standard TF/IDF algorithm, which treats document nodes as document units</li> <li>*<code>2:</code> Each text node is treated as a document unit in the TF/IDF algorithm. This variant is recommendable for large XML files which only contain one document node</li> </ul>
administrator, Bureaucrats, editor, Interface administrators, reviewer, Administrators


Navigation menu