Yapa 10g version notes
Yapa 10g version notes
Installation
0. Prerequisites
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.
The demo is based on the user "MED". If you want to create "MED", connect
as system (from sqlplus) and run
sql>create user med identified by med;
Then issue the following grants:
sql>grant resource,connect,ctxapp to med;
1. Create the schema
Connect as med (or your own user) and run
sql>@yapact.sql
2. 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
The loader.ctl file looks like:
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)
The loader.dat file looks like:
1;Approach to the Cardiac Patient: Introduction ;a0101076_01.html
2;Approach to the Cardiac Patient: The Cardiovascular History ;a0101076_02.html
...
Remember that the documents are not part of the demo. Other medical collections
available from the web:
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
Make sure you provide the right URLs for the source code and data. For example,
for StretchViewer, it should look something liks:
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
If you are running UNIX, please change the escape character ($ for !).
$loadpsp ... to
!loadpsp ... .
8. Classify the collection
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.
| 
Bookmark
