ERCIM

 

Special contact email for contact on the website

VirtuosoRDBMS SPECIAL Project


Chronological Thread 
  • From: Sonja Heward-Mills <snevitt@openlinksw.com>
  • To: sabrina.kirrane@wu.ac.at, jfernand@wu.ac.at, special-contact@ercim.eu
  • Subject: VirtuosoRDBMS SPECIAL Project
  • Date: Mon, 16 Jul 2018 10:45:38 +0100

Hello Sabrina

I understand you are the Scientific Coordinator of SPECIAL project and maybe interested in some commercial features of Virtuoso 8.x  - in particular Enhanced security (ABAC)

I can see in the project plan some features that are key which are available in the Commercial Edition of Virtuoso ie:

secure workflows that include usage/access control, robustness in terms of performance, scalability and security all of which are necessary to support privacy preserving innovation in Big Data environments

https://www.specialprivacy.eu/about/project-plan

Virtuoso is a multi-model RDBMS that supports RDF as one of its Data Definition Languages (DDL), SPARQL as a Data Definition, Data Manipulation (DML), and Reasoning & Inference Rules Languages is inescapably vital to any modern Digital Transformation endeavor.

As the following benchmark reports demonstrates, our Virtuoso RDBMS has slayed all performance and scalability demons, while also addressing the Data Security and Data Virtualization issues that are generally overlooked (even in this era of GDPR).

Latest benchmark report that compares Virtuoso 7.x and the latest Virtuoso 8.x releases: https://lnkd.in/eCQKVhm

What are the key feature differences b/w Virtuoso 7.x and 8.x?
SPARQL as a Rules Language and highly-scalable Attribute-based Access Controls (ABAC) for security are features of 8.x.


I hope this information is helpful and that you will highly consider Virtuoso 8.x as a solution for the SPECIAl project.

Regards

Sonja



On 17/01/2018 10:43, Sonja Heward-Mills wrote:

Hello Sabrina

Any change on this?

As Multi-Model RDBMS application, Virtuoso (version 7.x or 8.x) enables
cost-effective exploitation of both Linked Local Data and Linked Open
Data across disparately located data sources that are heterogeneously
shaped.

Here are live example links that demonstrate what's stated above,
courtesy of Virtuoso's Data Virtualization Layer connected to an Oracle
instance via ODBC.

[1] https://lnkd.in/eDdnY2A -- Linked Local Data ;(emphasized by the
Green Hyperlinks)

[2] https://lnkd.in/eBsEWP5 -- Linked Open Data ;(emphasized by
Hyperlinks functioning as Super Keys) that provides a conduit to a
broader Semantic Web of Linked Data accessible from any HTTP-aware
application or service.

[3] https://lnkd.in/eKYWKqC -- Sample Entity Description derived from an
Oracle Demo DB Record.


If you do receive approval to test the commercial release of Virtuoso
please let me know.

Regards
Sonja



On 02/11/2017 09:16, Javier D. Fernández wrote:
Thanks for your message Sonja,

We are still in the phase of evaluating different solutions.

All the best,

Javier


On 01/11/17 15:59, Sonja Heward-Mills wrote:
Hello Javier/Julian

Following communications in July can I confirm is your work linked to the SPECIAL project:
https://bach.wu.ac.at/d/research/projects/3011/#partners

Will you be using Virtuoso?

Regards

Sonja


---------------------------- Original Message ----------------------------
Subject: Re: Performance of virtuoso command line versus Virtuoso Jena
Provider
From:    "Hugh Williams" <hwilliams@openlinksw.com>
Date:    Tue, July 18, 2017 11:34 am
To:      jfernand@wu.ac.at
Cc:      "Julian Reindorf" <julian.reindorf@gmail.com>
        support@openlinksw.com
--------------------------------------------------------------------------

Hi Javier,

The Virtuoso Jena Provider [1] sits on top of the Virtuoso JDBC Driver
which is a SQL access interface and would thus give performance on a par
with the command line SQL interface and given the same level to
transaction etc control as in a traditional SQL application.

When you ask can the Jena Provider report on the performance of Virtuoso,
I assume you mean from an System Administrators point of view in terms of
monitoring resource consumption and other monitoring stats databases tend
to have ? Not sure the Jena Provider would be the best interface for this,
as you could simply make a JDBC connection from a Java app and run
commands like status() [2] or sys_stat() [3] to get metrics on the state
of the database as you would from isql or other SQL interface, which is
what others do when hooking Virtuoso into there in-house network
monitoring tools. Although with Virtuoso you can execute SQL
commands/queries in SPARQL ie Built-In-Functions (bifs) [4], thus you can
do things like:

SELECT
 ( bif:sys_stat('st_dbms_name')          AS ?name )
 ( bif:sys_stat('st_dbms_ver')           AS ?version )
 ( bif:sys_stat('st_build_thread_model') AS ?thread )
 ( bif:sys_stat('st_build_opsys_id')     AS ?opsys )
 ( bif:sys_stat('st_build_date')         AS ?date )
( bif:sys_stat('st_lic_owner')          AS ?owner )
( bif:sys_stat('st_lic_serial_number')  AS ?serial )

WHERE
 {  ?s  ?p  ?o  }
LIMIT 1

The Virtuoso Jena Provider open source code can be viewed from [5][6] ...

[1] http://vos.openlinksw.com/owiki/wiki/VOS/VirtJenaProvider
<http://vos.openlinksw.com/owiki/wiki/VOS/VirtJenaProvider>
[2] http://docs.openlinksw.com/virtuoso/fn_status/
<http://docs.openlinksw.com/virtuoso/fn_status/>
[3] http://docs.openlinksw.com/virtuoso/fn_sys_stat/
<http://docs.openlinksw.com/virtuoso/fn_sys_stat/>
[4]
http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksSPARQL11BuiltInF
<http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksSPARQL11BuiltInF>
[5]
https://github.com/openlink/virtuoso-opensource/tree/develop/7/binsrc/jena3
<https://github.com/openlink/virtuoso-opensource/tree/develop/7/binsrc/jena3>
[6]
https://github.com/openlink/virtuoso-opensource/tree/develop/7/binsrc/jena2
<https://github.com/openlink/virtuoso-opensource/tree/develop/7/binsrc/jena2>

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 18 Jul 2017, at 13:43, Javier D. Fernández <jfernand@wu.ac.at> wrote:

Good afternoon,

My name is Javier D. Fernández, researcher at the Vienna University of
Economics and Business. I would like to know if you have any concrete
insights about the performance of virtuoso command line (isql-vt) and
the Virtuoso jena provider. In particular, is the jena provider
slower/faster than the virtuoso command line? Can I use the jena
provider to report the virtuoso performance?

Also, do you have the source code for the jena provider available?

Thanks in advance for any help you could provide.

Best regards,

--
Javier D. Fernández

WU Vienna, Institute for Information Business
Tel: +43-1-31336/5241
https://www.wu.ac.at/en/infobiz/team/fernandez/








  • VirtuosoRDBMS SPECIAL Project, Sonja Heward-Mills

Archive powered by MhonArc 2.6.16.

§