1 Reply Latest reply on Aug 28, 2006 3:38 PM by Mannamal-Oracle

    Integration of Oracle RDF and Enterprise Search

    530153
      Hi,
      Has anyone tried integrating Enterprise Search with the new RDF feature to enable true semantic search?
        • 1. Re: Integration of Oracle RDF and Enterprise Search
          Mannamal-Oracle
          It would be interesting to hear from people who have tried this in an application.

          As an FYI, using RDF query capabilities in Oracle, simple PL/SQL code can be written to do this. Consider search based on a query term X. SDO_RDF_MATCH can be used to find all terms related to X in a given ontology/RDF data set. All these terms can then be used in the 'Contains' operator that is part of Oracle Text, to find all documents in a table that contain any of those terms. We have some sample code to do this, if you are interested write to me at melliyal <dot> annamalai <at> oracle <dot> com. Tighter integration is being planned in a future release as well.

          RDF queries can be also combined with other relational queries. An example in Oracle of simple SQL to combine querying RDF with a relational query is as follows:

          SELECT emp1.name, emp1.salary
          FROM emp1, TABLE(SDO_RDF_MATCH(
          '(?name :fatherOf :Matt)',
          SDO_RDF_Models('family'),
          null,
          SDO_RDF_Aliases(SDO_RDF_Alias('','http://www.example.org/family/')),
          null)) t where emp1.name=t.name;

          The father of Matt is found by querying the family model (represented using RDF) using SDO_RDF_MATCH, and his salary is found out by doing a join with the table emp. Since the output of SDO_RDF_MATCH is a table, it can be easily joined with other relational data.