Oracle Scores with Text Query Functions
October 17, 2011
Save Your Knowledge, an IT knowledge and experience blog, provides a useful how-to with, “Oracle Text: A Simple Way to Implement Scoring Text Search Engine on Oracle DB.” We quite like the allusions to the work of Edward Hopper too.
The author’s English is interesting, but the concept is clear:
In this post I will describe text query functionality. My customer wants search functionality on several database columns, and results must be ordered by their relevance. Using a “like” clause let’s you find results that contains a word but doesn’t say you how much relevant it is. For this purpose you can use Oracle Text extension.
Most licensees of Oracle’s flag ship database will have or be able to get access to the Text functions. Although getting long in the tooth, the system will index what’s in an Oracle table. Performance can be an interesting challenge. Scaling and speeding up the creaking technology of Oracle Text requires expertise and resources; that is, money and time. For more information about Oracle text, click here.
The author goes on to describe how to make this work in various contexts and also provides examples, screenshots, etc. The technique could be a helpful function for users of the Oracle application and is worth a look.
Emily Rae Aldridge, October 17, 2011
Sponsored by Pandia.com
Comments
3 Responses to “Oracle Scores with Text Query Functions”
-
- Subscribe to Beyond Search
Feature archive
News archive
-
I’m very glad that my posts can be useful. Thanks for your post. I’m sorry for my english but you know that writing a blog needs a lot of time and, usually, i don’t correct draft. I will pay more attention. 😀
I’m Maximilian’s collegue (sorry for my very interesting english) and I’m very invidious of him… I would write those interesting post like Max do… congratulations !!!
I think that the autor’s english is not important to understanding the basic of the concept he wants to exprime! My compliments. It is very useful! thanx thanx thanx!