Hi alll 
I want to create index on Abstract Field ...Just like the capability of
Oracle InterMediaText in which Themes can be generated using any of the
field.... 
Example of oracle InteMedia Text is 

SQL> create table DSpace 
(id          number Primary Key, 
 Abstract varchar2 (5000) 
) 
/ 

Table created. 

SQL> create table mythemes 
(Qry_id          number Primary Key, 
 Theme varchar2 (1500) 
Weightage  number 
) 
/ 
Table created. 

Inserting data into table 

SQL> Insert into DSpace (id, Abstract 
(01, 
‘Go to your favourite web search engine, type in a frequently occurring word
on the internet like “database”, and wait for plethora of search result to
return.’ 
) 
/ 
1  Row created. 

SQL> commit; 
Commit complete 



Index Creation 
SQL> Create index my_idx on DSpace (Abstract) indextype is ctxsys.context; 
    Index created 

PL/SQL Procedure 
SQL> Begin 
Ctx_doc.theme(index_name => ‘my_idx’, 
                            textkey        =>  ‘1’, 
                           restab           => ‘mytheme’ 
); 
end; 
/ 

PL/SQL Procedure successfully completed. 

View the themes with weight 

occurrences                                                            12 
search engine                                                         12 
internet                                                                  
11 
result                                                                      
11 
returns                                                                   
11 
databases                                                                11 
searches                                                                  10 
favouritism                                                              6 
type                                                                          
5 
plethora                                                                   
4 
frequency                                                                 3 
words                                                                       
3 



I want to create theme it in DSPACE.. 



--
View this message in context: 
http://dspace.2283337.n4.nabble.com/Theme-Generation-in-DSPACE-tp4662036.html
Sent from the DSpace - Devel mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel

Reply via email to