Yapa 10g version notes

Installation

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:

• Your Oracle database 10gis up and running.
• You have the Oracle PL/SQL gateway running (CD #2).
• You have a web server such as Apache up and running and correctly configured to send requests to the Oracle9i server.

sql>create user med identified by med;

sql>grant resource,connect,ctxapp to med;

Connect as med (or your own user) and run

sql>@yapact.sql 

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

...

• PubMed
• National Guideline Clearinghouse
• The Brown Lab

3. Load the categories

For this demo we are using a subset of Medical Subject Headings or MeSH.

sql>@yapald.sql

4. Create the indexes

sql>@yapaci.sql

5. Load the visualizations

sql>@yapalv.sql

insert into yvis values(5,'Categories','sv','http://oalonso-lnx.myserver-name.com:7777/classes_g/','http://oalonso-lnx.myserver-name.com:7777/pls/med/',0);

6. Cluster creation

sql>@yapacc.sql

7. Make the source code

sql>@make.sql

$loadpsp ...

!loadpsp ...

sql>exec yapautil.classifyDocs;

sql>commit

9. 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 Oracle10g server and returns server output to the browser.

In 9i there is used to be an interface available from the browser (http://yourlocalhost:7778 for NT, http://yourlocalhost:7777 for UNIX). In 10g, you have to manually create a dad configuration.

Please open the dads.conf file on the $ORACLE_HOME_CD2/Apache/modplsql/conf directory. Just follow one of the examples and make changes according to your settings.

See your web server documentation for more details.

10. Copy the images directory to Apache/images

If you don't have an images directory, create one under Apache/htdocs.

11. Copy the ThemeStar visualization

Copy the ThemeStar.class file to Apache/htdocs directory.

Finally, open browser and point to http://localhost:port/path/yapa

Here are screenshots that shows Yapa in action.