Basic text searching in Informix v11.50 became more versatile, configurable, and faster. See the What's New in Database Extensions
for more information.Process Multiple Basic Test Search
If basic text search queries are slow
because multiple users are running queries at the same time, you can add more
BTS virtual processors so that queries run simultaneously, each in their own
virtual processor. Previously, you could only create one BTS virtual processor
and queries ran serially.
Control the Results of a Fuzzy Search with the Basic Text Search DataBlade® module
You can now specify the degree of
similarity of search results in fuzzy searches when using the Basic Text Search
Specify a number between 0 and 1, where a higher value results in a higher
degree of similarity. To limit results, specify a higher number. To maximize
results, specify a lower number. The default degree of similarity is 0.5.
Map Characters for Indexing with the Basic Text Search DataBlade module
You can now map characters in your data to
other characters during indexing with the Basic Text Search DataBlade module. For
example, you can specify that letters with diacritical marks are indexed as the
same letters without marks. You can also standardize inconsistent prefixes or
delete character strings from indexed text. To use character maps, include the
canonical_maps parameter when you create your bts index.
Default Boolean Operator in Basic Text Search Queries
You can now change the default Boolean
operator between search terms in Basic Text Search queries from OR to AND by
using the query_default_operator parameter when you create a bts index. The default
operator is represented by a blank space between terms. Many popular end-user
search engines use AND as the default operator between search terms, where
end-users expect the search results to contain all their search terms.
Storage for Temporary Basic Text Search Files
You can now specify that temporary files
used by the Basic Text Search DataBlade module are stored in a separate sbspace from the
one used to store the bts index. Separating temporary files from the bts index might improve
Track Basic Text Search Query Trends
You can now track what queries are run
against your bts
index by including the query_log parameter when you create a bts index. You can use
query trends information to provide hints to end-users on popular queries or
work on optimizing the most popular queries.
Indexes by Expressions
You can now fragment bts indexes by
expressions into multiple sbspaces instead of a single sbspace.
Basic Text Search DataBlade
module Supports High-Availability Clusters
You can now use the Basic Text Search
DataBlade module to
perform searches on high-availability cluster servers by creating indexes in
sbspaces. Previously, the Basic Text Search DataBlade module only supported the creation of
indexes in extspaces, and thus could not participate in any queries on
high-availability secondary servers and in backup and restore operations.
Querying XML Attributes with the Basic Text DataBlade module
The Basic Text Search DataBlade module now
supports searches on XML attributes in a document repository. The new all_xmlattrs parameter
enables searches on all attributes that are contained in the XML tags or paths
in a column that contains an XML document.
Support added for a user-defined stopword list
You can create a customized stopword list for frequently occurring words in your
data or you can use the default stopword list.
Support added for XML-structured documents
You can use Basic Text Search XML index parameters to manipulate searches of XML
data in different ways.