Oracle text search

Rails
1

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?

2

Matt S.1 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.

3

Phlip wrote:

Matt S.1 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.
4

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… (-:

5

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