Is there an Oracle equivalent to MS SQL's full text search service?
是否有Oracle等同于MS SQL的全文搜索服务?
If so, has anyone implemented it and had good / bad experiences?
如果是这样,有没有人实施它并有好/坏经历?
3 个解决方案
#1
34
Oracle Text is the equivalent functionality.
Oracle Text是等效的功能。
I've had good experiences with it. Assuming that you are maintaining the text index asynchronously, that tends to be the first source of problems, since it may be a bit between a change being made and the index getting updated, but that's normally quite reasonable during normal operation.
我有过很好的经历。假设您正在异步维护文本索引,这往往是问题的第一个来源,因为它可能在正在进行更改和索引更新之间,但在正常操作期间通常是非常合理的。
#2
9
In addition to what Justin said, you can find more information about Oracle Text here.
除了Justin所说的,您还可以在此处找到有关Oracle Text的更多信息。
#3
2
And further to what Justin said, it is possible to create the index so it updates on commit, although this is not recommended for large amounts of text.
而Justin所说的,可以创建索引,以便在提交时更新,尽管不建议用于大量文本。
It offers much more power than a simple LIKE compare against %string%.
它比简单的LIKE与%string%相比提供了更多的功能。
#1
34
Oracle Text is the equivalent functionality.
Oracle Text是等效的功能。
I've had good experiences with it. Assuming that you are maintaining the text index asynchronously, that tends to be the first source of problems, since it may be a bit between a change being made and the index getting updated, but that's normally quite reasonable during normal operation.
我有过很好的经历。假设您正在异步维护文本索引,这往往是问题的第一个来源,因为它可能在正在进行更改和索引更新之间,但在正常操作期间通常是非常合理的。
#2
9
In addition to what Justin said, you can find more information about Oracle Text here.
除了Justin所说的,您还可以在此处找到有关Oracle Text的更多信息。
#3
2
And further to what Justin said, it is possible to create the index so it updates on commit, although this is not recommended for large amounts of text.
而Justin所说的,可以创建索引,以便在提交时更新,尽管不建议用于大量文本。
It offers much more power than a simple LIKE compare against %string%.
它比简单的LIKE与%string%相比提供了更多的功能。