Showing posts with label word. Show all posts
Showing posts with label word. Show all posts

Monday, March 26, 2012

Italian word braker

Hello,
is there the chance to personalize the word braker rules for italian
language on SQL 2005?
We need to index a lot of "ancient textual corpora" and modern rules do
not works fine. thanks
No, you would have to create your own word breaker. Consult msdn for
articles on how to do this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"salucci" <salucci@.gmail.com> wrote in message
news:1141075776.995621.150900@.j33g2000cwa.googlegr oups.com...
> Hello,
> is there the chance to personalize the word braker rules for italian
> language on SQL 2005?
> We need to index a lot of "ancient textual corpora" and modern rules do
> not works fine. thanks
>
|||Hilary Cotter wrote:
> No, you would have to create your own word breaker. Consult msdn for
> articles on how to do this.
> --
Thanks, Hilary.
Have you some links to give me?
|||http://search.microsoft.com/results...q=iwordbreaker
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"salucci" <salucci@.gmail.com> wrote in message
news:1141118776.380936.140760@.z34g2000cwc.googlegr oups.com...
> Hilary Cotter wrote:
> Thanks, Hilary.
> Have you some links to give me?
>
|||http://search.microsoft.com/results...q=iwordbreaker
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"salucci" <salucci@.gmail.com> wrote in message
news:1141118776.380936.140760@.z34g2000cwc.googlegr oups.com...
> Hilary Cotter wrote:
> Thanks, Hilary.
> Have you some links to give me?
>

Wednesday, March 7, 2012

Issue with full-text query (containstable)..

I've got a full-text index on a table 'items' with an image field
'item' into which I've imported word and pdf documents. I've only got
~10 docs imported currently, for testing. I know that each of these
documents, except for one, includes the term 'ontology' or
'ontologies'.
I've got the following query, which gives back only two of these
documents (1 word, 1 pdf):
select i.*, ct.rank as incl_ctr
from items i inner join
containstable(items, item,
' ("class*" and "info*") or "ontology" '
) ct on i.id = ct.[key]
where (ct.rank > 1) and i.incl_ext in ('.doc','.pdf')
order by ct.rank desc;
I know this is incomplete, based on the content of each document, which
is an issue I'd like to work out; but prior to that, if I write the
query with "onto*" as a prefix term instead of "ontology", it only
gives back one of the two docs (the pdf):
select i.*, ct.rank as incl_ctr
from items i inner join
containstable(items, item,
' ("class*" and "info*") or "onto*" '
) ct on i.id = ct.[key]
where (ct.rank > 1) and i.incl_ext in ('.doc','.pdf')
order by ct.rank desc;
I can't identify why this is. I'd be very interested in whatever input
I could get on this..
Installed evaluation version: 2000 - 8.00.194 on Windows XP.
Installing the pdf ifilter improves the circumstance described in the
initial post; yet I think it's odd that onto* yields fewer docs in that
query than ontology, which continues to be the case..