Full Text Indexing 1

[Mag0007]

I am using Apache Cloudscape, is there a Full Text Indexing method with this?

I am looking something similar to tsearch2

TIA!

 

[juliane26]

Apache Cloudscape ?
I guess you are using Cloudscape from Informix now IBM?

What do you want to do with full text index ? Indexing a text column or doing some information retrival stuff?

Well, indexing a text column is possible. You will have to consider the pagesize.
From the documentation:

NOTE: The size of the key columns in an index must be equal to or smaller than half the page size. If the length of the key columns in an index is larger than half the page size of the index, creating an index on those key columns for the table fails. For existing indexes, an insert of new rows for which the key columns are larger than half of the index page size causes the insert to fail.

-- use a larger page size for the index
CREATE INDEX large_index ON PageContent (large_text_column)
PROPERTIES db2j.storage.pageSize=8192

http://publibfi.boulder.ibm.com/epubs/html/cloud51/doc/html/coreframe.html

Juliane

 

[Mag0007]

Juliane26:

Thanks for the feedback!

I am basically trying to write a simple answer database, and I am trying to index the data for retreivel and ranking.

I am currently using a large file which has all of my data but I want to conver it to Cloudscape/Apache Derby.

I want to index all of my data! Any more docs or example? I have worked with tsearch2 (

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html)

I am looking for similar examples.

TIA!!!!!!

 

[juliane26]

What I can see from the documentation TSearch is more something of a text search extender or module, coming along with multiple functions and data types and tables ...

Sorry I can't help you there, I don't know Cloudscape that well. With the index option I mentioned you will be able to implement such functions yourself. I am not aware of an extension.

There are text search tools available doing that for you:

http://www.searchtools.com/info/database-search.html

May be searching the IBM DeveloperWorks Site has something more useful to offer.

Sorry.

Juliane