subject:"\[Virtuoso\-users\] triples not reached by the index\?"

[Virtuoso-users] triples not reached by the index?

2017-05-13 Thread Beppe Mazzola

Hi to everybody

I have generated with Virtuoso Open Source a virtual graph with the content
of many RDB tables.obtained with an R2RML mapping.

If I execute the following query I do not get any result.

select *
from
where {
  ?p ?o.
}

but if I execute this query (I suppose without index because it takes many
seconds)

select *
from
where {
?s ?p ?o filter regex(str(?s),'annex-0') .
}


I get the exact result, that is the content of the corresponding table row.

http://example.com/pesticides/resource/annex-0

http://

example.com
/pesticides/resource/annexId
0
http://example.com/pesticides/resource/annex-0

http://

example.com
/pesticides/resource/annexName
Not Assigned
http://example.com/pesticides/resource/annex-0

http://

example.com
/pesticides/resource/annexSpecial
0
http://example.com/pesticides/resource/annex-0

http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://

example.com

/pesticides/resource/Annex

It looks like the index does not catch the triples  This is the
involved R2RML mapping fragment

<#TriplesMapANNEXES> a rr:TriplesMap;
rr:logicalTable [
rr:tableSchema "DB" ;
rr:tableOwner "pest" ;
rr:tableName "ANNEXES"
];
rr:subjectMap [
rr:termType rr:IRI  ;
rr:template "
http://example.com/pesticides/resource/annex-{ANNEXES_ID}";;
rr:class pest:Annex;
rr:graph  ];
rr:predicateObjectMap [
rr:predicateMap [
rr:constant pest:annexId ] ;
rr:objectMap [
rr:column "ANNEXES_ID" ]; ] ;
rr:predicateObjectMap [
rr:predicateMap [
rr:constant pest:annexName ] ;
rr:objectMap [
rr:column "ANNEXES_NAMES" ]; ] ;
rr:predicateObjectMap [
rr:predicateMap [
rr:constant pest:annexPart ] ;
rr:objectMap [
rr:column "ANNEXES_PART" ]; ] ;
rr:predicateObjectMap [
rr:predicateMap [
rr:constant pest:annexSpecial ] ;
rr:objectMap [
rr:column "ANNEXES_SPECIAL" ];
] .

of the following Virtuoso table

CREATE TABLE DB.PEST.ANNEXES
(
  ANNEXES_ID NUMERIC NOT NULL
, ANNEXES_NAMES VARCHAR(50) NOT NULL
, ANNEXES_PART VARCHAR(1)
, ANNEXES_SPECIAL CHAR(1) NOT NULL
, CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )
);

Had anyone a similar experience? Any hint?

Thanks!

Cheers

Beppe
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] triples not reached by the index?

2017-05-14 Thread Hugh Williams

Hi 

Can you please provide the actual steps to reproduce the issue being 
encountered as it is not clear from the information 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/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 13 May 2017, at 18:01, Beppe Mazzola  wrote:
> 
> Hi to everybody
> 
> I have generated with Virtuoso Open Source a virtual graph with the content 
> of many RDB tables.obtained with an R2RML mapping.
> 
> If I execute the following query I do not get any result.
> 
> select * 
> from >
> where {
>   > ?p ?o.
> } 
> 
> but if I execute this query (I suppose without index because it takes many 
> seconds) 
> 
> select * 
> from >
> where {
> ?s ?p ?o filter regex(str(?s),'annex-0') .
> } 
> 
> 
> I get the exact result, that is the content of the corresponding table row.
> 
> http://example.com/pesticides/resource/annex-0  
> http://
>  
> example.com
>  
> /pesticides/resource/annexId
>   0
> http://example.com/pesticides/resource/annex-0 
>  
> http:// 
> example.com
>  
> /pesticides/resource/annexName
> Not Assigned
> http://example.com/pesticides/resource/annex-0 
>  
> http:// 
> example.com
>  
> /pesticides/resource/annexSpecial
>  0
> http://example.com/pesticides/resource/annex-0 
>  
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type  
> http:// 
> example.com
>  
> /pesticides/resource/Annex
> 
> It looks like the index does not catch the triples  This is the involved 
> R2RML mapping fragment
> 
> <#TriplesMapANNEXES> a rr:TriplesMap;
> rr:logicalTable [ 
> rr:tableSchema "DB" ;
> rr:tableOwner "pest" ;
> rr:tableName "ANNEXES" 
> ]; 
> rr:subjectMap [ 
> rr:termType rr:IRI  ;
> rr:template 
> "http://example.com/pesticides/resource/annex-{ANNEXES_ID} 
> ";
> rr:class pest:Annex;
> rr:graph  /pesticides/resource> ];
> rr:predicateObjectMap [ 
> rr:predicateMap [
> rr:constant pest:annexId ] ;
> rr:objectMap [
> rr:column "ANNEXES_ID" ]; ] ;
> rr:predicateObjectMap [ 
> rr:predicateMap [
> rr:constant pest:annexName ] ;
> rr:objectMap [
> rr:column "ANNEXES_NAMES" ]; ] ;
> rr:predicateObjectMap [ 
> rr:predicateMap [
> rr:constant pest:annexPart ] ;
> rr:objectMap [
> rr:column "ANNEXES_PART" ]; ] ;
> rr:predicateObjectMap [ 
> rr:predicateMap [
> rr:constant pest:annexSpecial ] ;
> rr:objectMap [
> rr:column "ANNEXES_SPECIAL" ]; 
> ] .
> 
> of the following Virtuoso table
> 
> CREATE TABLE DB.PEST.ANNEXES 
> (
>   ANNEXES_ID NUMERIC NOT NULL 
> , ANNEXES_NAMES VARCHAR(50) NOT NULL 
> , ANNEXES_PART VARCHAR(1) 
> , ANNEXES_SPECIAL CHAR(1) NOT NULL 
> , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )   
> );
> 
> Had anyone a similar experience? Any hint?
> 
> Thanks!
> 
> Cheers
> 
> Beppe
> 
> 
> 
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! 
> http://sdm.link/slashdot___
> Virtuoso-users mailing list
> Virtuoso

Re: [Virtuoso-users] triples not reached by the index?

2017-05-16 Thread Beppe Mazzola

Hi Hugh

Here are the steps to reproduce the problem.

1) Create the table

CREATE TABLE DB.PEST.ANNEXES
(
  ANNEXES_ID NUMERIC NOT NULL
, ANNEXES_NAMES VARCHAR(50) NOT NULL
, ANNEXES_PART VARCHAR(1)
, ANNEXES_SPECIAL CHAR(1) NOT NULL
, CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )
);

2) initialize it with the attached script initANNEXES.sql

3) create the virtual graph with the attached script ttlpExecTrial.sql

4) query the virtual graph
select *
from 
where {
 #
?p ?o.
 ?s ?p ?o filter regex(str(?s),'annex-0') .
}

I have used Virtuoso Open Source Edition (multi threaded)
Version 7.2.4.3217-threads as of Apr 25 2016
Compiled for Win64 (x86_64-generic-win-64)

Cheers

Beppe


2017-05-14 22:53 GMT+01:00 Hugh Williams :

> Hi
>
> Can you please provide the actual steps to reproduce the issue being
> encountered as it is not clear from the information 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/OpenLink
> Google+  -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>
>
> On 13 May 2017, at 18:01, Beppe Mazzola  wrote:
>
> Hi to everybody
>
> I have generated with Virtuoso Open Source a virtual graph with the
> content of many RDB tables.obtained with an R2RML mapping.
>
> If I execute the following query I do not get any result.
>
> select *
> from
> where {
>   ?p ?o.
> }
>
> but if I execute this query (I suppose without index because it takes many
> seconds)
>
> select *
> from
> where {
> ?s ?p ?o filter regex(str(?s),'annex-0') .
> }
>
>
> I get the exact result, that is the content of the corresponding table row.
>
> http://example.com/pesticides/resource/annex-0
> 
> http://
> 
> example.com
> 
> /pesticides/resource/annexId  0
> http://example.com/pesticides/resource/annex-0
> 
> http://
> 
> example.com
> 
> /pesticides/resource/annexNameNot Assigned
> http://example.com/pesticides/resource/annex-0
> 
> http://
> 
> example.com
> 
> /pesticides/resource/annexSpecial 0
> http://example.com/pesticides/resource/annex-0
> 
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://
> 
> example.com
> 
> /pesticides/resource/Annex
>
> It looks like the index does not catch the triples  This is the
> involved R2RML mapping fragment
>
> <#TriplesMapANNEXES> a rr:TriplesMap;
> rr:logicalTable [
> rr:tableSchema "DB" ;
> rr:tableOwner "pest" ;
> rr:tableName "ANNEXES"
> ];
> rr:subjectMap [
> rr:termType rr:IRI  ;
> rr:template "http://example.com/pesticides
> /resource/annex-{ANNEXES_ID}";
> rr:class pest:Annex;
> rr:graph  ];
> rr:predicateObjectMap [
> rr:predicateMap [
> rr:constant pest:annexId ] ;
> rr:objectMap [
> rr:column "ANNEXES_ID" ]; ] ;
> rr:predicateObjectMap [
> rr:predicateMap [
> rr:constant pest:annexName ] ;
> rr:objectMap [
> rr:column "ANNEXES_NAMES" ]; ] ;
> rr:predicateObjectMap [
> rr:predicateMap [
> rr:constant pest:annexPart ] ;
> rr:objectMap [
> rr:column "ANNEXES_PART" ]; ] ;
> rr:predicateObjectMap [
> rr:predicateMap [
> rr:constant pest:annexSpecial ] ;
> rr:objectMap [
> rr:column "ANNEXES_SPECIAL" ];
> ] .
>
> of the following Virtuoso table
>
> CREATE TABLE DB.PEST.ANNEXES
> (
>   ANNEXES_ID NUMERIC NOT NULL
> , ANNEXES_NAMES VARCHAR(50)

Re: [Virtuoso-users] triples not reached by the index?

2017-05-16 Thread Beppe Mazzola

Hi Hugh

I have noticed something strange related to the PK index of the table
provided to you.

After having run all the scripts I executed again by chance the first
INSERT statement and VOS allowed me to do it! And I could see both the rows
with ID=0 in the table...
At this point if you delete the rows with ID=0 one of them is deleted, and
the remaining one is visible only with select not using the PK index. This
might have a relation with the original RDF view issue

I have used the Conductor Interactive SQL.

Cheers

Beppe


2017-05-16 9:25 GMT+01:00 Beppe Mazzola :

> Hi Hugh
>
> Here are the steps to reproduce the problem.
>
> 1) Create the table
>
> CREATE TABLE DB.PEST.ANNEXES
> (
>   ANNEXES_ID NUMERIC NOT NULL
> , ANNEXES_NAMES VARCHAR(50) NOT NULL
> , ANNEXES_PART VARCHAR(1)
> , ANNEXES_SPECIAL CHAR(1) NOT NULL
> , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )
> );
>
> 2) initialize it with the attached script initANNEXES.sql
>
> 3) create the virtual graph with the attached script ttlpExecTrial.sql
>
> 4) query the virtual graph
> select *
> from 
> where {
>  # resource/annex-0> ?p ?o.
>  ?s ?p ?o filter regex(str(?s),'annex-0') .
> }
>
> I have used Virtuoso Open Source Edition (multi threaded)
> Version 7.2.4.3217-threads as of Apr 25 2016
> Compiled for Win64 (x86_64-generic-win-64)
>
> Cheers
>
> Beppe
>
>
> 2017-05-14 22:53 GMT+01:00 Hugh Williams :
>
>> Hi
>>
>> Can you please provide the actual steps to reproduce the issue being
>> encountered as it is not clear from the information 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/OpenLink
>> Google+  -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>
>>
>> On 13 May 2017, at 18:01, Beppe Mazzola  wrote:
>>
>> Hi to everybody
>>
>> I have generated with Virtuoso Open Source a virtual graph with the
>> content of many RDB tables.obtained with an R2RML mapping.
>>
>> If I execute the following query I do not get any result.
>>
>> select *
>> from
>> where {
>>   ?p ?o.
>> }
>>
>> but if I execute this query (I suppose without index because it takes
>> many seconds)
>>
>> select *
>> from
>> where {
>> ?s ?p ?o filter regex(str(?s),'annex-0') .
>> }
>>
>>
>> I get the exact result, that is the content of the corresponding table
>> row.
>>
>> http://example.com/pesticides/resource/annex-0
>> 
>> http://
>> 
>> example.com
>> 
>> /pesticides/resource/annexId  0
>> http://example.com/pesticides/resource/annex-0
>> 
>> http://
>> 
>> example.com
>> 
>> /pesticides/resource/annexNameNot Assigned
>> http://example.com/pesticides/resource/annex-0
>> 
>> http://
>> 
>> example.com
>> 
>> /pesticides/resource/annexSpecial 0
>> http://example.com/pesticides/resource/annex-0
>> 
>> http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://
>> 
>> example.com
>> 
>> /pesticides/resource/Annex
>>
>> It looks like the index does not catch the triples  This is the
>> involved R2RML mapping fragment
>>
>> <#TriplesMapANNEXES> a rr:TriplesMap;
>> rr:logicalTable [
>> rr:tableSchema "DB" ;
>> rr:tableOwner "pest" ;
>> rr:tableName "ANNEXES"
>> ];
>> rr:subjectMap [
>> rr:termType rr:IRI  ;
>> rr:template "http://example.com/pesticides
>> /resource/annex-{ANNEXES_ID}";
>> rr:class pest:Annex;
>> rr:graph  ];
>> rr:predicateObjectMap [
>> rr:predicateMap [
>> rr:constant pest:annexId ] ;
>> rr:objectMap [
>>

Re: [Virtuoso-users] triples not reached by the index?

2017-05-22 Thread Beppe Mazzola

Hi Hughs

It seems the problem is not related to the RDF views tied to the tables,
because it happens even before executing the mapping.
The problem arises *only *when I bulk load data into the tables with the
tool Sqlworkbench/J using the Virtuoso JDBC driver virtjdbc4_2.jar.
So there is something in the Sqlworkbench/j or (it seems to me more likely)
in the JDBC driver that causes the issue.

Cheers

Beppe



2017-05-16 10:27 GMT+01:00 Beppe Mazzola :

> Hi Hugh
>
> I have noticed something strange related to the PK index of the table
> provided to you.
>
> After having run all the scripts I executed again by chance the first
> INSERT statement and VOS allowed me to do it! And I could see both the rows
> with ID=0 in the table...
> At this point if you delete the rows with ID=0 one of them is deleted, and
> the remaining one is visible only with select not using the PK index. This
> might have a relation with the original RDF view issue
>
> I have used the Conductor Interactive SQL.
>
> Cheers
>
> Beppe
>
>
> 2017-05-16 9:25 GMT+01:00 Beppe Mazzola :
>
>> Hi Hugh
>>
>> Here are the steps to reproduce the problem.
>>
>> 1) Create the table
>>
>> CREATE TABLE DB.PEST.ANNEXES
>> (
>>   ANNEXES_ID NUMERIC NOT NULL
>> , ANNEXES_NAMES VARCHAR(50) NOT NULL
>> , ANNEXES_PART VARCHAR(1)
>> , ANNEXES_SPECIAL CHAR(1) NOT NULL
>> , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )
>> );
>>
>> 2) initialize it with the attached script initANNEXES.sql
>>
>> 3) create the virtual graph with the attached script ttlpExecTrial.sql
>>
>> 4) query the virtual graph
>> select *
>> from 
>> where {
>>  #> esource/annex-0> ?p ?o.
>>  ?s ?p ?o filter regex(str(?s),'annex-0') .
>> }
>>
>> I have used Virtuoso Open Source Edition (multi threaded)
>> Version 7.2.4.3217-threads as of Apr 25 2016
>> Compiled for Win64 (x86_64-generic-win-64)
>>
>> Cheers
>>
>> Beppe
>>
>>
>> 2017-05-14 22:53 GMT+01:00 Hugh Williams :
>>
>>> Hi
>>>
>>> Can you please provide the actual steps to reproduce the issue being
>>> encountered as it is not clear from the information 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/OpenLink
>>> Google+  -- http://plus.google.com/100570109519069333827/
>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>> Universal Data Access, Integration, and Management Technology Providers
>>>
>>>
>>>
>>> On 13 May 2017, at 18:01, Beppe Mazzola  wrote:
>>>
>>> Hi to everybody
>>>
>>> I have generated with Virtuoso Open Source a virtual graph with the
>>> content of many RDB tables.obtained with an R2RML mapping.
>>>
>>> If I execute the following query I do not get any result.
>>>
>>> select *
>>> from
>>> where {
>>>   ?p ?o.
>>> }
>>>
>>> but if I execute this query (I suppose without index because it takes
>>> many seconds)
>>>
>>> select *
>>> from
>>> where {
>>> ?s ?p ?o filter regex(str(?s),'annex-0') .
>>> }
>>>
>>>
>>> I get the exact result, that is the content of the corresponding table
>>> row.
>>>
>>> http://example.com/pesticides/resource/annex-0
>>> 
>>> http://
>>> 
>>> example.com
>>> 
>>> /pesticides/resource/annexId  0
>>> http://example.com/pesticides/resource/annex-0
>>> 
>>> http://
>>> 
>>> example.com
>>> 
>>> /pesticides/resource/annexNameNot Assigned
>>> http://example.com/pesticides/resource/annex-0
>>> 
>>> http://
>>> 
>>> example.com
>>> 
>>> /pesticides/resource/annexSpecial 0
>>> http://example.com/pesticides/resource/annex-0
>>> 
>>> http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://
>>> 
>>> example.com
>>> 
>>> /pesticides/resource/Annex
>>>
>>> It looks like the index does not catch the triples  This is the
>>> involved R2RML mapping

Re: [Virtuoso-users] triples not reached by the index?

2017-06-22 Thread Hugh Williams

Hi Beppe,

I am confused now as the original test case provided for recreating did not use 
SQLWorkbench or JDBC, so how can the issue then be recreated ?

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/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 22 May 2017, at 14:52, Beppe Mazzola  wrote:
> 
> Hi Hughs
> 
> It seems the problem is not related to the RDF views tied to the tables, 
> because it happens even before executing the mapping.
> The problem arises only when I bulk load data into the tables with the tool 
> Sqlworkbench/J using the Virtuoso JDBC driver virtjdbc4_2.jar.
> So there is something in the Sqlworkbench/j or (it seems to me more likely) 
> in the JDBC driver that causes the issue.
> 
> Cheers
> 
> Beppe
> 
> 
> 
> 2017-05-16 10:27 GMT+01:00 Beppe Mazzola  >:
> Hi Hugh
> 
> I have noticed something strange related to the PK index of the table 
> provided to you.
> 
> After having run all the scripts I executed again by chance the first INSERT 
> statement and VOS allowed me to do it! And I could see both the rows with 
> ID=0 in the table...
> At this point if you delete the rows with ID=0 one of them is deleted, and 
> the remaining one is visible only with select not using the PK index. This 
> might have a relation with the original RDF view issue
> 
> I have used the Conductor Interactive SQL.
> 
> Cheers
> 
> Beppe
> 
> 
> 2017-05-16 9:25 GMT+01:00 Beppe Mazzola  >:
> Hi Hugh
> 
> Here are the steps to reproduce the problem.
> 
> 1) Create the table 
> 
> CREATE TABLE DB.PEST.ANNEXES 
> (
>   ANNEXES_ID NUMERIC NOT NULL 
> , ANNEXES_NAMES VARCHAR(50) NOT NULL 
> , ANNEXES_PART VARCHAR(1) 
> , ANNEXES_SPECIAL CHAR(1) NOT NULL 
> , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )   
> );
> 
> 2) initialize it with the attached script initANNEXES.sql
> 
> 3) create the virtual graph with the attached script ttlpExecTrial.sql
> 
> 4) query the virtual graph 
> select *
> from >
> where {
>  # > 
> ?p ?o.
>  ?s ?p ?o filter regex(str(?s),'annex-0') .
> }
> 
> I have used Virtuoso Open Source Edition (multi threaded)
> Version 7.2.4.3217-threads as of Apr 25 2016
> Compiled for Win64 (x86_64-generic-win-64)
> 
> Cheers
> 
> Beppe
> 
> 
> 2017-05-14 22:53 GMT+01:00 Hugh Williams  >:
> Hi 
> 
> Can you please provide the actual steps to reproduce the issue being 
> encountered as it is not clear from the information 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/OpenLink 
> Google+  -- http://plus.google.com/100570109519069333827/ 
> 
> Facebook -- http://www.facebook.com/OpenLinkSoftware 
> 
> Universal Data Access, Integration, and Management Technology Providers
> 
> 
> 
>> On 13 May 2017, at 18:01, Beppe Mazzola > > wrote:
>> 
>> Hi to everybody
>> 
>> I have generated with Virtuoso Open Source a virtual graph with the content 
>> of many RDB tables.obtained with an R2RML mapping.
>> 
>> If I execute the following query I do not get any result.
>> 
>> select * 
>> from> >
>> where {
>>  > > ?p ?o.
>> } 
>> 
>> but if I execute this query (I suppose without index because it takes many 
>> seconds) 
>> 
>> select * 
>> from> >
>> where {
>> ?s ?p ?o filter regex(str(?s),'annex-0') .
>> } 
>> 
>> 
>> I get the exact result, that is the content of the corresponding table row.
>> 
>> http://example.com/pesticides/resource/annex-0  
>> http://
>>  
>> example.com
>>  
>>

Re: [Virtuoso-users] triples not reached by the index?

2017-06-23 Thread Beppe Mazzola

Hi Hugh

At the beginning I did not realize that the problem was caused before,
during the first loading of the table. In fact, in my understanding the
index of the table was corrupted somehow during the first bulk loading
performed by Sqlworkbench/j + Virtuoso JDBC driver. Later the strange
effect of "rows invisible to the index" appeared in the table, even if you
empty it and load it again with plain INSERT statements.

I did not investigate further the case, since the feature blocked by the
issue had to work asap, so I implemented the bulk load with a plain Java
program, using the Virtuoso JDBC driver.

My sensation was anyway that the problem was JDBC driver side, since
Sqlworkbench is "DB agnostic". If it was Sqlrorkbench fault it would have
appeared with other DBMS

I am available if you need more info/scripts to reproduce the problem
anyway. Let me know.

Cheers

Beppe

2017-06-22 23:39 GMT+01:00 Hugh Williams :

> Hi Beppe,
>
> I am confused now as the original test case provided for recreating did
> not use SQLWorkbench or JDBC, so how can the issue then be recreated ?
>
> 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/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>
>
> On 22 May 2017, at 14:52, Beppe Mazzola  wrote:
>
> Hi Hughs
>
> It seems the problem is not related to the RDF views tied to the tables,
> because it happens even before executing the mapping.
> The problem arises *only *when I bulk load data into the tables with the
> tool Sqlworkbench/J using the Virtuoso JDBC driver virtjdbc4_2.jar.
> So there is something in the Sqlworkbench/j or (it seems to me more
> likely) in the JDBC driver that causes the issue.
>
> Cheers
>
> Beppe
>
>
>
> 2017-05-16 10:27 GMT+01:00 Beppe Mazzola :
>
>> Hi Hugh
>>
>> I have noticed something strange related to the PK index of the table
>> provided to you.
>>
>> After having run all the scripts I executed again by chance the first
>> INSERT statement and VOS allowed me to do it! And I could see both the rows
>> with ID=0 in the table...
>> At this point if you delete the rows with ID=0 one of them is deleted,
>> and the remaining one is visible only with select not using the PK index.
>> This might have a relation with the original RDF view issue
>>
>> I have used the Conductor Interactive SQL.
>>
>> Cheers
>>
>> Beppe
>>
>>
>> 2017-05-16 9:25 GMT+01:00 Beppe Mazzola :
>>
>>> Hi Hugh
>>>
>>> Here are the steps to reproduce the problem.
>>>
>>> 1) Create the table
>>>
>>> CREATE TABLE DB.PEST.ANNEXES
>>> (
>>>   ANNEXES_ID NUMERIC NOT NULL
>>> , ANNEXES_NAMES VARCHAR(50) NOT NULL
>>> , ANNEXES_PART VARCHAR(1)
>>> , ANNEXES_SPECIAL CHAR(1) NOT NULL
>>> , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )
>>> );
>>>
>>> 2) initialize it with the attached script initANNEXES.sql
>>>
>>> 3) create the virtual graph with the attached script ttlpExecTrial.sql
>>>
>>> 4) query the virtual graph
>>> select *
>>> from 
>>> where {
>>>  #>> esource/annex-0> ?p ?o.
>>>  ?s ?p ?o filter regex(str(?s),'annex-0') .
>>> }
>>>
>>> I have used Virtuoso Open Source Edition (multi threaded)
>>> Version 7.2.4.3217-threads as of Apr 25 2016
>>> Compiled for Win64 (x86_64-generic-win-64)
>>>
>>> Cheers
>>>
>>> Beppe
>>>
>>>
>>> 2017-05-14 22:53 GMT+01:00 Hugh Williams :
>>>
 Hi

 Can you please provide the actual steps to reproduce the issue being
 encountered as it is not clear from the information 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/OpenLink
 Google+  -- http://plus.google.com/100570109519069333827/
 Facebook -- http://www.facebook.com/OpenLinkSoftware
 Universal Data Access, Integration, and Management Technology Providers

 On 13 May 2017, at 18:01, Beppe Mazzola  wrote:

 Hi to everybody

 I have generated with Virtuoso Open Source a virtual graph with the
 content of many RDB tables.obtained with an R2RML mapping.

 If I execute the following query I do not get any result.

 select *
 from
 where {
   ?p ?o.
 }

 but if I execute this query (I suppose without index because it takes
 many seconds)

 select *
 from

Re: [Virtuoso-users] triples not reached by the index?

2017-06-26 Thread Hugh Williams

Hi Beppe,

The steps to recreate this issue via SQLWorkBench and the JDBC driver is what 
would be required if that is deemed to be the source of 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/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 23 Jun 2017, at 08:59, Beppe Mazzola  wrote:
> 
> Hi Hugh
> 
> At the beginning I did not realize that the problem was caused before, during 
> the first loading of the table. In fact, in my understanding the index of the 
> table was corrupted somehow during the first bulk loading performed by 
> Sqlworkbench/j + Virtuoso JDBC driver. Later the strange effect of "rows 
> invisible to the index" appeared in the table, even if you empty it and load 
> it again with plain INSERT statements.
> 
> I did not investigate further the case, since the feature blocked by the 
> issue had to work asap, so I implemented the bulk load with a plain Java 
> program, using the Virtuoso JDBC driver.
> 
> My sensation was anyway that the problem was JDBC driver side, since 
> Sqlworkbench is "DB agnostic". If it was Sqlrorkbench fault it would have 
> appeared with other DBMS
> 
> I am available if you need more info/scripts to reproduce the problem anyway. 
> Let me know.
> 
> Cheers
> 
> Beppe
> 
> 2017-06-22 23:39 GMT+01:00 Hugh Williams  >:
> Hi Beppe,
> 
> I am confused now as the original test case provided for recreating did not 
> use SQLWorkbench or JDBC, so how can the issue then be recreated ?
> 
> 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/100570109519069333827/ 
> 
> Facebook -- http://www.facebook.com/OpenLinkSoftware 
> 
> Universal Data Access, Integration, and Management Technology Providers
> 
> 
> 
>> On 22 May 2017, at 14:52, Beppe Mazzola > > wrote:
>> 
>> Hi Hughs
>> 
>> It seems the problem is not related to the RDF views tied to the tables, 
>> because it happens even before executing the mapping.
>> The problem arises only when I bulk load data into the tables with the tool 
>> Sqlworkbench/J using the Virtuoso JDBC driver virtjdbc4_2.jar.
>> So there is something in the Sqlworkbench/j or (it seems to me more likely) 
>> in the JDBC driver that causes the issue.
>> 
>> Cheers
>> 
>> Beppe
>> 
>> 
>> 
>> 2017-05-16 10:27 GMT+01:00 Beppe Mazzola > >:
>> Hi Hugh
>> 
>> I have noticed something strange related to the PK index of the table 
>> provided to you.
>> 
>> After having run all the scripts I executed again by chance the first INSERT 
>> statement and VOS allowed me to do it! And I could see both the rows with 
>> ID=0 in the table...
>> At this point if you delete the rows with ID=0 one of them is deleted, and 
>> the remaining one is visible only with select not using the PK index. This 
>> might have a relation with the original RDF view issue
>> 
>> I have used the Conductor Interactive SQL.
>> 
>> Cheers
>> 
>> Beppe
>> 
>> 
>> 2017-05-16 9:25 GMT+01:00 Beppe Mazzola > >:
>> Hi Hugh
>> 
>> Here are the steps to reproduce the problem.
>> 
>> 1) Create the table 
>> 
>> CREATE TABLE DB.PEST.ANNEXES 
>> (
>>   ANNEXES_ID NUMERIC NOT NULL 
>> , ANNEXES_NAMES VARCHAR(50) NOT NULL 
>> , ANNEXES_PART VARCHAR(1) 
>> , ANNEXES_SPECIAL CHAR(1) NOT NULL 
>> , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID )   
>> );
>> 
>> 2) initialize it with the attached script initANNEXES.sql
>> 
>> 3) create the virtual graph with the attached script ttlpExecTrial.sql
>> 
>> 4) query the virtual graph 
>> select *
>> from >
>> where {
>>  #> > 
>> ?p ?o.
>>  ?s ?p ?o filter regex(str(?s),'annex-0') .
>> }
>> 
>> I have used Virtuoso Open Source Edition (multi threaded)
>> Version 7.2.4.3217-threads as of Apr 25 2016
>> Compiled for Win64 (x86_64-generic-win-64)
>> 
>> Cheers
>> 
>> Beppe
>> 
>> 
>> 2017-05-14 22:53 GMT+01:00 Hugh Williams >

[Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

Re: [Virtuoso-users] triples not reached by the index?

8 matches

Site Navigation

Mail list logo

Footer information