Sitemap

Amicuk Programming Answers

Performing filtering, highlights or markups on searches

-0001-11-30   Views:0

Advertisement

Greetings, I have developed a content management system which stores, searches etc a table containing different kinds of electronic documents stored as BLOBs. I am trying to integrate into the search function the ability to display a hundred or so ch

Greetings,
I have developed a content management system which stores, searches etc a table containing different kinds of electronic documents stored as BLOBs. I am trying to integrate into the search function the ability to display a hundred or so characters including the matching query words and the surrounding text. I have managed to do this and have come up with several possible alternatives. The problem is that all of them are too slow.
The first solution I came up with was to execute the CTX_DOC.MARKUP procedure, and then retrieve the CLOB to my application where I split it up according to the markup tags which served as delmiters and then selected the desired amount of text to display. This has several issues with it. The CLOB is passed back to the web application over the network, when only a fraction of it needs to be displayed. This roundtrip is excessive. This however is not the cause of the excessive slow in performance.
The second alternative would be to execute the CTX_DOC.HIGHLIGHT and MARKUP procedures, which would store the location of the query results in the markup up document. Once this is done, I would execute the dbms_lob.substr procedure combining the CLOB produced by MARKUP and the query offsets and lengths from HIGHLIGHT. First I would alter the lengths stored in the HIGHLIGHT result table so that the surrounding text would be displayed. I would then return a varchar2 with the results and display them in my application. This too however seems to take too long.
Does anyone know of an efficient way to highlight select terms and the surrounding text without resulting to executing such delaying procedures?

The replay answer
Advertisement
We have solved this highlighting issue using XML and XSLT.
The database transforms the output of a query into XML, including the search terms used (by the user). A XSL style sheet transforms the XML into (X)HTML and the search terms will be highlighted in the text.
This works fast, also on multi-row pages. Ctx_doc can only highlight a single row at a time.

Go to See the other 2 answers

Performing filtering, highlights or markups on searches

Category:DefaultRelease time:-0001-11-30Views:130

Greetings, I have developed a content management system which stores, searches etc a table containing different kinds of electronic documents stored as BLOBs. I am trying to integrate into the search function the ability to display a hundred or so ch[More]

Highlighted words in the search feature in mail

Category:DefaultRelease time:2015-10-11Views:130

hi all, ok, maybe i am going crazy, but in mail under tiger, i thought i use to be able to see any searched word highlighted in the messages mail found containing that word. now when i perform a search in mail under leopard, the searched for word is[More]

Bing does not appear in add ons or in the search engine list or control panel, in fact there is no reference to it on my computer, yet still, it has hijacked my search and the normally very useful 'highlight, right click, open search in a new tab'

Category:DefaultRelease time:-0001-11-30Views:130

Bing does not appear in add ons or in the search engine list or control panel, in fact there is no reference to it on my computer, yet still, it has hijacked my search and the normally very useful 'highlight, right click, open search in a new tab'Ins[More]

Performance restrictions using User-Defined Message Search in PI 7.1 EhP1

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, We want to apply the User-Defined Message Search in our productive system. We also want to set the extractors to run during Message Processing . Do you have any inputs on how this might affect the system performance? Any best practices, pre[More]

How do I keep from highlighting terms in the search bar when I modify a string in the search bar--other than by clicking three to five times?

Category:DefaultRelease time:2015-10-11Views:130

I'm not talking about terms in the search results; I'm talking about terms in the search string in the search bar in the upper right corner. (Mine is set to use only Google.) When I've searched on a string and decide to modify the string for a second[More]

When I used to highlight words- Right click- "Search google for ...." it used to open the search in a new tab while keeping current page. Now, the search opens in the current tab as well as a new tab. Is there any way to revert this back?

Category:DefaultRelease time:2015-10-11Views:130

Searching google on highlighted wordsStart Firefox in <u>[[Safe Mode]]</u> to check if one of the extensions or if hardware acceleration is causing the problem (switch to the DEFAULT theme: Firefox (Tools) > Add-ons > Appearance/Themes).[More]

Performance impact of Content based message search in IE

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, I am working on implementing Content based message search in IE in PI 7.0 and PI 7.1 landscape. All the configurations are done and its working fine in Development scenario. I need help in identifying , how this actually works on techn[More]

Read waveform file from .mat file and perform filtering

Category:DefaultRelease time:2015-10-11Views:130

I have a sample waveform stored in matlab (.mat) and would like to perform various filtering after reading it. I am able to read and view the the waveform on a Waveform graph, but unable to do any filtering. Can somebody help suggest a way to read th[More]

How do I turn off the keyword highlighting in my MSDN search results?

Category:DefaultRelease time:-0001-11-30Views:130

Whenever I do a search, all my keywords get highlighted in the returned results with no evident way to turn off the highlighting.  I can't stand looking at the results with all that ridiculous highlighting!! How do I turn the highlighting OFF ???? Ch[More]

Hit Highlighting in PDF Web Search

Category:DefaultRelease time:-0001-11-30Views:130

In Acrobat Reader 9, under Edit > Preferences > Search, "Enable search highlights from external highlight server" option is by default set to false. For those of us who use third party search engines to search PDF files on the web, this is[More]

Filtering non required updates from Search Folder

Category:DefaultRelease time:-0001-11-30Views:130

I wish to create a Search Folder for software updates that filters the updates on product, severity, whether it has been superseded or not, whether it has expired and also if it is required or not. I have managed to create the first four steps fine,[More]

Hot
In the Springfield, Virginia Verizon Store at 6432 Springfield Plaza, on September 22, 2014 I upgraded 3 phones that were no longer under contract.  It was clear that I would not receive or activate the new iPhones until they arrived on October 14, 2 [More]
Here's what happened... I hooked the Nano up to my computer at work to listen to it & charge it, but could not click on any of the music. Somehow I ended up with a prompt to "update the library" with a "yes" or "no" choic [More]
Hi all, I'm facing serious problems after the migration from jdev 11.1.1.0 version to new release 11.1.1.1.0, as i published with a sample at Problems with create new record o in JDev 11 R1 is this a big bug in the ide? Should i return to previous ve [More]
Dear All, For one of my fields of screen I have been calling a search help configured using F4IF_INT_TABLE_VALUE_REQUEST. In this function I am returning the field in dynfields. Let me know please how to change the Labels of Field Names being shown i [More]
What exactly is a signature? I know how to use it, but I am interested in more detail. Is it a separate entity from the email body? Is it just pasted into the body? Why are there problems sometimes, such as in an older version of mail, if there was a [More]
I just purchased an downloaded the Assassin's Creed game for my iPod Touch. After searching the net and Apple support I haven't found anyone else with this problem so I decided to ask here. After downloading and syncing, the "game" only plays a [More]
Dear SAP, I wanted to copy a standard bapi into Zbapi. As soon as i do this it is asking for access key. Is it ok to use the access key and create?? Is there any exit to do this ? Please help me in this regard. The Bapi name  /AFS/BAPI_SALESORD_CREAT [More]
i'm trying to complete the software update but i keep receiving the message 'the feature you are trying to use is on a network resource that is unavailable'. however, i have attempted to uninstall the programs and i am also receiving an error message [More]
Hi this issue has been occurring for the longest time. Sometimes when I calibrate my display or switch color profiles in system preferences and scroll up or down in Iphoto either (Events or Albums) A very bright distorted white and pinkish color will [More]
Don't know if there are flash inside because I can't see the full page and started a kernel panic. OS 10.6.4 + Safari 5.0.3 (6533.19.4) Since I'm using Firefox, no panics until now.Hi, OS 10.6.4 Update your system software. Click the Apple () menu / [More]