Re: [Virtuoso-users] Geo SPARQL : is it possible to do this ?

Hi Oliver, Did you build from the git stable/7 or develop/7 branch as there is a fix for this No table rdf_obj issue in develop/7 ? https://github.com/openlink/virtuoso-opensource Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Virtuoso: automatically generated graphs

be creating these additional graphs in the Quad Store ? There are any number of RDF insert methods that can be used with Virtuoso as detailed at [2], could someone else be inserting data into the server ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] Virtuoso DEB Packages

Hi Alexandru, We could consider offering this, what debian/ubuntu version would it be required for ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http

Re: [Virtuoso-users] Creating a rdf_sink folder

Hi Gofran, How exactly did you attempt to migrate from v6 to v7 and what is the error you get when attempting to create a new Web DAV Folder ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] Returning multiple result sets from stored procedure

needed to calculate things is not possible in a single select statement ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink

Re: [Virtuoso-users] question about locks

at: http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiaglocking Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company

Re: [Virtuoso-users] cannot edit dba user account vers 6.1.8

Hi Jason, This problem has been fixed in the open source git develop/6 branch, see: http://sourceforge.net/p/virtuoso/virtuoso-opensource/ci/56f47f979572ce0ed0d09fb136658b093d23259e/ Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Configuring implicit inferencing

has rules_B, what should sparql ADD g_A TO g_B do --- to add original triples or to add both original and inferred triples? Same is for replication. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] Passing Java String Array to Virtuoso Stored Procedure

... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http

Re: [Virtuoso-users] External Data Sources

Views which is more the norm ? As you indicate External Data Sources ie the Virtual Database Engine is not supported in open source as it is a commercial only feature. In what way does the commercial trail license not suffice for your needs in terms of concurrent connections ? Best Regards Hugh

Re: [Virtuoso-users] Virtuoso JDBC error

turn tracing on on the server with trace_on() [1] to get extra information in the Virtuoso log as to what are the last operations being performed. You can also enable the CallStackOnExcpetion[2] INI file param to potentially obtained more detailed errors on the client side. Best Regards Hugh

Re: [Virtuoso-users] Using column store structure for exiting data

Bart, On 26 May 2014, at 13:03, Bart Vandewoestyne bart.vandewoest...@telenet.be wrote: On 2014-05-18 16:11, Hugh Williams wrote: Hi Sumit Ah, didn't realise you started with a v6 row store database, thus how did you upgrade to v7 ? As if you simply check pointed and restarted the v6

Re: [Virtuoso-users] Virtuoso graph traversal operations

Hi Eugen, There has not been a follow-up to the blog post you refer to. What form of graph traversal operations are you seeking to perform or what is the use case you are seeking to implement ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Query via HTTP POST

Hi Olga, I have been able to recreate this , we are looking into it ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink

Re: [Virtuoso-users] Geometric Objects

to a particular integer value, nothing else. For real transformation of coordinates from one system to another, the ST_Transform() functions should be used which we are currently finalising the implementation of ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] cannot edit dba user account vers 6.1.8

Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] Geometric Objects

(''); REPORT VARCHAR ___ OpenLink Virtuoso Server Version 07.10.3209-pthreads for Darwin as of May 22 2014 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com

Re: [Virtuoso-users] Geometric Objects

on updates to the online docs to details the new types supported ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software

Re: [Virtuoso-users] Virtuoso Update query using Jena

Hi Gofran, As the request does not appear to be reaching the server, can you confirm that you explicitly changed the HTTP port for Virtuoso from it default of 8890 to 80, as the sparql endpoint URL you are giving is using port 80 ? Best Regards Hugh Williams Professional Services OpenLink

Re: [Virtuoso-users] Virtuoso Update query using Jena

Hi Gofran, If you turn server side tracing on in Virtuoso using the trace_on() [1] command is the request actually reaching the server ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com

Re: [Virtuoso-users] Error 22023/SR496 and full text search not working

/sparqlextensions.html#rdfsparqlrulespecifywhatindex Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http

Re: [Virtuoso-users] Virtuoso Update query using Jena

Hi Gofran, The trace results are written to the virtuoso.log in the database directory on the server ... remember to run trace_off() to turn it off when done otherwise the log can grow quite quickly especially if all tracing is on ... Best Regards Hugh Williams Professional Services OpenLink

Re: [Virtuoso-users] Using column store structure for exiting data

this answers your questions ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink

Re: [Virtuoso-users] Using column store structure for exiting data

this answers your questions ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink

Re: [Virtuoso-users] Using column store structure for exiting data

Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] Using column store structure for exiting data

rows to column wise are provided ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com

Re: [Virtuoso-users] Error 22023/SR496 and full text search not working

is but you could consider dumping the triples from the original database to file and reloading them into an empty database with the new binary using the dump and reload scripts at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFDatasetDump Best Regards Hugh Williams

Re: [Virtuoso-users] Using column store structure for exiting data

created as column wise. So any data loaded in the Quad Store using the RDF Bulk loader ie rdf_loader_run / ld_dir or any other method will be loaded in the Column wise Quad Store. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Graph List does not get updated after RDF load

to see if this resolves the problem ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com

Re: [Virtuoso-users] Graph List does not get updated after RDF load

to ensure that is committed to the database ? Does the load_list table indicate that all the datasets where loaded successfully ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] Using column store structure for exiting data

used for storing RDF data, which are created as column wise by default when a new v7 database is created, as is best suited for hosting RDF datasets. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] Cryptic error when BINDing a variable

Hi Oliver, I have reported this issue to development to look into, will let you know when there is a fix ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http

Re: [Virtuoso-users] Setting T_MAX_memory parameter in virtuoso.ini?

Hi Nicola, The param tn_max_memory can be set in the [Flags] section of the INI file or with the __dbf_set() function detailed at: http://docs.openlinksw.com/virtuoso/fn_dbf_set.html to control the transitive memory size ... Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] Max columns per table?

Hi Pascal, By vertical storage I presume you mean column store ? Will have to check with the development if such a limit still exists on columns/per table. What is the version you are using (virtuoso-t -?) ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] isparql receives wrong response format

-instance; xsi:schemaLocation=http://www.w3.org/2001/sw/DataAccess/rf1/result2.xsd; and I can't see how the request types can be changed in isparql, so will have to check with development to see if/how this can be done and why the change was made ... Best Regards Hugh Williams Professional

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

query plan may or may not have changed, but can't say for sure ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software

Re: [Virtuoso-users] GRAPHS

This is with a develop/7 git open source build, what version are you running also what is the version of rdb2rdf vad you installed and does this occur if you start with an empty database ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Instructions to upgrade to V 7.1.0

the fixes since the stable/7 release, as detailed at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] PROBLEM WITH HTTP_CLIENT

#ptunemetricdiagsqlissues which may provide more information in the client side and possibly in the Virtuoso Server log as to why this http_client error is occurring. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] seeing what parameters are in effect

, UseAIO, c_c_use_aio) == -1) c_c_use_aio = 0; if (cfg_getlong (pconfig, section, AsyncQueueMaxThreads, c_aq_max_threads) == -1) c_aq_max_threads = 10; Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] Incorrect query results with property paths and variable graphs (VOS 7.10.3207 Windows)

Hi Dominic, I see similar results testing against the latest develop/7 branch, have reported to development to look into ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] R2RML PROBLEM

Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] load into graph specified by nquads

Hi Mark, Have you actually tried it, as the 3rd param will simply be ignored it is an nquad file, just as it would if there are source-file.ext.graph or global.graph which would override the ld_dir() 3rd param setting, we load nquad all the time with the bulk loader ... Best Regards Hugh

Re: [Virtuoso-users] Problem with building VOS from Github

Hi Barry, Note this issue building on Ubuntu 14.04 has been fixed: https://github.com/openlink/virtuoso-opensource/issues/160 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com

Re: [Virtuoso-users] Export TABLE to CSV

you are welcome to try it and let us know if it works for you ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software

Re: [Virtuoso-users] speeding up SPARQL query

msec 0 reads 0% read 0 messages 0% clw 4 Rows. -- 1 msec. SQL Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink

Re: [Virtuoso-users] speeding up SPARQL query

know what they report ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink

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

to load from MySQL to Virtuoso, although replication is not part of Virtuoso open source as it is a commercial only feature ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] MaxCheckpointRemap parameter

and the default of 2000 could probably suffice in most cases ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http

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

() running. On Mon, Apr 21, 2014 at 10:52 PM, Hugh Williams hwilli...@openlinksw.com wrote: Hi Paul, Using the Virtuoso RDF Bulk Loader (rdf_loader_run) as you appear to be, the load is complete when all files in the load_list table have an ll_state = 2 , 0 means still to be loaded, 1

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

Thus you should specify the graphs or mode to use otherwise the graphs guessed might can be different than expected ie not the same as the select query ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

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

Re: [Virtuoso-users] Implicit ordering

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 Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

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

/VirtTipsAndTricksGuideLDMeterUtility Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google

Re: [Virtuoso-users] Problem with building VOS from Github

Hi Barry, This issue is scheduled to be looked into by developed, there is a git issue logged for it at: https://github.com/openlink/virtuoso-opensource/issues/160 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com

Re: [Virtuoso-users] Tips to prevent hanging TTLP_MT?

command report as being used by Virtuoso ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http

Re: [Virtuoso-users] speeding up SPARQL query

http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#EfficientSQL Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software

Re: [Virtuoso-users] Tips to prevent hanging TTLP_MT?

the bulk loader, although I did notice its existence when looking for help on the web. I assumed that when TTLP_MT() hangs when I call it from isql it would also hang when I use rdf_loader_run(). But maybe I should just give it a try. Regards, Frans On 2014-04-18 12:43, Hugh Williams

Re: [Virtuoso-users] speeding up SPARQL query

Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] speeding up SPARQL query

suggest you update your binary to the latest develop/7 archive, as the have been many many query optimisation improvements since then: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] speeding up SPARQL query

Bart, On 17 Apr 2014, at 15:42, Bart Vandewoestyne bart.vandewoest...@telenet.be wrote: On 2014-04-17 15:04, Hugh Williams wrote: Hi Bart, I note your Virtuoso version is reported as Version 07.00.3203-pthreads for Linux as of Mar 26 2014 which despite having been be built in March 2014

Re: [Virtuoso-users] speeding up SPARQL query

be removed and the server restarted: 2 buffers, 19878 used, IndexTreeMaps = 64 NumberOfBuffers = 200 MaxDirtyBuffers = 150 [HTTPServer] Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] Virtuoso 7: can't open Web Application Server tab

Hi Olga, Sounds like you are running a rather old v6 build (virtuoso-t -?) , try running the following to add the missing column required in latest builds: alter table WS.WS.SYS_DAV_RES add RES_SIZE integer Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] REST Web Services

Hi Ricardo, Have your reviewed the documentation below on publishing stored procedures as web services: http://docs.openlinksw.com/virtuoso/expwsmodules.html#expwsmodules Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Objects of data properties are broken for QUAD maps/SPAQRL views

Hi Alex, The table schema and some sample data to load would be required for recreation. Also, did you create the RDFView mappings by hand or using the conductor Linked Data View wizard ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Objects of data properties are broken for QUAD maps/SPAQRL views

Hi Alex, Are you able to provide a simple test case for recreation of this issue ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company

Re: [Virtuoso-users] problems loading Virtuos on Google cloud

Andrejs, On 9 Apr 2014, at 12:17, Andrejs Abele andr...@sindicetech.com wrote: Hi Hugh, 1. yes it was client side loader that crashes [Hugh] Why does the java client app crash if all it is really doing is activate the rdf_loader_run() function on the Virtuoso server ? 2. we run only one

Re: [Virtuoso-users] problems loading Virtuos on Google cloud

Andrejs, On 8 Apr 2014, at 22:36, Andrejs Abele andr...@sindicetech.com wrote: Hi Hugh, Thank you for your comments. When the loader fails, I continue from the point it failed. I want to clarify, that virtuoso server, was not crashing, but the loader. [Hugh] So it is your client side loader

Re: [Virtuoso-users] virtuoso service stops

and are they available for public download ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com

Re: [Virtuoso-users] Virtuoso crash when try to delete a huge graph

provide the output of running the command ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http

Re: [Virtuoso-users] Virtuoso SPARQL response limit

: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtSPARQLEndpointProtection Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com

Re: [Virtuoso-users] Sparql http update request with multiple update statements

for authentication and will then allow you to perform write operations, see the following docs for more details: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideSPARQLEndpoints Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] NumberOfBuffers confusion

Bart, On 1 Apr 2014, at 12:04, Bart Vandewoestyne bart.vandewoest...@telenet.be wrote: On 2014-04-01 11:35, Hugh Williams wrote: Hi Bart, You should set the NumberOfBuffers based on the amount of free memory available on the system , thus about 7.1GB * 0.66 / 8K (each buffer is 8K

Re: [Virtuoso-users] MaxCheckpointRemap set correct?

Hi Bart, It is the physical database size as the NumberOfBuffers is a memory param and the database size is the size on disk, where the checkpoint it committing the data to ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http

Re: [Virtuoso-users] Source quality (qs=...) values for SPARQL result variants in content negotiation

Hi Dorian, Currently the Virtuoso SPARQL endpoint expects one value in this header and always prefers to use the ‘format’ url parameter. Development are working on a fix to allow such accept headers and I shall notify when it is available ... Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] getting large SPARQL result sets

Hi Jakub, For a stable/consistent pagination, ORDER BY is always necessary. Even if data are constant and 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. Best Regards Hugh

Re: [Virtuoso-users] Strange result from SPARQL function st_within

Hi Frans, I am seeking confirmation from development on this ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software

Re: [Virtuoso-users] Strange result from SPARQL function st_within

will be extended in the next release. I hope this answers your question. Genarally, if you can provide some sample data and the queries being run it would help in understanding of the issue being reported ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] Geo SPARQL support

some live sample queries for the geometries support at: http://virtuoso.openlinksw.com/tutorials/sparql/SPARQL_Tutorials_Part_11/SPARQL_Tutorials_Part_11.html#(1) Note, you need to be using Virtuoso 7.1+ open source or commercial ... Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] Problem loading geographical data

Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] xsd:boolean in Virtuoso 7

Frans, On 17 Mar 2014, at 15:53, Frans Knibbe | Geodan frans.kni...@geodan.nl wrote: On 2013-11-08 7:37, Quentin wrote: Is it likely that Virtuoso 7 will come to support xsd:boolean without integer conversion? A good question. I have just noticed that when I import boolean literals

Re: [Virtuoso-users] Property functions in Virtuoso

Hi Alex Have you looked at the Star Schema bench mark which creates OLAP queries using SPARQL ? http://people.aifb.kit.edu/bka/ssb-benchmark/ Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] sparql INSERT with URI fragments not working

Hi Rob, You are correct, thanks for pointing that out ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter

Re: [Virtuoso-users] Literals, STR() in FILTER and query plan

1msec for the subsequent run, thus it would be interesting to see the complete compilation times of each query run which would also show the execution time ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http

Re: [Virtuoso-users] Property functions in Virtuoso

use case ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http

Re: [Virtuoso-users] ODBC architecture mismatch error using Virtuoso 07.10.3207

Pressac Traitement et analyse de bases de données Centre de Recherche Bretonne et Celtique UMS 3554 20 rue Duquesne CS 93837 29238 Brest cedex 3 tel : +33 (0)2 98 01 68 95 fax : +33 (0)2 98 01 63 93 Le 05/03/2014 18:39, Hugh Williams a écrit : Hi Jean-Baptiste, So the 7.1 ODBC Driver

Re: [Virtuoso-users] Freebase bulk loading is sluggish

Hi Can you please provide a copy of your virtuoso.ini file and the output of running the status(); command from isql ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] ODBC architecture mismatch error using Virtuoso 07.10.3207

Hi Jean-Baptiste, So the 7.1 ODBC Driver which is 64bit does work with your 64bit Apache/PHP version, whereas the 7.0 ODBC driver which should also be 64bit is giving the windows 193 system error ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] splt_and_decode

'; return split_and_decode(‘test+test+test',0,'%+'); } which returns: SQL select test.test.testUrlDecode1 (); testUrlDecode1 VARCHAR ___ test test test 1 Rows. -- 0 msec. SQL Best Regards Hugh Williams Professional Services

Re: [Virtuoso-users] compiling virtuoso-7 on FreeBSD 9.2 stops with flex errors

Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com

Re: [Virtuoso-users] Arrow keys in isql/Linux

#Configuring It is not enabled by default due to licensing issues on some OS'es ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink

Re: [Virtuoso-users] URI resources redirection to fct page

#AncmozTocId313638 Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google

Re: [Virtuoso-users] splt_and_decode

Hi Quinten, I am checking this with development ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter

Re: [Virtuoso-users] Exception thrown when deleting existing user

'); test.test.testUserDrop(1) }; Done. -- 1 msec. SQL test.test.testUserDrop(); Done. -- 2 msec. SQL user_drop('testUser'); Done. -- 2 msec. SQL Will ask development to check why the might be occurring via the Conductor ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc

Re: [Virtuoso-users] Virtuoso 7 query intermittently failing to return results

(*) from RDF_QUAD table option (index RDF_QUAD) select count(*) from RDF_QUAD table option (index RDF_QUAD_POGS) select count(*) from RDF_QUAD table option (index RDF_QUAD_SP) If you can provide a lcopy of the DB file it can be checked. ... Best Regards Hugh Williams Professional

Re: [Virtuoso-users] Startup error on stable7

Hi Quentin, You can use the DB.DBA.RDF_AUDIT_METADATA() to check and attempt to repair any issue found in the RDF meta data ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs

Re: [Virtuoso-users] Erratum inside Virtuoso Tips and Tricks wiki page

Hi Julien, Thanks for pointing this out, I have correct the page .. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software

Re: [Virtuoso-users] 7.1 /sparql unavailable (compression, character encoding problems)

additional tracing on the the Virtuoso server with the trace_on() command and see if any errors are logged that might provide more information, see: http://docs.openlinksw.com/virtuoso/fn_trace_on.html Then provide a copy of your virtuoso.log file for review ... Best Regards Hugh Williams

Re: [Virtuoso-users] Function db.dba.ttlp does not save XML datatype

Hi Enrico, The fix will typically make its way to the git develop/7 branch when available. You can track updates to this branch with the following atom RSS feed: https://github.com/openlink/virtuoso-opensource/commits/develop%2F7.atom Best Regards Hugh Williams Professional Services

<    1   2   3   4   5   6   7   8   9   10   >