Re: [Virtuoso-users] Query performance with R2RML remote RDBMS SQL Server
On 11/4/16 8:56 AM, CHARBEL EL KAED wrote: > > Thank you Kingsley, > > > > Is there an approximate date for the patch? > We can get it to you in about a week or less. Your case will be updated accordingly. 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 > <mailto:charbel.el-k...@schneider-electric.com> > > > > 800 Federal Street > Andover > United States > > > > http://www.apcmedia.com/emailsignature/images/998-19615502_BrandBusinessBanners_620x80_1.jpg > <http://www.schneider-electric.com/b2b/en/solutions/index.jsp#xtor=CS4-110-[Print]-[Event]-[LIO]-[Hong_Kong]> > > > > > *Please consider the environment before printing this e-mail > > > > FB <http://blog.schneider-electric.com/> FB > <https://www.facebook.com/SchneiderElectric> FB > <https://www.twitter.com/SchneiderElec> FB > <https://www.linkedin.com/company/schneider-electric> FB > <https://www.youtube.com/schneidercorporate> FB > <https://instagram.com/schneiderelectric> FB > <https://plus.google.com/+schneiderelectric> > > > > > > > > > *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 > <http://localhost:8890/sqldb50m# <http://localhost:8890/sqldb50m>> > > Where { > > [] <http://localhost:8890/schemas/sqldb50m/id> ?id; > > <http://localhost:8890/schemas/ sqldb50m /param1 > <http://localhost:8890/schemas/%20sqldb50m%20/param1>> ? param1; > > <http://localhost:8890/schemas/ sqldb50m /param2 > <http://localhost:8890/schemas/%20sqldb50m%20/param2%20>> ? param2. > > filter (?param1 < 5) > > { > > SELECT DISTINCT (strafter(str(?id1), "#") AS ?trimId) from > <http://localhost:8890/BOC# <http://localhost:8890/BOC>> > > 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 <http://dbpedia.org/sparql> > <http://dbpedia.org/sparql> from <http://dbpedia.org> > <http://dbpedia.org> > { > ?s ?p ?o .
Re: [Virtuoso-users] Using PREFIX in a prepared Statement
On 10/21/16 5:36 PM, Davis, Daniel (NIH/NLM) [C] wrote: > > So, I must run my application through a source code scanner, and it is > reasonably complaining that I am using String.format() and > stmt.executeQuery(query) with the Virtuoso JDBC connection. > > > > Yet, this is SPARQL. I see some discussion of prepared statements on > this list in the past. What I want to know is: > > ·What is the best way to get this to work at all? > > ·Is there any way I can bind a parameter whose value includes > a PREFIX in the query?Something like stmt.setString(1, “mesh:D20189”); > > > > Dan Davis, Systems/Applications Architect (Contractor), > > Office of Computer and Communications Systems, > > National Library of Medicine, NIH > > > I assume your query is of the form: SPARQL {SPARQL-Query} OR SELECT {SELECT-LIST} FROM {SPARQL {SPARQL-QUERY} } AS {SQL Tabular Relation ALIAS} . [1] http://bit.ly/sparql-as-sql-tabular-relation -- SPARQL Query as SQL Tabular Relation (note: user "vdb" for user and pwd) in FROM CLAUSE [2] http://bit.ly/sparql-as-sql-tabular-relation2 -- SPARQL Query as SQL Tabular Relation -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] Using PREFIX in a prepared Statement
On 10/24/16 12:00 PM, Davis, Daniel (NIH/NLM) [C] wrote: > > Kingsley, > > > > I’m not sure exactly how this helps me. Let me be clearer on the > problem. Because this application runs within a federal government > site, I’m required to submit my source code to static analysis. > Although the data is read-only, and the database user has only > read-only access, there are still general guidelines. > > I’m inquiring in the sense therefore that I want to figure out the > boundaries of how Virtuoso JDBC can enable me to pass these > guidelines, even though I think I can get an exemption by labeling the > SQL injection complaint a false positive. > > > > What I’m talking about is doing this through a JDBC interface, and > rather than using a query of the form: > > > > String queryFormat= "SPARQL" > > + " define input:inference > \"http://id.nlm.nih.gov/mesh/vocab\"; > > + " PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>" > > + " PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>" > > + " PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>" > > + " PREFIX owl: <http://www.w3.org/2002/07/owl#>" > > + " PREFIX meshv: <http://id.nlm.nih.gov/mesh/vocab#>" > > + " PREFIX mesh: <http://id.nlm.nih.gov/mesh/>" > > + " SELECT ?l" > > + " FROM <http://id.nlm.nih.gov/mesh>" > > + " WHERE { mesh:%s %s ?l }"; > > String query= String./format/(queryFormat, id, prop); > > log.info(query); > > Statement stmt= connection.createStatement(); > > ResultSet rset= stmt.executeQuery(query); > > > > I would rather do this using a prepared statement, maybe still > formatting in the property so that the query plan can benefit from the > predicate index: > > > > String queryFormat= "SPARQL" > > + " define input:inference > \"http://id.nlm.nih.gov/mesh/vocab\"; > > + " PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>" > > + " PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>" > > + " PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>" > > + " PREFIX owl: <http://www.w3.org/2002/07/owl#>" > > + " PREFIX meshv: <http://id.nlm.nih.gov/mesh/vocab#>" > > + " PREFIX mesh: <http://id.nlm.nih.gov/mesh/>" > > + " SELECT ?l" > > + " FROM <http://id.nlm.nih.gov/mesh>" > > + " WHERE { ?? %s ?l }"; > > String query= String./format/(queryFormat, prop); > > log.info(query); > > PreparedStatement stmt= connection.prepareStatement(query); > > stmt.setString(1, "http://id.nlm.nih.gov/mesh/"+id); > > > > So far, this general approach of using a prepared statement is not > working for me. I may struggle through it, but is there anyway for > me to preserve the convenience of prefixes: > > > > … WHERE { mesh:?? %s ?l }; > > > > And then later bind the query argument? > Understood. Problem is that we need to publish more examples re., use of SPARQL via ODBC and JDBC connections. To our issue: It will be something like: String queryFormat = "SPARQL" + " define input:inference \"http://id.nlm.nih.gov/mesh/vocab\"; + " PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>" + " PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>" + " PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>" + " PREFIX owl: <http://www.w3.org/2002/07/owl#>" + " PREFIX meshv: <http://id.nlm.nih.gov/mesh/vocab#>" + " PREFIX mesh: <http://id.nlm.nih.gov/mesh/>" + " SELECT ?l" + " FROM <http://id.nlm.nih.gov/mesh>" + " *WHERE { `iri(??)` `iri(??)` ?l }*"; // String query = String.format(queryFormat, id, prop); // log.info(query); PreparedStatement ps = connection.prepareStatement(query); ps.setString(1, "http://id.nlm.nih.gov/mesh/"+id); ps.setString(2, prop); ResultSet rset = ps.executeQuery(); Note: You have to quote URIs without < > Example: String prop = "http://testhost.o
Re: [Virtuoso-users] geometry data type in virtuoso
On 11/11/16 12:04 PM, Peter F. Patel-Schneider wrote: > My experience is different. I refreshed virtuoso opensource to the version of > 9 November. When I tried to load a file with the triple I got an error. > > > idefix /home/virtuoso/var/lib/virtuoso/db> /home/virtuoso/bin/isql dba > dba > Connected to OpenLink Virtuoso > Driver: 07.20.3217 OpenLink Virtuoso ODBC Driver > OpenLink Interactive SQL (Virtuoso), version 0.9849b. > Type HELP; for help and EXIT; to exit. > SQL> DELETE FROM DB.DBA.load_list; > > Done. -- 4 msec. > SQL> ld_dir ('/home/local/SoftwareDownloads/wikidata', > 'wikidata-mars.ttl', 'http://bkr.nuance.com/wikidata'); > > Done. -- 3 msec. > SQL> rdf_loader_run(); > 08:53:19 PL LOG: Loader started > 08:53:19 PL LOG: File > /home/local/SoftwareDownloads/wikidata/wikidata-mars.ttl error 42000 RDFGE: > RDF box with a geometry RDF type and a non-geometry content > 08:53:19 PL LOG: No more files to load. Loader has finished, > > Done. -- 8 msec. > SQL> idefix /home/virtuoso/var/lib/virtuoso/db> > /home/virtuoso/bin/virtuoso-t --version > Virtuoso Open Source Edition (Column Store) (multi threaded) > Version 7.2.5-dev.3217-pthreads as of Nov 9 2016 > Compiled for Linux (x86_64-unknown-linux-gnu) > Copyright (C) 1998-2016 OpenLink Software > > I think that the URL for geo: in your file is not one that is recognized by > virtuoso as the namespace for the geospatial datatype. > > wikidata-mars.ttl has > @prefix geo: <http://www.opengis.net/ont/geosparql#> . > which is taken from the wikidata RDF dump. > > Your file has > @prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> . > > peter Yes, he following isn't being loaded for overzealous reasons: @prefix wdt: <http://www.wikidata.org/entity/> . @prefix wd: <http://www.wikidata.org/entity1/> . @prefix wikibase: <http://www.wikidata.org/entity2/> . @prefix geo: <http://www.opengis.net/ont/geosparql#> . wd:Q24227 a wikibase:Item ; wdt:P625 " <http://www.wikidata.org/entity/Q111> Point(351.83-14.47)"^^gro:wktLiteral . It should load, even if Vituoso can't make sense of the geometric context with regards to SPARQL queries etc.. Kingsley > > >> Peter, >> >> I mispoke about SPARQL and GeoSPARQL. My apologies for the confusion. >> >> The triple is valid and it loads, as per the simple test I have at: >> >> http://kingsley.idehen.net/DAV/home/kidehen/Public/Linked%20Data%20Documents/Nanotations/test.ttl >> . >> >> or: >> >> curl -i >> http://kingsley.idehen.net/DAV/home/kidehen/Public/Linked%20Data%20Documents/Nanotations/test.ttl >> >> >> Thus, we need to figure out if this is something to do with the version you >> are workings with (as my versions are typically hot of the press etc..). >> >> -- >> 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 >> >> >> >> -- >> Developer Access Program for Intel Xeon Phi Processors >> Access to Intel Xeon Phi processor-based developer platforms. >> With one year of Intel Parallel Studio XE. >> Training and support from Colfax. >> Order your platform today. http://sdm.link/xeonphi >> >> >> >> ___ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> >> >> -- >> Developer Access Program for Intel Xeon Phi Processors >> Access to Intel Xeon Phi processor-based developer platforms. >> With one year of Intel Parallel Studio XE. >> Training and support from Colfax. >> Order your platform today. http://sdm.l
Re: [Virtuoso-users] How to deal with partially executed SPARQL updates?
On 10/30/16 10:50 AM, Jindřich Mynarz wrote: > > the behaviour you describe is what I'd like to be able to rely on. (In > fact, it's the opposite of the Anytime query.) Updates should either > be executed completely or fail transparently, so that the incomplete > execution may be handled. > > I will have to test this properly to ensure that partial updates > indeed occur. A partial update shouldn't occur. Now of course in SPARQL that means a combination of INSERT and DELETE, so you do have transaction management issues in play with regards to commits and rollbacks which exist in SQL but not SPARQL. Please share more information about what you are executing and why you think a partial UPDATE may have occurred. As per your earlier inquiry, Anytime Query is strictly a SELECT or ASK query feature. -- 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 -- The Command Line: Reinvented for Modern Developers Did the resurgence of CLI tooling catch you by surprise? Reconnect with the command line and become more productive. Learn the new .NET and ASP.NET CLI. Get your free copy! http://sdm.link/telerik ___ 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
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 > <http://localhost:8890/sqldb50m# <http://localhost:8890/sqldb50m>> > > Where { > > [] <http://localhost:8890/schemas/sqldb50m/id> ?id; > > <http://localhost:8890/schemas/ sqldb50m /param1 > <http://localhost:8890/schemas/%20sqldb50m%20/param1>> ? param1; > > <http://localhost:8890/schemas/ sqldb50m /param2 > <http://localhost:8890/schemas/%20sqldb50m%20/param2%20>> ? param2. > > filter (?param1 < 5) > > { > > SELECT DISTINCT (strafter(str(?id1), "#") AS ?trimId) from > <http://localhost:8890/BOC# <http://localhost:8890/BOC>> > > 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 <http://dbpedia.org/sparql> from <http://dbpedia.org> { ?s ?p ?o . FILTER (?p != <http://dbpedia.org/property/abstract>) } 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 <http://dbpedia.org/sparql> from <http://dbpedia.org> { ?s ?p ?o . FILTER (?p != <http://dbpedia.org/property/abstract>) } * ***## shared variable block end ## *}* OPTIONAL { ?p rdfs:label ?lbl } } ORDER BY ASC (COUNT (?o)) ## Another example that failed where I am passing values using BIND. This failed and will work properly when the fix is in ## PREFIX csv: <https://gist.githubusercontent.com/lawlesst/bdbd2142c2ab667eae1be3b7a789f5da/raw/643196cb31a13ddc3746d7a340bf3674d31f3bc2/top_250_by_pages.csv#> SELECT ?w ?p ?o2 FROM NAMED <https://gist.githubusercontent.com/lawlesst/bdbd2142c2ab667eae1be3b7a789f5da/raw/643196cb31a13ddc3746d7a340bf3674d31f3bc2/top_250_by_pages.csv> WHERE { GRAPH <https://gist.githubusercontent.com/lawlesst/bdbd2142c2ab667eae1be3b7a789f5da/raw/643196cb31a13ddc3746d7a340bf3674d31f3bc2/top_250_by_pages.csv> {?s csv:wikidata ?o . } BIND (IRI(?o) AS ?w) SERVICE <http://dbpedia.org/sparql> { SELECT * WHERE {?w ?p ?o2. } LIMIT 50 } } -- 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/kide
Re: [Virtuoso-users] Can delete "built in" Graphs?
On 10/11/16 11:34 AM, Pasquale Di Donato wrote: > Dear all, > > considering a "fresh" installation of Virtuoso + the faceted browser, > under "Linked Data --> Graphs --> Graphs" I see a list of "built in" > graphs, e.g.: > > http://www.openlinksw.com/schemas/virtrdf# > > http://www.w3.org/ns/ldp# > > http://localhost:8890/sparql > > http://localhost:8890/DAV/ > > http://www.w3.org/2002/07/owl# > > b3sonto > > b3sifp > > urn:rules.skos > > http://www.openlinksw.com/schemas/oplweb# > > virtrdf-label > > facets > > Are all these graphs needed or can I delete them/some of them? > > Many thanks for any feedback > > Pasquale You can delete all but: http://www.openlinksw.com/schemas/virtrdf# http://www.w3.org/ns/ldp# facets virtrdf-label . -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] How to import a dump file
On 10/11/16 10:23 AM, Safran, Tracy (NIH/NCI) [C] wrote: > > > > I dumped a an open-source virtuoso triplestore with 37 separate graphs > using the dump_nquads command. Now I would like to load the resulting > nq files into another commercial instance of a virtuoso but the only > load commands I find ask me to specify a graph name. I would like the > load to use the graph names that were saved into the dump file. How > can I do this? > > > > Do I need to back up and dump the graphs in a different way. > > > > Thank you, > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > > > Hi Tracy, You can load data from nquad documents into Virtuoso. Please read about how to bulk-load named-graph partitioned data from nquad files into Virtuoso at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoader . -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] Problem with advanced queries
On 10/11/16 4:37 PM, Safran, Tracy (NIH/NCI) [C] wrote: > > I am having problems doing some slightly advanced queries against > http. A simple query works but other queries don’t. Is there a > deeper issue with permissions or indexes that I need to look into? > > > > Example: This works. > > > > /SELECT * / > > /FROM <http://NCIT_NG1> where { ?s ?p ?o } LIMIT 50/ > > > > But this does not (note: prefix left out for brevity) > > /SELECT ?subject ?role ?object/ > > /WHERE {/ > > /?subject rdfs:subClassOf ?an ./ > > /?an owl:onProperty ?role ./ > > /?an owl:someValuesFrom ?object ./ > > /?subject rdfs:subClassOf* ncit:Gene/ > > /}/ > > /ORDER BY _asc_(?subject)/ > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > I assume you are getting: Virtuoso 37000 Error TR...: transitive start not given ? You need to add some qualification to the query to optimize for unknowns such as db size and available memory. Examples: 1. http://dbpedia.org/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3AClass+.%0D%0A%3Fobject+a+owl%3AClass+.%0D%0A%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0Afilter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A%7D%0D%0A%0D%0AORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100=text%2Fx-html%2Btr_redir_for_subjs=121_redir_for_hrefs==3=on -- DBpedia Static 2. http://dbpedia-live.openlinksw.com/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3AClass+.%0D%0A%3Fobject+a+owl%3AClass+.%0D%0A%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0Afilter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A%7D%0D%0A%0D%0AORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100=text%2Fx-html%2Btr_redir_for_subjs=121_redir_for_hrefs==3=on -- DBpedia Live 3. http://lod.openlinksw.com/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3AClass+.%0D%0A%3Fobject+a+owl%3AClass+.%0D%0A%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0Afilter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27umbel%27%29%29%0D%0A%7D%0D%0A%0D%0AORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100=text%2Fx-html%2Btr_redir_for_subjs=121_redir_for_hrefs==3=on -- massive 30 Billion+ LOD Cloud Cache -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] Problem with advanced queries
On 10/11/16 8:59 PM, Safran, Tracy (NIH/NCI) [C] wrote: > > I am not getting any error, just an empty class list. (: > []) The same dataset is loaded into Stardog, for the sake of > comparison, and the exact same query returns results. > > > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > My examples are against pretty large datasets, but using the commercial edition of Virtuoso. Are you able to provide any insights into your datasets? Please try the following to see if they shed any light on this matter. : /SELECT ?subject ?role ?object/ /WHERE { GRAPH //<http://NCIT_NG1> <http://NCIT_NG1> WHERE {/ /?subject rdfs:subClassOf ?an ./ /?an owl:onProperty ?role ./ /?an owl:someValuesFrom ?object ./ /?subject rdfs:subClassOf* ncit:Gene/ /}/ / }/ // /ORDER BY _asc_(?subject) ; / /SELECT ?subject ?role ?object/ /WHERE { GRAPH //<http://NCIT_NG1> <http://NCIT_NG1> WHERE {/ /?subject rdfs:subClassOf ?an ./ /?an owl:onProperty ?role ./ /?an owl:someValuesFrom ?object ./ /?subject rdfs:subClassOf+ ncit:Gene/ /}/ / }/ // /ORDER BY _asc_(?subject) ; / /SELECT ?subject ?role ?object/ /WHERE { GRAPH //<http://NCIT_NG1> <http://NCIT_NG1> WHERE {/ /?subject rdfs:subClassOf ?an ./ /?an owl:onProperty ?role ./ /?an owl:someValuesFrom ?object ./ /?subject rdfs:subClassOf+ ncit:Gene/ /}/ / }/ // /ORDER BY _asc_(?subject) LIMIT 50 ; / Kingsley / / > > > > > > *From: *Kingsley Idehen <kide...@openlinksw.com> > *Date: *Tuesday, October 11, 2016 at 6:17 PM > *To: *"virtuoso-users@lists.sourceforge.net" > <virtuoso-users@lists.sourceforge.net> > *Subject: *Re: [Virtuoso-users] Problem with advanced queries > > > > On 10/11/16 4:37 PM, Safran, Tracy (NIH/NCI) [C] wrote: > > I am having problems doing some slightly advanced queries against > http. A simple query works but other queries don’t. Is there a > deeper issue with permissions or indexes that I need to look into? > > > > Example: This works. > > > > /SELECT * / > > /FROM <http://NCIT_NG1> <http://NCIT_NG1> where { ?s ?p ?o } > LIMIT 50/ > > > > But this does not (note: prefix left out for brevity) > > /SELECT ?subject ?role ?object/ > > /WHERE {/ > > /?subject rdfs:subClassOf ?an ./ > > /?an owl:onProperty ?role ./ > > /?an owl:someValuesFrom ?object ./ > > /?subject rdfs:subClassOf* ncit:Gene/ > > /}/ > > /ORDER BY _asc_(?subject)/ > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > > > > I assume you are getting: > > Virtuoso 37000 Error TR...: transitive start not given ? > > You need to add some qualification to the query to optimize for > unknowns such as db size and available memory. > > Examples: > > 1. > http://dbpedia.org/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3AClass+.%0D%0A%3Fobject+a+owl%3AClass+.%0D%0A%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0Afilter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A%7D%0D%0A%0D%0AORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100=text%2Fx-html%2Btr_redir_for_subjs=121_redir_for_hrefs==3=on > -- DBpedia Static > > 2. > http://dbpedia-live.openlinksw.com/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3AClass+.%0D%0A%3Fobject+a+owl%3AClass+.%0D%0A%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0Afilter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A%7D%0D%0A%0D%0AORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100=text%2Fx-html%2Btr_redir_for_subjs=121_redir_for_hrefs==3=on > -- DBpedia Live > > 3. > http://lod.openlinksw.com/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3ACl
Re: [Virtuoso-users] Problem with advanced queries
On 10/12/16 12:24 PM, Safran, Tracy (NIH/NCI) [C] wrote: > > More information: If I query the open-source version of Virtuoso, > loaded with the same set of graphs, it returns results. I suspect > there is something in the configuration or security of the commercial > that is not letting this return. I am not really sure where to look > to debug this. > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > If you are using the security features of the commercial edition then this boils down to you target named graph potentially being set to private. So yes, this is security configuration related, as long as target named-graph rather than structure of query is source of the query solution anomaly. Simple cleanup sequence: -- Remove <http://NCIT_NG1> from Private Named Graphs Group, should it be currently set to Private DB.DBA.RDF_GRAPH_GROUP_DEL ('http://www.openlinksw.com/schemas/virtrdf#PrivateGraphs','http://NCIT_NG1') ; -- Clearout perms set for 'nobody' DB.DBA.RDF_ALL_USER_PERMS_DEL ('nobody') ; -- Read privileges for 'nobody' on 'world' (public) named graphs DB.DBA.RDF_DEFAULT_USER_PERMS_SET ('nobody', 1, 0); -- Graph Security Rules Sanity Check RDF_GRAPH_SECURITY_AUDIT ( 0 ) ; [1] http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFGraphsSecurity Kingsley > > > > > > *From: *"Safran , Tracy (NIH/NCI) [C]" <safr...@mail.nih.gov> > *Date: *Tuesday, October 11, 2016 at 8:59 PM > *To: *Kingsley Idehen <kide...@openlinksw.com>, > "virtuoso-users@lists.sourceforge.net" > <virtuoso-users@lists.sourceforge.net> > *Subject: *Re: [Virtuoso-users] Problem with advanced queries > > > > I am not getting any error, just an empty class list. (: > []) The same dataset is loaded into Stardog, for the sake of > comparison, and the exact same query returns results. > > > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > > > > > > *From: *Kingsley Idehen <kide...@openlinksw.com> > *Date: *Tuesday, October 11, 2016 at 6:17 PM > *To: *"virtuoso-users@lists.sourceforge.net" > <virtuoso-users@lists.sourceforge.net> > *Subject: *Re: [Virtuoso-users] Problem with advanced queries > > > > On 10/11/16 4:37 PM, Safran, Tracy (NIH/NCI) [C] wrote: > > I am having problems doing some slightly advanced queries against > http. A simple query works but other queries don’t. Is there a > deeper issue with permissions or indexes that I need to look into? > > > > Example: This works. > > > > /SELECT * / > > /FROM <http://NCIT_NG1> <http://NCIT_NG1> where { ?s ?p ?o } > LIMIT 50/ > > > > But this does not (note: prefix left out for brevity) > > /SELECT ?subject ?role ?object/ > > /WHERE {/ > > /?subject rdfs:subClassOf ?an ./ > > /?an owl:onProperty ?role ./ > > /?an owl:someValuesFrom ?object ./ > > /?subject rdfs:subClassOf* ncit:Gene/ > > /}/ > > /ORDER BY _asc_(?subject)/ > > > > Tracy M. Safran > > Programmer Analyst - EVS support > > Frederick National Laboratory for Cancer Research > > Leidos Biomedical Research, Inc. > > Ph: 240-276-5172 > > tracy.saf...@fnlcr.nih.gov <mailto:tracy.saf...@fnlcr.nih.gov> > > > > I assume you are getting: > > Virtuoso 37000 Error TR...: transitive start not given ? > > You need to add some qualification to the query to optimize for > unknowns such as db size and available memory. > > Examples: > > 1. > http://dbpedia.org/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%0D%0A%0D%0AWHERE+%7B%0D%0A%0D%0A%0D%0A%3Fsubject+a+owl%3AClass+.%0D%0A%3Fobject+a+owl%3AClass+.%0D%0A%3Fsubject+rdfs%3AsubClassOf*+%3Fobject+.+%0D%0A%0D%0Afilter+%28contains%28xsd%3Astring%28%3Fsubject%29%2C%27dbpedia.org%27%29%29%0D%0A%7D%0D%0A%0D%0AORDER+BY+asc%281%29%0D%0A%0D%0ALIMIT+100=text%2Fx-html%2Btr_redir_for_subjs=121_redir_for_hrefs==3=on > -- DBpedia Static > > 2. > http://dbpedia-live.openlinksw.com/sparql?default-graph-uri==SELECT+distinct+%3Fsubject+%3Fobject%
[Virtuoso-users] ANN: DBpedia version 2016-04 released
o > > Lector Facts:This experimental dataset was provided by Matteo > Cannaviccio and demonstrates his approach > <http://dl.acm.org/citation.cfm?id=2932203>to generating facts > by using common sequences of words (i.e. phrases) that are > frequently used to describe instances of binary relations in a > text. We are looking into using this approach as a regular > extraction step. It would be helpful to get some feedback from > you. > > > > > > Credits > > Lots of thanks to > > * > > Markus Freudenberg (University of Leipzig / DBpedia Association) > for taking over the whole release process and creating the > revamped download & statistics pages. > > * > > Dimitris Kontokostas (University of Leipzig / DBpedia Association) > for conveying his considerable knowledge of the extraction and > release process. > > * > > All editors that contributed to the DBpedia ontology mappings via > the Mappings Wiki. > > * > > The whole DBpedia Internationalization Committee for pushing the > DBpedia internationalization forward. > > * > > Heiko Paulheim (University of Mannheim) for providing the > necessary code for his algorithm to generate additional type > statements for formerly untyped resources and identify and removed > wrong statements. Which is now part of the DIEF. > > * > > Václav Zeman, Thomas Klieger and the whole LHD team (University of > Prague) for their contribution of additional DBpedia types > > * > > Marco Fossati (FBK) for contributing the DBTax types > > * > > Alan Meehan (TCD) for performing a big external link cleanup > > * > > Aldo Gangemi (LIPN University, France & ISTC-CNR, Italy) for > providing the links from DOLCE to DBpedia ontology. > > * > > Kingsley Idehen, Patrick van Kleef, and Mitko Iliev (all OpenLink > Software) for loading the new data set into the Virtuoso instance > that provides 5-Star Linked Open Data publication and SPARQL Query > Services. > > * > > OpenLink Software (http://www.openlinksw.com/) collectively for > providing the SPARQL Query Services and Linked Open Data > publishing infrastructure for DBpedia in addition to their > continuous infrastructure support. > > * > > Ruben Verborgh from Ghent University – iMinds for publishing the > dataset asTriple Pattern Fragments > <http://fragments.dbpedia.org/>, and iMinds for sponsoring > DBpedia’s Triple Pattern Fragments server. > > * > > Ali Ismayilov (University of Bonn) for extending the DBpedia > Wikidata dataset. > > * > > Vladimir Alexiev (Ontotext) for leading a successful mapping and > ontology clean up effort. > > * > > All the GSoC students and mentors which directly or indirectly > influenced the DBpedia release > > * > > Special thanks to members of theDBpedia Association > <http://dbpedia.org/dbpedia-association>, theAKSW > <http://aksw.org/About.html>and the department forBusiness > Information Systems > <http://bis.informatik.uni-leipzig.de/en/Welcome>of the University > of Leipzig. > > > > > The work on the DBpedia 2016-04 release was financially supported by > the European Commission through the project ALIGNED – quality-centric, > software and data engineering (http://aligned-project.eu/). > > More information about DBpedia is found athttp://dbpedia.org > <http://dbpedia.org/>as well as in the new overview article about the > project available athttp://wiki.dbpedia.org/Publications > <http://wiki.dbpedia.org/Publications>. > > Have fun with the new DBpedia 2016-04 release! > > Cheers, > > Markus Freudenberg, Dimitris Kontokostas, Sebastian Hellmann -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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
[Virtuoso-users] DBpedia 2016-04 Live Edition for Amazon AWS Cloud
All, Quick FYI: You can now instantiate personal or service-specific DBpedia 2016-04 instances via the Amazon AWS Cloud. I explain the benefits and setup process in a recent blog post [1]. Links: [1] https://medium.com/virtuoso-blog/dbpedia-live-via-openlink-virtuoso-in-the-amazon-web-services-cloud-99b6fafbae2e -- DBpedia 2016-04 LIve Edition Setup & Usage -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/xeonphi___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] request using rdfs:subPropertyOf* and rdfs:subClassOf*
th on data with the query : >>> >>> PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#> >>> PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> >>> PREFIX: >>> >>> SELECT DISTINCT ?A ?B >>> WHERE >>> { >>> ?A ?subProperty8 ?B. >>> ?subProperty8 rdfs:subPropertyOf* :myrel. >>> >>> #constraint 1 >>> ?A rdf:type ?A_SubClassOf. >>> ?A_SubClassOf rdfs:subClassOf* :mytype1. >>> >>> #constraint 2 >>> ?B rdf:type ?B_SubClassOf. >>> ?B_SubClassOf rdfs:subClassOf* :mytype2. >>> } >>> >>> I get only one result : >>> urn:my:graphA urn:my:graphX1 >>> >>> If I remove the first or the second constraint, I get all results >>> that I >>> should find : >>> urn:my:graphA urn:my:graphX1 >>> urn:my:graphC urn:my:graphX1 >>> urn:my:graphB urn:my:graphX2 >>> >>> Could you say me if I did a wrong sparql insertion/request or if it's a >>> bug ? >>> >>> Regards, >>> Olivier F. >>> >>> >>> -- >>> Filangi Olivier >>> +33 (0)2 23 48 51 48 >>> Biodiversity and Polyploidy team - UMR1349 IGEPP - INRA - Agrocampus >>> Ouest >>> +33 (0)2 99 84 74 22 >>> GenOuest Bioinformatics Platform - IRISA >>> >>> >>> -- >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, SlashDot.org <http://slashdot.org>! >>> http://sdm.link/slashdot >>> ___ >>> Virtuoso-users mailing list >>> Virtuoso-users@lists.sourceforge.net >>> <mailto:Virtuoso-users@lists.sourceforge.net> >>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> >> >> -- >> 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 > > > > -- > 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 -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] 409 Invalid Path with SPARQL POST Direct
On 12/21/16 7:25 AM, Nikolaos Beredimas wrote: > I am trying to POST a SPARQL query using the "query via POST directly" > method described in SPARQL 1.1 Protocol ( paragraph 2.1.3) > (https://www.w3.org/TR/2013/REC-sparql11-protocol-20130321/#query-via-post-direct) > > However I am confused if Virtuoso actually does support this method > I have managed to work both with GET and URL-encoded POST (at the same > /sparql path) > but when trying the direct POST method I get a 409 Invalid Path > > > curl -i -X POST -H "Content-Type: application/sparql-query" -d > 'SELECT * WHERE { ?s ?p ?o . }' "http://localhost:8890/sparql; > > HTTP/1.1 409 Invalid path > Server: Virtuoso/07.20.3215 (Win64) x86_64-generic-win-64 > Connection: Keep-Alive > Content-Type: text/html; charset=UTF-8 > Date: Wed, 21 Dec 2016 12:09:51 GMT > Accept-Ranges: bytes > Content-Length: 0 > > Just to make sure it's not a problem on the request side, I launched a > Jena Fuseki instance just for testing, and it appears to work correctly: > curl -i -X POST -H "Content-Type: application/sparql-query" -d > 'SELECT * WHERE { ?s ?p ?o . }' "http://localhost:/mytest/sparql; > HTTP/1.1 200 OK > Date: Wed, 21 Dec 2016 12:14:47 GMT > Fuseki-Request-ID: 2 > Cache-Control: must-revalidate,no-cache,no-store > Pragma: no-cache > Content-Type: application/sparql-results+json; charset=utf-8 > Transfer-Encoding: chunked > > { > "head": { > "vars": [ "s" , "p" , "o" ] > } , > "results": { > "bindings": [ > > ] > } > } > > > > > I have tried using Virtuoso VOS 7.20.3215 & 7.20.3217 > > Now, there have been a couple of threads in the past referencing the > same issue, but unfortunately it was never resolved. > > So is it me doing something wrong, is it a bug, or does Virtuoso not > support this method? > Because the " 409 Invalid Path" doesn't make any sense to me. > Note that if I ommit the Content-Type: application/sparql-query header > I simply get back the SPARQL HTML page, so clearly there is something > going wrong but the error message is either wrong or cryptic Reproduced using: curl -i -X POST -H "Content-Type: application/sparql-query" -d 'SELECT * WHERE { ?s a ?o . } limit 5' "http://dbpedia.org/sparql/; HTTP/1.1 409 Invalid path Date: Wed, 21 Dec 2016 14:01:15 GMT Content-Type: text/html; charset=UTF-8 Content-Length: 0 Connection: keep-alive Server: Virtuoso/07.20.3217 (Linux) i686-generic-linux-glibc212-64 VDB Access-Control-Allow-Origin: * Access-Control-Allow-Credentials: true Access-Control-Allow-Methods: GET, POST, OPTIONS Access-Control-Allow-Headers: DNT,X-CustomHeader,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type,Accept-Encoding That's a bug. Basically, functionality has regressed. It will be looked into, quickly. -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/intel___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Inference howto/if possible without materialization
On 12/22/16 9:38 AM, Jerven Tjalling Bolleman wrote: > Dear Virtuoso Developers and other users. > > > I have a question on inference. > > In the UniProt sparql endpoint there are 1,018,511,122 reification > quads. > > e.g. > > [] a rdf:Statement ; > rdf:subject ?subject ; > rdf:predicate ?predicate ; > rdf:object ?object . > > Now the data modeling is what is so assume its invariant. > Can we use virtuoso inferencing to infer the existence of the predicate > > [] a rdf:Statement > > given the matching statement . > > [] rdf:subject ?subject . > > i.e. infer the class relation ship from the rdf:subject predicate? > > If this is possible. How do we turn it on? > > Regards, > Jerven > > -- Jerven Tjalling Bolleman SIB | Swiss Institute of Bioinformatics > CMU - 1, rue Michel Servet - 1211 Geneva 4 t: +41 22 379 58 85 - f: > +41 22 379 58 58 Jerven.Bolleman@sib.swiss - http://www.sib.swiss Hi Jerven, This is a Custom Inference feature which is part of Virtuoso 8.0 Commercial Edition (currently undergoing final release QA). Using SPIN notation for rule declaration , it would be something along the lines of: rdf:Statement a owl:Class ; spin:rule [ a sp:Construct ; sp:text """ CONSTRUCT { ?s a rdf:Statement . } WHERE {?s rdf:subject ?o} """ ] ; -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/intel___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Mapping XML files to RDF graph using Virtuoso?
On 3/17/17 11:49 AM, Eng.Bassam wrote: > > Thank Kingsley > Could you please support me more information about 2 fundementals that > you has said ??? > may be short example :) ?? > > 1. I think first create an ontology data model for my native XML files. > You have to have an understanding of the entity relationship types in the XML doc. An over / under Tree has no information by way of its structure. > > 2. The second step is create a data model mapping between my XML file > and an ontology data model which created in the first step "as R2RML > does RDB2RDF mapping". > My comment above implies the first step must be completed i.e., what exactly does the XML document content attempt to represent? This hurdle would apply if it were a JSON, CSV, or any other kind of doc. Kingsley > > Thanks again. > > > On Mar 17, 2017 5:05 PM, "Kingsley Idehen" <kide...@openlinksw.com > <mailto:kide...@openlinksw.com>> wrote: > > On 3/17/17 10:05 AM, Eng.Bassam wrote: >> Hi >> I transformed an SQL database to RDF graph using an R2RML in >> a commercial edition of Virtuoso 7.2. >> Now I have 5000 *standard XML files*, Can I do a mapping to RDF >> Graph "same as R2RML" for those XML files using a Virtuoso??? >> >> Thanks. >> > > Only if you can turn the content of the XML files into RDF which > requires: > > 1. Ontological understanding of whats represented in the XML files > > 2. Mechanism for using said understanding to transform that > content into RDF -- e.g., deriving an RDF/XML doc. > > There might be an RML processor for achieving the above. > Naturally, you can also use the Virtuoso Cartridge system to > achieve the same goal. > > Links: > > > 1. > > https://virtuoso.openlinksw.com/whitepapers/sponger%20cartridge%20programmers%20guide%20rdf%20middleware.html > > <https://virtuoso.openlinksw.com/whitepapers/sponger%20cartridge%20programmers%20guide%20rdf%20middleware.html> > > 2. > > https://virtuoso.openlinksw.com/whitepapers/sponger%20cartridge%20programmers%20guide%20rdf%20middleware.html#mozTocId139 > > <https://virtuoso.openlinksw.com/whitepapers/sponger%20cartridge%20programmers%20guide%20rdf%20middleware.html#mozTocId139> > > -- XSLT part of Cartridge Creation > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software (Home Page: http://www.openlinksw.com) > > Weblogs (Blogs): > Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ > <http://www.openlinksw.com/blog/%7Ekidehen/> > Blogspot Blog: http://kidehen.blogspot.com > Medium Blog: https://medium.com/@kidehen > > Profile Pages: > Pinterest: https://www.pinterest.com/kidehen/ > <https://www.pinterest.com/kidehen/> > Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen > <https://www.quora.com/profile/Kingsley-Uyi-Idehen> > Twitter: https://twitter.com/kidehen > Google+: https://plus.google.com/+KingsleyIdehen/about > <https://plus.google.com/+KingsleyIdehen/about> > LinkedIn: http://www.linkedin.com/in/kidehen > <http://www.linkedin.com/in/kidehen> > > Web Identities (WebID): > Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this > <http://kingsley.idehen.net/dataspace/person/kidehen#this> > : > http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this > > <http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this> > > > -- > 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 > <mailto:Virtuoso-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> > > -- > 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 -- Regards, Kingsley Idehen Founder & CEO OpenLink Software (Home
Re: [Virtuoso-users] Mapping XML files to RDF graph using Virtuoso?
On 3/17/17 10:05 AM, Eng.Bassam wrote: > Hi > I transformed an SQL database to RDF graph using an R2RML in > a commercial edition of Virtuoso 7.2. > Now I have 5000 *standard XML files*, Can I do a mapping to RDF Graph > "same as R2RML" for those XML files using a Virtuoso??? > > Thanks. > Only if you can turn the content of the XML files into RDF which requires: 1. Ontological understanding of whats represented in the XML files 2. Mechanism for using said understanding to transform that content into RDF -- e.g., deriving an RDF/XML doc. There might be an RML processor for achieving the above. Naturally, you can also use the Virtuoso Cartridge system to achieve the same goal. Links: 1. https://virtuoso.openlinksw.com/whitepapers/sponger%20cartridge%20programmers%20guide%20rdf%20middleware.html 2. https://virtuoso.openlinksw.com/whitepapers/sponger%20cartridge%20programmers%20guide%20rdf%20middleware.html#mozTocId139 -- XSLT part of Cartridge Creation -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] SPARQL endpoint Update permissions
On 4/4/17 9:54 AM, Iker Esnaola wrote: > > Hello, > > > > I am trying to update my Graph by means of the SPARQL endpoint and the > following query: > > > > DELETE {?s rdf:type "A "} > INSERT {?s rdf:type "B" } > from > WHERE { ?s rdf:type "A"} > > > > I am getting the following error: Virtuoso 42000 Error SR186:SECURITY: > No permission to execute procedure > DB.DBA.SPARQL_MODIFY_BY_DICT_CONTENTS with user ID 107, group ID 107 > > > > After giving SPARQL_UPDATE permissions to the “SPARQL” user, there is > no such a problem and I am able to perform the query. > > > > However, my SPARQL endpoint is public so this is not a good practice. > > > > I have been looking for information in this matter but I didn’t find > anything decisive. Is there any possibility of login in the SPARQL > endpoint? I am thinking of some way of enabling certain users to > update the content (e.g. administrators) while leaving the rest of the > users with only query permissions. > > > > Thanks in advance, > To cut a long story short, you will need attrtibute-based acls (ABAC) which are part of the commercial edition of Virtuoso [1]. If you don't want to exploit that degree of sophistication you can try role-based acls (RBAC) via our Graph Security feature. [1] https://medium.com/virtuoso-blog/web-logic-sentences-and-the-magic-of-being-you-e2a719d01f73 -- End to End Example re. Attributed-based access control [2] https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFGraphsSecurity -- Role-based Graph Security -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] Federated queries and time zones.
On 3/10/17 7:49 AM, Pasquale Di Donato wrote: > Hi List, > > I'm trying a federated query with some filters on date and getting > weird results. > Does the time zone has an impact on this kind of queries. > In my case the two services have 2 different time zones: GMT+0 and GMT+1. > > Any feedback will be appreciated. Thanks > Pasquale Please share a SPARQL Query or Results page URI that demonstrates the problem. That simplifies the issue analysis process. -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] client javascript
On 7/6/17 1:31 PM, Carlo Capelli wrote: > Hi Kingsley > > Thanks for your answer, sorry for the late reply... > > From the (verbose and very sparse!) information I've collected so far, > seems I have to send my credentials to perform basic authentication > with the server. > > So, inspecting - with help from the browser developer tools - the > default interface protocol (the HTTP form with the fields > httpd_password,httpd_username, presented upfront the URL request, > let's say https://www.example.com/sparql), > I've managed to issue a correct call - using php curl, where I can > trust better the transmission. > Alas, the return payload value is encrypted... still more problems, > and low level details to 'guess'... > > This seems way too complicated for such a simple use case. > I wonder what could be the reason to keep the details of the client so > difficult to find. > Isn't authenticated access via HTTPS almost a necessity these days? Hi Carlo, To cut a long story short, if you want to use TLS to authenticate you need to use WebID+TLS+Delegation protocol. You can also use Digest Authentication via /sparql-auth endpoint. The only requirement is CORs enabling the SPARQL endpoint. [1] https://enable-cors.org/server_virtuoso.html [2] http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksCORsEnableSPARQLURLs [3] http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksGuideCORSSetup Kingsley > > 2017-07-03 15:41 GMT+02:00 Kingsley Idehen <kide...@openlinksw.com > <mailto:kide...@openlinksw.com>>: > > On 7/3/17 5:16 AM, Carlo Capelli wrote: >> Hi All >> >> I had no luck searching for a javascript client with capability >> to connect to a secured endpoint, >> and nobody could help me on stackoverflow ( >> https://stackoverflow.com/q/44871467/874024 >> <https://stackoverflow.com/q/44871467/874024> ). >> >> Is there some open source code sample I could start from ? >> If I will solve this, my plan is to contribute to this client ( >> https://www.npmjs.com/package/virtuoso-sparql-client >> <https://www.npmjs.com/package/virtuoso-sparql-client> ) >> >> Best regards, Carlo > > CORs-enable your endpoint. > > > Now the endpoint is CORS enabled. But it didn't solved my problem. > > > DBpedia's endpoint (a Virtuoso instance) is CORs enabled, thus you > should verify you work against that. > > > Not sure I follow, I'm using a module (virtuoso-sparql-client > <https://www.npmjs.com/package/virtuoso-sparql-client>) that for sure > allows to fetch public data from dbpedia... > > Best regards, Carlo > > > Kingsley >> >> >> >> >> -- >> 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 >> <mailto:Virtuoso-users@lists.sourceforge.net> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> > > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software (Home Page: http://www.openlinksw.com) > > Weblogs (Blogs): > Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ > <http://www.openlinksw.com/blog/%7Ekidehen/> > Blogspot Blog: http://kidehen.blogspot.com > Medium Blog: https://medium.com/@kidehen > > Profile Pages: > Pinterest: https://www.pinterest.com/kidehen/ > <https://www.pinterest.com/kidehen/> > Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen > <https://www.quora.com/profile/Kingsley-Uyi-Idehen> > Twitter: https://twitter.com/kidehen > Google+: https://plus.google.com/+KingsleyIdehen/about > <https://plus.google.com/+KingsleyIdehen/about> > LinkedIn: http://www.linkedin.com/in/kidehen > <http://www.linkedin.com/in/kidehen> > > Web Identities (WebID): > Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i > <http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i> > : > http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this > > <http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this> > > > > --
[Virtuoso-users] Virtuoso INI files Spreadsheet
All, If you have a sizable Virtuoso instance (i.e., 2 Billion+ Triples), please notify me (by way of email reply) about your desire to add said instance configuration to the spreadsheet at: https://docs.google.com/spreadsheets/d/1-stlTC_WJmMU3xA_NxA1tSLHw6_sbpjff-5OITtrbFw/edit#gid=812792186 -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] client javascript
On 7/3/17 5:16 AM, Carlo Capelli wrote: > Hi All > > I had no luck searching for a javascript client with capability to > connect to a secured endpoint, > and nobody could help me on stackoverflow ( > https://stackoverflow.com/q/44871467/874024 ). > > Is there some open source code sample I could start from ? > If I will solve this, my plan is to contribute to this client ( > https://www.npmjs.com/package/virtuoso-sparql-client ) > > Best regards, Carlo CORs-enable your endpoint. DBpedia's endpoint (a Virtuoso instance) is CORs enabled, thus you should verify you work against that. Kingsley > > > > -- > 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 -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Virtuoso Transitive Query Error
On 5/5/17 5:29 PM, S.M.Shamimul Hasan wrote: > Hello, > > I am trying to run the following query on the Virtuoso SPARQL endpoint > to calculate the path between nodes. However, it is giving me > following error. Could you please let me know how to fix it? BTW the > query works fine for the Jena TDB. However, I want to use Virtuoso > triplestore because it contains all of my datasets. > > Query: > - > PREFIX fused:<http://test.edu/vocab/> > > select ?super ?sub (count(?mid) as ?distance) from > <http://test.edu/example/replicate9/> { > ?mid fused:getInfectedBy* ?super. > ?sub fused:getInfectedBy+ ?mid. > } > group by ?super ?sub > order by ?super ?sub > > Error: > > Virtuoso 37000 Error TR...: Query contains a transitive derived table > but neither end of it is bound by equality to other columns or parameters. > > Thanks a lot. > > Sincerely, > S.M.Shamimul Hasan ## Fails (correctly so) with Transitivity error; Virtuoso 37000 Error TR...: Query contains a transitive derived table but neither end of it is bound PREFIX fused:<http://test.edu/vocab/> SELECT ?super ?sub (count(?mid) as ?distance) WHERE { ?mid fused:getInfectedBy* ?super. ?sub fused:getInfectedBy+ ?mid. } GROUP BY ?super ?sub ORDER BY ?super ?sub LIMIT 1 ## Workaround using a sub-query PREFIX fused: <http://test.edu/vocab/> SELECT SAMPLE(?t) ?super ?sub (count(?mid) as ?distance) WHERE { { SELECT distinct ?super WHERE { ?x fused:getInfectedBy ?super } } ?mid fused:getInfectedBy* ?super. ?sub fused:getInfectedBy+ ?mid. } GROUP BY ?super ?sub ORDER BY ?super ?sub LIMIT 1 You can copy and paste each to the SPARQL endpoint at http://linkeddata.uriburner.com/sparql or even http://dbpedia.org/sparql. In either case, the second query will return an empty solution as solution proof. -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] utilizing domain ruleset in virtuoso?
On 5/2/17 1:00 AM, 손태모 wrote: > Dear all, > > i am wondering that can i use domain rule set in virtuoso inference ? > i have searched virtuoso documents about rule inference . > but unfortunately , there are only rdfs semantics level inference such > as subClassOf, subPropertyOf, Transitive rule etc. and i have not > found any topic about inference triple using user defined domain rule > set. > > can i define domain rule and use it in virtuoso ? > > thanks in advance. Custom Inference Rules (e.g., using SPIN Vocabulary) is a feature of Virtuoso 8.0 which will be out in beta this week [1]. [1] https://www.linkedin.com/pulse/reasoning-inference-using-british-royal-family-part-idehen -- Virtuoso 8.0 Custom Inference Rules & Examples Kingsley > > > > Sohn, Taemo > LiST Co., Ltd. > 9th Floor, Yangyong bldg., > 3, Beodeunaru-ro 19-gil, Yeongdeungpo-gu, Seoul, Korea > > Tel +82 2 2632 5133 > Fax +82 2 2632 5134 > Mobile +82 10 2647 0108 > > > > -- > 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 -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] Virtuoso Transitive Query Error
On 5/8/17 1:13 PM, S.M.Shamimul Hasan wrote: > Dear Kingsley Idehen, > > Thank you very much for your reply. I have tried the solution with > sub-query that you provided me. However, it is giving me following > error. Could you please let me know how to fix it? > > Virtuoso 37000 Error SP031: SPARQL compiler: Variable 't' is used in > the query result set but not assigned > > Thanks a lot. > > Sincerely, > S.M.Shamimul Hasan > > > On Sun, May 7, 2017 at 12:59 PM, Kingsley Idehen > <kide...@openlinksw.com <mailto:kide...@openlinksw.com>> wrote: > > On 5/5/17 5:29 PM, S.M.Shamimul Hasan wrote: > > Hello, > > > > I am trying to run the following query on the Virtuoso SPARQL > endpoint > > to calculate the path between nodes. However, it is giving me > > following error. Could you please let me know how to fix it? BTW the > > query works fine for the Jena TDB. However, I want to use Virtuoso > > triplestore because it contains all of my datasets. > > > > Query: > > - > > PREFIX fused:<http://test.edu/vocab/> > > > > select ?super ?sub (count(?mid) as ?distance) from > > <http://test.edu/example/replicate9/ > <http://test.edu/example/replicate9/>> { > > ?mid fused:getInfectedBy* ?super. > > ?sub fused:getInfectedBy+ ?mid. > > } > > group by ?super ?sub > > order by ?super ?sub > > > > Error: > > > > Virtuoso 37000 Error TR...: Query contains a transitive derived > table > > but neither end of it is bound by equality to other columns or > parameters. > > > > Thanks a lot. > > > > Sincerely, > > S.M.Shamimul Hasan > > ## Fails (correctly so) with Transitivity error; Virtuoso 37000 Error > TR...: Query contains a transitive derived table but neither end of it > is bound > > PREFIX fused:<http://test.edu/vocab/> > > SELECT ?super ?sub (count(?mid) as ?distance) > WHERE { > ?mid fused:getInfectedBy* ?super. > ?sub fused:getInfectedBy+ ?mid. > } > GROUP BY ?super ?sub > ORDER BY ?super ?sub > LIMIT 1 > > > ## Workaround using a sub-query > > PREFIX fused: <http://test.edu/vocab/> > > SELECT SAMPLE(?t) ?super ?sub (count(?mid) as ?distance) > WHERE { > { SELECT distinct ?super > WHERE { ?x fused:getInfectedBy ?super } > } > >?mid fused:getInfectedBy* ?super. >?sub fused:getInfectedBy+ ?mid. >} > GROUP BY ?super ?sub > ORDER BY ?super ?sub > LIMIT 1 > See: http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org=PREFIX+fused%3A+%3Chttp%3A%2F%2Ftest.edu%2Fvocab%2F%3E%0D%0A%0D%0ASELECT+SAMPLE%28%3Ft%29+%3Fsuper+%3Fsub+%28count%28%3Fmid%29+as+%3Fdistance%29%0D%0AWHERE+%7B%0D%0A%7B+SELECT+distinct+%3Fsuper%0D%0A++WHERE+%7B+%3Fx+fused%3AgetInfectedBy+%3Fsuper+%7D%0D%0A%7D%0D%0A%0D%0A+++%3Fmid+fused%3AgetInfectedBy*+%3Fsuper.%0D%0A+++%3Fsub+fused%3AgetInfectedBy%2B+%3Fmid.%0D%0A+++%7D%0D%0AGROUP+BY+%3Fsuper+%3Fsub%0D%0AORDER+BY+%3Fsuper+%3Fsub%0D%0ALIMIT+1=text%2Fhtml_redir_for_subjs=121_redir_for_hrefs==3 -- empty solution as would be expected. Unhatch " Strict checking of void variables" check-box in the SPARQL Query Editor. -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] Disabling logging & transactions with DB.DBA.TTLP_MT
On 6/27/17 4:00 PM, Frederick Giasson wrote: > Hi, > > Quick question regarding DB.DBA.TTLP_MT. I run the following command: > > DB.DBA.TTLP_MT (file_to_string_output ('some.n3'), '', > 'http://foo/bar/' 0, 0, 4, 0); > > "some.n3" is about 30G big with a few hundred million triples. > > I thought that this would disable transactions and logging, but it > doesn't look like that. If I import that N3 file in an empty database, > then I can eventually see "virtuoso.trx" growing (into the G in size) > which suggest me that transactions are **not** disabled. > > I also tried "log_enable(3, 1)" and I am getting the same behavior. > > am sending these queries via "isql" and I am using Virtuoso version > 7.2.4.2 > > Thanks! > > Fred Fred, Please try log_enable(2,1). Or just run the bulk loader . Links: 1. http://docs.openlinksw.com/virtuoso/fn_log_enable/ 2. http://vos.openlinksw.com/owiki/wiki/VOS/VirtBulkRDFLoader -- 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 smime.p7s Description: S/MIME Cryptographic Signature -- 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] testing SPIN rules in Virtuoso 8
g & Inference Context per SPARQL Query. Links: [1] http://linkeddata.uriburner.com/sparql?default-graph-uri==DEFINE+input%3Amacro-lib+%3Curn%3Aspin%3Arule%3Ageometry%3Alib%3E%0D%0APREFIX+shapes%3A+%3Chttp%3A%2F%2Fexample.org%2Fshapes%23%3E%0D%0A%0D%0ASELECT+*%0D%0AWHERE%0D%0A%7B%0D%0A%3Fs+shapes%3Awidth+%3Fw.%0D%0A++++%3Fs+shapes%3Aheight+%3Fh.%0D%0AOPTIONAL+%7B+%3Fs+shapes%3Aarea++%3Farea+%7D.%0D%0A%7D==text%2Fhtml_redir_for_subjs=121_redir_for_hrefs==3000 -- SPARQL Query Results page where solution is constructed with Custom Reasoning & Inference Context enabled. -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Define a built-in SPIN function
On 9/13/17 10:14 AM, Angelo Santoro wrote: > Hello, > > I'm developing a project in which I use Virtuoso Open Source as > storage. I'm pretty new to Virtuoso, so I would like to know if it's > possible to write a SPIN function, load it to the triple store, and > call it in another SPARQL query. > > Thanks. > > Angelo > Hi Angelo, Not with the Open Source Edition of Virtuoso. -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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
[Virtuoso-users] Correction: testing SPIN rules in Virtuoso 8
On 9/14/17 4:52 PM, Kingsley Idehen wrote: > On 9/13/17 10:28 AM, Adam Sanchez wrote: >> Hi all, >> >> I am testing SPIN rules in the demo version of Virtuoso 8 but I have >> still no success. >> I wrote a simple SPIN rule to compute the area of an instance of a >> class Rectangle given its width and its height. In this script you can >> see all the queries I used. This script must be executed in the SQL >> console of Virtuoso 8. >> >> https://tinyurl.com/yb359owr >> >> As you can see here at the bottom, >> >> http://imageshack.com/a/img923/1182/qG4HmJ.png >> >> the rule is loaded but it does not work when I run a query >> >> http://imagizer.imageshack.us/a/img922/7629/it260O.png >> >> For you reference, I was using this output as reference to see how the >> loaded rule must look. >> >> https://tinyurl.com/ycm3zp6p >> >> Also, I have read these links so far >> >> https://medium.com/virtuoso-blog/virtuoso-8-0-creating-a-custom-inference-rules-using-spin-vocabulary-d7a060f859ef >> https://www.mail-archive.com/virtuoso-users@lists.sourceforge.net/msg07790.html >> https://www.linkedin.com/pulse/reasoning-inference-using-british-royal-family-part-idehen >> https://medium.com/virtuoso-blog/using-british-royal-family-data-snippets-to-demonstrate-sparql-query-language-based-reasoning-56626a152419 >> http://docs.openlinksw.com/virtuoso/udt_overview/ >> >> BTW, in RDF4j works. I do not need to load the rule separately, I just >> loaded the full ontology and that's all, the SPIN rule worked. See >> >> http://imagizer.imageshack.us/a/img924/7717/Q9JYau.png >> http://imagizer.imageshack.us/a/img924/9828/4dQPzg.png >> >> >> Any idea? >> >> Thanks in advance, >> >> Adam > Hi Adam, > > We don't have a problem with Virtuoso's SPIN Rules handling, once a few > errors (I assume typos) in your example are fixed. Here's my rendition > of what you shared: > > -- This a SPARQL script to test SPIN Rules in Virtuoso 8 > -- It should compute the area of an instance of the class Rectangle > given its width and its height. > -- This script must be run in the SQL console of Virtuoso > > -- Additional commands > > SPARQL CLEAR GRAPH <http://geometry> ; > SPARQL CLEAR GRAPH ; > SPARQL DROP SPIN LIBRARY ; > > -- create a named graph > > -- SPARQL CREATE GRAPH <http://geometry> ; > > SPARQL > PREFIX shapes: <http://example.org/shapes#> > PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> > PREFIX owl: <http://www.w3.org/2002/07/owl#> > > WITH <http://geometry> > INSERT { > shapes:Rectangle > rdf:type owl:Class . > > shapes:rectangle_1 > rdf:type shapes:Rectangle ; > shapes:height "5" ; > shapes:width "49" . > shapes:area rdf:type owl:DatatypeProperty . > shapes:height rdf:type owl:DatatypeProperty . > shapes:width rdf:type owl:DatatypeProperty . > } ; > > -- create the rule > -- SPARQL CREATE GRAPH ; > > SPARQL > PREFIX shapes: <http://example.org/shapes#> > PREFIX spin: <http://spinrdf.org/spin#> > PREFIX sp: <http://spinrdf.org/sp#> > PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> > PREFIX owl: <http://www.w3.org/2002/07/owl#> > > WITH > INSERT { > shapes:Rectangle > rdf:type owl:Class; > rdfs:label "Rectangle class"; > spin:rule [ > a sp:Construct; > sp:text """ CONSTRUCT { ?this > <http://example.org/shapes#area> ?area . } > WHERE { ?this > <http://example.org/shapes#width> ?width . > ?this > <http://example.org/shapes#height> ?height . > BIND ((xsd:float(?height) * > xsd:float(?width)) AS ?area) . > } > """ > ] . > } ; > > EXEC ('SPARQL ' || > SPARQL_SPIN_GRAPH_TO_DEFSPIN('urn:spin:rule:geometry:lib')); > > -- run a sparql query to test the spin rule > > SPARQL > DEFINE input:macro-lib > PREFIX shapes: <http://example.org/shapes#> > > SELECT * > WHERE > { > ?s shapes:width ?w. > ?s shapes:height ?h. > OPTIONAL { ?s shapes:area ?area }. > } ; > > > All you have to do is copy, paste, and then run the script above via > the HTM-based Admin UI (Conductor) or iSQL co
[Virtuoso-users] Fixed: Correction: testing SPIN rules in Virtuoso 8
On 9/14/17 5:08 PM, Kingsley Idehen wrote: > On 9/14/17 4:52 PM, Kingsley Idehen wrote: >> On 9/13/17 10:28 AM, Adam Sanchez wrote: >>> Hi all, >>> >>> I am testing SPIN rules in the demo version of Virtuoso 8 but I have >>> still no success. >>> I wrote a simple SPIN rule to compute the area of an instance of a >>> class Rectangle given its width and its height. In this script you can >>> see all the queries I used. This script must be executed in the SQL >>> console of Virtuoso 8. >>> >>> https://tinyurl.com/yb359owr >>> >>> As you can see here at the bottom, >>> >>> http://imageshack.com/a/img923/1182/qG4HmJ.png >>> >>> the rule is loaded but it does not work when I run a query >>> >>> http://imagizer.imageshack.us/a/img922/7629/it260O.png >>> >>> For you reference, I was using this output as reference to see how the >>> loaded rule must look. >>> >>> https://tinyurl.com/ycm3zp6p >>> >>> Also, I have read these links so far >>> >>> https://medium.com/virtuoso-blog/virtuoso-8-0-creating-a-custom-inference-rules-using-spin-vocabulary-d7a060f859ef >>> https://www.mail-archive.com/virtuoso-users@lists.sourceforge.net/msg07790.html >>> https://www.linkedin.com/pulse/reasoning-inference-using-british-royal-family-part-idehen >>> https://medium.com/virtuoso-blog/using-british-royal-family-data-snippets-to-demonstrate-sparql-query-language-based-reasoning-56626a152419 >>> http://docs.openlinksw.com/virtuoso/udt_overview/ >>> >>> BTW, in RDF4j works. I do not need to load the rule separately, I just >>> loaded the full ontology and that's all, the SPIN rule worked. See >>> >>> http://imagizer.imageshack.us/a/img924/7717/Q9JYau.png >>> http://imagizer.imageshack.us/a/img924/9828/4dQPzg.png >>> >>> >>> Any idea? >>> >>> Thanks in advance, >>> >>> Adam >> Hi Adam, >> >> We don't have a problem with Virtuoso's SPIN Rules handling, once a few >> errors (I assume typos) in your example are fixed. Here's my rendition >> of what you shared: >> >> -- This a SPARQL script to test SPIN Rules in Virtuoso 8 >> -- It should compute the area of an instance of the class Rectangle >> given its width and its height. >> -- This script must be run in the SQL console of Virtuoso >> >> -- Additional commands >> >> SPARQL CLEAR GRAPH <http://geometry> ; >> SPARQL CLEAR GRAPH ; >> SPARQL DROP SPIN LIBRARY ; >> >> -- create a named graph >> >> -- SPARQL CREATE GRAPH <http://geometry> ; >> >> SPARQL >> PREFIX shapes: <http://example.org/shapes#> >> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> >> PREFIX owl: <http://www.w3.org/2002/07/owl#> >> >> WITH <http://geometry> >> INSERT { >> shapes:Rectangle >> rdf:type owl:Class . >> >> shapes:rectangle_1 >> rdf:type shapes:Rectangle ; >> shapes:height "5" ; >> shapes:width "49" . >> shapes:area rdf:type owl:DatatypeProperty . >> shapes:height rdf:type owl:DatatypeProperty . >> shapes:width rdf:type owl:DatatypeProperty . >> } ; >> >> -- create the rule >> -- SPARQL CREATE GRAPH ; >> >> SPARQL >> PREFIX shapes: <http://example.org/shapes#> >> PREFIX spin: <http://spinrdf.org/spin#> >> PREFIX sp: <http://spinrdf.org/sp#> >> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> >> PREFIX owl: <http://www.w3.org/2002/07/owl#> >> >> WITH >> INSERT { >> shapes:Rectangle >> rdf:type owl:Class; >> rdfs:label "Rectangle class"; >> spin:rule [ >> a sp:Construct; >> sp:text """ CONSTRUCT { ?this >> <http://example.org/shapes#area> ?area . } >> WHERE { ?this >> <http://example.org/shapes#width> ?width . >> ?this >> <http://example.org/shapes#height> ?height . >> BIND ((xsd:float(?height) * >> xsd:float(?width)) AS ?area) . >> } >> """ >> ] . >> } ; >> >> EXEC ('SPARQL ' || >> SPARQL
Re: [Virtuoso-users] A wrong behavior of SPARQL with transitive relationships.
On 5/12/18 5:11 PM, Jason Koh wrote: > From https://www.w3.org/TR/sparql11-property-paths/, > /elt*/A path of zero or more occurrences of /elt/. > > > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> You have: You have: ``` sparql prefix : <http://test.abc#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix owl: <http://www.w3.org/2002/07/owl#> insert IN GRAPH { :class1 a owl:Class . :class2 a owl:Class . :entity0 a :class1. :entity1 a :class2. :entity2 a :class2. :entity0 :relation1 :entity1. :entity0 :relation1 :entity2. }; ``` Where are your rdfs:subClassOf relations? Implies it should have been: ``` sparql prefix : <http://test.abc#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix owl: <http://www.w3.org/2002/07/owl#> insert IN GRAPH { :class1 a owl:Class . :class2 a owl:Class . ## Note relation added here ## :class2 rdfs:subClassOf :class1 . :entity0 a :class1. :entity1 a :class2. :entity2 a :class2. :entity0 :relation1 :entity1. :entity0 :relation1 :entity2. }; ``` Kingsley > > On Sat, May 12, 2018 at 2:10 PM, Jason Koh <jb...@eng.ucsd.edu > <mailto:jb...@eng.ucsd.edu>> wrote: > > Hi Kingsley, > > I put * path modifier, which should also match no subClassOf > relationship pattern in my understanding. > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> > > On Sat, May 12, 2018 at 1:57 PM, Kingsley Idehen > <kide...@openlinksw.com <mailto:kide...@openlinksw.com>> wrote: > > On 5/11/18 4:56 PM, Jason Koh wrote: >> Hi, >> >> I am using Virtuoso opensource v7.2.4. I found that SPARQLs >> with transitive relationships return partial results. Could >> you confirm this behavior? Here are the reproducing ISQL queries. >> >> - Data insertion: >> >> ``` >> sparql >> prefix : <http://test.abc#> >> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns# >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> >> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema# >> <http://www.w3.org/2000/01/rdf-schema#>> >> prefix owl: <http://www.w3.org/2002/07/owl# >> <http://www.w3.org/2002/07/owl#>> >> insert IN GRAPH >> { >> :class1 a owl:Class . >> :class2 a owl:Class . >> :entity0 a :class1. >> :entity1 a :class2. >> :entity2 a :class2. >> :entity0 :relation1 :entity1. >> :entity0 :relation1 :entity2. >> }; >> ``` >> >> - Verification of the data >> >> ``` >> sparql >> select ?s ?p ?o from where {?s ?p ?o .}; >> ``` >> >> - The problem query >> ``` >> sparql >> prefix : <http://test.abc> >> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema# >> <http://www.w3.org/2000/01/rdf-schema#>> >> select ?s ?o where { >> #?o a/rdfs:subClassOf* :class2. # Only returns a tuple. I >> think incorrect. >> ?o a :class2. # returns all the tuples. I think correct. >> ?s :relation1 ?o. >> }; >> ``` >> >> If I run the above query, it only returns one pair of ?s and >> ?o instead of two pairs of (entity0, entity1) and (entity0, >> entity1). If I comment out the transitive line and uncomment >> the second line, it returns the correct result with the two >> pairs. I believe those two queries should return the same result. >> >> Is this a bug or do I misunderstand something in the SPARQL? >> >> Thank you! >> >> >> >> With regards, >> Jason Koh >> cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> >> > > You have: > > ``` > sparql > prefix : <http://test.abc#> > prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns# > <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> > prefix rdfs: <http://www.w3.org/2000/01/rdf-schema# > <http://www.w3.org/2000/01/rdf-schema#>> >
Re: [Virtuoso-users] Question for querying with a variable as a predicate?
On 5/23/18 8:32 PM, Jason Koh wrote: > Hi, > > First I would like to appreciate this community where I am receiving a > lot of help. > > I have a query would like to get answers but a variable predicate. > > The dataset is: > ``` > # Insert Triples > sparql > > prefix owl: <http://www.w3.org/2002/07/owl#> > prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> > prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> > prefix : <http://example.com#> > > insert data { > graph { > :PropB a owl:TransitiveProperty. > :PropB1 rdfs:subPropertyOf :PropB. > :PropB2 rdfs:subPropertyOf :propB1. > > :b a :EntityB. > :b1 a :EntityB. > :b2 a :EntityB. > :aaa a :EntityB; > :propB :b; > :propB1 :b1; > :propB2 :b2. > } > }; > ``` > Basically there is "aaa" who is related to "b", "b1", "b2" with > "PropB", "PropB1", "PropB2". And they have a hierarchy as PropB2 is a > sub property of PropB1 that is a sub property of PropB. > > However, below query does not return anything: > ``` > sparql > prefix owl: <http://www.w3.org/2002/07/owl#> > prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> > prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> > prefix : <http://example.com#> > > select ?s ?p ?o from where { > ?p rdfs:subPropertyOf* :PropB. > ?s ?p ?o. > }; > ``` > > So I added reasoning rules based on Kingsley's previous comment. > > Here's the rule graph: > ``` > sparql > prefix owl: <http://www.w3.org/2002/07/owl#> > prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> > prefix : <http://example.com#> > > insert data { > graph { > :PropB a owl:TransitiveProperty. > :PropB1 rdfs:subPropertyOf :PropB. > :PropB2 rdfs:subPropertyOf :propB1. > } > }; > ``` > > Then I inserted the rule with a command: > ``rdfs_rule_set ('urn:proptest:rules', 'urn:proptest:rules') ;`` > > Then I enabled the rule in the query: > ``` > sparql > DEFINE input:inference 'urn:proptest:rules' > prefix owl: <http://www.w3.org/2002/07/owl#> > prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> > prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> > prefix : <http://example.com#> > > select ?s ?p ?o from where { > ?p rdfs:subPropertyOf* :PropB. > ?s ?p ?o. > }; > ``` > But still it does not return anything. > > I am not sure if the query is valid in SPARQL or there is something I > miss in Virtuoso. > > If there is anything that I can learn about, please let me know. > > Thank you! > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> Jason, Here is a complete script. Please study it. ``` -- Clear Graphs SPARQL CLEAR GRAPH ; SPARQL CLEAR GRAPH ; -- Load TBox Data SPARQL PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <#> INSERT DATA { GRAPH { rdfs:subPropertyOf a owl:TransitiveProperty . rdfs:subClassOf a owl:TransitiveProperty . :rel1 a rdf:Property . :rel2 rdfs:subPropertyOf :rel1 . :rel3 rdfs:subPropertyOf :rel2 . } }; -- Load Abox Data SPARQL PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <#> INSERT DATA { GRAPH { :this :rel3 :that . :this :rel3 :that . :that :rel2 :other . :other :rel1 :final . } }; SPARQL SELECT * FROM WHERE {?s ?p ?o} ; RDFS_RULE_SET ('urn:rdfs:inference:rules', 'urn:rdfs:inference:rules:def') ; SELECT * FROM DB.DBA.SYS_RDF_SCHEMA WHERE RS_NAME = 'urn:rdfs:inference:rules' ; -- Test Query 1 using Property Path "+" operator SPARQL DEFINE input:inference 'urn:rdfs:inference:rules' PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <#> SELECT DISTINCT :this ?p ?o FROM WHERE { :this :rel1+ ?o ; ?p ?o2. } ; -- Test Query 2 using Property Path "*" operator SPARQL DEFINE input:inference 'urn:rdfs:inference:rules' PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <#> SELECT DISTINCT :this ?o ?p ?o2 FROM WHERE {
[Virtuoso-users] Simple Linked Data Deployment Tutorial
Happy New Year to everyone! I would like to open the year by sharing an updated version of an old post about Linked Data deployment using relative HTTP URIs [1]. Fundamentally, the act of using hyperlinks to identify the subject, predicate, and object of RDF sentences, shouldn't be a point of technical intimidation or confusion regarding the notion of a Semantic Web of Linked Data. Links: [1] https://medium.com/openlink-software-blog/simple-linked-data-deployment-tutorial-a532e568c82f -- Simple Linked Data Deployment Tutorial -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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
[Virtuoso-users] FYI Re: WebDataCommons releases 38.7 billion quads Microdata, Embedded JSON-LD, RDFa and Microformat data originating from 7.4 million pay-level-domains
notate their content. > > * * > > *Richer Descriptions of Job Postings* > > Following the release of the “Google for Jobs” search vertical and the > more detailed guidance by Google on how to annotate job postings > (https://developers.google.com/search/docs/data-types/job-posting), we > see an increase in the number of websites annotating job postings > (2017: 7,023, 2016: 6,352). In addition, the job posting annotations > tend to become richer in comparison to the previous years as the > number of Job Posting related properties adopted by at least 30% of > the websites containing job offers has increased from 4 (2016) to 7 > (2017). The newly adopted properties are JobPosting/url, > JobPosting/datePosted, and JobPosting/employmentType. > > You can find a more extended analysis concerning specific topics, like > Job Posting and Product, here > > http://webdatacommons.org/structureddata/2017-12/stats/schema_org_subsets.html#extendedanalysis > > > > *Download * > > The overall size of the November 2017 RDFa, Microdata, Embedded > JSON-LD and Microformat data sets is 38.7 billion RDF quads. For > download, we split the data into 8,433 files with a total size of 858 GB. > > http://webdatacommons.org/structureddata/2017-12/stats/how_to_get_the_data.html > > In addition, we have created for over 40 different schema.org > <http://schema.org/> classes separate files, including all quads > extracted from pages, using a specific schema.org class. > > http://webdatacommons.org/structureddata/2017-12/stats/schema_org_subsets.html > > > > *Lots of thanks to:* > > + the Common Crawl project for providing their great web crawl and > thus enabling the WebDataCommons project. > + the Any23 project for providing their great library of structured > data parsers. > + Amazon Web Services in Education Grant for supporting WebDataCommons. > + the Ministry of Economy, Research and Arts of Baden – Württemberg > which supported through the ViCE project the extraction and analysis > of the November 2017 corpus. > > *General Information about the WebDataCommons Project* > > The WebDataCommons project extracts structured data from the Common > Crawl, the largest web corpus available to the public, and provides > the extracted data for public download in order to support researchers > and companies in exploiting the wealth of information that is > available on the Web. Beside of the yearly extractions of semantic > annotations from webpages, the WebDataCommons project also provides > large hyperlink graphs, the largest public corpus of WebTables, a > corpus of product data, as well as a collection of hypernyms extracted > from billions of web pages for public download. General information > about the WebDataCommons project is found at > > http://webdatacommons.org/ > > > Have fun with the new data set. > > Cheers, > Anna Primpeli, Robert Meusel and Chris Bizer > > > -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Inference support?
On 2/22/18 10:33 PM, Jason Koh wrote: > Just to provide my use case, > > I presumed if there is a graph like > > ```turtle > ex:a rdf:type sch:Class1 . > sch:Class1 owl:equivalentClass sch:Class2 . > ``` > . a query like this should work > ```sparql > select ?s where { > ?s rdf:type sch:Class2 . > } > ``` > > Thanks! > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> > > On Thu, Feb 22, 2018 at 5:33 PM, Jason Koh <jb...@eng.ucsd.edu > <mailto:jb...@eng.ucsd.edu>> wrote: > > Hi, > > I would like to exploit OWL/RDFS inferences like > here: > https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtSPARQLReasoningTutorial#Step > > <https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtSPARQLReasoningTutorial#Step> > 6.: SPARQL Inference Queries > > 1. However, I can't find the "define rules" for > owl:equivalentClass as mentioned > here: > http://docs.openlinksw.com/virtuoso/virtuosotipsandtricksrdfschowlinfrl/ > > <http://docs.openlinksw.com/virtuoso/virtuosotipsandtricksrdfschowlinfrl/>. > > What is the exact keyword to use owl:equivalentClass like ``DEFINE > input:same-as "yes"``? > > > 2. And if I use inference instead of transitive search like > ``rel:ancestorOf+``, is it faster? > > Thank you! > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> > Steps: SQL> sparql define get:soft "no-sponge" load <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl> ; Done. -- 6146 msec. SQL> rdfs_rule_set ('urn:equivalent:class:inference:rules:demo:2018:16:45', 'http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl'); Done. -- 182 msec. SQL> p_score_init (); Here are links Virtuoso's Reasoning & Inference functionality with live demo links based on the above [1] http://lod.openlinksw.com/describe/?url=http%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2FOrganization=1 -- FOAF Organization instances modulo built-in Reasoning & Inference [2] http://lod.openlinksw.com/describe/?uri=http%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2FOrganization=urn%3Aequivalent%3Aclass%3Ainference%3Arules%3Ademo%3A2018%3A16%3A45 -- Ditto, but with built-in Reasoning & Inference by initializing inference rule identified by . Links: [1] http://kidehen.blogspot.com/2014/02/class-equivalence-based-reasoning.html -- Built-In Reasoning & Inference using Class Equivalence Semantics [2] https://www.linkedin.com/pulse/simple-sparql-based-query-reasoning-inference-example-idehen/ -- Built-In Reasoning & Inference using British Royal Family relationship types [3] https://www.linkedin.com/pulse/reasoning-inference-using-british-royal-family-part-idehen/ -- Custom Reasoning & Inference (leveraging SPARQL as Rules Language via SPIN Vocabulary terms) a using British Royal Family relationship types -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Virtuoso SPARQL tab separated results with language tags and dataypes
On 8/22/18 11:43 AM, Peter F. Patel-Schneider wrote: > Try > > curl http://dbpedia.org/sparql --get --header "Accept: > text/tab-separated-values" --data-urlencode query@- < select * where { <http://dbpedia.org/resource/31_June> ?p ?o } > EOF > > Note that Work/runtime doesn't have a datatype and the labels don't have a > language tag even though https://www.w3.org/TR/sparql11-results-csv-tsv/#tsv > requires them. As well, IRIs are enclosed in "" instead of <>. > > Then try the same query on the web interface at https://dbpedia.org/sparql. > There the datatypes and languages tags do show up. However, there are some > langStrings without language tags there. > > > I'm also running into the same problem with a locally installed Virtuoso open > source 7.2.5. > > peter HTML-based SPARQL Results doc: http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org=select+distinct+%3Flabel+lang%28%3Flabel%29+as+%3FlangTag%0D%0A+where+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F31_June%3E+rdfs%3Alabel+%3Flabel+%7D=text%2Fhtm=3 CSV-based SPARQL Results doc: http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org=select+distinct+%3Flabel+lang%28%3Flabel%29+as+%3FlangTag%0D%0A+where+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F31_June%3E+rdfs%3Alabel+%3Flabel+%7D=text%2Fcsv=3 I believe that demonstrates the problem re missing lang tags in the CSV output, right? -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Virtuoso SPARQL tab separated results with language tags and dataypes
On 8/22/18 10:24 AM, Peter F. Patel-Schneider wrote: > I was hoping to be able to get the SPARQL TSV results format in > https://www.w3.org/TR/sparql11-results-csv-tsv/ > > I can probably limp along with explicit language tags and datatypes but that's > a pain to process. > > peter Hi Peter, Please share a SPARQL Query Results doc URI that illustrates your problem. Then, if fixable, we can reply in kind with a URI that demonstrates the fix. -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Virtuoso SPARQL tab separated results with language tags and dataypes
On 8/22/18 12:01 PM, Peter F. Patel-Schneider wrote: > More or less, except that CSV output doesn't include language tags and doesn't > provide facilities for anything other than numeric and string literal values. > TSV format, on the other hand, does include language tags (shown explicitly in > an example) and datatypes (implied by wording in several places, particularly > "The SPARQL Results TSV Results Format does encode the details of RDF terms in > the results table by using the syntax that SPARQL [SPARQL11-QUERY] and Turtle > [TURTLE] use. An application receiving a TSV-encoded results set can split > each line into elements of the result row, and extract all the details it > wishes to process of the RDF terms by simple string processing, without a > complete XML or JSON parser required by the more complex SPARQL result > formats.). > > So it's not a problem with the CSV output but instead with the TSV output. > > (I would be happy to have a variant of CSV that included language tags and > datatypes, but conforming to the requirements of TSV output would be better.) > > peter Okay, so the following shows the problem, right? http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org=select+distinct+%3Flabel+lang%28%3Flabel%29+as+%3FlangTag%0D%0A+where+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F31_June%3E+rdfs%3Alabel+%3Flabel+%7D=text%2Ftab-separated-values=3 I am purposely using doc URIs as this helps the entire problem confirmation and resolution cycle. Kingsley > > > On 08/22/2018 08:51 AM, Kingsley Idehen wrote: >> On 8/22/18 11:43 AM, Peter F. Patel-Schneider wrote: >>> Try >>> >>> curl http://dbpedia.org/sparql --get --header "Accept: >>> text/tab-separated-values" --data-urlencode query@- <>> select * where { <http://dbpedia.org/resource/31_June> ?p ?o } >>> EOF >>> >>> Note that Work/runtime doesn't have a datatype and the labels don't have a >>> language tag even though https://www.w3.org/TR/sparql11-results-csv-tsv/#tsv >>> requires them. As well, IRIs are enclosed in "" instead of <>. >>> >>> Then try the same query on the web interface at https://dbpedia.org/sparql. >>> There the datatypes and languages tags do show up. However, there are some >>> langStrings without language tags there. >>> >>> >>> I'm also running into the same problem with a locally installed Virtuoso >>> open >>> source 7.2.5. >>> >>> peter >> >> HTML-based SPARQL Results doc: >> >> http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org=select+distinct+%3Flabel+lang%28%3Flabel%29+as+%3FlangTag%0D%0A+where+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F31_June%3E+rdfs%3Alabel+%3Flabel+%7D=text%2Fhtm=3 >> >> CSV-based SPARQL Results doc: >> >> http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org=select+distinct+%3Flabel+lang%28%3Flabel%29+as+%3FlangTag%0D%0A+where+%7B+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F31_June%3E+rdfs%3Alabel+%3Flabel+%7D=text%2Fcsv=3 >> >> >> I believe that demonstrates the problem re missing lang tags in the CSV >> output, right? >> >> -- >> 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/public_home/kidehen/profile.ttl#i >> : >> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this >> > -- > 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 > -- 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://
Re: [Virtuoso-users] Query optimization, possible indexing?
On 1/22/18 5:11 PM, Jason Koh wrote: > Hi there, > > I am trying to use Virtuoso for metadata of city-scale sensor > database. (metroinsight.io <http://metroinsight.io>). > > I wonder if there is a way to optimize certain SPARQL query pattern. I > often query this: > ```sparql > select ?s where { > ?s base:name ex:mySensor1 . > } > ``` > > I could optimize it by caching those with Redis or else, but I wonder > if I can force indexing "name" properties in Virtuoso. > > Thank you! > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> Have you looked at text indexing in Virtuoso with regards to SPARQL? [1] http://docs.openlinksw.com/virtuoso/rdfsparqlrulefulltext/ . -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] Inference support?
On 2/23/18 7:45 PM, Jason Koh wrote: > Hi Kingsley, > > I did the same thing for my schema but it didn't work, I will debug it > more. > > btw, what does p_score_init (); do? I receive when I run it: > ``` > Error 42001: [Virtuoso Driver][Virtuoso Server]SR185: Undefined > procedure DB.DBA.p_score_init. > at line 5 of Top-Level: > ``` > > I use Virtuoso 7.2.4.2. > > Thanks! > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> Oops, that was a cut and paste error. That procedure isn't relevant to this kind of built-in reasoning and inference. > > On Fri, Feb 23, 2018 at 1:56 PM, Kingsley Idehen > <kide...@openlinksw.com <mailto:kide...@openlinksw.com>> wrote: > > On 2/22/18 10:33 PM, Jason Koh wrote: >> Just to provide my use case, >> >> I presumed if there is a graph like >> >> ```turtle >> ex:a rdf:type sch:Class1 . >> sch:Class1 owl:equivalentClass sch:Class2 . >> ``` >> . a query like this should work >> ```sparql >> select ?s where { >> ?s rdf:type sch:Class2 . >> } >> ``` >> >> Yes, if you have mapped a built-in inference rule to the named graph that contains you owl:equivalenClass statements. As per my example, map the rule to a graph containing owl:equivalentClass statements, and then reference rule using pragma in your sparql query, to invoke built-in reasoning and inference context. In my example: Graph IRI: <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl> <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl> Rule Mapping to Named Graph: rdfs_rule_set ('urn:equivalent:class:inference:rules:demo:2018:16:45', 'http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl>') Invocation Pragma usage example : DEFINE input:inference 'urn:equivalent:class:inference:rules:demo:2018:16:45' What's missing from my initial response is that you should also load owl:ontology into your named graph, so in my case I would: SPARQL APPEND <http://www.w3.org/2002/07/owl#> TO <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl>> . I didn't state that earlier because my named graph <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl>> also contains triples from <http://www.w3.org/2002/07/owl#> that describe the nature of owl:equivalentClass relations. That's the problem you are having, following my initial response verbatim :) Kingsley > >> On Thu, Feb 22, 2018 at 5:33 PM, Jason Koh <jb...@eng.ucsd.edu >> <mailto:jb...@eng.ucsd.edu>> wrote: >> >> Hi, >> >> I would like to exploit OWL/RDFS inferences like >> here: >> https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtSPARQLReasoningTutorial#Step >> >> <https://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtSPARQLReasoningTutorial#Step> >> 6.: SPARQL Inference Queries >> >> 1. However, I can't find the "define rules" for >> owl:equivalentClass as mentioned >> here: >> http://docs.openlinksw.com/virtuoso/virtuosotipsandtricksrdfschowlinfrl/ >> >> <http://docs.openlinksw.com/virtuoso/virtuosotipsandtricksrdfschowlinfrl/>. >> >> What is the exact keyword to use owl:equivalentClass like >> ``DEFINE input:same-as "yes"``? >> >> >> 2. And if I use inference instead of transitive search like >> ``rel:ancestorOf+``, is it faster? >> >> Thank you! >> >> >> With regards, >> Jason Koh >> cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> >> > Steps: > > SQL> sparql define get:soft "no-sponge" load > > <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl> > > <http://www.openlinksw.com/data/turtle/ontology_mappings/schemas_mappings/SchemaOrgToOpenLink.ttl> > ; > > Done. -- 6146 msec. > SQL> rdfs_rule_set > ('urn:equivalent:class:inference:rules:demo:2018:16:45', >
Re: [Virtuoso-users] RDF4J's SAIL support? (or direct SHACL?)
On 2/23/18 7:56 PM, Jason Koh wrote: > Hi there, > > RDF4J SAIL is pushing a charming feature supporting SHACL, but I found > that SAILRepository is incompatible with > Virtuoso: https://groups.google.com/forum/#!topic/rdf4j-users/TcGqG3915jc > <https://groups.google.com/forum/#%21topic/rdf4j-users/TcGqG3915jc> > > Is there any plan to update Virtuoso-RDF4J to include SAIL? Otherwise, > is there any plan for direct support of SHACL? > > Thank you! > > > With regards, > Jason Koh > cseweb.ucsd.edu/~jbkoh <http://cseweb.ucsd.edu/%7Ejbkoh> See this post regarding Custom Reasoning and Inference re. RDF4j. As for SHACL, we are going to tweak our SPIN-vocabulary based reasoning to accommodate terms from SHACL-vocabulary. Note, Custom Reasoning & Inference is a commercial edition feature. You can obtain this edition on a Free Evaluation basis. Kingsley > > > -- > 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 -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature -- 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] remove graph limitations on /describe/ service in FCT ?
On 9/27/18 1:50 PM, Hugh Williams wrote: > Hi Thomas, > > I am going to open up this question on our community discussion forum at: > > https://community.openlinksw.com > > so that you and others benefit from the answer, thus can be please > register and post the question there.Hi Thomas, I see an answer has already been posted [1]. On a general note, we are encouraging the use of our new community discussion space due to the fact that it provides a better forum for: [1] Answer Creation [2] Answer Publication that leverages Web as a search and query friendly Knowledge Graph Links: [1] https://community.openlinksw.com/t/faceted-browser-not-listing-all-resources-on-page-description/93 . -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] URI html views, similar to dbpedia
On 11/14/18 5:02 AM, Conor Sheehan wrote: > Hi all, > > I'm new to virtuoso. I have a sparql enpoint I'd like to add html > views to. > What I mean is that when I run a query I get a table of URIs, but none > of them resolve to a webpage. I get > > > Error HTTP/1.1 404 File not found > > The requested URL was not foundURI = '/place/411' > All dbpedia URIs resolve to html page, and I'd like my endpoint to > behave the same way. > > Can this be done in virtuoso itself? > Or do I need to install the facet browser? > Or some other third party tool? > > Thanks in advance, > Conor > Hi Conor, Due to the fact that this resolution to this question would benefit a broad audience of Virtuoso users, and the fact that resolution would be a useful knowledgebase entry for future recall, would you be okay opening up a topic for this matter in our new community discussion forum [1] ? Benefits? Broader audience for problem resolution thereby reducing response time :) Links: [1] https://community.openlinksw.com/c/rdbms/linked-data-deployment -- just click to open a topic in under this category -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Can't create ldp:Resource from Turtle file
On 9/19/18 8:39 AM, Mark Wilkinson UPM wrote: > Hi all, > > I'm following the instructions at > http://vos.openlinksw.com/owiki/wiki/VOS/VirtLDP and am not having > much joy. (Virtuoso 7.20) > > > A few things: > > > in Conductor, steps 3 and 4 of "enable LDP on folder" - the > screenshots don't match what I see. I have an additional checkbox for > "LDP enable/disable" (which I have set to "on"). I am unable to set > properties LDP = ldp:BasicContainer as indicated in the instructions. > The LDP property is not in the dropdown list, and if I type it > manually and press "update" it doesn't stick - it isn't there the next > time I look at the properties. I'm guessing that it is working (??) > because I can create LDP containers as expected... but it's > disconcerting. > > I am, however, unable to create an ldp:Resource from a turtle file. > Every Turtle file I try to send (Content-type: text/turtle) fails with > a HTTP 500: SP029: TURTLE RDF loader, line 1: syntax error (both PUT > and POST). > > (There is no syntax error in my turtle file - I have tried with > several, including sample files from W3C) > > I am able to create an ldp:Resource that is plaintext (Content-type: > text/plain header), and the container correctly gets the additional > "contains" property, so that seems to be working well! > > Any advice on creating RDF resources? > > > Thanks! > > Mark Hi Mark, You need to install the ODS-Framework [1] and ODS-Briefcase [2] modules atop your Virtuoso instance. Net effect, it adds an LDP layer to the Virtuoso WebDAV core. Once installed, you can simply perform the following verification tests. Setup verification tests: 1. curl -X OPTIONS -IH "Accept: text/turtle" {URI-of-LDP-Folder} 2. curl -iH "Accept: text/turtle" {URI-of-LDP-Folder} If the above is successful, you can perform some based read-write tests: JSON-LD: curl --cert {pkcs#12-file}.p12:1234 --cert-type P12 -X POST -H 'Content-Type: application/ld+json' \ -d '[{"@id":"","http://schema.org/name":"Foo"}]' {URI-of-LDP-Folder}/test.jsonld RDF-Turtle: curl --cert {pkcs#12-file}.p12:1234 --cert-type P12 -X POST -H'Content-Type: text/turtle' \ -d '<#this> <#relatedTo> <#that> .' {URI-of-LDP-Folder}/test.ttl Links: [1] http://download3.openlinksw.com/uda/vad-packages/7.2/ods_framework_dav.vad [2] http://download3.openlinksw.com/uda/vad-packages/7.2/ods_briefcase_dav.vad [3] https://medium.com/virtuoso-blog/http-read-write-operations-using-ldp-protocols-virtuoso-http-s-server-bdaa2736169f -- Post about LDP & Virtuoso . -- 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Can't create ldp:Resource from Turtle file
On 9/20/18 3:28 AM, Mark Wilkinson UPM wrote: > After installing the packages via Conductor upload, and confirming > that ods is now an option (the interface is now available) I'm still > hitting problems. > > I can start "briefcase", and see folders that belong to me (dav user - > logged-in); however,I cannot interact with them. I just get thrown > back to the ODS login page (even though I am logged-in!), which then > rejects my dav username and password. > > If I simply attempt to interact with (via LDP curl calls) the Public > or RDFData folders within the dav folder, I still get the turtle > parser error that I initially reported. > > So... I'm not making a lot of progress. > > Suggestions? > > Mark You don't really need to take the ODS-Briefcase route into this LDP/WebDAV realm. You can also get their via the Conductor. Thus, when you get in via the Conductor UI ("Content Management" menu item) do you see the "enable LDP" button associated with the property lookup on a folder? Kingsley > > > > > On 09/19/2018 05:01 PM, Patrick van Kleef wrote: >> All, >> >> >>> You need to install the ODS-Framework [1] and ODS-Briefcase [2] >>> modules >>> atop your Virtuoso instance. Net effect, it adds an LDP layer to the >>> Virtuoso WebDAV core. >>> >>> Once installed, you can simply perform the following verification >>> tests. >>> >>> Setup verification tests: >>> >>> >>> 1. curl -X OPTIONS -IH "Accept: text/turtle" {URI-of-LDP-Folder} >>> >>> 2. curl -iH "Accept: text/turtle" {URI-of-LDP-Folder} >>> >>> If the above is successful, you can perform some based read-write >>> tests: >>> >>> JSON-LD: >>> >>> curl --cert {pkcs#12-file}.p12:1234 --cert-type P12 -X POST -H >>> 'Content-Type: application/ld+json' \ >>> -d '[{"@id":"","http://schema.org/name":"Foo"}]' >>> {URI-of-LDP-Folder}/test.jsonld >>> >>> >>> RDF-Turtle: >>> >>> curl --cert {pkcs#12-file}.p12:1234 --cert-type P12 -X POST >>> -H'Content-Type: text/turtle' \ >>> -d '<#this> <#relatedTo> <#that> .' {URI-of-LDP-Folder}/test.ttl >>> >>> >> VOS requires a different version of the ODS packages in order to work: >> >> >>> Links: >>> >>> [1] >>> http://download3.openlinksw.com/uda/vad-packages/7.2/ods_framework_dav.vad >>> >>> >> http://download3.openlinksw.com/uda/vad-vos-packages/7.2/ods_framework_dav.vad >> >> >>> [2] >>> http://download3.openlinksw.com/uda/vad-packages/7.2/ods_briefcase_dav.vad >>> >> http://download3.openlinksw.com/uda/vad-vos-packages/7.2/ods_briefcase_dav.vad >> >> >> >> Patrick >> --- >> Patrick van Kleef >> Program Manager >> OpenLink Software >> >> http://www.openlinksw.com/ >> http://twitter.com/openlink/ >> >> >> >> ___ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> > -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Can't create ldp:Resource from Turtle file
On 9/20/18 8:23 AM, Mark Wilkinson UPM wrote: > curl --cert {pkcs#12-file}.p12:1234 --cert-type P12 -X POST > -H'Content-Type: text/turtle' \ > -d '<#this> <#relatedTo> <#that> .' {URI-of-LDP-Folder}/test.ttl You mean the following fails? curl --cert {pkcs#12-file}.p12:1234 --cert-type P12 -X POST -H'Content-Type: text/turtle' \ -d '<#this> <#relatedTo> <#that> .' {URI-of-LDP-Folder}/test.ttl If so, please run the following command and then try again: WEBDAV.DBA.ldp_recovery_aq ('/DAV/{ldp-enabled-folder}') If that procedure doesn't exist, please create it by running the following via iSQL UI in the Conductor: CREATE PROCEDURE ldp_recov (in fld varchar) { DECLARE id int; DECLARE path any; id := DAV_SEARCH_ID (fld, 'C'); IF (NOT LDP_ENABLED (id)) RETURN; FOR SELECT COL_NAME FROM WS.WS.SYS_DAV_COL WHERE COL_ID = id DO { DECLARE s, uri, path any; uri := WS.WS.DAV_IRI (fld); TTLP ('@prefix ldp: <http://www.w3.org/ns/ldp#> . <> a ldp:BasicContainer, ldp:Container .', uri, uri); FOR SELECT RES_CONTENT, RES_FULL_PATH FROM WS.WS.SYS_DAV_RES WHERE RES_COL = id AND RES_TYPE = 'text/turtle' DO { DECLARE ruri any; ruri := WS.WS.DAV_IRI (RES_FULL_PATH); TTLP (sprintf ('<%s> <http://www.w3.org/ns/ldp#contains> <%s> .', uri, ruri), uri, uri); { DECLARE continue handler for sqlstate '*'; TTLP (CAST (RES_CONTENT as varchar), ruri, ruri, 255); } } FOR SELECT COL_NAME FROM WS.WS.SYS_DAV_COL WHERE COL_PARENT = id AND COL_DET IS NULL DO { DECLARE ruri any; path := fld || COL_NAME || '/'; ruri := WS.WS.DAV_IRI (path); TTLP (sprintf ('<%s> <http://www.w3.org/ns/ldp#contains> <%s> .', uri, ruri), uri, uri); } } FOR SELECT COL_NAME FROM WS.WS.SYS_DAV_COL WHERE COL_PARENT = id AND COL_DET IS NULL DO { path := fld || COL_NAME || '/'; ldp_recov (path); } }; -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] On Linked Data Views
On 12/19/18 9:17 AM, Pasquale Di Donato wrote: > Hi all, > > I'd like to provide RDF on top of external relational tables (in > Postgresql). > So i guess i will have to use linked data views (and Virtuoso > commercial edition): am i right? > > Are the linked data views dynamically synchronized with the relational > database? I mean if something is changed in the (external) relational > database, are these changes automatically available as RDF (via the > views)? > > And can I configure more than 1 view? > > Any input will be appreciated, > Many thanks, > > Pasquale Hi Pasquale, This is a very important post. Would you be kind enough to open it up as a topic in our new community discussion space [1] ? I (or someone else) will answer it via the discussion topic category created for this matter [2] :) Links: [1] https://community.openlinksw.com/ [2] https://community.openlinksw.com/t/about-the-rdf-views-over-sql-data-sources-category/482 -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Support for literal as subjects/Relative URI support
On 2/4/19 11:20 PM, pranav.puri via Virtuoso-users wrote: > Hi, > > I am using Virtuoso opensource V07.20.3217.I am trying to ingest yago > dataset into virtuoso .But I am unable to.. > > I am using DB.DBA.TTLP_MT on isql. > > Error: Virtuoso does not support literal subjects > > Is it due to the relative URI yago dataset has? How can we handle > relative URI in virtuoso ? > > regards > Pranav > > > > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > RDF doesn't support literal objects, neither does Virtuoso. Are you sure that you are dealing with literal relation subjects? Relative URIs are not literal subjects. -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Editing forms based on RDF/OWL classes?
On 1/25/19 9:50 AM, Peter Lawrence wrote: > I have created an OData2SPARQL proxy server that publishes any RDF > model as an OData service > (http://inova8.com/bg_inova8.com/offerings/odata2sparql/) . That > service can then be consumed via many HTML/JavaScript frameworks. I > prefer to use OpenUI5 (https://openui5.org/) but there are many > others. This combination then allows full round trip viewing and > editing of the RDF. (https://www.youtube.com/watch?v=QFhcsS8Bx-U). > > *Peter J. Lawrence* > _inova8_ > /*Providing answers for users' information questions*/ > *Mobile:* +44 7546 095977 | +1 330 631 3772 | *Phone:*+44 1298 > 872375 |*Skype:* PeterJLawrence > *Email:* peter.lawre...@inova8.com > <mailto:peter.lawre...@inova8.com> | *Web:*www.inova8.com > <http://www.inova8.com> > *LinkedIn: *_http://www.linkedin.com/in/peterjohnlawrence > _ > > > On Fri, 25 Jan 2019 at 14:21, Pantelis Natsiavas <mailto:natsia...@gmail.com>> wrote: > > I am looking for an RDF/OWL based Domain Driven Development (DDD) > framework. > > I have an OWL ontology used as a TBox model uploaded on my > Virtuoso (open source edition) and I want to build CRUD > (create-retrieve-update-delete) forms upon my classes defined in > the TBox. For example, for classes “Student” and “Teacher” I would > like to create two forms allowing me to > create-retrieve-update-delete their instances (and of course their > property values) using a simple User Interface (UI). > > If nobody could suggest a solution working out of the box, I was > thinking that perhaps I could use a data access library for > virtuoso (e.g. ADO NET/Entity Framework or JDBC/Hibernate) to get > my *RDF/OWL classes as entities*, and then use .NET or Java based > Rapid Application Development (RAD) frameworks based on the > produced entities. I have seen similar approaches on relevant > (quite outdated) tutorials (tutorial1 > <http://vos.openlinksw.com/owiki/wiki/VOS/VirtRDFODataExample> and > tutorial2 > > <http://vos.openlinksw.com/owiki/wiki/VOS/VirtUsingMsAdoNetDataServicesWithVirtuoso>) > > My questions: > > 1. Could anyone propose a specific software stack following this > rationale of DDD upon RDF/OWL classes? > 2. I can only find examples using rather old versions of Visual > Studio. Are the ADO NET and JDBCconnectors stable and updated? > Can they be used with recent versions of .NET/java development > stack? > 3.Is my assumption (i.e. that I could produce .NET or > Java *entities corresponding to my RDF/OWL classes* via ADO > NET or Hibernate) valid? > > Best regards, > Pantelis Natsiavas > > PS. I have also posted the same question in the community forum > > <https://community.openlinksw.com/t/editing-forms-based-on-rdf-owl-classes/615> > because > it is not clear to me whether this email list is active or not. > Sorry for double posting. > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > <mailto: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 Hi Peter, I would very much like to get this OData->SPARQL bridge working so that it can be widely promoted. A few questions: 1. How does it handle protected SPARQL Endpoints? 2. Do you have a live demo instance anywhere ? -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Editing forms based on RDF/OWL classes?
On 1/25/19 9:20 AM, Pantelis Natsiavas wrote: > > I am looking for an RDF/OWL based Domain Driven Development (DDD) > framework. > > I have an OWL ontology used as a TBox model uploaded on my Virtuoso > (open source edition) and I want to build CRUD > (create-retrieve-update-delete) forms upon my classes defined in the > TBox. For example, for classes “Student” and “Teacher” I would like to > create two forms allowing me to create-retrieve-update-delete their > instances (and of course their property values) using a simple User > Interface (UI). > > If nobody could suggest a solution working out of the box, I was > thinking that perhaps I could use a data access library for virtuoso > (e.g. ADO NET/Entity Framework or JDBC/Hibernate) to get my *RDF/OWL > classes as entities*, and then use .NET or Java based Rapid > Application Development (RAD) frameworks based on the produced > entities. I have seen similar approaches on relevant (quite outdated) > tutorials (tutorial1 > <http://vos.openlinksw.com/owiki/wiki/VOS/VirtRDFODataExample> and tutorial2 > <http://vos.openlinksw.com/owiki/wiki/VOS/VirtUsingMsAdoNetDataServicesWithVirtuoso>) > > My questions: > > 1. Could anyone propose a specific software stack following this > rationale of DDD upon RDF/OWL classes? > 2. I can only find examples using rather old versions of Visual > Studio. Are the ADO NET and JDBCconnectors stable and updated? Can > they be used with recent versions of .NET/java development stack? > 3.Is my assumption (i.e. that I could produce .NET or > Java *entities corresponding to my RDF/OWL classes* via ADO NET or > Hibernate) valid? > > Best regards, > Pantelis Natsiavas > > PS. I have also posted the same question in the community forum > <https://community.openlinksw.com/t/editing-forms-based-on-rdf-owl-classes/615> > because > it is not clear to me whether this email list is active or not. Sorry > for double posting. > > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users Hi Pantelis Natsiavas, A reply has been posted to our community forum [1], which is our preferred space for handling matters like this going forward :) Link: [1] https://community.openlinksw.com/t/editing-forms-based-on-rdf-owl-classes/615/2 -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] I want to know how much memory of virtuoso can be reduced.
On 6/13/19 10:13 PM, sagawa_e...@fujitsu.com wrote: > I want to downsize the memory of virutoso. I want to know how much memory of > virtuoso can be reduced. > 私はvirutosoのメモリのダウンサイジングを行いたい。私はvirtuosoのメモリをどこまで縮小できるのかを知りたい。 > > I know that the memory is reserved as per the NumberOfBuffer value. (I saw > with ps command.) > 私はNumberOfBuffer値の通りにメモリが確保されていることは知っている。 (私はpsコマンドで見た。) > > However, I do not know what data is loaded on virtuoso's memory and whether > it is fully used. > しかし、virtuosoのメモリ上にどのようなデータがロードしているのか、そしてフルに使われているのかが分からない。 Hi Eiji, > > > [私の質問] > [My questions] > > 1. I want to know how to find out what data is currently deployed in > virtuoso's memory. > 1. 現在どのデータがどれくらいvirtuosoのメモリに展開されているかが把握できる手段を知りたい。 The data in the database is ultimately in memory, subject to the memory you allocated via buffer settings in the virtuoso.ini file. > > 2. I want to know how to check the usage status of the memory area secured > by virtuoso. > 2. virtuosoが確保したメモリ領域の利用状況を確認する手段を知りたい。 You can use commands like top and ps commands for that, during the progression of your usage from initial startup to warm up stage etc.. > > 3. Besides caching by search execution, I would like to confirm the method > if there is a method to expand arbitrary data in virtuoso's memory beforehand. > 3. 検索実行によるキャッシュ以外に、予め任意のデータをvirtuosoのメモリへ展開する方法があればその手段を確認したい。 You do that via buffers settings. There is also a publicly available Google Spreadsheet about variety Virtuoso instance that could also be of help here. Links [1] https://docs.google.com/spreadsheets/d/1-stlTC_WJmMU3xA_NxA1tSLHw6_sbpjff-5OITtrbFw/edit [2] https://community.openlinksw.com/ -- our active community forum for additional assistance Kingsley > > > > [About server environment] > [サーバ環境について] > > Physical/Virtual Type : Virtual machine > 物理/仮想種別:仮想マシン > > Operating System:CentOS 7.3 (64bit) > > Number of processors : 10 > プロセッサー数:10 > > OS installed memory : 512GB > OS搭載メモリ:512 GB > > Data file (virtuoso.db) size : 680GB > データファイル(virtuoso.db)サイズ : 680GB > > > [Other] > [その他] > I changed the NumberOfBuffer and MaxDirtyBuffers values in virutoso.ini and > measured the search speed. > 私はvirutoso.iniのNumberOfBuffer値およびMaxDirtyBuffers値を変えて検索速度を測定した。 > > I ran several different searches. The first search has a response from 21 > seconds to 29 seconds. > 私は数回の異なる検索を実行した。検索1回目は21秒〜29秒でレスポンスがある。 > > The second and subsequent search responses were less than one second. > 2回目以降の検索レスポンスはいづれの場合も1秒未満であった。 > > Search speed did not improve even if the NumberOfBuffer and MaxDirtyBuffers > values were high. > NumberOfBuffer値およびMaxDirtyBuffers値が大きくても、検索速度は向上しなかった。 > > Even if virtuoso reserves memory, is it not loading data at first? > virtuosoはメモリを確保していても、最初はデータをロードしていない? > > > よろしくお願い致します。 > Best regards, > Eiji Sagawa > > > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] CREATE GRAPH command returns error "Error 37000: [Virtuoso Driver][Virtuoso Server]SQ074: Line 1:"
On 6/12/19 1:38 AM, Allan Kamau wrote: > I am trying to load data into Virtuoso server. I order to do so I > assume I first need to construct a graph into which to load the data. > I have configured a password for the dba user, then logged in as user > dba using isql application. > When I issue a command such as the one below, I am presented with the > error message "Error 37000: [Virtuoso Driver][Virtuoso Server]SQ074: > Line 1:" > > CREATE GRAPH ; > > What could I be doing wrong? > > Essentially I have several RDF/XML graph data files that I would like > to load into Virtuoso. > Each data file contains data from one row of a CSV spreadsheet. > All the data belongs to a single dataset hence I assume these data > should be uploaded into a common "graph". > > Allan. Hi Allan, In this situation, you would load data into Virtuoso from RDF datasets using the Bulk Loader [1]. BTW -- we have a Community Forum [2] where you questions would be exposed to a broader pool of Virtuoso users :) [1] http://vos.openlinksw.com/owiki/wiki/VOS/VirtBulkRDFLoader -- Bulk Loading RDF document content into Virtuoso [2] https://community.openlinksw.com Kingsley > > > > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] Executing commands from file via isql
On 7/3/19 10:31 AM, Allan Kamau wrote: > I am trying to execute some GRANT commands and an UPDATE command to > change the WS.WS.SYS_DAV_USER from a file using isql. > > The command I have looks something like this. > > isql -S -U dba -P dba /path/to/some/file.sql; > > When I execute the above it seems the file (and its contents) are > ignored and I get the SQL>prompt. > > > Is there a switch I may have left out. > Somehow it seems this simple exercise has taken me hours so far to debug. > > In short is there a way I can execute SQL command from a file the same > way I could execute commands from PostgreSQL using psql? > > > > Allan. > > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users Allan, Our iSQL command allows you to execute statements via a file. isql dba dba VERBOSE=OFF 'EXEC=status()' test.sql test2.sql -i arg1 arg2 I would strongly encourage you to use our community forum [2] for posts like this since it has the dual benefits of exposing your questions to other Virtuoso users while also encouraging crowd-support :) Links: [1] http://docs.openlinksw.com/virtuoso/invokingisql/ [2] https://community.openlinksw.com/ -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] federated query over VAL secured endpoints
On 6/27/19 1:26 AM, 宗像善久 wrote: > Hi, > > Is it possible to execute federated query over OpenID connect > authenticated > VAL secured SPARQL endpoints ? (VAL:Virtuoso Authentication Layer) > Is someone know the detailed relation between the virtuoso authentication > mechanism and the virtuoso implementation specification about > federated query? > > I'd appreciate it if you let me know. > > Thanks in advance, > > > > > > ___ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users Not at the current time, without custom development i.e., implementing OpenID Connect as part of the SPARQL-FED implementation. -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
Re: [Virtuoso-users] How can I list granted privileges in Virtuoso?
On 10/17/19 1:03 AM, Allan Kamau wrote: > Is there a "SHOW PRIVILEGES" command on Virtuoso by which I may better > understand the issue below? > > I have a Virtuoso installation for which I am unable to clear the > graph I constructed. The error message is show below > > "Virtuoso 42000 Error SR186:SECURITY: No permission to execute > procedure DB.DBA.SPARUL_CLEAR with user ID 107, group ID 107" > > Below is the command I issued. > > ###clear the graph (start) > sqarql_query=" > CLEAR GRAPH 'http://abc.somethere.com' > " \ > && time curl \ > --user dba:secret \ > -X POST "http://xyz.somewhere.com:8891/sparql; \ > -H "Content-Type: application/x-www-form-urlencoded" \ > -H "Accept:application/sparql-results+json" \ > --data-urlencode 'format=json' --data-urlencode > 'default-graph-uri=http://abc.somethere.com' \ > --data-urlencode "query=${sqarql_query}" \ > --write-out > '%{url_effective};%{http_code};%{time_total};%{time_namelookup};%{time_connect};%{size_download};%{speed_download}\n' > \ > ;date; > ###clear the graph (end) Allan, Due to the nature of this kind of issue and it broader benefits to others, would you be able to move this question over to our community forum? l1]. [1] https://community.openlinksw.com/c/rdbms . -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com 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/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this smime.p7s Description: S/MIME Cryptographic Signature ___ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users