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

Hi, This might be possible but reading through the function reference, I can't see anyway to do it that doesn't require breaking a component down to integers or strings and then rebuilding. I'd like to suggest add a new feature to the wishlist that builds an xsd:dateTime from an xsd:date and an x

Re: [Virtuoso-users] Describe without default graph give partial result

Hi Nicola, The procedures can be found in ~/libsrc/Wi/sparql.sql of a Virtuoso open source archive ie https://github.com/openlink/virtuoso-opensource/blob/develop/7/libsrc/Wi/sparql.sql Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.open

Re: [Virtuoso-users] Implicit ordering

Hi Štěpán For a stable/consistent pagination, an ORDER BY is always necessary. Even if the data is constant and the statistics of indexes are not refreshed between fetching different pages, the optimizer can chose different ordering depending on number of rows to skip and return. In fact no ORD

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, You still have not provided the "profile" for each query. You can do this by running "SET PROFILE ON/OFF" as did for the explain plans ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.ope

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-18 19:19, Hugh Williams wrote: > Hi Bart, > > The explain command whilst useful only provide the compile into,, where > the new v7 "profile(0" function provided both compile and execute info. > and it was I requested ie > > profile('select * from table where field = ''text'''); > > The p

[Virtuoso-users] Implicit ordering

Hi, I'm working with Silk to find links within a dataset. I have several graphs, each with tens of thousands of resources for linking in a Virtuoso instance. When given Virtuoso SPARQL endpoint parameters to Silk it is able to load in batches (default by 1000) all resources needed, even though

Re: [Virtuoso-users] Describe without default graph give partial result

Hi Hugh, I am aware of the (un)defined output of DESCRIBE but here are some reason why I think this output is "wrong": * SPARQL rec says: " The |DESCRIBE| form " assembles a single RDF graph by taking a "description" which can come from ANY information available including the target RDF

Re: [Virtuoso-users] MaxCheckpointRemap parameter

Hi Bart, MaxCheckpointRemap is applicable to both sections as it relates to the main DB and the temp DB and in both cases should be set to about 1/4 of he database size. It is mainly required for the main database ie "[Paramters]" section as the temp DB tends not to grow that much and the defau

Re: [Virtuoso-users] When is a bulk load done?

Hi Paul, If there are still rdf_loader_run() processes running then the "status();" would show this to be the case or whatever other process might be running, but if all files are in ll_state=2 in the load_list table then no rdf_loader_run() processes should be in use. Best Regards Hugh Willia

Re: [Virtuoso-users] Describe without default graph give partial result

Hi Nicola, The SPARQL specification does not define the precise output of DESCRIBE, so different applications may need different results for the same subject, see the following documentation for more details: http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsqlfromsparqldescribe

Re: [Virtuoso-users] Describe without default graph give partial result

On 4/22/14 5:02 AM, ghirardi nicola wrote: I'm facing the following error: http://answers.semanticweb.com/questions/22955/describe-in-virtuoso-unexpected-behaviour Running sparql describe returns only triples within some graphs and not the complete store. It gives different result running select

[Virtuoso-users] LOADing SQL dump from POD & Fwd: LOAD TO VIRTUOSO (SQL DUMP)

Hi Jakub, Am I correct in assuming these are MySQL dumps you are seeking to load as is into Virtuoso ? As there are DDL differences between MySQL and Virtuoso so I would not expect this to work as is, unless the dumps are pure SQL-92 ? Virtuoso replication would probably be the best way to loa

Re: [Virtuoso-users] Describe without default graph give partial result

Hi Nicola, Are you able to provide a use case for recreation ie against one of our live endpoint like dbpedia.org/sparql or lod.openlinksw.com/sparql or datasets for local recreation ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openl

Re: [Virtuoso-users] Describe without default graph give partial result

On 4/22/14 11:55 AM, ghirardi nicola wrote: Hi Hugh, You can find my test sparql endpont here: http://rdi.cineca.it/query/public/sparql Describe query: DESCRIBE Select query: SELECT * WHERE {