Working Group Assignment #4.

(Recommended working time for this assignment are: Thursdays 24.10.02 and 31.10.02 during the lab periods. ) Write answers and show all input and output in a Word document. Send it to Judith as an attachment to email.

The Case Study Example in the following article is reproducable on our database. http://otn.oracle.com/products/oracle9i/daily/nov30.html

Part I.

Reproduce the Case Study Example and (4) select statements. 
create table proceedings (tk number, papers sys.XMLTYPE);
insert into proceedings(tk,papers) values (1, sys.XMLType.createXML(
'<?xml version="1.0"?>
<paper>
<title> Accelerating Dynamic Web Sites using Edge Side Includes </title>
<authors>Soo Yun and Scott Davies </authors>
<company> Oracle Corporation </company>
<abstract> The main focus of this presentation….include entire abstract. </abstract>
<track> Fast Track to Oracle9i  </track>
</paper>'));
create index proc_idx on proceedings(papers) indextype is ctxsys.context;

Part II.

Drop the table and index. Recreate the table. Insert (5) five different papers in the proceedings table such that they fit into (2) two different tracks.

Demonstrate path selection searching using the INPATH operator such that you have (2) select statements that search for data in "abstract" and display the "title" in the hitlist. The (2) two statements must show:

(I have removed the attribute searching because our input data did not use attributes in the tags. Otherwise this would have worked. - Judith (after lab 26.10.02)

These are described in section 6-16 of the Oracle Text Application Developer's Guide.

Last question: If you moved Track name up above the <title> tag, how would you change the select statements? Rewrite the 2 select statements in Part II. You do not acctually have to implement this.