Enabling Oracle 11G Semantic Indexing with IntuScan Server

Hi All,

Again some one some where feel's ,Why this person updating blog's single day with lot of posts , Actually i am very lately realized that blogs are the in-direct Repository for the person.

SAME STEPS HAVE BEEN PERFORMED WHICH MENTIONED IN THE DOCUMENT:::

1. Alter user mdsys identified by password123 account unlock;

2. Create tablespace sem_users datafile '/u12/oradata/SIGMAD/oradata/sigmad/sem_users01.dbf' size 128M reuse auto extend on next 64M maxsize unlimited segment space management auto;

3. Create temporary tablespace sem_temp tempfile /u12/oradata/SIGMAD/oradata/sigmad/sem_temp01.dbf' size 128M reuse autoextend on next 32M maxsize unlimited;

4. begin sem_apis.create_rdf_network('sem_users'); end; 

 

The above output has been given when running from terminal.

The same when tried from sql developer executed the command.

5. create user sem_user identified by sem_user default tablespace sem_users temporary tablespace sem_temp;

6. grant create session, create any directory, resource to sem_user;

Created the user sem_user/sem_user.

8. create table ont_data (id number, triple SDO_RDF_TRIPLE_S);

9. execute sem_apis.create_sem_model('ont_model', 'ont_data', 'triple');

10. create table stable(RDF$STC_sub varchar2(4000) not null, RDF$STC_pred varchar2(4000) not null, RDF$STC_obj varchar2(4000) not null, RDF$STC_sub_ext varchar2(64), RDF$STC_pred_ext varchar2(64), RDF$STC_obj_ext varchar2(64), RDF$STC_canon_ext varchar2(64));

11. grant insert on ont_data to mdsys;

12. grant select, update (RDF$STC_sub_ext, RDF$STC_pred_ext, RDF$STC_obj_ext, RDF$STC_canon_ext) on stable to mdsys;

13. create directory "SEM_DIR" as 'c:/temp'; 

 

Before executing this go to the directory

/u10/app/SIGMAD/custom/SIGMA/Ripples/IntuScanRDFExtractor

Open the command line and cd to the IntuScan files directory (the same directory containing this file).

From the command line run the bulk loader utility batch file: bulk_load.bat 

 


 

In SQL Developer open the sem_user connection.

Open and execute the following sql scripts (all found in the IntuScan files directory): SPLIT.sql, EXTRACT_DIR_PATH.sql, EXTRACT_FILE_NAME.sql, READ_FILE.sql, INTUSCAN_EXTRACT_XML.sql, INTUSCAN_EXTRACTOR-body.sql, INTUSCAN_EXTRACTOR.sql

Semantic Indexing

From the sem_user connection run the following commands:

18. execute sem_rdfctx.create_policy(policy_name => 'intuscan', extractor=> intuscan_extractor(null),preferences => sys.xmltype('<RDFCTXPreferences><Datastore type="FILE"><Path>SEM_DIR</Path></Datastore></RDFCTXPreferences>'));

19. execute sem_rdfctx.create_policy(policy_name => 'intuscan2', base_policy => 'intuscan', user_models => SEM_MODELS('ont_model'));

20. create table sources (id number, path varchar2(1024));

21. create index sem_index on sources (path) indextype is mdsys.semcontext parameters ('intuscan2');

The below has not been done as it require some changes.

22. execute sem_apis.create_entailment('sem_ent', SEM_Models('ONT_MODEL', 'RDFCTX_MOD_'), SEM_Rulebases('RDFS'));

 Regards,
naga.