Re: [Virtuoso-users] Publish and query relational data as RDF

2010-05-03 Thread Kingsley Idehen
Silvia Stefanova wrote: Hello, I am using V5 and I would like to query by Sparql relational data stored in MS SQL server. In order to achive this I made the following steps: 1) Link my database ( a table person with columns sn, name, tel) from MSSQL server into Virtuso 2) Go through 'Generate

[Virtuoso-users] Publish and query relational data as RDF

2010-05-03 Thread Silvia Stefanova
Hello, I am using V5 and I would like to query by Sparql relational data stored in MS SQL server. In order to achive this I made the following steps: 1) Link my database ( a table person with columns sn, name, tel) from MSSQL server into Virtuso 2) Go through 'Generate and Publish RDF view' an

Re: [Virtuoso-users] Query performance issues

2010-05-03 Thread Sebastian Trüg
On 05/03/2010 12:55 PM, Kingsley Idehen wrote: > Sebastian Trüg wrote: >> Hi Ivan, >> >> while this is very good to know it is hard to do it generically. After >> all users and developers can create all sorts of queries. >> >> Thanks for the explanation. >> >> Can this be considered a bug in the qu

Re: [Virtuoso-users] Query performance issues

2010-05-03 Thread Kingsley Idehen
Sebastian Trüg wrote: Hi Ivan, while this is very good to know it is hard to do it generically. After all users and developers can create all sorts of queries. Thanks for the explanation. Can this be considered a bug in the query optimizer? Sebastian, Cost based Query Optimization is a bo

Re: [Virtuoso-users] Query performance issues

2010-05-03 Thread Sebastian Trüg
Hi Ivan, while this is very good to know it is hard to do it generically. After all users and developers can create all sorts of queries. Thanks for the explanation. Can this be considered a bug in the query optimizer? Cheers, Sebastian On 05/03/2010 10:20 AM, Ivan Mikhailov wrote: > Hello Seb

Re: [Virtuoso-users] Grant rdfs_rule_set

2010-05-03 Thread Hugh Williams
Hi Roberto, You would need to grant execute rights on rdfs_rule_set to the new user as follows: grant execute on rdfs_rule_set to "new_user" You can execute this either from the Virtuoso command line isql tool or the iSQL interface in the Conductor. Note the double quotes around the n

[Virtuoso-users] Grant rdfs_rule_set

2010-05-03 Thread Roberto García
Dear all, What should I do to grant a new user account permission to execute "rdfs_rule_set"? Currently I've added roles SPARQL_SELECT and SPARQL_UPDATE but I can find the "rdfs_rule_set" procedure in Conductor System Admin/Users Accounts/Grants and I get: virtuoso.jdbc3.VirtuosoException: SR186:

Re: [Virtuoso-users] Query performance issues

2010-05-03 Thread Ivan Mikhailov
Hello Sebastian, With select * where { ?r a nfo:FileDataObject . ?r nfo:fileName ?f . ?f bif:contains 'breaking' . } the optimizer decides for some reason that being nfo:FileDataObject is much less frequent property of ?r than containing "breaking" word in a filename. That's weird decision becau