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
Hi,   In SRM Dev system I have created a Change request (Transport Request) and released to the QA system.The Change request has imported successfully to the SRM QA system. Now the Case is: The Released Request in the SRM Dev system has to be Export [More]
I've tried several times downloading iTunes, each and every time it tells me there is an "uspecified error". I don't know what the error is because I just bought my laptop today so I do not have any cookies or bad files in database. How can I so [More]
Is there a way i can make my primary key updatable in a tabular form. I have two tables one called proposal details and one called student current details. Bascially you select one of your proposal details to become your current project this is done [More]
Hi there No too long ago I purchased Dreamweaver 8 and I am currently designing a website for an organisation but I am having diffculties setting up the Access Database..I have no problem with connecting Dreamweaver 8 to the database. So in order to [More]
Hi, always after succes saving of my package, developer show me similar logging page: SEVERE 427 0 oracle.javatools.db.plsql.PlSqlDerivedPropertySupport$PlSqlDerivedPropertyBuilder Build of property blocks failed: null SEVERE 426 332197 oracle.javato [More]
Hi, When I create a new page as a copy of an existing page with page authorization set to some authorization scheme, the newly created page does not work. When I edit the page definition, "Authorization Scheme" is set to some random number inste [More]
Hi all, I am facing following problem: we have exchange the Team Viewer by the Team Explorer (EP 6.0). It is working quite fine. The only thing is the Team Explorer is not expanded to its full width when the user calls it for the first time. I have f [More]
Hi, The workflow I am working on requires sending of a notification email to the administrator. For that I have been asked to use the Object type as “SELFITEM” and method as “SENDTASKDESCRIPTION”. 1) Can anyone give me the documentation that automati [More]
Hello world , sorry if my englsih is bad I've installed Plymouth on my laptop (Lenovo Thinkpad Edge E330, with intel GPU) but i've a display problem with every themes of plymouth , le screen is black with 3 white dots. My /etc/default/grub is : GRUB_ [More]
Dear Experts, while i am creating sale order with excise condition i can see assigment of tax code , this tax code how we can assign  with  condition type.? or how it is comming in sale order? 1. I have not maintained  tax code in condition record as [More]