注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

中吴南顾惟一笑

成功法则就是那19个字

 
 
 

日志

 
 

Full text search in Database  

2011-03-17 14:55:52|  分类: dbms |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Full-text search is applicable in a wide range of business scenarios such as e-businesses—searching for items on a web site; law firms—searching for case histories in a legal-data repository; or human resources departments—matching job descriptions with stored resumes. The basic administrative and development tasks of full-text search are equivalent regardless of business scenarios.


a). Specific words or phrase (simple term)
b). A word or a phrase begin with specified text (prefix term)
c). Inflectional forms of a specific word (generation term)
d). A word or phrase close to another word or phrase (proximity term)
Synonymous forms of a specific word (thesaurus)


The Full-Text Engine performs word breaking and, optionally, thesaurus expansions, stemming(conjugates verbs and performs inflectional expansions), and stopword (noise-word) processing(sometimes language-specific ).
At indexing time, these information is used to perform linguistic analysis on the textual data from a given table column.

Sqlite
1). CREATE VIRTUAL TABLE statement
2). One or more columns of fully indexed text
3). Insert rows into a full-text table in the same way as into an ordinary table with columns of type TEXT
4). Use 'MATCH' to perform a full-text search on a column in a full-text table


Mysql
1). Define FULLTEXT index on some columns
2). Search using MATCH and AGAINST statements
eg.    SELECT headline, story FROM news WHERE MATCH (headline,story) AGAINST ('Hurricane');
    
SQLServer
1). Create a full-text index on one or more character-based columns in the table.
2). Provides a set of full-text predicates (CONTAINS and FREETEXT) and rowset-valued functions (CONTAINSTABLE and FREETEXTTABLE)
3). Seperate full-text catalog, track changes in the base table and its columns
  评论这张
 
阅读(108)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017