Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Full Text Indexing

Full Text Indexing

Full Text Indexing

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

I am looking something similar to tsearch2


RE: Full Text Indexing

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



RE: Full Text Indexing


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.


RE: Full Text Indexing

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:

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



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close