Re: [Virtuoso-users] cite virtuoso

Am 11.05.2011 18:29, schrieb Pierre-Yves Chibon: > I was wondering, does anybody know how people have referred to Virtuoso > on published article? > Is there an article which have been published, or should be refer to the > website? There is the following article, which is commonly cited for Virtu

Re: [Virtuoso-users] DISTINCT query problem

/VirtuosoPHP documentation. I shall look into why the "odbc_fetch_array()" function is problematic in the morning ... Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw

[Virtuoso-users] DISTINCT query problem

Hi all, I have a problem with a SPARQL query using the DISTINCT feature. I installed the commercial Virtuoso 6.2 distribution for Windows. In order to run some experiments, I loaded the 1M BSBM data [1]. When I run the following query in conductor I get the correct results: SELECT DISTINCT ?o F

Re: [Virtuoso-users] SQL subquery embedded in a SPARQL query

On 14.07.2010 4:38, Ted Thibodeau Jr wrote: While not exactly what you're asking for, this may be sufficient for what you want to achieve -- Yes, we have seen this, but this will be very inefficient for large datasets.

[Virtuoso-users] SQL subquery embedded in a SPARQL query

Hi, For some experiments we plan to run it would be very useful to embed an SQL query as a subquery inside a SPARQL query. We want to combine relational with RDF data for example in the following way: Lets assume we have foaf profiles in the triple store and a relational table with informati

[Virtuoso-users] Transaction aborted because it's log after image size went above the limit

Hi all, When creating a table from a select query we got the following error message: Transaction aborted because it's log after image size went above the limit at line 18 of Top-Level: CREATE TABLE DB.DBA.ef_cache_gpv_d3455cb7d101000cacfe8a90d6b68970 AS SELECT __ro2sq ("s-6-0_rbc"."produc

Re: [Virtuoso-users] Scalable SPARQL querying in PHP?

Daniel Alexander Smith wrote: I've been using the ARC PHP libraries to query my local Virtuoso SPARQL end point. While this works fine for small amounts of data, the Why do you need the ARC libraries? You can just query Virtuoso via an ODBC connection. This is very scalable and there should

Re: [Virtuoso-users] Insert data fast

Ivan Mikhailov wrote: Unfortunately, we can offer plain INSERTs only, but they're not bad, esp. when parametrized. You mean wen run as prepared statements? Your request for fast CSV loading is the first one for this feature, we can schedule that, but not for this month, I'm afraid. I guess

Re: [Virtuoso-users] Insert data fast

Kingsley Idehen wrote: Are you loading SQL. RDF, or RDF via SQL channel into Virtuoso? We need to know which of these you mean before providing a response about optimal paths. Its just plain SQL - else I wouldn't have compared Virtuoso to MySQL ;-) --Sören

[Virtuoso-users] Insert data fast

Hi, I'm currently making some experiments with loading really large data into Virtuoso and I'm wondering whether there are ways to speed up loading of data into empty tables. mySQL e.g. allows to disable keys and to load data from CSV files, which is by factor 5 faster than traditional insert

[Virtuoso-users] Problem with quietcast option

For our DBpedia query builder I need the quitecast option, but I'm not getting it to work. Consider the following simplified example: create table qctest (value varchar); insert into qctest values('100'); insert into qctest values('1000'); insert into qctest values('abc'); Now I'm trying: select

Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

On 10/7/07, Virtuoso Maintainer wrote: > I am currently in contact with the pdo_odbc module owner. I will discuss > with him the current implementation of pdo_odbc and see if we can put > some more calls into this implementation. I will also see if we can > introduce a setting for the php odbc mod

Re: [Virtuoso-users] Check if a table exists / retrieve list of tables

On 10/6/07, Yrjänä Rankka wrote: > Here's one way I've used before. To query for a specific table DB.DBA.FUBAR: > select 1 from sys_keys where key_table = 'DB.DBA.FUBAR'; Thanks that helped! Sören

[Virtuoso-users] Check if a table exists / retrieve list of tables

Hi all, I spend some time today trying to figure out how I can check if there exists a table with a certain name. For the PHP ODBC module there exists the function odbc_tables(), which works. However, due to the problem of the PHP ODBC module with TOP queries I'm now using the pdo_odbc module, whi

Re: [Virtuoso-users] Problem with TOP queries

I finally found a solution: the pdo_odbc driver seems to work fine :-) Quite easy solution, but it took me a while to figure that out :-( Sören

Re: [Virtuoso-users] Problem with TOP queries

On 10/5/07, Mitko Iliev wrote: > The problem is that php open the cursor as dynamic, as a workaround can > try to set the cursor as forward only. That seems to be too complicated for me right now. I'm also wondering why TOP is even not considered if I do SELECT DISTINCT, which according to the do

Re: [Virtuoso-users] ENUM and SET column types

On 10/5/07, Rumi Tsekova wrote: > You can add check constraint either in the create table statement, or add it > afterwards. > > i.e. for ex.: > > create table person ( > name varchar, > likes_fruits varchar CHECK ( likes_fruits in ('apple', 'pear','orange')) > ); Yes, but I'm not so much bothere

[Virtuoso-users] Problem with TOP queries

Hi all, I tried the following code with both Virtuoso for Windows and Linux: $db=odbc_connect('virtuoso','dba','dba'); $result = odbc_exec($db,'SELECT TOP 3 * FROM DB.DBA.SYS_USERS'); print_r(odbc_result_all($result)); However, I always get the full result set and not just the top three as I wou

[Virtuoso-users] ENUM and SET column types

Hi all, MySQL has the neat feature of defining a table column to be a enumeration or set of a number of elements, e.g.: create table person ( name varchar, sex enum('male', 'female') ) or: create table person ( name varchar, likes_fruits set('apple', 'pear','orange') ) I guess somethin

Re: [Virtuoso-users] virtuoso-php5-t crashes on Vista with malformed SQL

On 10/3/07, Hugh Williams wrote: > 1. Confirm the Version of the Virtuoso ODBC Driver being used which can be > obtain from the Drivers Tab of the ODBC Administrator The drivers tab contains for Virtuoso: Name: Virtuoso (Open Source) Version: Not marked Company: Not marked File: VIRTODBC.DLL Lis

[Virtuoso-users] virtuoso-php5-t crashes on Vista with malformed SQL

When sending malformed SQL via ODBC to Virtuoso virtuoso-php5-t crashes without any error. I'm executing the following PHP: $db=odbc_connect('virtuoso','dba','dba'); $result = odbc_exec($db,'SELECT * FROM DB.DBA.SYS_USERS'); print_r(odbc_result_all($result)); everything works fine and as expected

Re: [Virtuoso-users] Virtuoso with PHP on Windows

I saw you updated the Virtuoso on Windows guide quickly :-) Just one little remark: if Virtuoso runs as a service the DSN should be created as a "System DSN" - "User DSN" won't work, but is opened as a default in the ODBC connections dialog. Cheers, Sören

Re: [Virtuoso-users] Virtuoso with PHP on Windows

On 10/3/07, Mitko Iliev wrote: > To the basic installation steps from > http://virtuoso.openlinksw.com/wiki/main/Main/VOSUsageWindows could be > added following in regard to Virtuoso with PHP hosting : > > The PATH variable in the system wide environment must have : > > \bin;\lib; Ok - maybe you

Re: [Virtuoso-users] Virtuoso with PHP on Windows

On 10/2/07, Patrick van Kleef wrote: > OpenLink provides a zip file with a complete build of VOS, now > including also the binary and support libraries for php5 hosting: > > http://virtuoso.openlinksw.com/wiki/main/Main/VOSDownload Thanks, that helps indeed. However, I think the installation

[Virtuoso-users] Virtuoso with PHP on Windows

Hi all, together with my team, we would like to bring our semantic collaboration platform OntoWiki [1] together with Virtuoso. Many first-time OntoWiki users (and also some developers such as me) use Windows to test-drive (or develop) OntoWiki. Hence, it is a fundamental requirement for us that ev

[Virtuoso-users] Virtuoso on Vista

Hi all, I'm trying to get virtuoso-opensource-win32-5.0.1 running on Windows Vista. Unfortunately, when I try to register the ODBC driver as described in [1] as follows: regsvr32 virtodbc.dll RegSvr32 responds with the following error message: The module "virtodbc.dll" was loaded but the call