sql server 2008 R2中的文本挖掘 [英] Text mining in sql server 2008 R2
问题描述
想要从评论表中分别提取好评和坏评论
i有一个数据库表名称tblcomments,其中有来自全球客户的1000条评论......现在我们想通过在Sql server 2008 R2商业智能工具中通过文本挖掘使用的单词来区分好的和坏的评论....
将不胜感激任何回复
谢谢
hussain
hussain。[删除] @gmail.com
SHOUTING删除,Spurious big and bold删除,Email删除 - OriginalGriff [/ edit]
want to extract good and bad comments separately from comments table
i have a database table name tblcomments which has 1000s of comments from customer all over the world... now we want to separate good and bad comments from it by words used through text mining in Sql server 2008 R2 Buisness intelligence tool....
will appreciate any response
thanks
hussain
hussain.[DELETED]@gmail.com
[edit]SHOUTING removed, Spurious big and bold removed, Email removed - OriginalGriff[/edit]
推荐答案
成千上万的评论并不是那么多。恕我直言,你不需要任何特殊的商业智能工具。只需要使用这样的simle查询
Thousands of comments is not really that much. IMHO you don''t need any special business intelligence tool for this. Just go with simle query like this
SELECT *
FROM tblComments
WHERE commentColumn LIKE '%bad_word_1%' or
commentColumn LIKE '%bad_word_2%' or
commentColumn LIKE '%bad_word_3%' or
commentColumn LIKE '%bad_word_4%'
MSDN [ ^ ]
还有一个关于这个主题的免费电子书 - 这里只是其中的一个链接 http://www.ebooksdownloadfree.com/Databases/Data-Mining-with -Microsoft-SQL-Server-2008-BI2278.html [ ^ ]
甚至有一个专门用于主题的整个网站 http://www.sqlserverdatamining.com/ssdm/Home/FAQ/tabid/55/Default.aspx [<一个href =http://www.sqlserverdatamining.com/ssdm/Home/FAQ/tabid/55/Default.aspx\"target =_ blanktitle =New Window> ^ ]
There are several articles on MSDN[^]
There''s also a free ebook on the subject - here is just one of many links to ithttp://www.ebooksdownloadfree.com/Databases/Data-Mining-with-Microsoft-SQL-Server-2008-BI2278.html[^]
There''s even a whole site dedicated to the subject http://www.sqlserverdatamining.com/ssdm/Home/FAQ/tabid/55/Default.aspx[^]
请参阅下文es $>
数据挖掘白皮书概述 [ ^ ]
SQL Server 2005文本挖掘教程 [ ^ ]
Refer below articles
Data mining whitepaper overview [^]
SQL Server 2005 Text Mining tutorial [^]
这篇关于sql server 2008 R2中的文本挖掘的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!