3 Ответы Последний ответ: 13.06.2008 14:57, автор: alwu-Oracle

    about benchmark

    609674
      Hi all,

      last week,I downloaded the Lehigh University Benchmark (LUBM) ,generated some data and loaded the data into Oracle. At first, like the SQL 1, I put a department into triple pattern as a filter.than ran it, I couldn't get the result.
      So, I put the department into where clause like the second SQL. it's a very strange,I could get the result actually.
      for checking my mind, I ran the third SQL, I could also get the data that property is worksFor and object is <http://www.Department0.University0.edu> a URI.
      I'm sorry I always have so many questions, but I still want to know why so this?

      select *
      from TABLE
      (SEM_MATCH('
      (?X ub:worksFor <http://www.Department0.University0.edu>)
      ',
      SEM_Models('BENCHMARK'),null,
      SEM_Aliases(SEM_Alias('rdf','http://www.w3.org/1999/02/22-rdf-syntax-ns#'),
      SEM_Alias('ub','http://www.lehigh.edu/~zhp2/2004/0401/univ-bench.owl#')),
      null)
      )


      select *
      from TABLE
      (SEM_MATCH('
      (?X ub:worksFor ?o)
      ',
      SEM_Models('BENCHMARK'),null,
      SEM_Aliases(SEM_Alias('rdf','http://www.w3.org/1999/02/22-rdf-syntax-ns#'),
      SEM_Alias('ub','http://www.lehigh.edu/~zhp2/2004/0401/univ-bench.owl#')),
      null)
      )
      where o='http://www.Department0.University0.edu'

      select t.triple.get_triple() from benchmark t
      where to_char(t.triple.get_object()) ='<http://www.Department0.University0.edu>'


      Steven
      June 11,2008
        • 1. Re: about benchmark
          alwu-Oracle
          Sounds very strange. Here is my test. I merely changed the model name.

          SQL> list
          1 select *
          2 from TABLE
          3 (SEM_MATCH('
          4 (?X ub:worksFor <http://www.Department0.University0.edu>)
          5 ',
          6 SEM_Models('lubm'),null,
          7 SEM_Aliases(SEM_Alias('rdf','http://www.w3.org/1999/02/22-rdf-syntax-ns#'),
          8 SEM_Alias('ub','http://www.lehigh.edu/~zhp2/2004/0401/univ-bench.owl#')),
          9 null)
          10 )
          11*
          SQL> /

          X
          --------------------------------------------------------------------------------
          X$R
          ---
          http://www.Department0.University0.edu/AssociateProfessor6
          URI

          http://www.Department0.University0.edu/AssistantProfessor4
          URI
          ....


          Exactly how did you insert the data into Oracle 11g RDF/OWL store?
          • 2. Re: about benchmark
            609674
            Hi alwu,

            Thanks a lot, I have found the way, that is I forgot a patch for bulk data loading.


            Now,the problem has been fixed.


            Steven
            June 13,2008
            • 3. Re: about benchmark
              alwu-Oracle
              Yep. That patch is required.