This HTML5 document contains 34 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

PrefixNamespace IRI
dctermshttp://purl.org/dc/terms/
n9http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtRDFDatasetDump/sioc.
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n5http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n19http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n4http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n6http://rdfs.org/sioc/services#
n15http://vos.openlinksw.com/dataspace/person/dav#
siocthttp://rdfs.org/sioc/types#
n11http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n17http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n14http://vos.openlinksw.com/dataspace/person/owiki#
n16http://daas.openlinksw.com/data#
siochttp://rdfs.org/sioc/ns#
Subject Item
n15:this
foaf:made
n2:VirtRDFDatasetDump
Subject Item
n4:this
sioc:creator_of
n2:VirtRDFDatasetDump
Subject Item
n5:item
n6:services_of
n2:VirtRDFDatasetDump
Subject Item
n17:this
sioc:creator_of
n2:VirtRDFDatasetDump
Subject Item
n11:VOS
sioc:container_of
n2:VirtRDFDatasetDump
atom:entry
n2:VirtRDFDatasetDump
atom:contains
n2:VirtRDFDatasetDump
Subject Item
n2:VOSIndex
sioc:links_to
n2:VirtRDFDatasetDump
Subject Item
n2:VirtRDFDatasetDump
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T05:42:03.494338
dcterms:modified
2020-02-24T08:20:50.942755
rdfs:label
VirtRDFDatasetDump
foaf:maker
n14:this n15:this
dc:title
VirtRDFDatasetDump
opl:isDescribedUsing
n9:rdf
sioc:has_creator
n4:this n17:this
sioc:content
%META:TOPICPARENT{name="VOSIndex"}% ---+ Producing RDF dumps from the Virtuoso Triple-/Quad-Store %TOC% ---++What? How to export RDF model data from Virtuoso's Quad Store. ---++Why? Every DBMS needs to offer a mechanism for bulk export and import of data. Virtuoso supports dumping and reloading graph model data (e.g., RDF), as well as relational data (e.g., SQL) (discussed elsewhere). ---++ How? We have created stored procedures for the task. The dump procedures leverage SPARQL to facilitate selective data dump(s) from one or more Named Graphs, each denoted by an IRI. ---+++ Dump One Graph The procedure <b><code><nowiki>dump_one_graph</nowiki></code></b> can be used to dump any single Named Graph. ---++++ Parameters * <code>IN <b>srcgraph</b> VARCHAR</code> -- source graph * <code>IN <b>out_file</b> VARCHAR</code> -- output file * <code>IN <b><nowiki>file_length_limit</nowiki></b> INTEGER</code> -- maximum length of dump files ---++++ Procedure source <verbatim> CREATE PROCEDURE dump_one_graph ( IN srcgraph VARCHAR , IN out_file VARCHAR , IN file_length_limit INTEGER := 1000000000 ) { DECLARE file_name VARCHAR; DECLARE env, ses ANY; DECLARE ses_len , max_ses_len , file_len , file_idx INTEGER; SET ISOLATION = 'uncommitted'; max_ses_len := 10000000; file_len := 0; file_idx := 1; file_name := sprintf ('%s%06d.ttl', out_file, file_idx); string_to_file ( file_name || '.graph', srcgraph, -2 ); string_to_file ( file_name, sprintf ( '# Dump of graph <%s>, as of %s\n@base <> .\n', srcgraph, CAST (NOW() AS VARCHAR) ), -2 ); env := vector (dict_new (16000), 0, '', '', '', 0, 0, 0, 0, 0); ses := string_output (); FOR (SELECT * FROM ( SPARQL DEFINE input:storage "" SELECT ?s ?p ?o { GRAPH `iri(?:srcgraph)` { ?s ?p ?o } } ) AS sub OPTION (LOOP)) DO { http_ttl_triple (env, "s", "p", "o", ses); ses_len := length (ses); IF (ses_len > max_ses_len) { file_len := file_len + ses_len; IF (file_len > file_length_limit) { http (' .\n', ses); string_to_file (file_name, ses, -1); gz_compress_file (file_name, file_name||'.gz'); file_delete (file_name); file_len := 0; file_idx := file_idx + 1; file_name := sprintf ('%s%06d.ttl', out_file, file_idx); string_to_file ( file_name, sprintf ( '# Dump of graph <%s>, as of %s (part %d)\n@base <> .\n', srcgraph, CAST (NOW() AS VARCHAR), file_idx), -2 ); env := VECTOR (dict_new (16000), 0, '', '', '', 0, 0, 0, 0, 0); } ELSE string_to_file (file_name, ses, -1); ses := string_output (); } } IF (LENGTH (ses)) { http (' .\n', ses); string_to_file (file_name, ses, -1); gz_compress_file (file_name, file_name||'.gz'); file_delete (file_name); } } ; </verbatim> To load the procedure into Virtuoso, it can simply be copied and pasted into the Virtuoso "isql" command line tool or Interactive SQL UI of the Conductor and execute. ---++++ Example 1. Call the <code><nowiki><nowiki>dump_one_graph</nowiki></nowiki></code> procedure with appropriate arguments: <verbatim> $ pwd /Applications/OpenLink Virtuoso/Virtuoso 6.1/database $ grep DirsAllowed virtuoso.ini DirsAllowed = ., ../vad, $ /opt/virtuoso/bin/isql 1111 Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL&gt; dump_one_graph ('http://daas.openlinksw.com/data#', './data_', 1000000000); Done. -- 1438 msec. </verbatim> 1. As a result, a dump of the graph &lt;[[http://daas.openlinksw.com/data#][http://daas.openlinksw.com/data#]]&gt; will be found in the files <code>data_XX</code> (located in your Virtuoso db folder): <verbatim> $ ls data_000001.ttl data_000002.ttl .... data_000001.ttl.graph </verbatim> ---+++ Dump Multiple Graphs See the following documentation on [[VirtRDFDumpNQuad][dumping Virtuoso RDF Quad store hosted data into NQuad datasets]]. ---++ Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[VirtRDFDumpNQuad][RDF dumps from Virtuoso Quad store hosted data into NQuad dumps]] * [[http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfdumpandreloadgraphs][Virtuoso Documentation]]
sioc:id
d01dffcce897fdddd348ec65731e1580
sioc:link
n2:VirtRDFDatasetDump
sioc:has_container
n11:VOS
n6:has_services
n5:item
atom:title
VirtRDFDatasetDump
sioc:links_to
n2:VirtRDFDumpNQuad n2:VirtTipsAndTricksGuide n16: n19:rdfperfdumpandreloadgraphs
atom:source
n11:VOS
atom:author
n15:this
atom:published
2017-06-13T05:42:03Z
atom:updated
2020-02-24T08:20:50Z
sioc:topic
n11:VOS