The current version of Yapa is a mix of PSP (PL/SQL Server Pages) and PL/SQL. A Java version will be available soon. The demo has the following requirements:
sql>create user med identified by med;
sql>grant resource,connect,ctxapp to med;1. Create the schema
Connect as med (or your own user) and run
sql>@yapact.sql2. Load the documents.
Unfortunately due to copyright issues we can't post the content as part of the demo. We'll store the documents in the CLOB column of the table med_table. We use SQL*loader for loading content:
$ sqlldr userid=med/med control=loader.ctl
LOAD DATA INFILE 'loader.dat' INTO TABLE med_table REPLACE FIELDS TERMINATED BY ';' (tk INTEGER EXTERNAL, title CHAR, text_file FILLER CHAR, text LOBFILE(text_file) TERMINATED BY EOF)
1;Approach to the Cardiac Patient: Introduction ;a0101076_01.html 2;Approach to the Cardiac Patient: The Cardiovascular History ;a0101076_02.html ...
3. Load the categories
For this demo we are using a subset of Medical Subject Headings or MeSH.
4. Create the indexes
5. Compile the ctx_cluster package
6. Make the source code
!loadpsp ...7. Classify the collection
sql>exec yapautil.classifyDocs; sql>commit
8. Setting the Mod_plsql from Apache
You must configure your web server to accept client PSP requests as a URL. Your web server forwards these requests to the Oracle9i server and returns server output to the browser.
Go to your HTTP page (http://yourlocalhost:7778 for NT, http://yourlocalhost:7777 for UNIX)
See your web server documentation for more details.
9. Copy the images directory to Apache/images
If you don't have an images directory, create one under Apache/htdocs.
Finally, open browser and point to http://localhost:port/path/yapa
Here are screenshots that shows Yapa in action.