On 06/11/13 00:31, Adeeb Noor wrote:
Any help with my question please.
AdeeB
On Mon, Nov 4, 2013 at 1:48 PM, Adeeb Noor <[email protected]> wrote:
Hi Andy:
Thanks for the response.
My TDB is on my hard drive with 15GB size wise.
How many triples?
And how much of the DB does the SELECT query match?
What's SELECT (count(*) AS ?c) ....
What's SELECT (count(distinct *) AS ?c) ....
We still know little about your setup.
and my PC is Mac Pro with
2.4 GHZ and 4GB of memory.
Java 32 bit or 64 bit?
I was not able to use QueryExecution.execConstructTriples as
it returnees an iterator and I want to save the subgraph into a new TDB .
Why is that a problem? Add them to a TDB database.
Or even use a SPARQL Update operation.
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 <[email protected]> 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 <[email protected]>
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 <[email protected]> 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: [email protected]
--
Adeeb Noor
Ph.D. Candidate
Dept of Computer Science
University of Colorado at Boulder
Cell: 571-484-3303
Email: [email protected]
