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
I spent years of frustration using a PC and hearing Mac users telling me how they never have issues with their computers. In January, I finally broke down and spent more than $4,000 on a Mac OS X, Version 10.5.2 with the following installed: Processo [More]
I must be very stupid (admitted) but I cannot get Hello to work for me. Where do I put the email adddress of a person I wish to contcact.Hi Brad, I really appreciate your taking the effort to help - I must be the greatest of idiots or someting is wro [More]
I am evaluating the new Photoshop CS4 (it is purchased copy and not running on the 30 day trial) and have run into a problem in using Bridge CS4. I am able to open an image using Photoshop's File Open command BUT when I attempt to do so in Bridge I g [More]
We have two Motorola QIP7232 2 DVR/Receivers. Since we got them back in March of 2012 we have had sporadic issues where programs that show to be recorded (30 minutes, 60 minutes, etc), won't play back.  The DVR simply reverts back to live TV as if we [More]
Hello guys, Yesterday, a customer camed to me asking if I can connect his standard BH-803 bluetooth handsfree to his 8800 Saph. phone, telling me that he tried and tried after the manuals but nothing... I took the operations in my hands... The blueto [More]
Well I the problem of ads not showing up for a few weeks now and miraculously i republished my pages today and now all the ads work! it seems that the servers are in working order. just letting people know who i know were really frustratedits a seaga [More]
Hi experts, we are planning to use the TAXINN procedure in our rollout project but the existing system doesn't have the all E CESS, S&HE CESS condition types. we just want to know the standard condition types prescribed by the SAP for E CESS, S&HE [More]
Hello, If just hat my N96 software updated and now he resist to restart, he doesn't give any signal at all just "Phone start-up failed.Contact the retailer". What's wrong with it? My N96 has never worked properly, my N95 was better but also not [More]
I have an old PowerPC running 10.4.11 and a Macbook Pro running 10.6.7 sitting side by side. Both are using AirPort to connect to the internet wirelessly to the same wireless router. The old Mac connects with full bars but the MBP struggles with only [More]
I am using IE9. i tried uninstalling,installing.. i have gotten to the install page and it looks like it will work but the box that says installing adobe download manager. Just disappears idk wat to do. nothing will work for me. if you can help TY. Y [More]