Full-text queries behave linguistic searches against reader observations in full-text indexes aside operating on words and phrases based on rules of a faithful jargon such as English or Japanese. Full-text queries can incorporate dense words and phrases or multiple forms of a little talk or locution.
Full-text search is high-mindedness in a as much as possible distance of conglomerate scenarios such as e-businesses-searching as a replacement for items on a spider’s web site; law firms-searching as a replacement for lawsuit histories in a legal-data repository; or good-natured resources departments-matching field descriptions with stored resumes. However, in a actuality conglomerate working, full-text objective and queries can be honed to congregate conglomerate goals. The prime administrative and advance tasks of full-text search are alike regardless of conglomerate scenarios.
For notification, as a replacement for an e-business maximizing about influence be more high-level than ranking of results, deny preciseness (how tons of the existing matches are indubitably returned aside a full-text query), or supporting multiple languages.
Support Forms of Query Terms (Full-Text Search)
http://technet.microsoft.com/en-us/library/cc879300.aspx – this area of study introduces the forms of full-text queries supported aside SQL Server, and summarizes the back up provided as a replacement for each conglomerate of assuredly question aside the full-text predicates and rowset-valued functions. For a law forceful, returning every accomplishable experience (total deny of information) influence be the most high-level geniality. Full-text queries can be be unfaithful no greater than on columns that be compelled been full-text indexed.
The tests be compelled been made to English and Hebrew languages.
Full-Text Search Tests
The following area of study disposition castigate of the tests be compelled been made on full-text search.
The following tests be compelled been made:
Inflectional forms of a definitive little talk (generation term) – The inflectional forms are the signal tenses of a verb or the signal and plural forms of a noun.
If distinct rows in the comestible incorporate the words “drive”, “drives”, “drove”, “driving”, and “driven”, all would be in the effect instal because each of these can be inflectionally generated from the little talk lane. For notification, search as a replacement for the inflectional conglomerate of the little talk “drive”.
Synonymous forms of a definitive little talk (thesaurus) – A dictionary defines user-specified synonyms as a replacement for terms. All rows in the comestible queried that incorporate the words “automobile”, “truck”, “van”, or “car”, mortify in the effect instal because each of these words be fit to be owned aside to the synonym burgeoning instal containing the little talk “car”. For notification, if an entrВe, “{car, automobile, wares, van}”, is added to a dictionary, you can search as a replacement for the dictionary conglomerate of the little talk “car”.
A little talk or a locution where the words start eccentric with specified reader (prefix term) – A prefix session refers to a lead that is affixed to the blind of a little talk to mount a plagiarized little talk or an inflected conglomerate. For notification, the session “auto*” matches “automatic”, “automobile”, and so forth.
For a pick prefix session, any little talk starting with the specified session disposition be essentially of the effect instal.
For a locution, each little talk within the locution is considered to be a prefix session.
A little talk or locution not far-off to another little talk or locution (proximity term) – A contiguousness session indicates words or phrases that are in not far-off contiguousness to another little talk or locution or two words or phrases in any order. For notification, the session “auto tran*” matches “automatic transmission” and “automobile transducer”, but it does not lord “automatic motor transmission”.
For notification, you dearth to arouse the rows in which the little talk “ice” is not far-off the little talk “hockey” or in which the locution “ice skating” is not far-off the locution “ice hockey”. Many observations points are considered when scampish nearness. Whether two terms or phrases are considered to be not far-off to each other is non-violent internally and is not configurable aside the operator.
Each of the inaccurate of reach of disposition be comprehensive in the next topics; dividing tests be compelled been made as a replacement for each bromide.
Test Number #1: Inflectional forms of a definitive word
The exam has been made as a replacement for checking comparable between words like Cow-Cows.
