Oracle Database 11g Search Features
October 13, 2010
I must admit that I don’t follow Oracle’s search and retrieval initiatives with the assiduity of the past. My goodness there is so much activity in the NoSQL world that I find that the new is driving out the old. A reader sent me a link to a useful write up by Richard Foote. “Oracle OpenWorld Day 5 Highlights.” The article includes a useful summary of search features and I wanted to capture his thoughts and urge you to read his original post. On the other hand, you could navigate to www.oracle.com, use the Web site search function, and locate the information yourself. (It did take me some time to find what I sought, but your mileage may vary.)
I learnt to my surprise that there are a quite a number of new features in relation to Oracle Text in the recent 18.104.22.168 release. New features include Entity Extraction whereby Oracle will automatically find entities in text such as people, cities, phone numbers, etc. a new Name Search facility in which people names with different spelling can more easily be found (such as Stephen and Steven) and a new Resultset Interface capability in which details and data can be nicely summarized. Also mentioned are enhancements in the manner by which frequent and not so frequent accesses to text tokens can be stored and processed. Also had a really interesting look at what new things are being planned, such as automatic partitioning, automatic optimizations of indexes via the use of a staging index, section specific index options, two index levels with better management of common terms in memory, substring index options to name but a few. Looks like there are going to be considerable functional improvements to text indexes on their way soon.
Oracle is a very large outfit, and I must invest some time in figuring out what happened to TripleHop, SES11g, Oracle Text, and the search functions that once were resident within such Oracle acquisitions as PeopleSoft. Soon. Hopefully soon. More rumors about a deal between Oracle and a search vendor. No comments on that, however.
Stephen E Arnold, October 13, 2010