Oct. 17, 2002

W3: This is the 3rd working group assignment. There are parts (1)-(4) in 
this assignment. Put your answer to parts (3) and (4) only 
in a .txt file and send it in email to j.molka-danielsen@himolde.no

Reminder that the Oracle documentation that is on our web page or on the web.
(These are: http://otn.oracle.com/products/text/ or 
http://otn.oracl.com/forums/text.html or others found on google.com)

Parts
------
(1) Log into oracle using
	userid= your-group-userid
	password= you-know-it
	SID=	textdb  
	
	Use the SqlPlus application the first time you log in.
	It should prompt you to change your password. Change your password.
	Then you can choose to use SqlPlus Worksheet.

-------
(2) Repeat the steps that were outlined in W2. 
	Make sure that the URL that you use is to your own path.  
	Instead of doing one "insert", you should insert "5" small text files.

(*---These are sql statements----------------------------------------*)
exec ctx_ddl.create_preference('mygrpurl','URL_DATASTORE');

(*-The drop statements are only needed if you have previously created something.-*)
drop index mygrpindex;
drop table mygrptable;
create table mygrptable(id number primary key, docs varchar2(2000));
   
(*-Move a .txt file into your /html directory.-*)

insert into mygrptable values(1103,'http://home.himolde.no/~molka/sometext.txt');

create index mygrpindex on mygrptable (docs )
  indextype is ctxsys.context
    parameters ('DATASTORE mygrpurl');
 
------
(3) Use a "select" statement with a "score" operator so that you get a score=100
for a returned document in a word query. Show the search and response in your answer file.
    
(*-This is an example of a "select" statement.-*)
select  id,docs,score(1) from mygrptable where contains (docs,'Clouds',1)>0;
------
(4) Write one example of a "select" statement for each of the following operators.
	So you should have 4 statements, and 4 hits lists.
	- NEAR (This deomonstrates proximity search)
	- ABOUT (This demonstrates relevancy on concepts.)
	- choose one of any boolean operators (AND,OR,...)
	- fuzzy (This allows for misspellings and variations on character order in 
		 strings.You can try several of these. Note that on a fuzzy search
		 if I spell "clouds" as "cloud","clouded","cloudy",or "clousd" that
		 I will get different "scores" on my hit set.)
		 
    For this part, only show me the statements and the outputs in your answer text file.  
--------