Oracle text search

Hi,

I've been asked to move an application to Oracle.

It uses Ferret drb for text search [& its been really stable thank you
very much].

Any one have any thoughts on how to do text searching in Oracle?

Matt Stone1 wrote:

I've been asked to move an application to Oracle.

It uses Ferret drb for text search [& its been really stable thank you
very much].

Any one have any thoughts on how to do text searching in Oracle?

Write a cron job that reads Oracle and writes Ferret every day, and trigger this cron in some kind of "update" mode when specific new data come in.

Phlip wrote:

Matt Stone1 wrote:

I've been asked to move an application to Oracle.

It uses Ferret drb for text search [& its been really stable thank you
very much].

Any one have any thoughts on how to do text searching in Oracle?

Write a cron job that reads Oracle and writes Ferret every day, and
trigger this
cron in some kind of "update" mode when specific new data come in.

Thanks Phlip,

Yep, that would work.

I guess I was hoping that oracle had its own elegant text search
features that could be accessed by rails, possible via stored
procedures.

- matt.

Write a cron job that reads Oracle and writes Ferret every day, and trigger this
cron in some kind of "update" mode when specific new data come in.

I guess I was hoping that oracle had its own elegant text search features that could be accessed by rails, possible via stored procedures.

If you do it my way, you can deploy the feature first. Then you would have lots of time to research the awesome toy that is Oracle, without making your clients wait for their feature. Software development should always be incremental - even if you must temporarily degrade performance just to avoid rewriting too much.

Your network admins might ask about your new CPU load, though... (-:

I've been asked to move an application to Oracle.

It uses Ferret drb for text search [& its been really stable thank you
very much].

Any one have any thoughts on how to do text searching in Oracle?

You might want to look into Oracle Text.
http://www.oracle.com/technology/products/text/index.html
http://www.oracle.com/technology/pub/articles/asplund-textsearch.html