Web Query Application Overview

A common use of Oracle Text is to index HTML files on Web sites and provide search capabilities to users. The sample application in this appendix indexes a set of HTML files stored in the database and uses a Web server connected to Oracle Database to provide the search service.

This appendix describes two versions of the Web query application:

  • One using PL/SQL Server Pages (PSP)

  • One using Java Server Pages (JSP)

Figure A-1 shows what the JSP version of the text query application looks like.

Figure A-1 The Text Query Application

Description of
Description of "Figure A-1 The Text Query Application"

Figure A-2 shows the results of the text query.

Figure A-2 The Text Query Application with Results

Description of
Description of "Figure A-2 The Text Query Application with Results"

The application returns links to documents containing the search term. Each document has four links:

  • The HTML link displays the document.

    Graphics are not displayed in the filtered document. (You can see the source document for the first hit by looking at Figure 5-1.)

  • The Highlight link displays the document with the search term highlighted. Figure 5-2 shows an example of highlighting.

  • The Theme link shows the top 50 themes associated with the document. Figure 5-3 shows an example of theme extraction.

  • The Gist link displays a short summary of the document. Figure 5-4 shows an example of this gisting feature.