Skip to content

Instantly share code, notes, and snippets.

@asanchez75
Forked from blokhin/virtuoso.isql
Created September 27, 2020 08:11
Show Gist options
  • Save asanchez75/1b84967a2c2e42ea1af791e7286abcd9 to your computer and use it in GitHub Desktop.
Save asanchez75/1b84967a2c2e42ea1af791e7286abcd9 to your computer and use it in GitHub Desktop.
SELECT * FROM sys_rdf_schema;
ld_dir('/data', '*.ttl', 'http://www.example.com/genealogy.owl#');
delete from DB.DBA.load_list where ll_file='/data//einstein.ttl';
SPARQL SELECT (COUNT(DISTINCT ?x) AS ?count) WHERE { ?x ?y ?z };
sparql clear graph <http://www.example.com/genealogy.owl#>;
sparql load <https://github.com/blokhin/genealogical-trees/raw/master/data/header.ttl> into <http://www.example.com/genealogy.owl#>;
rdfs_rule_set('fhkb', 'http://www.example.com/genealogy.owl#');
SPARQL SELECT ?g count(*) as ?count WHERE { GRAPH ?g {?s ?p ?o } } GROUP BY ?g ORDER BY DESC 2;
DB.DBA.RDF_AUDIT_METADATA(2, '*');
select distinct id_to_iri(g) from rdf_quad;
select * from SPARQL_SELECT_KNOWN_GRAPHS_T;
./bin/virtuoso-t -fd -c var/lib/virtuoso/db/virtuoso.ini
./bin/virtuoso-t -c var/lib/virtuoso/db/virtuoso.ini
delete from DB.DBA.load_list;
ld_dir('/data/triples', '%.ttl', 'http://worldmaterials.pro/');
select * from DB.DBA.load_list;
rdf_loader_run();
checkpoint;
rdfs_rule_set('http://worldmaterials.pro/', 'http://worldmaterials.pro/');
SELECT * FROM sys_rdf_schema;
SPARQL DEFINE input:inference <http://worldmaterials.pro/>
SELECT (COUNT(DISTINCT ?x) AS ?count) WHERE { ?x <http://worldmaterials.pro/hasPhysicalProp> ?y };
SPARQL SELECT (COUNT(DISTINCT ?x) AS ?count) WHERE { ?x rdf:ID ?y };
SPARQL SELECT ?x ?p ?y WHERE { ?i rdfs:label ?x ; <http://worldmaterials.pro/hasProp200> ?y . <http://worldmaterials.pro/hasProp200> rdfs:label ?p } LIMIT 20;
sparql clear graph <http://worldmaterials.pro/>;
sparql drop silent graph <http://worldmaterials.pro/>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment