[Virtuoso-users] Incorrect result from transitive query

This takes a little bit of explaining. Bear with me. This query returns just one property: SELECT * WHERE { ?parent_prop rdfs:subPropertyOf dss:parent-group . } -> http://psi.dss.dep.no/sesam/ad/parentObject This query returns the correct result (all ancestor groups): SELECT * WHERE {

Re: [Virtuoso-users] renaming graph via conductor

* Hugh Williams > > Both log_enable 2 & 3, enable row by row auto commit which avoid deadlocks, 2 > then has transaction logging disabled and 3 has logging enabled so I don’t > see how you are expecting both approaches to be combined ? It is the row y > row auto-commit that makes both approac

Re: [Virtuoso-users] renaming graph via conductor

* Hugh Williams > > When renaming, deleting or performing other such operations on Large graphs > the key is to set “log_enable(3.1)” before hand such that the operation runs > in row-autocommit mode avoiding a transaction being created in memory that > consumes it all for large graphs, as de

Re: [Virtuoso-users] Cannot start Virtuoso on Windows

* Hugh Williams > > By “commercial” I mean the physical binary being used as opposed to open > source, be it an evaluation or acquired license. Ah, I see. Sure, no problem. --Lars M. http://www.garshol.priv.no/tmphoto/ http://www.garshol.priv.no/blog/

Re: [Virtuoso-users] Cannot start Virtuoso on Windows

Hi Hugh, * Hugh Williams > > Being a commercial installation you should open a support case or post on the > support forums rather than the open source mailing list. This isn't a commercial installation. It's just an evaluation at the moment. Different customer. :-) If you still want me to do

[Virtuoso-users] Cannot start Virtuoso on Windows

I've installed Virtuoso Universal Server (Release 6.3) on Windows XP/Vista/7/200x (64 Bit) (x86_64) Multi-Threaded Universal Server (Commercial Edition) for OpenLink Virtuoso 6.3 on a Windows 64-bit machine. However, trying to start the Virtuoso Service Control Manager has no effect. Noth

Re: [Virtuoso-users] Paging long SPARQL query

* Lars Marius Garshol > > Trying to do simple paging via > > order by ?uri limit 1000 offset 4000 > > and stepping up the offset doesn't work, because I get [...] > > I've tried simply turning off paging and trying to get the entire data set in > one g

[Virtuoso-users] Paging long SPARQL query

I want to link two Linked Open Data sets (specifically dbpedia and data.deichman.no) that are 800,000 and 200,000 records respectively. The only way I have of accessing these are open SPARQL endpoints. Both run Virtuoso, but I have no JDBC, iSQL or any other form of access except SPARQL. Tryin

Re: [Virtuoso-users] Running Virtuoso in 200M of RAM?

* Hugh Williams > > Which you will have to perform manually rather than via the Conductor, whose > behaviour will be change to similarly turn of transactions when performing > such operations in the next release ... Very good answer, thank you. I can work around it for now. Very glad to see

Re: [Virtuoso-users] Running Virtuoso in 200M of RAM?

* Hugh Williams > > Is this 120K triples already loaded and what is the current triple count of > your Virtuoso instance ? Yes, they were already loaded. I did some more deletions, and now the total triple count is 2 295 633. It contains some graphs left over from older work and some unwante

[Virtuoso-users] Running Virtuoso in 200M of RAM?

I want to try to use Virtuoso for a private web application (non-commercial), but since this is a virtual host (Linux), it doesn't have much memory available. Running Virtuoso on my laptop (MacOS X) I see it consistently use 400-600M of RAM, which is too much for this particular use case. The g

Re: [Virtuoso-users] Detailed access control for SPARQL?

* Kingsley Idehen > > You need the granularity of WebID. > > Each SQL user can be associated with a WebID. > > We'll get a note published in the coming days about how this works. Has there been any progress on this? It's a major issue for us in an upcoming application, so without some more de

Re: [Virtuoso-users] Detailed access control for SPARQL?

Hi Ivan, Thanks for the quick answer! * Ivan Mikhailov > > Virtuoso support graph-level security for SPARQL, as described in > http://docs.openlinksw.com/virtuoso/rdfgraphsecurity.html > If used, different SQL users may get selective read and/or write access > to specific graphs. This helps,

[Virtuoso-users] Detailed access control for SPARQL?

Does Virtuoso support access control for named graphs, or even down to the triple level? We have a potential case where we would need to be able to limit access at least by graph, but probably also more fine-grained than that. Is this possible with Virtuoso? --Lars M. http://www.garshol.priv.n

Re: [Virtuoso-users] Escaping of non-ASCII characters in URIs

* Ivan Mikhailov > > It means that I should write one more %-something formatter for sprintf. > Or, more probably, two of them --- for strings in narrow charset and for > strings that are actually UTF-8 but for some reason stored in a narrow > LATIN-1 column. > I'm providing this patch soon. Gre

[Virtuoso-users] Escaping of non-ASCII characters in URIs

We are using the RDF views (of RDBMS data) in Virtuoso, and it's working really well for us. However, we have a problem with the URIs generated by Virtuoso. The root cause of the problem is that the primary keys in the original databases contain non-ASCII characters. This is not good, but it's

Re: [Virtuoso-users] How to convert IRI_ID into a full URI?

* Ivan Mikhailov > > Opps, some portion of virtuoso function docs is lost in compilation. > While it's being recovered, the brief summary of functions is here: > [...] Thank you! Meanwhile I worked around it by counting the number of statements in the various graphs with SPARQL, then with SQL.

[Virtuoso-users] How to convert IRI_ID into a full URI?

We have a changelog table built from RDF_QUAD by triggers. Now I need to clear out the log for one particular graph. Basically, I need to do delete from RDF_LOG where G = 'http://...' But G is IRI_ID. So I really need to do delete from RDF_LOG where G = convert_iri_id_to_uri('http://...')

[Virtuoso-users] owl:inverseOf inferencing in Virtuoso

I've gotten inferencing on inverseOf to work in Virtuoso, so that DEFINE input:inference 'urn:ifs.ontology' select ?o where { ifs:has-address ?o . } returns an address that's actually associated the other way with ifs:address-of. However, if I try DEFINE input:inference 'urn:ifs.ontology'

[Virtuoso-users] Detected stale lock

I'm running Virtuoso locally on my Macbook and trying to start it gives me a dialog saying "Detected stale lock". Virtuoso then refuses to start and that's it. I discovered that the following command: sudo rm "/Applications/OpenLink Virtuoso/Virtuoso 6.2/database/virtuoso.lck" solves the prob

Re: [Virtuoso-users] SPARQL Update string literals

* Patrick van Kleef > > As far as i can see this issue has been resolved in the upcoming release of > VOS: [...] > > Note that the next VOS release is scheduled to happen over the next few days. Excellent! That's all we need. Thank you! -- Lars Marius Garshol lar...@ontopia.net

[Virtuoso-users] SPARQL Update string literals

oso/rdfsparql.html However, according to production [88] here, it's definitely legal: http://www.w3.org/Submission/SPARQL-Update/#rSTRING_LITERAL2 Thoughts? -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] Testing virtuoso with 100 Million triples

d perform a simple query 200 times per second. -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] SPARQL Update problems

ebID. Yes, once we're past prototyping and testing we do want some sort of protection on this. Thanks for the pointer. We'll look into WebID when we get that far. -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] SPARQL Update problems

RL is a qname. I suppose I could work around it by defining a prefix, but that won't be possible in all cases, and I shouldn't really have to. Also, is there a more complete spec of the SPARQL Update language that Virtuoso implements somewhere? -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] SPARQL Update problems

* Lars Marius Garshol > > SPARQL Request Failed > 42000 Error SR186: No permission to execute procedure DB.DBA.SPARUL_CREATE. It took me a while, but in the end I figured out the solution. This did not work: grant execute on DB.DBA.SPARUL_CREATE to SPARQL_UPDATE This, however,

Re: [Virtuoso-users] SPARQL Update problems

* Lars Marius Garshol > > I'm trying to use the SPARQL Update functionality in Virtuoso, but struggling > to figure out what the endpoint is. I've tried [...] Apologies for this duplicate posting. I posted from the wrong email address, then forgot to cancel it. -- Lars

Re: [Virtuoso-users] SPARQL Update problems

so Driver][Virtuoso Server]U0002: The object "SPARUL_CREATE" does not exist. at line 2 of Top-Level: grant SPARUL_CREATE to "SPARQL" I've looked through the manual and other documentation, but can't seem to find the necessary role. Any ideas? -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] SPARQL Update problems

* Ivan Mikhailov > > The parameter name should be "query=", not "update=" . In addition, the > supported syntax is "original" SPARUL, not SPARQL 1.1 variant, so it's > INSERT DATA IN { } . Aha! Now that explains things. Thank you! :-) -- Lars Marius Garshol lar...@ontopia.net

Re: [Virtuoso-users] SPARQL Update problems

ject "SPARQL" already have role "SPARQL_UPDATE" assigned at line 1 of Top-Level: grant SPARQL_UPDATE to "SPARQL" H. So it looks like this wasn't the cause after all. Any ideas? -- Lars Marius Garshol lar...@ontopia.net

[Virtuoso-users] SPARQL Update problems

I'm trying to use the SPARQL Update functionality in Virtuoso, but struggling to figure out what the endpoint is. I've tried http://localhost:8890/sparql/ but that doesn't seem to accept SPARQL Update. I found a hint in the manual that says: > If SPARQL_UPDATE role is granted to SPARQL user,

[Virtuoso-users] SPARQL Update problems

I'm trying to use the SPARQL Update functionality in Virtuoso, but struggling to figure out what the endpoint is. I've tried http://localhost:8890/sparql/ but that doesn't seem to accept SPARQL Update. I found a hint in the manual that says: > If SPARQL_UPDATE role is granted to SPARQL user

[Virtuoso-users] Sponger implementation question

I want to implement a service which polls a remote URL for updates and applies any changes found to a local graph. However, I do not want to replace the entire graph, just those bits which have changed. The remote URL is basically an Atom feed of changes, which is how I'm able to do this. We o

Re: [Virtuoso-users] ETL from SQL to RDF?

* Kingsley Idehen > > Okay, so this is just good old ETL using RDF. You can achieve this in a > loosely coupled way :-) Exactly. --Lars M. http://www.garshol.priv.no/tmphoto/ http://www.garshol.priv.no/blog/

Re: [Virtuoso-users] ETL from SQL to RDF?

* Kingsley Idehen > > I am sure you understand that as a fundamental principle, OpenLink > implements standards whenever such exist. If standards don't exist and a > problem persists, we innovate. If standards emerge later, we support > immediately. What I wrote was not meant as criticism of

Re: [Virtuoso-users] ETL from SQL to RDF?

* Hugh Williams > > What are the remote database(s) you are seeking to virtualize data into > Virtuoso from ? To begin with we're looking at an ERP system known as IFS. However, there will likely be 2-3 more systems in the first iteration. We envision separate Virtuoso databases serving SDsha

Re: [Virtuoso-users] ETL from SQL to RDF?

* Mark James > > The commercial version of virtuoso has a 'virtual database' capability. You > can create tables within virtuoso that are links to tables within other > rdbms. It's then possible to create rdf views and either materialize the > triples or query the rdbms data directly. Thank y

[Virtuoso-users] ETL from SQL to RDF?

Is there functionality in Virtuoso for doing ETL from relational data to RDF? I looked at RDF Views, but it doesn't seem to be what we want, and there don't appear to be any spongers for this purpose. I did find a blog post about the subject that seemed to imply that ETL was not the preferred a