date:20161114

Re: [Virtuoso-users] Better question on virt-jena.jar

2016-11-14 Thread Sergey Malinin

08/11/16 02:05, Kingsley Idehen wrote:
> On 11/7/16 10:55 AM, Davis, Daniel (NIH/NLM) [C] wrote:
>>
>> Who is maintaining virt-jena?  What is the process of maintaining this, e.g. 
>> is this portion of virtuoso purely contributed, or does OpenLink plan to 
>> update
>> it and maintain it.
>>
>> My application depends on virt-jena.  I will need to tell my boss where an 
>> upgrade to virt-jena is in an OpenLink roadmap, and also, whether we need to
>> dedicate resources ourselves to keep this up to date, or socialize the issue 
>> with the contributors.  The claimed compatibility of virt-jena.jar is very 
>> old,
>> and while it works up to 2.13.0, Jena 3 is now over a year old, and has many 
>> releases.
>>
>> As a government shop, I ran my webapp dependencies through the OWASP 
>> dependency checker, and while I could make everything compliant, it is not 
>> the best way
>> to override individual dependent libraries, and better to get individual 
>> dependent libraries to be updated.   I’d also love to see the process change 
>> to use
>> Maven or Ant with ivy.
>>
>
> Daniel,
>
> We are committed to keeping our native Jena Providers up to date. I'll take a 
> look at the Jena 3 issue.
>

[Sergey]
For Jena 2.13 the virt_jena2.jar must be used
For Jena3  the virt_jena3.jar
All are in the git open sources.

> --
> Regards,
>
> Kingsley Idehen   
> Founder & CEO
> OpenLink Software   (Home Page:http://www.openlinksw.com)
>
> Weblogs (Blogs):
> Legacy Blog:http://www.openlinksw.com/blog/~kidehen/
> Blogspot Blog:http://kidehen.blogspot.com
> Medium Blog:https://medium.com/@kidehen
>
> Profile Pages:
> Pinterest:https://www.pinterest.com/kidehen/
> Quora:https://www.quora.com/profile/Kingsley-Uyi-Idehen
> Twitter:https://twitter.com/kidehen
> Google+:https://plus.google.com/+KingsleyIdehen/about
> LinkedIn:http://www.linkedin.com/in/kidehen
>
> Web Identities (WebID):
> Personal:http://kingsley.idehen.net/dataspace/person/kidehen#this
>  
> :http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
>


-- 
Best Regards,
Sergey Malinin

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Better question on virt-jena.jar

2016-11-14 Thread Sergey Malinin

08/11/16 02:19, Davis, Daniel (NIH/NLM) [C] wrote:
> Idehen/Hugh/Sergei,
>
> I did my own research on this. OpenLink wrote the initial 
> virt_jena.jardriver, and maintains it, but does not enhance it.  Sorry for 
> the dumb questions – I can
> check this stuff on github.com, but sometimes a conversation is a good thing.
>
> Sergei, https://github.com/smalinin, github suggests you contributed both the 
> Jena2 and Jena3 driver and are still contributing to them.  Looking at the
> commits, OpenLink commits the binary virt_jena2.jarand virt_jena3.jar, and 
> changes version numbers, from time to time.
>
> It might be good to communicate about the roadmap for these – I see 
> virt_jena3.jarthere, but I know my application would need other changes above 
> Virtuoso JDBC
> and virt_jena3 as well to use Jena 3. If we make these, I will think about 
> any suggestions I could make.   Maybe I can make these into github.com 
> issues, with
> or without pull requests depending on my availability.

[Sergey]
The latest sources are located in 
https://github.com/openlink/virtuoso-opensource
The virt_jena.jar may be used with Jena2 ver < 2.7.x
The virt_jena2.jar was created because Jena2 was switched to new version of JDK.
If you use Jena2 ver>= 2.7.x, you could use virt_jena2.jar with 
virtjdbc4.jar(or virtjdbc4ssl.jar) and JDK ver>=1.6
If you use Jena3, so you must to use virt_jena3.jar with virtjdbc4_2.jar(or 
virtjdbc4_2ssl.jar) and JDK ver >=1.8

Basically, if you use Jena2, you could switch to virt_jena2.jar driver, the 
virt_jena3.jar driver supports the same features (it was created for support 
Jena3).

You could create pull request, if you need it on 
https://github.com/openlink/virtuoso-opensource


>
> Dan Davis, Systems/Applications Architect (Contractor),
>
> Office of Computer and Communications Systems,
>
> National Library of Medicine, NIH
>
> *From:*Kingsley Idehen [mailto:kide...@openlinksw.com]
> *Sent:* Monday, November 07, 2016 11:05 AM
> *To:* virtuoso-users@lists.sourceforge.net
> *Cc:* Hugh Williams ; Sergei Malinin 
> 
> *Subject:* Re: [Virtuoso-users] Better question on virt-jena.jar
>
> On 11/7/16 10:55 AM, Davis, Daniel (NIH/NLM) [C] wrote:
>
> Who is maintaining virt-jena?  What is the process of maintaining this, 
> e.g. is this portion of virtuoso purely contributed, or does OpenLink plan to 
> update
> it and maintain it.
>
> My application depends on virt-jena.  I will need to tell my boss where 
> an upgrade to virt-jena is in an OpenLink roadmap, and also, whether we need 
> to
> dedicate resources ourselves to keep this up to date, or socialize the 
> issue with the contributors.  The claimed compatibility of virt-jena.jar is 
> very old,
> and while it works up to 2.13.0, Jena 3 is now over a year old, and has 
> many releases.
>
> As a government shop, I ran my webapp dependencies through the OWASP 
> dependency checker, and while I could make everything compliant, it is not 
> the best way
> to override individual dependent libraries, and better to get individual 
> dependent libraries to be updated.   I’d also love to see the process change 
> to use
> Maven or Ant with ivy.
>
> Daniel,
>
> We are committed to keeping our native Jena Providers up to date. I'll take a 
> look at the Jena 3 issue.
>
> --
>
> Regards,
>
>
>
> Kingsley Idehen
>
> Founder & CEO
>
> OpenLink Software   (Home Page:http://www.openlinksw.com)
>
>
>
> Weblogs (Blogs):
>
> Legacy Blog:http://www.openlinksw.com/blog/~kidehen/
>
> Blogspot Blog:http://kidehen.blogspot.com
>
> Medium Blog:https://medium.com/@kidehen
>
>
>
> Profile Pages:
>
> Pinterest:https://www.pinterest.com/kidehen/
>
> Quora:https://www.quora.com/profile/Kingsley-Uyi-Idehen
>
> Twitter:https://twitter.com/kidehen
>
> Google+:https://plus.google.com/+KingsleyIdehen/about
>
> LinkedIn:http://www.linkedin.com/in/kidehen
>
>
>
> Web Identities (WebID):
>
> Personal:http://kingsley.idehen.net/dataspace/person/kidehen#this
>
>  
> :http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
>
>
>


-- 
Best Regards,
Sergey Malinin

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Query performance with R2RML remote RDBMS SQL Server

2016-11-14 Thread Kingsley Idehen

On 11/4/16 8:56 AM, CHARBEL EL KAED wrote:
>
> Thank you Kingsley,
>
>  
>
> Is there an approximate date for the patch?
>

Current ETA would be Wednesday, latest.

Kingsley
>
> Thank you,
>
> Best/Cordialement,
>
> Charbel El Kaed, PhD
> Business Architect
> Digital Services Platform
> Global Solutions
> Schneider Electric
>
>   
>
> D  +1 (978) 975-9361 x59361
> M  +1 (978) 289-3190
> E  charbel.el-k...@schneider-electric.com
> 
>
>   
>
> 800 Federal Street
> Andover
> United States
>
>  
>
> http://www.apcmedia.com/emailsignature/images/998-19615502_BrandBusinessBanners_620x80_1.jpg
> 
>
>  
>
>
> *Please consider the environment before printing this e-mail
>
>   
>
> FB  FB
>  FB
>  FB
>  FB
>  FB
>  FB
>  
>
>
>   
>
>  
>
>  
>
> *From:*Kingsley Idehen [mailto:kide...@openlinksw.com]
> *Sent:* Thursday, November 03, 2016 9:30 PM
> *To:* virtuoso-users@lists.sourceforge.net
> *Subject:* Re: [Virtuoso-users] Query performance with R2RML remote
> RDBMS SQL Server
>
>  
>
> On 10/14/16 12:41 PM, CHARBEL EL KAED wrote:
>
> Hello,
>
>  
>
> I would like to have your opinion on the following:
>
>  
>
> I installed Virtuoso Enterprise on a Windows VM with:
>
> 8 cores
>
> 28 GB RAM
>
> 56 GB SSD
>
>  
>
> I attached virtuoso configuration file.
>
>  
>
> On virtuoso I have a local RDF Table with 8221 triples and a
> remote MS SQL Azure with 50 million records. A record is simply an
> id, param1 and param2, with (id and param1) as a composite primary
> key.
>
> I have the following query:
>
>  
>
> Select ?id ?param1 ?param2 {
>
>Select ?id ?param1 ?param2 FROM
> >
>
>  Where {
>
> []  ?id;
>
>  > ? param1;
>
>  > ? param2. 
>
> filter (?param1 < 5)
>
> {
>
> SELECT DISTINCT (strafter(str(?id1), "#") AS ?trimId) from
> >
>
> WHERE
>
> {
>
> ?server qt:hasId ?id1. //returns 42 ids
>
> }
>
> }
>
> filter( ?trimId = ?id)
>
> }
>
>  };
>
>  
>
> The query is expected to return 1 million record result.
>
> I initiated the query yesterday through iSQL, it is still running
> since, more than 12 hours. On the Windows VM, the task manager
> shows that Virtuoso consumes 10 GB of RAM and less then 5% of CPU.
>
> On the MS SQL monitoring tool, you can notice the load is constant
> using only 10% of the CPU and 10% of the DTU.
>
>  
>
> Any recommendations to improve the performance?
>
>  
>
> Thank you
>
>  
>
> There should be an update in your support case about this matter.
> Fundamentally, there was a SPARQL Optimizer bug that lead to the
> shared variable effect not kicking in i.e., executing the remote part
> of the query. Here are examples to explain the gist of the matter:
>
>  
>
> ## Problematic  due to missing {} around dataset modifier fragments
> that contain shared variables between local and remote
>
> ## Data Sources
>
> SELECT ?s ?p (sql:BEST_LANGMATCH (?o, "ru, en-gb;q=0.8, en;q=0.7,
> *;q=0.1", "")) as ?o_filtered
> WHERE {
> ?s a foaf:Person .
> # Virtuoso Extension for setting Named Graph scope on a Remote
> SPARQL service
> SERVICE 
>  from 
> 
>   {
>  ?s ?p ?o .
>  FILTER (?p != 
> )
>   }
>  
> OPTIONAL { ?p rdfs:label ?lbl }
>   }
> ORDER BY ASC (COUNT (?o))
>
>
> ## Revised query using {} to group dataset modifier fragments to set
> scope for shared variable identifiers
>
> SELECT ?s ?p (sql:BEST_LANGMATCH (?o, "ru, en-gb;q=0.8, en;q=0.7,
> *;q=0.1", "")) as ?o_filtered
> WHERE {* *
>
> *  {  ## shared variable block start ##*
> ?s a foaf:Person .
> # Virtuoso Extension for setting Named Graph scope on a
> Remote SPARQL service
> SERVICE 
>  from 
>

Re: [Virtuoso-users] Better question on virt-jena.jar

2016-11-14 Thread Davis, Daniel (NIH/NLM) [C]

Thanks again.

-Original Message-
From: Sergey Malinin [mailto:sergmali...@gmail.com] 
Sent: Monday, November 07, 2016 11:16 AM
To: Kingsley Idehen ; 
virtuoso-users@lists.sourceforge.net
Cc: Hugh Williams 
Subject: Re: [Virtuoso-users] Better question on virt-jena.jar

08/11/16 02:05, Kingsley Idehen wrote:
> On 11/7/16 10:55 AM, Davis, Daniel (NIH/NLM) [C] wrote:
>>
>> Who is maintaining virt-jena?  What is the process of maintaining 
>> this, e.g. is this portion of virtuoso purely contributed, or does OpenLink 
>> plan to update it and maintain it.
>>
>> My application depends on virt-jena.  I will need to tell my boss 
>> where an upgrade to virt-jena is in an OpenLink roadmap, and also, 
>> whether we need to dedicate resources ourselves to keep this up to date, or 
>> socialize the issue with the contributors.  The claimed compatibility of 
>> virt-jena.jar is very old, and while it works up to 2.13.0, Jena 3 is now 
>> over a year old, and has many releases.
>>
>> As a government shop, I ran my webapp dependencies through the OWASP 
>> dependency checker, and while I could make everything compliant, it is not 
>> the best way
>> to override individual dependent libraries, and better to get individual 
>> dependent libraries to be updated.   I'd also love to see the process change 
>> to use
>> Maven or Ant with ivy.
>>
>
> Daniel,
>
> We are committed to keeping our native Jena Providers up to date. I'll take a 
> look at the Jena 3 issue.
>

[Sergey]
For Jena 2.13 the virt_jena2.jar must be used For Jena3  the virt_jena3.jar All 
are in the git open sources.

> --
> Regards,
>
> Kingsley Idehen   
> Founder & CEO
> OpenLink Software   (Home Page:http://www.openlinksw.com)
>
> Weblogs (Blogs):
> Legacy Blog:http://www.openlinksw.com/blog/~kidehen/
> Blogspot Blog:http://kidehen.blogspot.com Medium 
> Blog:https://medium.com/@kidehen
>
> Profile Pages:
> Pinterest:https://www.pinterest.com/kidehen/
> Quora:https://www.quora.com/profile/Kingsley-Uyi-Idehen
> Twitter:https://twitter.com/kidehen
> Google+:https://plus.google.com/+KingsleyIdehen/about
> LinkedIn:http://www.linkedin.com/in/kidehen
>
> Web Identities (WebID):
> Personal:http://kingsley.idehen.net/dataspace/person/kidehen#this
>  
> :http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.t
> tl#this
>


--
Best Regards,
Sergey Malinin

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

--
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Better question on virt-jena.jar

Re: [Virtuoso-users] Better question on virt-jena.jar

Re: [Virtuoso-users] Query performance with R2RML remote RDBMS SQL Server

Re: [Virtuoso-users] Better question on virt-jena.jar

4 matches

Site Navigation

Mail list logo

Footer information