Hi Alan,
I wasn't using Attachment. I followed your instructions and it worked!
Thanks.

I have a few more follow up questions.

1. If I call create_entailment on my model, does that result in faster execution of the query? Does the attachment code create the OWLPrime entailment on the fly? I would prefer to build the entailment in the database rather than doing it on the fly.

2. Where is the documentation for the Attachment class?

3. Can I use Attachment with my own set of rules? If so, can you provide some pseudo-code for loading a rule set from a file?

Thank you.

thanks Alan. I'll give it a try.

Hi Alan,
I'm having a bit of trouble using my rule. First, I created my rule by executing the following commands from SQL*PLUS:

execute sem_apis.create_rulebase('user_rulebase');

INSERT INTO mdsys.semr_user_rulebase VALUES ('obo_has_part',
'(?whole <http://www.w3.org/2000/01/rdf-schema#subClassOf> ?sub) (?sub <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://www.w3.org/2002/07/owl#Restriction>) (?sub <http://www.w3.org/2002/07/owl#onProperty> <http://www.obofoundry.org/ro/ro.owl#has_part>) (?sub <http://www.w3.org/2002/07/owl#someValuesFrom> ?part)', NULL, '(?whole <http://www.obofoundry.org/ro/ro.owl#has_part> ?part)', null);

Now I am trying to use the following code to execute my new rule along with the OWLPRIME rules from Java:

...
String[] rulelist = new String[2];
rulelist[0] = new String("OWLPRIME");
rulelist[1] = new String("USER_RULEBASE");

Attachment attachment = Attachment.createInstance(
Attachment.NO_ADDITIONAL_MODELS, rulelist,
InferenceMaintenanceMode.NO_UPDATE,
QueryOptions.DEFAULT);
...
graph.performInference();
graph.analyzeInferredGraph();


I am seeing the following output and errors:

INFO [main] (SimpleLog.java:49) - performInference: has valid entailment already
INFO [main] (SimpleLog.java:49) - Final clause = SELECT part$RDFVTYP, part$RDFLTYP, part$RDFLANG, part$RDFCLOB, decode(part$RDFVTYP, 'BLN', ('_:'||substr(part,instr(part,'m',4)+1)), part) part, whole$RDFVTYP, decode(whole$RDFVTYP, 'BLN', ('_:'||substr(whole,instr(whole,'m',4)+1)), whole) whole FROM table(sdo_rdf_match('(?whole <http://www.obofoundry.org/ro/ro.owl#has_part> ?part) ', sdo_rdf_models('NEURON_ONTOLOGY'), sdo_rdf_rulebases('OWLPRIME','USER_RULEBASE'), null, null, null))
Error: rethrew: java.sql.SQLException: ORA-20000: We do not have a rules index for this Model-Rulebase combination
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 176
ORA-06512: at line 1

Do I need to run sem_apis.create_entailment?

Thanks,
Chuck

Hi Alan,
I call graph.deleteInference and that eliminates the "performInference: has valid entailment already" from my output. However, my rules do not appear to be firing. I dropped my old rule base using the drop_rulebase API call. I then create a new rule base called 'obo_rules' using the create_rulebase API call. I created a simpler rule called obo_test using the following SQL:

INSERT INTO mdsys.semr_obo_rules VALUES ('obo_test',
'(?whole <http://www.w3.org/2000/01/rdf-schema#subClassOf> ?sub)', NULL, '(?whole <http://sw.brainstage.com/has_subclass> ?sub)', null);

Obviously this isn't a very useful rule. All I'm doing is replacing the rdfs:subClassOf with my own property. However, it simplifies my testing.

Using SPARQL and Jena, I can return several records if I select "?whole <http://www.w3.org/2000/01/rdf-schema#subClassOf> ?sub". However, I never return any records if I select "?whole <http://sw.brainstage.com/has_subclass> ?sub". I can select the information on my rule from the mdsys.semr_obo_rules table. The antecedents and consequents look fine.

You asked if I was using 11gR1. How do I check? According to "select * from v$version", I am running 11.1.0.6.0.

Thanks,
Chuck

Hi Alan,
I ran your code and made the following modification:

String queryString =
" SELECT ?s ?o " +
"WHERE { ?s <http://sw.brainstage.com/has_subclass> ?o } ";

No results were returned. If it works for you then obviously it is something on my end. The OWLPRIME rules appear to work correctly. The graph returns transitive relationships according to the OWLPRIME rules. However, it does not recognize my rules. I must be missing an update or a patch. Is there an update that affects the user defined rules? Is there something to check to make sure I am fully up to date? I tried creating the rules using Jena. When I make this call:

OracleUserRuleBase userrb = OracleUserRuleBase.createInstance(oracle, rbName);

I get this error:

java.lang.NoClassDefFoundError: oracle/spatial/rdf/server/ParseException

This makes me think I am not up to date.

Thanks,
Chuck