Any help with my question please.
AdeeB
On Mon, Nov 4, 2013 at 1:48 PM, Adeeb Noor <adeeb.n...@colorado.edu> wrote:
> Hi Andy:
>
> Thanks for the response.
>
> My TDB is on my hard drive with 15GB size wise. and my PC is Mac Pro with
> 2.4 GHZ and 4GB of memory.
>
> I was not able to use QueryExecution.execConstructTriples as
> it returnees an iterator and I want to save the subgraph into a new TDB .
> Here is my code below:
>
> FileLoader fileLoader = new FileLoader("src/DDICONSTRUCT.tql");
>
> String q = fileLoader.loadAll();
>
> Query query = QueryFactory.create(q) ;
>
> QueryExecution qexec = QueryExecutionFactory.create(query, data.tdb);
>
>
> Model constructModel = qexec.execConstruct();
>
>
> The program has been running for almost a day now, let me know if there is
> something wrong or if there is an alternative to CONSTRUCT thing.
>
>
>
> On Sun, Nov 3, 2013 at 12:59 PM, Andy Seaborne <a...@apache.org> wrote:
>
>> 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, where
>> the 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
>>>>
>>>>
>>>
>>>
>>>
>>
>
>
> --
> Adeeb Noor
> Ph.D. Candidate
> Dept of Computer Science
> University of Colorado at Boulder
> Cell: 571-484-3303
> Email: adeeb.n...@colorado.edu
>
--
Adeeb Noor
Ph.D. Candidate
Dept of Computer Science
University of Colorado at Boulder
Cell: 571-484-3303
Email: adeeb.n...@colorado.edu
