Re: Store query results in new RDF

Andy Seaborne Sun, 03 Nov 2013 12:00:37 -0800

On 03/11/13 07:05, Adeeb Noor wrote:

Hi Andy:


I did figure it out, however it takes to much time (CONSTRUCT) to finish as
my query is complex. Is that something normal ? in fact, it is still
running

Hard to tell - it depends on many factors such as machine setup, wherethe data is stored, structure and volume of your data


Try

QueryExecution.execConstructTriples

        Andy


AdeeB


On Sat, Nov 2, 2013 at 9:56 AM, Adeeb Noor <adeeb.n...@colorado.edu> wrote:

Hi Andy:

Thanks for the quick response. I tried CONSTRUCT and it did work out. But
how can I reformat such a query to CONSTRUCT one:

SELECT DISTINCT *

  {

   ?ddi ddids:has_association ?c .

  ?ddi ddids:has_association ?c2 .

?c ddids:chemical_or_drug_affects_gene_product ?omim .

?omim ddids:gene_product_encoded_by_gene ?g .

?g ddids:gene_plays_role_in_process ?w .

?g ddids:gene_plays_role_in_process ?bp .

?bp ddids:process_involves_gene ?g2 .

?g2 ddids:gene_plays_role_in_process ?bp2 .


where I need each variable ( for example ?w, ?bp , etc) to be a new
resources.

Thanks


On Sat, Nov 2, 2013 at 6:41 AM, Andy Seaborne <a...@apache.org> wrote:

You need to use a CONSTRUCT query, not a SELECT one.

outputAsRDF encodes the result set (i.e. the table) as RDF - it is not
the datamodel of the original data.

CONSTRUCT allows you to create one RDF graph from data from another.

See also SPARQL Update for doign that from one graph to another in the
same database.

         Andy


On 02/11/13 05:35, Adeeb Noor wrote:

Hi guys:

I would like to save my SPARQL result coming from ResultSet into new rdf.
(new rdf resources) cause I want to do more work on this subgraph and it
has to be in the original rdf format.

I tried outputAsRDF function and it worked however the result I got the
following:

<rdf:Description rdf:nodeID="A5">
      <rs:value rdf:resource="
https://csel.cs.colorado.edu/~noor/Drug_Disease_ontology/
DDID.owl#genotypePhenotype
"/>
      <rs:variable>omimt</rs:variable>
    </rdf:Description>
    <rdf:Description rdf:nodeID="A6">
      <rs:value rdf:resource="
https://csel.cs.colorado.edu/~noor/Drug_Disease_ontology/
DDID.rdf#C0007589
"/>
      <rs:variable>w</rs:variable>
    </rdf:Description>
    <rdf:Description rdf:nodeID="A7">
      <rs:binding rdf:nodeID="A8"/>
      <rs:binding rdf:nodeID="A9"/>
      <rs:binding rdf:nodeID="A10"/>
      <rs:binding rdf:nodeID="A11"/>
      <rs:binding rdf:nodeID="A12"/>
      <rs:binding rdf:nodeID="A13"/>
      <rs:binding rdf:nodeID="A14"/>
      <rs:binding rdf:nodeID="A15"/>
      <rs:binding rdf:nodeID="A16"/>
      <rs:binding rdf:nodeID="A17"/>
      <rs:binding rdf:nodeID="A18"/>
      <rs:binding rdf:nodeID="A19"/>
      <rs:binding rdf:nodeID="A20"/>
      <rs:binding rdf:nodeID="A21"/>
      <rs:binding rdf:nodeID="A22"/>
      <rs:binding rdf:nodeID="A23"/>
      <rs:binding rdf:nodeID="A24"/>
      <rs:binding rdf:nodeID="A25"/>
      <rs:binding rdf:nodeID="A26"/>
      <rs:binding rdf:nodeID="A27"/>
    </rdf:Description>

how I can remove this nodes things and make it something like:

   <rdf:Description rdf:about="
https://csel.cs.colorado.edu/~noor/Drug_Disease_ontology/
DDID.rdf#C3229174">
      <j.0:label>Cytra-K Oral Product</j.0:label>
      <rdf:type rdf:resource="
https://csel.cs.colorado.edu/~noor/Drug_Disease_ontology/
DDID.owl#chemical
"/>
    </rdf:Description>

please help me out



--
Adeeb Noor
Ph.D. Candidate
Dept of Computer Science
University of Colorado at Boulder
Cell: 571-484-3303
Email: adeeb.n...@colorado.edu

Re: Store query results in new RDF

Reply via email to