The Full-Text Search Specialty Data Store product performs powerful, full-text searches on Adaptive Server data. In Adaptive Server, without the Full-Text Search engine, you can search text columns only for data that matches what you specify in a select statement. For example, if a table contains documents about dog breeds, and you perform a search on the words “Saint Bernard,” the query produces only the rows that include “Saint Bernard” in the text column.
With the Full-Text Search engine, you can expand queries on text columns to do the following:
Rank the results by order of how often a searched item appears in the selected document. For example, you can obtain a list of document titles that reference the words “Saint Bernard” five or more times.
Select documents in which the words you search for appear within n number of words of each other. For example, you can search only for the documents that include the words “Saint Bernard” and “Swiss Alps” and that appear within 10 words of each other.
Select documents that include all the search elements you specify within a single paragraph or sentence. For example, you can query the documents that include the words “Saint Bernard” in the same paragraph or sentence as the words “Swiss Alps.”
Select documents that contain one or more synonyms of the word you specify. For example, you can select documents that discuss “dogs,” and it returns documents that contain the words “dogs,” “canine,” “pooch,” “pup,” and so on.
Create your own custom thesaurus. For example, you can create a custom thesaurus that includes “working dogs,” “St. Bernard,” “large dogs,” and “European Breeds” as synonyms for “Saint Bernard.”
Create topics that specify the search criteria for a query. For example, you can create a topic that returns documents that include the phrase “Saint Bernard” or “St. Bernard,” followed by documents that include the phrase “working dogs,” “large dogs,” or “European Breeds.”
Return documents grouped in clusters to give you a sense of the major topics covered in the documents.
Select a section of relevant text in a document and search for other, similar documents.
Index many different document types, such as Microsoft Word, and FrameMaker.
Sort documents using up to 16 sort orders.
Integrated backup and restore capabilities
Ability to change the value of a configuration parameter using a system procedure
Ability to optimize indexes for text searches when your server is inactive, to enhance performance
Additional system management reports for viewing setup information
Ability to bring databases online automatically for text searches