Re: Limit memory usage of Fuseki server?

2018-02-06 Thread Mikael Pesonen
so it is not the system killing Fuseki, its the JVM exiting. With a single TDB, 12G is way too much heap (try 2G) but the figure may include mapped files.     Andy On 06/02/18 09:56, Mikael Pesonen wrote: Hi, ok I'll try that. I had out of memory error on other server now. Is there

Re: Limit memory usage of Fuseki server?

2018-02-06 Thread Mikael Pesonen
so it is not the system killing Fuseki, its the JVM exiting. With a single TDB, 12G is way too much heap (try 2G) but the figure may include mapped files.     Andy On 06/02/18 09:56, Mikael Pesonen wrote: Hi, ok I'll try that. I had out of memory error on other server now. Is there

Re: Fuseki errors with concurrent requests

2018-02-06 Thread Mikael Pesonen
ent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) On Jan 24, 2018, at 10:31 AM, Mikael Pesonen wrote: And running the test set with 1 concurrent loop, it

Re: Limit memory usage of Fuseki server?

2018-02-06 Thread Mikael Pesonen
) and monitor how your VM responds Sent: Tuesday, February 06, 2018 at 9:22 AM From: "Mikael Pesonen" To: users@jena.apache.org Subject: Re: Limit memory usage of Fuseki server? Hi, config.ttl is defaut, Fuseki is ran as service, here is the log from around the kill (notice

Re: Limit memory usage of Fuseki server?

2018-02-06 Thread Mikael Pesonen
memory it wants. You can do this with cgroups. Sent: Monday, February 05, 2018 at 12:56 PM From: "Mikael Pesonen" To: users@jena.apache.org Subject: Limit memory usage of Fuseki server? We have a cloud server with 4gb of memory and after a while system is killing Fuseki server j

Limit memory usage of Fuseki server?

2018-02-05 Thread Mikael Pesonen
www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-0013

Re: Fuseki errors with concurrent requests

2018-01-30 Thread Mikael Pesonen
Fuseki?     Andy On 30/01/18 09:28, Mikael Pesonen wrote: Hi, My test is dependent of REST API we developed. So basically simultaneous calls to Apahe web server which loads php which calls Fuseki using curl. On 29.1.2018 16:56, ajs6f wrote: That might be worth trying, although since TDB1 i

Re: Fuseki errors with concurrent requests

2018-01-30 Thread Mikael Pesonen
of updates should be going on on the server-side. I haven't had time to look at this issue, and it's difficult to say much without a reproducible phenomenon. Do you either of y'all have test code we can use to demonstrate this? ajs6f On Jan 29, 2018, at 5:43 AM, Mikael Pesonen

Re: Fuseki errors with concurrent requests

2018-01-29 Thread Mikael Pesonen
4) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) On Jan 24, 2018, at 10:31 AM, Mikael Pesonen wrote: And running the test set with 1 concurrent loop, it was repeated 1 times without errors. So error occ

Re: Concurrency with Jena/GSP

2018-01-25 Thread Mikael Pesonen
e it is an MRSW lock so visibility is atomic unless you have some quite complex multi-dataset setup with shared models. What's behind the question? Andy On 24 January 2018 at 08:35, Mikael Pesonen wrote: Sorry meant to ask, if I POST a large dataset, is it possible that reader g

Re: Fuseki errors with concurrent requests

2018-01-24 Thread Mikael Pesonen
en we don't know what is supposed to happen. ajs6f On Jan 24, 2018, at 10:26 AM, Mikael Pesonen wrote: Hi, I have a test script running 10 concurrent CRUD operations in a loop. After few operations I get HTTP error 500 and these are in fuseki server output. Am I doing something wrong here?

Re: Fuseki errors with concurrent requests

2018-01-24 Thread Mikael Pesonen
going wrong when we don't know what is supposed to happen. ajs6f On Jan 24, 2018, at 10:26 AM, Mikael Pesonen wrote: Hi, I have a test script running 10 concurrent CRUD operations in a loop. After few operations I get HTTP error 500 and these are in fuseki server output. Am I doing so

Fuseki errors with concurrent requests

2018-01-24 Thread Mikael Pesonen
) -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time z

Re: Concurrency with Jena/GSP

2018-01-24 Thread Mikael Pesonen
Sorry meant to ask, if I POST a large dataset, is it possible that reader gets just some of the triplets but not all? On 24.1.2018 15:25, Mikael Pesonen wrote: I'm using Jena directly with HTTP (curl) and GSP. Are all db opetations atomic? If I PUT large JSON-LD data and rea

Concurrency with Jena/GSP

2018-01-24 Thread Mikael Pesonen
ement www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 H

Re: Getting JSON+LS with GSP

2018-01-05 Thread Mikael Pesonen
anks On 4.1.2018 21:28, James Anderson wrote: good evening, On 2018-01-04, at 15:25, Mikael Pesonen wrote: Thanks, got it working now! This is not Jena related anymore, but any tip how to create an ordered list in JSON-LD format? CONSTRUCT just serializes triplets in unordered fashion. So I

Re: Getting JSON+LS with GSP

2018-01-05 Thread Mikael Pesonen
Hi, so the best way to achieve ordering is to export JSON-LD and reorder the result array in Jena client code and add "@list": true to context. Mikael On 4.1.2018 21:28, James Anderson wrote: good evening, On 2018-01-04, at 15:25, Mikael Pesonen wrote: Thanks, got it w

Re: Getting JSON+LS with GSP

2018-01-04 Thread Mikael Pesonen
:27, Andy Seaborne wrote: JSON-LD is an RDF serialization, and not a SPARQL result set serialization. Make a CONSTRUCT query.     Andy On 03/01/18 10:23, Mikael Pesonen wrote: Hi, I'm making a simple query SELECT * WHERE {    GRAPH ?g    { <https://.../9f6c495c-1f99-4

Getting JSON+LS with GSP

2018-01-03 Thread Mikael Pesonen
ng application/sparql-results+json also. What am I doing wrong? Thanks -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen Syste

Re: Links in JSON-LD

2018-01-03 Thread Mikael Pesonen
Sorry I had a post processing that broke the code, so all good. Thanks, Mikael On 2.1.2018 22:49, Andy Seaborne wrote: Because curl does magic @ or {}?     Andy On 02/01/18 15:59, Mikael Pesonen wrote: Any idea what could be causing these? I'm using curl: $ch = curl

Re: Links in JSON-LD

2018-01-02 Thread Mikael Pesonen
.org/dc/terms/> . _:b0    dc:identifier    "1234" ;     dcterms:subject <https://finto.fi/koko/fi/page/p57158> ;     dcterms:subject <https://finto.fi/koko/fi/page/p57159> .     Andy On 02/01/18 15:06, Mikael Pesonen wrote: Also tried with context {  

Re: Links in JSON-LD

2018-01-02 Thread Mikael Pesonen
<https://finto.fi/koko/fi/page/p57158> ;     dcterms:subject <https://finto.fi/koko/fi/page/p57159> . --- which agrees with the JSON playground. Which version are you using?     Andy On 02/01/18 12:36, Mikael Pesonen wrote: Hi, following JSON-L

Re: Links in JSON-LD

2018-01-02 Thread Mikael Pesonen
    dcterms:subject <https://finto.fi/koko/fi/page/p57158> ;     dcterms:subject <https://finto.fi/koko/fi/page/p57159> . --- which agrees with the JSON playground. Which version are you using?     Andy On 02/01/18 12:36, Mikael Pesonen wrot

Links in JSON-LD

2018-01-02 Thread Mikael Pesonen
;,         "dcterms": "http://purl.org/dc/terms/"; ... add datatype descriptions for dcterms:subject here     } } Thanks -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's

Re: Reading JSON-LD into Jena

2017-12-22 Thread Mikael Pesonen
Awesome, thanks for the tip! On 22.12.2017 13:34, ajs6f wrote: If your HTTP headers are correctly set (Content-type: application/ld+json), Fuseki can read JSON-LD perfectly well. ajs6f On Dec 22, 2017, at 6:26 AM, Mikael Pesonen wrote: Hi, this is not directly related to Jena, but we

Reading JSON-LD into Jena

2017-12-22 Thread Mikael Pesonen
Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Kauppiaskatu 5

Re: Fuseki export and import

2017-12-12 Thread Mikael Pesonen
VERB datasetURI graphName [file] e.g. s-put http://localhost:3030/dataset http://example/graph data.ttl ajs6f On Dec 12, 2017, at 9:58 AM, Mikael Pesonen wrote: Looks like s-get outputs now turtle regardless of file name extension. Is this changed at some point? On 12.12.2017 16:48, ajs6f

Re: Fuseki export and import

2017-12-12 Thread Mikael Pesonen
Looks like s-get outputs now turtle regardless of file name extension. Is this changed at some point? On 12.12.2017 16:48, ajs6f wrote: What is in dump.rdf? You don't show any of your actual data here. Is it JSON? ajs6f On Dec 12, 2017, at 9:46 AM, Mikael Pesonen wrote: Hi,

Fuseki export and import

2017-12-12 Thread Mikael Pesonen
1 column 1 of the JSON data" Tried exporting .ttl and .xml also. This worked before with some older version. Br, -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Te

Re: Insert binary data using SPARQL

2017-12-08 Thread Mikael Pesonen
Thanks, that works! On 8.12.2017 13:41, Andy Seaborne wrote: By using xsd:base64Binary or xsd:hexBinary (and you'll need to encode them IIRC)     Andy On 08/12/17 10:10, Mikael Pesonen wrote: Hi, is it possible to insert few kBs of binary data into Jena (3.5.0) triplet using SPARQ

Insert binary data using SPARQL

2017-12-08 Thread Mikael Pesonen
- E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Kauppiaskatu 5 A FI-20100 Turku FINLAND

Re: Similar results with full text search

2017-11-23 Thread Mikael Pesonen
in ES, so it can also be queried outside Jena. If you had the documents + jena-text indexed metadata in ES, you could use ES facilities for similarity search and still do some things in SPARQL. -Osma Mikael Pesonen kirjoitti 23.11.2017 klo 12:59: Hi Osma! we have a set of documents and

Re: Similar results with full text search

2017-11-23 Thread Mikael Pesonen
37: Hi Mikael! Fuzzy search is a basic Lucene feature, just like prefix searches. You should be able to use it directly via jena-text using a query like ?s text:query "word~" or ?s text:query "word~1" There is AFAICT nothing to implement on the jena-text side as this alre

Similar results with full text search

2017-11-22 Thread Mikael Pesonen
Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Tu

Re: Slow query when getting rdf:type

2017-11-14 Thread Mikael Pesonen
ndy (the overall query counts would be useful as well). On 08/11/17 10:37, Mikael Pesonen wrote: Hi, only opt file is the stats.opt, and I made sure there was not such file before running the tool. Br On 8.11.2017 11:13, Andy Seaborne wrote: Mikael, Did the database directory have a stat

Re: distinct in SPARQL group_concat

2017-11-10 Thread Mikael Pesonen
Thanks, that worked! Br On 7.11.2017 20:31, Andy Seaborne wrote: Try adding a STR: SELECT (group_concat(distinct STR(?o_label_g); separator=", ") as ?o_label) On 07/11/17 14:55, Mikael Pesonen wrote: That is true, but since language tags are stripped from literals in group_c

Re: Slow query when getting rdf:type

2017-11-08 Thread Mikael Pesonen
is "fixed".     Andy -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...

Re: Slow query when getting rdf:type

2017-11-07 Thread Mikael Pesonen
optimize the execution of queries. Any change you would expect to see in behavior will occur at query time. Try your queries again and see if there are changes in the execution times or query explanations. ajs6f Mikael Pesonen wrote on 11/7/17 9:43 AM: Thanks for the help. So outputted stats into

Re: distinct in SPARQL group_concat

2017-11-07 Thread Mikael Pesonen
e but different language tags ar not identical. On Tue, Nov 7, 2017 at 3:34 PM, Mikael Pesonen wrote: Hi, in FOAF schema there are values rdfs:label <https://insight-dev.lingsoft.fi/browse.php?s=http%3A%2F%2Fw ww.w3.org%2F2000%2F01%2Frdf-schema%23label> Agent rdfs:label <h

Re: Slow query when getting rdf:type

2017-11-07 Thread Mikael Pesonen
ent you again. Please read the _entire_ page carefully. Under: http://jena.apache.org/documentation/tdb/optimizer.html#generating-a-statistics-file You will see: "The command line tdbstats will scan the data and produce a rules file based on the frequency of properties. The output should f

distinct in SPARQL group_concat

2017-11-07 Thread Mikael Pesonen
with language labels stripped out of the values? If this works how it should, is there an easy way to remove duplicates? Br, Mikael -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer'

Re: Slow query when getting rdf:type

2017-11-07 Thread Mikael Pesonen
)   (<http://purl.org/dc/terms/type> 1624)   (<http://purl.org/dc/terms/accessRights> 2)   (<http://purl.org/dc/terms/identifier> 78) ... On 30.10.2017 17:10, Andy Seaborne wrote: Mikael, I can't find anything that makes rdf:type special.  Maybe some distribution of data is th

Re: Slow query when getting rdf:type

2017-10-27 Thread Mikael Pesonen
/1999/02/22-rdf-syntax-ns#type> ?type) ) (quadpattern   (quad ?g ?s ?p )   (quad ?g ?s ?p2 ?o2) ))) Are you using inference as well? Is it the same ? Is the timing for the rdf:type variant on a cold system?     Andy On 27/10/17 10:22, Mikael Pesonen wrote: Hi, thanks! I'll try that

Re: Slow query when getting rdf:type

2017-10-27 Thread Mikael Pesonen
10/17 10:22, Mikael Pesonen wrote: Hi, thanks! I'll try that when get chance to stop jena. Yes we are using TDB. On 26.10.2017 16:15, Rob Vesse wrote: Is TDB the underlying database? If so is there a stats.opt  file in your database directory? I remember there being issues in t

Re: Slow query when getting rdf:type

2017-10-27 Thread Mikael Pesonen
er to run this as only a single process is permitted to access a TDB database at a time Rob On 26/10/2017 13:47, "Mikael Pesonen" wrote: Hi, I have trouble understanding why the first query is slow and second one is fast. Using Jena Fuseki 3.4.0. So I

Slow query when getting rdf:type

2017-10-26 Thread Mikael Pesonen
Hi, I have trouble understanding why the first query is slow and second one is fast. Using Jena Fuseki 3.4.0. So I want to get all resources that reference , and their types: SELECT * WHERE { GRAPH ?g { ?s ?p . ?s a ?type } } SELECT

Re: Getting xml with s-get

2017-10-02 Thread Mikael Pesonen
That's right. I guess dump.xml would output XML, haven't tested though. Br On 2.10.2017 15:40, Martynas Jusevičius wrote: Which would mean you were getting Turtle into dump.rdf, not RDF/XML? On Mon, Oct 2, 2017 at 2:37 PM, Mikael Pesonen wrote: That was easily solved once took a

Re: Getting xml with s-get

2017-10-02 Thread Mikael Pesonen
  s-get ... | riot --formatted RDF/XML -- - Syntax is just what goes over the wire - nothign is stored in RDF/XML or Turtle, it's triples.     Andy On 02/10/17 11:18, Mikael Pesonen wrote: Hi Rob, so I make a dump apache-jena-fuseki-3.4.0/bin/s-get https://localhost:3030/ds/ > dump.rdf

Re: Getting xml with s-get

2017-10-02 Thread Mikael Pesonen
17 10:53, "Mikael Pesonen" wrote: Still having problems. Looks like it's not possible to export rdf, edit it, and import back? Jena assumes all input is XML? So how can I import back rdf that is got from s-get? I don't know how to cod

Re: Getting xml with s-get

2017-10-02 Thread Mikael Pesonen
Still having problems. Looks like it's not possible to export rdf, edit it, and import back? Jena assumes all input is XML? So how can I import back rdf that is got from s-get? I don't know how to code Java. Thank you. On 26.9.2017 18:22, Mikael Pesonen wrote: Thanks!

Re: Getting xml with s-get

2017-09-26 Thread Mikael Pesonen
: https://jena.apache.org/documentation/fuseki2/soh.html#soh-sparql-http "file is needed for PUT and POST. The file name extension determines the HTTP content type." ajs6f Mikael Pesonen wrote on 9/26/17 11:04 AM: Related to this, when trying to s-put triple data back to jena, which

Re: Getting xml with s-get

2017-09-26 Thread Mikael Pesonen
ithub.com/apache/jena/blob/master/jena-fuseki2/apache-jena-fuseki/bin/s-get#L29 that remains a TODO. Maybe file a ticket? ajs6f Mikael Pesonen wrote on 9/21/17 9:20 AM: Sorry if this is documented somewhere but could not find info on how to change the output format of s-get command line to

Getting xml with s-get

2017-09-21 Thread Mikael Pesonen
7;s Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Kauppiaskatu 5 A FI-20100 Turku FINLAND

Re: GC overhead limit exceeded with DELETE/INSERT

2017-09-11 Thread Mikael Pesonen
ace on the URIs (perhaps with sed) and then loading back the result. -Osma Mikael Pesonen kirjoitti 11.09.2017 klo 15:35: Hi Osma! I'm currently running jena with param -Xmx3600M. What I read "GC overhead limit exceeded" relates to java garbage collection, so maybe upping memory

Re: GC overhead limit exceeded with DELETE/INSERT

2017-09-11 Thread Mikael Pesonen
given Fuseki? I think the startup scripts default to 1.2GB. Adjusting the -Xmx command line parameter to a more reasonable value (say 4G or 8G) might help. -Osma Mikael Pesonen kirjoitti 11.09.2017 klo 15:23: Hi, I'm performing this replace in jena fuseki 3.0.0 web gui: DELETE { GRAP

GC overhead limit exceeded with DELETE/INSERT

2017-09-11 Thread Mikael Pesonen
-- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone:

Re: 400 Not a file upload

2017-08-30 Thread Mikael Pesonen
Upgraded to version 3.4.0 and now works! Br, Mikael On 30.8.2017 13:22, Andy Seaborne wrote: What does the server log say? Can you upgrade?     Andy On 30/08/17 11:10, Mikael Pesonen wrote: Hi, I'm getting that error from cmd: apache-jena-fuseki-2.4.1/bin/s-update --service

Re: Latest Fuseki standalone server

2017-08-30 Thread Mikael Pesonen
Mikael Pesonen wrote on 8/29/17 8:51 AM: Hi, is 2.4.1 still the latest fuseki-server.jar server? At least it's not included in current apache-jena-fuseki-3.4.0.tar.gz archive. Br, -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Manag

Re: Latest Fuseki standalone server

2017-08-30 Thread Mikael Pesonen
Jena used to maintain separate versioning for the core and for Fuseki2. But no longer! You have the latest version, and you need keep track of only one version number. (Thanks, Andy!) https://issues.apache.org/jira/browse/JENA-1373 ajs6f Mikael Pesonen wrote on 8/29/17 8:51 AM: Hi, is 2.4.1

Re: 400 Not a file upload

2017-08-30 Thread Mikael Pesonen
ad (0 ms) Br Mikael On 30.8.2017 13:22, Andy Seaborne wrote: What does the server log say? Can you upgrade?     Andy On 30/08/17 11:10, Mikael Pesonen wrote: Hi, I'm getting that error from cmd: apache-jena-fuseki-2.4.1/bin/s-update --service=http://:3030/ds/update --file=/tmp/sparql_up

400 Not a file upload

2017-08-30 Thread Mikael Pesonen
ement www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki

Latest Fuseki standalone server

2017-08-29 Thread Mikael Pesonen
d Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Kauppiaskatu 5 A FI-20100 Turku FINLAND

Re: s-update and EOF error

2017-06-09 Thread Mikael Pesonen
14:40, aj...@apache.org wrote: Please show us the actual lines in the file. ajs6f Mikael Pesonen wrote on 6/9/17 6:54 AM: Hi, I'm inserting ~300 triplets from file like this: apache-jena-fuseki-2.3.1/bin/s-update --service=http://xxx.lingsoft.fi:3030/ds/update --file=/tmp/sparql_insert_dat

s-update and EOF error

2017-06-09 Thread Mikael Pesonen
t.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Tur

OntoWiki with Jena

2017-03-14 Thread Mikael Pesonen
Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Kauppiaskatu 5 A FI-20100 Turku FINLAND

Re: Problem with sparql MINUS

2017-01-10 Thread Mikael Pesonen
which is almost certainly not your intent Movingthe earlier pattern that selects specific ?child values of interest inside of the minus likely gives you the results you were after because that puts the two variables in the same scope Rob On 10/01/2017 10:32, "Mikael Pesonen" wrote:

Problem with sparql MINUS

2017-01-10 Thread Mikael Pesonen
ng here. I'm using Jena Fuseki 2.3.1. Thanks, Mikael -- Lingsoft - 30 years of Leading Language Management www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail:

Re: Tools for browsing and editing RDF data

2016-11-08 Thread Mikael Pesonen
le store. > > On 11/8/16, 9:20 AM, "Mikael Pesonen" wrote: > > >Thank you for all the suggestions! Protege is familiar tool so have to >check how it can be customized. I'll check the Datao as well. > >Br,

Re: Tools for browsing and editing RDF data

2016-11-08 Thread Mikael Pesonen
riple store. On 11/8/16, 9:20 AM, "Mikael Pesonen" wrote: Thank you for all the suggestions! Protege is familiar tool so have to check how it can be customized. I'll check the Datao as well. Br, Mikael On 8.11.2016 1:37, Olivier Rossel w

Re: Tools for browsing and editing RDF data

2016-11-08 Thread Mikael Pesonen
on of Protege-Forms. The data model extraction is available also as a service. If this tool seems to be useful for your needs, feel free to contact me for a demo. PS: the tool is not open source, it is a freeware. On Wed, Nov 2, 2016 at 1:51 PM, Mikael Pesonen wrote: Hi, I'm having troub

Tools for browsing and editing RDF data

2016-11-02 Thread Mikael Pesonen
from ontology schemas. Hope there exist such a system. BR, Mikael Pesonen -- www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel.

Re: Formatting of values in SPARQL

2016-10-10 Thread Mikael Pesonen
From: "mikael pesonen" To: "Miika Alonen" , users@jena.apache.org Sent: Friday, 7 October, 2016 14:21:56 Subject: Re: Formatting of values in SPARQL Hi, never would have though this, quite nice way. Those 3 technologies are new to me and spin especially seems interesting - also i

Re: Formatting of values in SPARQL

2016-10-07 Thread Mikael Pesonen
VALUES ?type { rdf:Property owl:DatatypeProperty } ?p rdfs:range ?range . } } ... But it might be better to validate the data first using sieve, SPIN or SHACL etc. Best Regards, Miika Alonen CSC - IT Center for Science miika.alo...@csc.fi - Original Message - From: "Mikael Pe

Formatting of values in SPARQL

2016-10-07 Thread Mikael Pesonen
Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Linnankatu 10 A FI-20100 Turku FINLAND

Re: Slow SPARQL query

2016-09-27 Thread Mikael Pesonen
{?concept skos:prefLabel ?prefLabelm FILTER ( (lang(?prefLabelm) = "fi" || lang(... ... Really have to start studying the inner workings of SPARQL queries... Mikael On 24.9.2016 17:02, Andy Seaborne wrote: On 23/09/16 09:35, Mikael Pesonen wrote: Hi, I have another qu

Re: Slow SPARQL query

2016-09-27 Thread Mikael Pesonen
Hi, On 24.9.2016 17:02, Andy Seaborne wrote: On 23/09/16 09:35, Mikael Pesonen wrote: Hi, I have another query that is behaving illogically to me. I am searching for terms in SKOS vocabulary and also need to retrieve topmost level concept for each search result. This query returns

Re: Slow SPARQL query

2016-09-23 Thread Mikael Pesonen
} limit 200 } ?concept skos:prefLabel ?prefLabel . OPTIONAL { ?concept skos:altLabel ?altLabel } OPTIONAL { ?concept skos:definition ?def1 . OPTIONAL {?def1 rdf:value ?def2 } } *OPTIONAL { ?topConcept skos:topConceptOf ?graph .

Re: Slow SPARQL query

2016-09-05 Thread Mikael Pesonen
Leaving child out from inner results was quite obvious mistake. Now paging works and queries are fast. Thank you! Mikael On 4.9.2016 20:31, Andy Seaborne wrote: On 02/09/16 13:22, Mikael Pesonen wrote: Sorry for bombing with questions. No problem in this case though replies may be

Re: Slow SPARQL query

2016-09-02 Thread Mikael Pesonen
t; skos:narrower* ?child}}} GRAPH <http://www.lingsoft.fi/resource-meta/> { ?s <http://purl.org/dc/terms/subject> ?child . ?s <http://purl.org/dc/terms/isPartOf> <http://www.lingsoft.fi/rdf/uid/57aae39836662> . ?s ?p ?o . } } limit 200 Mikael On 2.9.2016 12:04, Mikael

Re: Slow SPARQL query

2016-09-02 Thread Mikael Pesonen
But I think we can handle this by adding paging, so not a show stopper... On 2.9.2016 11:52, Mikael Pesonen wrote: Tested that one. Example query, similar that Ive sent here, took on average ~14 secs on 2.3.1 and 13.5 secs on 2.4.1. So a bit of improvement but we need to get that query to

Re: Slow SPARQL query

2016-09-02 Thread Mikael Pesonen
/16 09:20, Mikael Pesonen wrote: How do I get the snapshot? I found this page https://builds.apache.org/job/Jena_Development_Deploy/lastStableBuild/ but how to download? Mikael The builds end up in a maven repo: https://repository.apache.org/content/repositories/snapshots/org/apache/jena

Re: Slow SPARQL query

2016-09-01 Thread Mikael Pesonen
How do I get the snapshot? I found this page https://builds.apache.org/job/Jena_Development_Deploy/lastStableBuild/ but how to download? Mikael On 28.8.2016 13:34, Andy Seaborne wrote: On 26/08/16 12:17, Mikael Pesonen wrote: I'm happy to try out the snapshot. Its just matter of ru

Re: Slow SPARQL query

2016-08-26 Thread Mikael Pesonen
e values of the ?graph variable. ARQ should then be able to use that information to restrict which graphs in the database it scans. Rob Andy -- www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books an

Re: Slow SPARQL query

2016-08-26 Thread Mikael Pesonen
ug 26, 2016, at 6:40 AM, Mikael Pesonen wrote: Hi Rob, Im using this command to start db: /usr/bin/java -Xmx3600M -jar apache-jena-fuseki-2.3.1/fuseki-server.jar --update --port 3030 --loc=../apache-jena-3.0.1/DB /ds and s- command line tools to make queries. In documentation there is tdb

Re: Slow SPARQL query

2016-08-26 Thread Mikael Pesonen
worth noting that some queries are simply hard for any query engine to answer Rob On 26/08/2016 10:46, "Mikael Pesonen" wrote: Hi, still wondering what I should do to make the performance better. I read that TDB is faster. What is the reason not to use TDB? Cant

Re: Slow SPARQL query

2016-08-26 Thread Mikael Pesonen
Hi, still wondering what I should do to make the performance better. I read that TDB is faster. What is the reason not to use TDB? Cant find any comparison on SDB and TDB in that regard. Br, Mikael On 16.8.2016 13:13, Andy Seaborne wrote: On 15/08/16 09:47, Mikael Pesonen wrote: Hi

Re: Jena crash

2016-08-24 Thread Mikael Pesonen
Cause of error might be the same as discussed earlier: inserts being still too small and frequent. Mikael On 24.8.2016 16:28, Mikael Pesonen wrote: Hi, while adding triplets to db, it crashed. ... thousands of lines like this: at

Jena crash

2016-08-24 Thread Mikael Pesonen
at org.apache.jena.fuseki.cmd.FusekiCmd.main(FusekiCmd.java:60) Br, Mikael -- www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone:

RDF/XML dump from command line

2016-08-19 Thread Mikael Pesonen
esponsible for making contributions to the resource. ... Br, Mikael -- www.lingsoft.fi Speech Applications - Language Management - Translation - Reader's and Writer's Tools - Text Tools - E-books and M-books Mikael Pesonen System Engineer e-mail: mikael.peso...@lingsoft.fi Tel. +358 2 279 3300 Time zone: GMT+2 Helsinki Office Eteläranta 10 FI-00130 Helsinki FINLAND Turku Office Linnankatu 10 A FI-20100 Turku FINLAND

Re: Slow SPARQL query

2016-08-16 Thread Mikael Pesonen
instead of a specific one. -Osma On 16/08/16 15:50, Mikael Pesonen wrote: Hi Osma! unfortunatelly I need to match those certain subjects - the application is document search by selected keywords. And even if ?s <http://purl.org/dc/terms/subject> ?child . is left out the search takes

Re: Slow SPARQL query

2016-08-16 Thread Mikael Pesonen
url.org/dc/terms/isPartOf> <http://www.lingsoft.fi/rdf/uid/574ef1a40236a> . ?s <http://purl.org/dc/terms/subject> [] . ?s ?p ?o } } -Osma On 16/08/16 13:36, Mikael Pesonen wrote: Inner DISTINCT helps to halve the execution time, but entire query is low even with that. I

Re: Slow SPARQL query

2016-08-16 Thread Mikael Pesonen
ve to get faster queries? Mikael On 16.8.2016 13:13, Andy Seaborne wrote: On 15/08/16 09:47, Mikael Pesonen wrote: Hi, what do you mean by masking? It should remove duplicates and it makes the query run in half time compared to without DISTINCT. Result count at least is the same. Mikael If

Re: Slow SPARQL query

2016-08-15 Thread Mikael Pesonen
Hi, what do you mean by masking? It should remove duplicates and it makes the query run in half time compared to without DISTINCT. Result count at least is the same. Mikael On 12.8.2016 13:53, Andy Seaborne wrote: On 08/08/16 11:56, Mikael Pesonen wrote: Hi Andy, storage is started

Re: java.lang.StackOverflowError

2016-08-11 Thread Mikael Pesonen
Ok concatenating looks like the easiest solution for me. Is the update rate limit related to speed only - would just adding some delay between insertions solve the issue too? -Mikael On 11.8.2016 15:55, Andy Seaborne wrote: On 11/08/16 09:36, Mikael Pesonen wrote: Hi Andy, I did some

Re: java.lang.StackOverflowError

2016-08-11 Thread Mikael Pesonen
same time as another? Andy On 10/08/16 14:57, Mikael Pesonen wrote: Hi, I'm inserting data to jena store and got this exception. Server is: /usr/bin/java -Xmx3600M -jar /home/text/tools/apache-jena-fuseki-2.3.1/fuseki-server.jar --update --port 3030 Im inserting in a loop max 100 t

java.lang.StackOverflowError

2016-08-10 Thread Mikael Pesonen
Hi, I'm inserting data to jena store and got this exception. Server is: /usr/bin/java -Xmx3600M -jar /home/text/tools/apache-jena-fuseki-2.3.1/fuseki-server.jar --update --port 3030 Im inserting in a loop max 100 triplets at a time with bin/s-update. Error occured after a few 1000 inserti

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
t the data somewhere then I could try the queries myself to see if I could make it faster. Håvard On 08 Aug 2016, at 14:16, Mikael Pesonen wrote: For some reason with filter I dont get any results (corrected == to = ). Without filter it takes 12 secs so about the same speed. -Mikael On 8

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
} union { GRAPH <http://www.lingsoft.fi/resource-meta/> { ?s <http://purl.org/dc/terms/subject> ?child2 . ?s <http://purl.org/dc/terms/isPartOf> <http://www.lingsoft.fi/rdf/uid/574ef1a40236a> . ?s ?p ?o } } filter(?child == ?child2) } H

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
?child} UNION {<http://www.lingsoft.fi/b7cb30c4efed996a> skos:narrower* ?child} } } } Regards, Håvard M. Ottestad On 08 Aug 2016, at 11:25, Mikael Pesonen wrote: Hi, I'm not if this is the correct forum to ask but hope you can help. This query takes over 20 se

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
.lingsoft.fi/b7cb30c4efed996a> skos:narrower* ?child} } } } Regards, Håvard M. Ottestad On 08 Aug 2016, at 11:25, Mikael Pesonen wrote: Hi, I'm not if this is the correct forum to ask but hope you can help. This query takes over 20 seconds with jena: SELECT DISTIN

<    1   2   3   4   5   >