Re: [Virtuoso-users] SPARQL endpoint Update permissions

2018-07-28 Thread Ivan Mikhailov
Hello Iker, All recent versions of Virtuoso have /sparql-auth web service endpoint configured like /sparql but with authentication enabled. Similarly, there's /sparql-graph-crud-auth like /sparql-graph-crud . Best Regards Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue,

Re: [Virtuoso-users] Virtuoso 37000 Error

2018-04-12 Thread Ivan Mikhailov
issions you can also inspect the content of DB.DBA.SYS_SPARQL_HOST table and check SH_DEFINES there (see http://doc s.openlinksw.com/virtuoso/rdfdefaultgraph/ for more details) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Fri, 2016-06-10 at 19:08 -0400, S.M.Shami

Re: [Virtuoso-users] SPARQL run-time errors querying a virtual graph

2017-05-11 Thread Ivan Mikhailov
practical to send directly to me, not via mail list. I'm also available at Skype as iv_an_ru. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2017-05-03 at 18:15 +0100, Beppe Mazzola wrote: > Hi to everybody > > I am trying to query the conten

Re: [Virtuoso-users] Virtuoso 22011 Error SR026

2016-11-02 Thread Ivan Mikhailov
, the order of execution may be non-linear. So the simplest step of debugging is an additional test: what if SUBSTR(?literal, 8, 1) is replaced with IF (STRLEN(?literal) = 8), SUBSTR(?literal, 8, 1), "some fallback value") ? Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.ope

Re: [Virtuoso-users] performance toll for using variables as properties

2016-07-24 Thread Ivan Mikhailov
t may be practical to inline P into the text of the query rather than using ?:p parameter passing notation. At least, it's practical to have a separate variant of the query for parameter set to rdf:type Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Fri,

Re: [Virtuoso-users] Temporary DB size and server restart

2016-03-31 Thread Ivan Mikhailov
of the application server (multiplied by factor 1.5--2--3 for extra safety). Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2016-03-30 at 16:08 +, Davis, Daniel (NIH/NLM) [C] wrote: > I have a strange failure condition somewhere in my deployment. > Vir

Re: [Virtuoso-users] first eval? SERVICE or sub-SELECT

2016-03-09 Thread Ivan Mikhailov
le-specific options are placed right after object of the desired triple pattern (or right after sub-SELECT) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2016-03-08 at 20:53 +0100, Jürgen Jakobitsch wrote: > hi, > > > i'd need

Re: [Virtuoso-users] Trouble loading

2015-09-03 Thread Ivan Mikhailov
Hello Alan, I'd recommend to use DB.DBA.TTLP instead, as described in the doc and use TTLP (file_open (?)...) or TTLP (gz_file_open (?)...) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2015-07-23 at 05:56 +, Alan Ruttenberg wrote: > I

Re: [Virtuoso-users] Long SPARQL query translation to SQL

2015-06-23 Thread Ivan Mikhailov
Hello Lorena, I don't know exact version you're using but there's one more (less convenient but reliable) way of getting the sql text: set blobs on; select sparql_to_sql_text ('SELECT ...') as X long varchar; That will work with any combination of an isql client and the server. The disadvantages

Re: [Virtuoso-users] Documentation for "Strict checking of void variables"

2014-12-11 Thread Ivan Mikhailov
4/02/skos/core#> SELECT ?broader WHERE { { SELECT ?broader WHERE { GRAPH <http://linked.opendata.cz/resource/dataset/cpv-2008> { <http://linked.opendata.cz/resource/cpv-2008/concept/72212461> skos:broaderTransitive{1,3} ?broader . } } } } Yes I can reproduce it locally and it's

Re: [Virtuoso-users] Documentation for "Strict checking of void variables"

2014-12-08 Thread Ivan Mikhailov
want to add "define sql:signal-weird-variables 1" for the "opposite" case of variables bound with no effect on the environment. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2014-11-24 at 10:23 +0100, Jindřich Mynarz wrote: > Hi, > >

Re: [Virtuoso-users] specific graph stored datas problem with virtuoso 7

2014-06-13 Thread Ivan Mikhailov
t uses the IRI of a graph group. If dbpedia were secret and you would like to allow me read it you'd set bit 1 for http://fr.dbpedia.org/live , http://static.fr.dbpedia.org and other member graph IRIs, and both bit 8 and bit 1 (i.e., value 9) for http://fr.dbpedia.org IRI . Best Regards

Re: [Virtuoso-users] Managing roles for users for UPDATE/DELETE/INSERT in SPARQL

2014-06-04 Thread Ivan Mikhailov
e password-protected /sparql-auth/ . The use of Conductor is possible, of course, but it can be less convenient. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2014-06-04 at 09:29 +0200, Jesús Redondo wrote: > Hello, > > I would like to mana

Re: [Virtuoso-users] What does "not support OPTION (...) clause for triples so SPARQL query can not be composed" mean?

2014-06-02 Thread Ivan Mikhailov
o it should have SPARQL_WRITE permission. I tend to use in vain the name of DBA Almighty for such operations (via ISQL or Conductor), other convenient way is to use /sparql-auth endpoint instead of /sparql and provide username/password of some "powerful"

Re: [Virtuoso-users] xsd:date+xsd:time->xsd:dateTime

2014-04-25 Thread Ivan Mikhailov
Hello Quentin, It's possible to make such a merge function, but please clarify one thing first: what should it do if date and time arguments are in different timezones? Best Regards Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2014-04-24 at 10:13 +1000, Quentin

Re: [Virtuoso-users] Insert wrong numerical values

2014-04-14 Thread Ivan Mikhailov
trdf:bad-float, so the name of xsd:float type is not used in vain and virtrdf:bad-float-s can be refined later. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Sun, 2014-04-13 at 12:32 +0200, Alex Stolz wrote: > Hi, > > I am running Virtuoso 7.1.0 (buil

Re: [Virtuoso-users] Speedup datediff query

2013-08-12 Thread Ivan Mikhailov
could be ordered naturally via hot index used by the filter. Note also that if you know the datatype of an object literal, there's no need to write a cast like xsd:dateTime --- it can make an expression index-unfriendly even if it will always return the argument unchanged on your specific data.

Re: [Virtuoso-users] Questions about prefixes in virtuoso db

2013-06-25 Thread Ivan Mikhailov
tuoso/fn_xml_set_ns_decl.html and related pages. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2013-06-25 at 11:07 +0800, 126 wrote: > Hi, all! > I have imported dbpedia datasets into my local virtuoso, now I > want to import yago datasets too, however, I noticed

Re: [Virtuoso-users] Size (in bytes) of Named Graph

2013-05-21 Thread Ivan Mikhailov
l mechanics of 2TB sub-10-ms hard drive is cheaper than the folded sheet metal of a PC case. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com smime.p7s Description: S/MIME cryptographic signature ---

Re: [Virtuoso-users] Sparql using delete insert problem

2013-05-14 Thread Ivan Mikhailov
the actual edition of the database. No nao:lastModified ?mod at the very beginning --- no manipulations prepared --- no effect. The solution is to make separate DELETE and then an unconditional INSERT. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2013-05-1

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Ivan Mikhailov
add more syntax sugar and implicitly put { select distinct ?sub { ?sub [] [] }} at the front of a transitive path pattern, but that will masquerade the issue, not resolve it. Best Regards, Ivan Mikhailov OpenLink Software On Tue, 2013-05-14 at 15:06 +0200, Jerven Bolleman wrote: > Hi Ivan, > >

Re: [Virtuoso-users] Path query with * -> transitive temp memory ran out

2013-05-14 Thread Ivan Mikhailov
sparql insert { ?s p ?o } where { ?s p* ?o . filter (?s = ?:end) } ; } inside a stored procedure. The advantage is that the DML statements in the loop body can be placed in an async_queue, providing better hardware utilization on multi-processor box or on a cluster. Best Regar

Re: [Virtuoso-users] Virtuoso and ontowiki

2013-04-25 Thread Ivan Mikhailov
Hello Rok Backslashes acts as a character escaping, so please try DB.DBA.RDF_LOAD_RDFXML(FILE_TO_STRING_OUTPUT('C:\\xampp\\tmp\ \php479C.tmp'), 'http://localhost/lambda_test/', 'http://localhost/lambda_test/') Best Regards, Ivan Mikhailov OpenLink Software http://v

Re: [Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

2013-04-09 Thread Ivan Mikhailov
; exit; so text/turtle is supported now without any additional heuristics. Best Regards Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2013-04-09 at 08:10 -0400, Erich Bremer wrote: > Hi Hugh, > > virtuoso-t -? > Virtuoso Open Source Edition (multi threaded) &

Re: [Virtuoso-users] Bug in Graph Store HTTP protocol turtle uploads

2013-04-09 Thread Ivan Mikhailov
ed as a hint to understand that it's an Turtle whereas words like were too ambiguous. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2013-04-08 at 10:39 -0400, Erich Bremer wrote: > Hi Hugh, > > Yes, the first file is "single.ttl" c

Re: [Virtuoso-users] HTTP Request Size in Virtuoso

2012-12-17 Thread Ivan Mikhailov
3.org/2002/07/owl#sameAs> <http://dbpedia.org/resource/Cannabinol> . ?Int_30 <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/interactionDrug1> ?y_30 . ?Int_30 <http://www4.wiwiss.fu-berlin.de/drugbank/resource/drugbank/interactionDrug2> ?IntDrug_30 .

Re: [Virtuoso-users] Undefined STACK in virtuoso-opensource-5.0.10

2012-08-23 Thread Ivan Mikhailov
. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com diff -U5 --recursive virtuoso-opensource-5.0.10/libsrc/Dk/Dkernel.c vos-5.0.10/libsrc/Dk/Dkernel.c --- virtuoso-opensource-5.0.10/libsrc/Dk/Dkernel.c 2008-12-18 18:55:45.0 +0600 +++ vos-5.0.10/libsrc/Dk

Re: [Virtuoso-users] isql scripting help

2012-07-21 Thread Ivan Mikhailov
portion of system metadata. > > Sorry if I am a noob regarding db consistency. I never worked with it in > practice, just classes :) > > I updated the script, incorporating your suggestions. Does it make more > sense now? > http://dbpedia.hg.sourceforge.net/hgweb/dbpedia/extraction_framework/file/tip/wiktionary/load.isql Sorry, I can't access it: " An error occurred while processing your request wiktionary/load.isql@c871ba718cf6: not found in manifest " Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] isql scripting help

2012-07-19 Thread Ivan Mikhailov
r that rollbacks and add > a "commit work" after the last operation right? Does this interfere with > the checkpoints? Is there a example for that? atomic(1) will give the whole database in your solo possession. That does not cancel the need for proper use of checkpoints at moments

Re: [Virtuoso-users] Again Internal error: 'output:valmode' declarationconflicts with 'output:format'

2012-07-14 Thread Ivan Mikhailov
prefix declaration. Even if it's fixed, the query will return nothing because filtering can only shorten the set of bindings and the set is initially empty because there's no triple pattern that could produce a binding. Probably you need something like select distinct ?o

Re: [Virtuoso-users] SPARQL Service Experiment

2012-06-26 Thread Ivan Mikhailov
Hello Jürgen, The remote endpoint ( i.e., http://tuqs.semantic-web.at/sparql/UKAT ) returns HTML instead of expected result set and Virtuoso fails to parse it. I'll get more details later today. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2012-06-

Re: [Virtuoso-users] Fwd: [Dbpedia-developers] unexpected results with filter

2012-06-18 Thread Ivan Mikhailov
are casted to integers > (the xml output contains the attribute > datatype="http://www.w3.org/2001/XMLSchema#integer"; for both). Unfortunately Virtuoso does not keep difference between equal numeric values of different types. The optimizer knows that and puts the constant right into the result set. Sorry for inconvenience. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Deleting Blank Nodes via ADO.Net Provider

2012-06-01 Thread Ivan Mikhailov
run in same server, so the application should identify bnodes by properties before doing bif:iri_id_XXX tricks. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] PubSub for large RDF data

2012-05-31 Thread Ivan Mikhailov
, someone else will clarify. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com P.S., some Virtuoso-based PubSubHub servers may provide a web page named /GraphCmp/, to make experiments with diff logic used at that servers.

Re: [Virtuoso-users] multiple accumulator in user defined aggregate function

2012-05-11 Thread Ivan Mikhailov
each individual box of the cluster calculate portion of an aggregate for locally stored data and finally partial results are merged together, pairwise, championship style. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Upgrading virtuoso....

2012-05-02 Thread Ivan Mikhailov
select count(distinct ?g) where{graph ?g {?s ?p ?o}}; gives me 8. > The conductor also shows correctly my graphs. We have a cheat with select distinct ?g where {graph ?g {?s ?p ?o}} We replace this query with select distinct ?g where {graph ?g {?s a ?t}} because it is orders of magni

Re: [Virtuoso-users] type inferencing problem

2012-04-26 Thread Ivan Mikhailov
asic integrity checks. That toolkit is tried on processing R2RML files that usually lack most of required rdf:type triples but domains and ranges of all properties are restricted by the spec. It may be similar to what you need, but with materialization instead of on-demand inference. Best Regards

Re: [Virtuoso-users] SQL transitivity features usage

2012-04-26 Thread Ivan Mikhailov
T_IN variables. However either I've made a bug in my sample application or we have a but in this SPARQL feature but I'm getting results I can't explain. I will report additionally the result of the check. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com O

Re: [Virtuoso-users] Ask queries

2012-04-11 Thread Ivan Mikhailov
tp://www.w3.org/2001/XMLSchema#"; > http://www.w3.org/2001/XMLSchema#boolean";>0 1 Rows. -- 4 msec. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2012-04-11 at 18:52 +0300, Alex wrote: > Hello there, > > are ask queries supp

Re: [Virtuoso-users] Using SPARQL 1.1 CONCAT and STRAFTER

2012-03-19 Thread Ivan Mikhailov
{?s ?p ?o} The SPARQL client you use has altered the query via an incorrect preamble. There's no graph IRI between "define input:default-graph-uri" and "select", so the parser runs a bit further before it discovers that "select" is not a valid default graph un

Re: [Virtuoso-users] Named Graph Weird Behavior

2012-03-19 Thread Ivan Mikhailov
irely empty, it should contain at least virtrdf: row in the answer, i.e., the system configuration graph. Thus there may be some additional errors there. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2012-03-19 at 11:32 -0400, Erich Bremer wrote: > H

Re: [Virtuoso-users] About bif:contains and REGEX producing different results

2012-03-07 Thread Ivan Mikhailov
Roberto, You can search for an exact phrase if you put it into quotes, or you can require some weaker proximity between terms by using NEAR operator, like Paris NEAR Hil* Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2012-03-07 at 11:26 +0100, Roberto

Re: [Virtuoso-users] Problem concenring deleting triples

2012-02-29 Thread Ivan Mikhailov
empty, it erases everything and then load the default content of http://www.openlinksw.com/schemas/virtrdf# . Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2012-02-29 at 12:58 +0200, aliki aliki wrote: > Hello! > > I have great trouble while trying

Re: [Virtuoso-users] Insertion w/ explicit datatypes

2012-02-28 Thread Ivan Mikhailov
not match exactly as well. Non-numeric types are kept accurately, so xsd:string and xsd:String will always differ from each other and from untyped. Languages are kept accurately as well. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2012-02-23 at 18:49

Re: [Virtuoso-users] Strange error sparql 6.1.3 to 6.1.4

2012-02-22 Thread Ivan Mikhailov
Hello Peter, What's the full text of the query? Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2012-02-22 at 16:42 +1100, Peter Secomb wrote: > Hi everyone, > > We just upgraded virtuoso from 6.1.3 to 6.1.4 in our test environment >

Re: [Virtuoso-users] Request manager

2012-02-21 Thread Ivan Mikhailov
Hello Maxime, Have you looked at http://docs.openlinksw.com/virtuoso/ASYNCEXECMULTITHREAD.html ? Is that enough or you need some more functionality? Best Regards Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2012-02-20 at 15:10 +0100, Maxime Teissèdre wrote: > Hi

Re: [Virtuoso-users] Using LIMIT and OFFSET in sparql sub-queries

2012-02-01 Thread Ivan Mikhailov
t order to what is expected? Indeed. No ORDER BY clause implies that the optimizer may do whatever with the order, including different order for different runs of same query on same data. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2012-01-30 at 14:14 +

Re: [Virtuoso-users] Dealing with Years as xsd:gYear in Virtuoso, Bug?

2012-01-25 Thread Ivan Mikhailov
treat more than 4 digits of the year as a syntax error. The reason is that some old systems recorded dates as 8 digits without any delimiters, like "20120126" and a long year may trigger the parsing according to that format. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso

Re: [Virtuoso-users] SPARQL 1.1 BINDINGS support

2012-01-24 Thread Ivan Mikhailov
uture? Yes we're intending to implement it in some future, but the priority is moderate to low. The reason is that nobody asked about it, more popular requests will come first. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Renaming a big graph

2012-01-23 Thread Ivan Mikhailov
ry? I'd like to check how was it possible for the server to properly enter the use of memory reserve but not cancel the dangerous activity and not recover after the disaster. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Multiple datasets returned even after restrictions

2012-01-23 Thread Ivan Mikhailov
raphs identical, just remember that these two lists are (almost) independent. ("Almost" refers to an exception with named graphs specified and no default graph, see the spec). Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2012-01-23 at 12:44 +110

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

2012-01-13 Thread Ivan Mikhailov
endpoints exists, similar to /sparql and /sparql-graph-crud but with HTTP "digest" authentication, so SQL accounts that have some RDF access rights can use these endpoints. Best Regards, Ivan Mikhailov Openlink Software http://virtuoso.openlinksw.com On Fri, 2012-01-13 at 08:55 +0100, L

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Ivan Mikhailov
o limit the selection, use MODIFY <http://test.com/> delete {...} insert {...} FROM <http://test.com/> WHERE {...} Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2012-01-12 at 10:55 -0200, Percy Enrique Rivera Salas wrote: > Hi Hugh, >

Re: [Virtuoso-users] MODIFY statement doesn't work properly

2012-01-12 Thread Ivan Mikhailov
://test.com/link";)) } } } but in any case I'd convert string to IRI somewhere before trying to construct a subject node. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2012-01-12 at 10:55 -0200, Percy Enrique Rivera Salas wrote: > Hi Hugh, &

Re: [Virtuoso-users] load command from jdbc

2012-01-12 Thread Ivan Mikhailov
e ; So it loads not every SQL file that can be loaded by ISQL, but that's the best thing I can suggest at the server side. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2012-01-12 at 01:01 -0300, Marcelo Aliquintuy wrote: > Hi. > > > I

Re: [Virtuoso-users] Views over RDF graphs in Virtuoso

2012-01-03 Thread Ivan Mikhailov
union { graph { ?s . filter exists {?s ?o2} } } } ...if it were simpler, we'd rather implemented it years ago :| Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2012-01-03 at 17:17 -0200, lorena wrote: > Hi! > > I would like to dynamicall

Re: [Virtuoso-users] Delete a tripple with space in subject

2011-12-13 Thread Ivan Mikhailov
Sachit, You may wish to delete from { `iri("http://isbsg.clearbluewater.com.au/wsf/datasets/378/Capers Jones_107_12122011081257")` a <http://isbsg.org/ontology/data/Dataset> }; Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2011-12-1

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

2011-12-08 Thread Ivan Mikhailov
Hello Lars, 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. Best Regards,

Re: [Virtuoso-users] Propery value uniqueness

2011-12-02 Thread Ivan Mikhailov
Hello Ícaro, You mean, to check whether some value of a given property appears in more than one subject? Or, to check whether a given property has no more than one value for every subject? Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-12-01 at 17

Re: [Virtuoso-users] construct + aggregate function

2011-12-02 Thread Ivan Mikhailov
STINCT ?category count(?category) AS ?count WHERE { ?s <http://purl.org/dc/terms/subject> ?category FILTER(?s = <http://dbpedia.org/resource/Higgs_boson> || ?s = <http://dbpedia.org/resource/Gluon>) } } } Best Regards, Ivan Mikhailov Ope

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Ivan Mikhailov
> Also is the "commit work" necessary? result() will not execute the query and will not set "state" or "msg" variables. commit work is not necessary for small number of small graphs, but many big graphs may exceed transaction log limit size. Best Regards, Ivan

Re: [Virtuoso-users] Help with stored procedure

2011-11-24 Thread Ivan Mikhailov
graph <http://test3/> {}; sparql select * where { graph ?g { ?s ?o} }; --- Should return three rows. nrl_drop_graphs ('select ?g where { graph ?g { ?s ?o }}'); sparql select * where { graph ?g { ?s ?o} }; --- Should return zero rows because graphs are just dropped. Bes

Re: [Virtuoso-users] Virtuoso Jena Provider and ARQ keywords

2011-11-12 Thread Ivan Mikhailov
"Novosibirsk" } returns 314. Keeping in mind that "Новосибирск" is Russian and "Novosibirsk" is English transcription for same city, these numbers differ for a good reason :) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Sat, 2011

Re: [Virtuoso-users] Confusion with xpath_eval

2011-11-03 Thread Ivan Mikhailov
mparing entities, you will not worry whether a single document is shared by entities or few copies are used. However DOM-style functions can write to the document and the change may affect all entities of that document at once ( http://docs.openlinksw.com/virtuoso/xmldom.html ). Best Regards, Ivan Mi

Re: [Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-10-28 Thread Ivan Mikhailov
2 and PLDebug = 1 or 2, as described in http://docs.openlinksw.com/virtuoso/dbadm.html#VIRTINI ) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-10-27 at 17:50 +1100, Peter Secomb wrote: > Hi Ivan, > > I've played around a bit with fu

Re: [Virtuoso-users] Calling Sponger cartridge with options from sparql select

2011-10-27 Thread Ivan Mikhailov
not depend from any selected variables, so the data are in place when the rest of select is starting its loops. [1] http://docs.openlinksw.com/virtuoso/fn_connection_get.html [2] http://docs.openlinksw.com/virtuoso/fn_connection_set.html Best Regards, Ivan Mikhailov OpenLink Sof

Re: [Virtuoso-users] SPARQL Virtuoso Extension Help

2011-10-12 Thread Ivan Mikhailov
ns.com/foaf/0.1/Person>. ?id_prop rdfs:domain ?id_prop_rel } optional { ?id_prop rdfs:domain ?id_prop_master } } group by ?id_name ?id_prop_name ?id_prop ?id_prop_rel_name ?id_prop_rel (Note also that PREFIX bif: is reserved in Virtuoso-BI, so I cut it away from the tex

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

2011-10-06 Thread Ivan Mikhailov
archar id_to_iri_nosignal (in arg any): similar to id_to_iri(), but it never signal errors, it return NULL instead. Last two functions of the list is what you need. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-10-06 at 09:36 +0200, Lars Marius Garsh

Re: [Virtuoso-users] [bif:contains] all options

2011-10-05 Thread Ivan Mikhailov
Hello Michael, Supported bif:contains free-text options are OFFBAND, SCORE and SCORE_LIMIT. OFFBAND is described in http://docs.openlinksw.com/virtuoso/creatingtxtidxs.html#offbanddata but it is useful only if data comers via an RDF View and the source relational table uses this trick. SCORE is

Re: [Virtuoso-users] [bif:contains] all options

2011-10-05 Thread Ivan Mikhailov
calculated according to http://docs.openlinksw.com/virtuoso/creatingtxtidxs.html#hitscores and SCORE_LIMIT works as it is in plain SQL free-text: http://docs.openlinksw.com/virtuoso/queryingftcols.html Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2011-10

Re: [Virtuoso-users] Sparql Nested depth exceed error

2011-10-03 Thread Ivan Mikhailov
> ?isbsgProject*>isbsg:data_quality_rating > as ?data_quality_rating > > ?isbsgProject*>isbsg:ufp_rating as ?ufp_rating > > > > ... > Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2011-10-

Re: [Virtuoso-users] Sparql Nested depth exceed error

2011-09-30 Thread Ivan Mikhailov
ceeds the limit of > 2147483647 (sec).I increased the execution time to test but > the estimated time isn't even greater than the limit and still > i get the above error. That may demonstrate the issue with error report, that is unable to properly print the n

Re: [Virtuoso-users] New to virtuoso - capturing output

2011-09-22 Thread Ivan Mikhailov
-s of all sorts. If you want to keep the whole log, not only look at it and cut&paste by mouse, then use "tee" command-line tool shipped with most of OSes. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-09-22 at 09:45 +1000, Peter Seco

Re: [Virtuoso-users] Error from a valid xsl file

2011-09-21 Thread Ivan Mikhailov
more meaningful, because I've made poor error diagnostics :| I'll improve it. The workaroud is to replace the namespace prefix or drop it at all --- it's out of real use anyway. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2011-09-21 at 23:3

Re: [Virtuoso-users] DB.DBA.TTLP_MT_LOCAL_FILE error

2011-08-30 Thread Ivan Mikhailov
hosted by Virtuoso. See http://docs.openlinksw.com/virtuoso/fn_http_root.html Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2011-08-30 at 11:54 -0300, Percy Enrique Rivera Salas wrote: > Hi everyone, > > > I tried to upload a file through DB.DBA.TT

Re: [Virtuoso-users] dump_graphs() error

2011-08-21 Thread Ivan Mikhailov
f both the server and the function are of same age (say, both recent) but the error persists then I'd like to get some sample data in order to reproduce the bug locally. Best Regards Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Sat, 2011-08-20 at 16:38 -0400, Gregory Will

Re: [Virtuoso-users] Configuring new user

2011-08-04 Thread Ivan Mikhailov
lication should pay attention to these issues, but it's so inconvenient for end users... One of practical methods is to cast all values to UTC and place explicit 'Z' to the end of every datetime. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-

Re: [Virtuoso-users] Subquery and SAMPLE keyword (SPARQL 1.1)

2011-08-03 Thread Ivan Mikhailov
Hello Houda In fresh versions of Virtuoso, you can use sql:SAMPLE() as a temporary workaround for missing SAMPLE (). SPARQL 1.1 will be supported rather sooner than later, we hope we can make it one of two implementations required by W3C policy for CR status of the spec. Best Regards, Ivan

Re: [Virtuoso-users] Typecast (datatype) problem?

2011-07-28 Thread Ivan Mikhailov
f DATATYPE() into SQL call of DB.DBA.RDF_DATATYPE_OF_OBJ :) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2011-07-26 at 19:30 -0300, Renan Moreira de Oliveira wrote: > Hi, > > If I try to query after an object as string, and in the insert > operation it was typ

Re: [Virtuoso-users] Error while compiling the types DB.DBA.XMLType / DB.DBA.xmla_discover

2011-07-13 Thread Ivan Mikhailov
Ryan, You can drop both class DB.DBA."XMLTYPE" and class DB.DBA."XMLType" then restart the server. Declarations will be re-created during plain start-up activity of the server. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2011-

Re: [Virtuoso-users] Error while compiling the types DB.DBA.XMLType / DB.DBA.xmla_discover

2011-07-12 Thread Ivan Mikhailov
Hello Ryan, Have you ever changed the CaseMode parameter in virtuoso.ini configuration file? What are the current and the previous values of this parameter? Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2011-07-12 at 09:18 -0400, Ryan Shaw wrote: > I

Re: [Virtuoso-users] SPARQL sub-query to return a single result

2011-07-04 Thread Ivan Mikhailov
ainedBy `(select ?a where { ?a nao:identifier "nepomukindexer" })` . } Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2011-07-04 at 14:42 +0200, Sebastian Trüg wrote: > Hi list, > > in a query like this: > > select distinct

Re: [Virtuoso-users] Caseinsensitive search for uri

2011-07-03 Thread Ivan Mikhailov
mit 100 Having sufficient number of customer requests, I can add efficient search for IRIs by some IRI properties (e.g. free-text on them). So far, studying each reported use case in depth reveals either some inaccuracy/incompleteness in ontology or some way of fetching subjects by their textual p

Re: [Virtuoso-users] Clear graph query problem

2011-06-30 Thread Ivan Mikhailov
irtuosos as well) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2011-06-29 at 12:41 +0200, Sebastian Trüg wrote: > Hi list, > > With this query: > > clear graph ?mg where { > ?mg nrl:coreGraphMetadataFor ?g . > FILTER(?g i

Re: [Virtuoso-users] Virtuoso Server Hardware Suggestions

2011-06-23 Thread Ivan Mikhailov
used for relatively long time. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-06-23 at 15:53 -0500, Peter DeVries wrote: > Hi, > > > I need to spec out a system that will be probably be slightly larger > than the DBpedia data set. &g

Re: [Virtuoso-users] Comparing date/time literals of different types

2011-06-21 Thread Ivan Mikhailov
some common type. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Tue, 2011-06-21 at 17:39 +0200, Martin Gerlach wrote: > Hi, > > is there any documentation on which date/time types can be safely used > in comparisons? > > I noticed that xsd:gY

Re: [Virtuoso-users] Clear graph

2011-06-11 Thread Ivan Mikhailov
Hi Alexander > log_enable(3,1); > delete from rdf_quad where g = iri_to_id (‘graph-name’); Note that this will not even try to remove free-text index data for this graph. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Clear graph

2011-06-10 Thread Ivan Mikhailov
of an bigger SQL query or Virtuoso/PL procedure then they're between SPARQL keyword and the SPARQL query itself. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com > I forgot about that discussion and it really looks like the same > problem. Unfortunately I

Re: [Virtuoso-users] RDF geo queries in open source edition

2011-06-10 Thread Ivan Mikhailov
Hello Babis, Sorry, geospatial things are in commercial version only. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Fri, 2011-06-10 at 15:01 +0100, Babis Doulaverakis wrote: > Hello, > I am using the open source edition for Virtuoso but I am unable

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-10 Thread Ivan Mikhailov
an provide is to specify graph if possible (as FROM or GRAPH {...} or at least GRAPH ?g { ... } ). If it's something else then please provide the whole query. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] bif:contains - using a string variable as search term

2011-06-09 Thread Ivan Mikhailov
versions also support (not yet documented) FILTER (bif:strcontains (?haystack, ?needle)) (strcontains returns boolean, not a position or NULL) FILTER (bif:starts_with (?dachshund, ?nose)) FILTER (bif:ends_with (?dachshund, ?tail)) Best Regards, Ivan Mikhailov OpenLink Software http

[Virtuoso-users] GROUP_CONCAT and SAMPLE SPARQL 1.1 aggreagates for VOS

2011-06-06 Thread Ivan Mikhailov
;s no real immediate need for that, because these functions will not be upgraded automatically by new built-in versions, if these functions are changed in some distant future (procedures created by user takes priority over any built-in things). Best Regards, Ivan Mikhailov OpenLink Sof

Re: [Virtuoso-users] Regex-based renaming of graphs

2011-05-29 Thread Ivan Mikhailov
ole storage is free-text indexed, not on per-graph basis, you should update free-text index, because the inverse index data of each literal are enriched with list of graphs that contain this literal in some quads, and renaming a graph make these data (partially) obsolete. Best Regards, Ivan Mikha

Re: [Virtuoso-users] Regex-based renaming of graphs

2011-05-26 Thread Ivan Mikhailov
Alexandre, I've posted a procedure to find all distinct predicates that start with some specified substring. It's trivial to turn it into a procedure to list all distinct graphs with same filtering and make an update based on th results. Best Regards, Ivan Mikhailov OpenLink Sof

Re: [Virtuoso-users] bif:contains for predicate values

2011-05-26 Thread Ivan Mikhailov
ew and it in turn can be used in an RDF View but it is redundand for most of applications. For typical "almost static" data, it is more practical to write a procedure that will store all found predicates in some dedicated "dictionary" graph and then use the graph as usual. Best Reg

Re: [Virtuoso-users] Best Configuration Parameters

2011-05-03 Thread Ivan Mikhailov
hen next query can be used: select id_to_iri (REC_GRAPH_IID) from DB.DBA.RDF_EXPLICITLY_CREATED_GRAPH where exists (select top 1 1 from DB.DBA.RDF_QUAD where G=REC_GRAPH_IID); Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Built-in Protection against SQL / SPARQL Injections.

2011-04-18 Thread Ivan Mikhailov
n URL that point to them and contain SQL injections stored previously by attacker in his application data. In this aspect Virtuoso is neither better nor worse than any other server, because no automatic protection is possible. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlink

Re: [Virtuoso-users] Best way to query a random sample?

2011-04-13 Thread Ivan Mikhailov
lements are tried already and J were selected out of them then the probability of selecting the current element should be (N-J)/(M-I) Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com

Re: [Virtuoso-users] Best way to query a random sample?

2011-04-11 Thread Ivan Mikhailov
RQL front-end to omit redundand conversions of values. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2011-04-11 at 10:52 +0200, Konrad Höffner wrote: > Hello, > > I would like to know the best method to get a random sample of all > tri

Re: [Virtuoso-users] run virtuoso in a cluster

2011-03-31 Thread Ivan Mikhailov
open-source list, to not confuse other VOS users with details of the commercial version. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Thu, 2011-03-31 at 22:22 +0800, kun ren wrote: > Dear developer and virtuoso users, > > Recently I am using opensource

  1   2   3   4   5   >