Sophie

Sophie

distrib > Fedora > 14 > x86_64 > media > updates > by-pkgid > 71d40963b505df4524269198e237b3e3 > files > 436

virtuoso-opensource-doc-6.1.4-2.fc14.noarch.rpm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
 <head profile="http://internetalchemy.org/2003/02/profile">
  <link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
  <link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
  <meta name="dc.title" content="Function: DB.DBA.RDF_AUDIT_METADATA - Virtuoso Functions Guide" />
  <meta name="dc.subject" content="Function: DB.DBA.RDF_AUDIT_METADATA - Virtuoso Functions Guide" />
  <meta name="dc.creator" content="OpenLink Software Documentation Team ;&#10;" />
  <meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
  <link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
  <link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
  <link rel="parent" href="functions.html" title="Chapter Contents" />
  <link rel="prev" href="appendixa.html" title="Appendix" />
  <link rel="next" href="functions.html#.html" title="" />
  <link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
  <link rel="stylesheet" type="text/css" href="doc.css" />
  <link rel="stylesheet" type="text/css" href="/doc/translation.css" />
  <title>Function: DB.DBA.RDF_AUDIT_METADATA - Virtuoso Functions Guide</title>
  <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
  <meta name="author" content="OpenLink Software Documentation Team ;&#10;" />
  <meta name="copyright" content="OpenLink Software, 1999 - 2009" />
  <meta name="keywords" content="" />
  <meta name="GENERATOR" content="OpenLink XSLT Team" />
 </head>
 <body>
  <div id="header">
    <a name="fn_rdf_audit_metadata" />
    <img src="../images/misc/logo.jpg" alt="" />
    <h1>22. Virtuoso Functions Guide - DB.DBA.RDF_AUDIT_METADATA</h1>
  </div>
  <div id="navbartop">
   <div>
      <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_sparql_to_sql_text.html" title="sparql_to_sql_text">Prev</a> | <a class="link" href="fn_rdf_backup_metadata.html" title="DB.DBA.RDF_BACKUP_METADATA">Next</a>
   </div>
  </div>
  <div id="currenttoc">
   <form method="post" action="/doc/adv_search.vspx">
    <div class="search">Keyword Search: <br />
        <input type="text" name="q" /> <input type="submit" name="go" value="Go" />
    </div>
   </form>
   <div>
      <a href="http://www.openlinksw.com/">www.openlinksw.com</a>
   </div>
   <div>
      <a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
   </div>
    <br />
   <div>
      <a href="index.html">Book Home</a>
   </div>
    <br />
   <div>
      <a href="contents.html">Contents</a>
   </div>
   <div>
      <a href="preface.html">Preface</a>
   </div>
    <br />
   <div>
      <a class="selected" href="functions.html">Virtuoso Functions Guide</a>
   </div>
    <br />
   <div>
      <a href="functions.html#admin">Administration</a>
   </div>
   <div>
      <a href="functions.html#aggr">Aggregate Functions</a>
   </div>
   <div>
      <a href="functions.html#array">Array Manipulation</a>
   </div>
   <div>
      <a href="functions.html#bpel">BPEL APIs</a>
   </div>
   <div>
      <a href="functions.html#backup">Backup</a>
   </div>
   <div>
      <a href="functions.html#compression">Compression</a>
   </div>
   <div>
      <a href="functions.html#cursors">Cursor</a>
   </div>
   <div>
      <a href="functions.html#time">Date &amp; Time Manipulation</a>
   </div>
   <div>
      <a href="functions.html#debug">Debug</a>
   </div>
   <div>
      <a href="functions.html#dict">Dictionary Manipulation</a>
   </div>
   <div>
      <a href="functions.html#encoding">Encoding &amp; Decoding</a>
   </div>
   <div>
      <a href="functions.html#file">File Manipulation</a>
   </div>
   <div>
      <a href="functions.html#ft">Free Text</a>
   </div>
   <div>
      <a href="functions.html#hash">Hashing / Cryptographic</a>
   </div>
   <div>
      <a href="functions.html#ldap">LDAP</a>
   </div>
   <div>
      <a href="functions.html#localization">Locale</a>
   </div>
   <div>
      <a href="functions.html#mail">Mail</a>
   </div>
   <div>
      <a href="functions.html#misc">Miscellaneous</a>
   </div>
   <div>
      <a href="functions.html#number">Number</a>
   </div>
   <div>
      <a href="functions.html#phrz">Phrases</a>
   </div>
   <div>
      <a class="selected" href="functions.html#rdf">RDF data</a>
   </div>
   <div class="selected">
    <div>
        <a href="fn_rdf_64bit_upgrade.html">db.dba.rdf_64bit_upg...</a>
    </div>
    <div>
        <a class="selected" href="fn_rdf_audit_metadata.html">db.dba.rdf_audit_met...</a>
    </div>
    <div>
        <a href="fn_rdf_backup_metadata.html">db.dba.rdf_backup_me...</a>
    </div>
    <div>
        <a href="fn_rdf_convert_rdfxml_to_ttl.html">db.dba.rdf_convert_r...</a>
    </div>
    <div>
        <a href="fn_rdf_datatype_of_obj.html">db.dba.rdf_datatype_...</a>
    </div>
    <div>
        <a href="fn_rdf_graph_collect_fp_list.html">db.dba.rdf_graph_col...</a>
    </div>
    <div>
        <a href="fn_rdf_graph_diff.html">db.dba.rdf_graph_dif...</a>
    </div>
    <div>
        <a href="fn_rdf_graph_group_create.html">db.dba.rdf_graph_gro...</a>
    </div>
    <div>
        <a href="fn_rdf_graph_group_ins.html">db.dba.rdf_graph_gro...</a>
    </div>
    <div>
        <a href="fn_rdf_langmatches.html">db.dba.rdf_langmatch...</a>
    </div>
    <div>
        <a href="fn_rdf_load_rdfa.html">db.dba.rdf_load_rdfa</a>
    </div>
    <div>
        <a href="fn_rdf_load_rdfxml.html">db.dba.rdf_load_rdfx...</a>
    </div>
    <div>
        <a href="fn_rdf_load_rdfxml_mt.html">db.dba.rdf_load_rdfx...</a>
    </div>
    <div>
        <a href="fn_rdf_quad_uri.html">db.dba.rdf_quad_uri</a>
    </div>
    <div>
        <a href="fn_rdf_quad_uri_l.html">db.dba.rdf_quad_uri_...</a>
    </div>
    <div>
        <a href="fn_rdf_quad_uri_l_typed.html">db.dba.rdf_quad_uri_...</a>
    </div>
    <div>
        <a href="fn_rdf_regex.html">db.dba.rdf_regex</a>
    </div>
    <div>
        <a href="fn_rdf_restore_metadata.html">db.dba.rdf_restore_m...</a>
    </div>
    <div>
        <a href="fn_rdf_suo_apply_patch.html">db.dba.rdf_suo_apply...</a>
    </div>
    <div>
        <a href="fn_rdf_suo_diff_ttl.html">db.dba.rdf_suo_diff_...</a>
    </div>
    <div>
        <a href="fn_rdf_triples_to_rdf_xml_text.html">db.dba.rdf_triples_t...</a>
    </div>
    <div>
        <a href="fn_rdf_triples_to_ttl.html">db.dba.rdf_triples_t...</a>
    </div>
    <div>
        <a href="fn_rdf_ttl2hash.html">db.dba.rdf_ttl2hash</a>
    </div>
    <div>
        <a href="fn_rdf_void_store.html">db.dba.rdf_void_stor...</a>
    </div>
    <div>
        <a href="fn_sparql_eval.html">db.dba.sparql_eval</a>
    </div>
    <div>
        <a href="fn_sparql_eval_to_array.html">db.dba.sparql_eval_t...</a>
    </div>
    <div>
        <a href="fn_sparql_rdb2rdf_codegen.html">db.dba.sparql_rdb2rd...</a>
    </div>
    <div>
        <a href="fn_sparql_rdb2rdf_list_tables.html">db.dba.sparql_rdb2rd...</a>
    </div>
    <div>
        <a href="fn_sparql_rexec.html">db.dba.sparql_rexec</a>
    </div>
    <div>
        <a href="fn_sparql_rexec_to_array.html">db.dba.sparql_rexec_...</a>
    </div>
    <div>
        <a href="fn_sparql_rexec_with_meta.html">db.dba.sparql_rexec_...</a>
    </div>
    <div>
        <a href="fn_sparql_select_known_graphs.html">db.dba.sparql_select...</a>
    </div>
    <div>
        <a href="fn_ttlp.html">db.dba.ttlp</a>
    </div>
    <div>
        <a href="fn_ttlp_mt.html">db.dba.ttlp_mt</a>
    </div>
    <div>
        <a href="fn_ttlp_mt_local_file.html">db.dba.ttlp_mt_local...</a>
    </div>
    <div>
        <a href="fn_GROUP_CONCAT.html">group_concat</a>
    </div>
    <div>
        <a href="fn_isref.html">isref</a>
    </div>
    <div>
        <a href="fn_sample.html">sample</a>
    </div>
    <div>
        <a href="fn___xml_get_ns_prefix.html">__xml_get_ns_prefix</a>
    </div>
    <div>
        <a href="fn___xml_get_ns_uri.html">__xml_get_ns_uri</a>
    </div>
    <div>
        <a href="fn_http_nt_triple.html">http_nt_triple</a>
    </div>
    <div>
        <a href="fn_http_ttl_triple.html">http_ttl_triple</a>
    </div>
    <div>
        <a href="fn_iri_split.html">iri_split</a>
    </div>
    <div>
        <a href="fn_ld_dir.html">ld_dir</a>
    </div>
    <div>
        <a href="fn_rdfs_rule_set.html">rdfs_rule_set</a>
    </div>
    <div>
        <a href="fn_sparql_to_sql_text.html">sparql_to_sql_text</a>
    </div>
   </div>
   <div>
      <a href="functions.html#rmt">Remote SQL Data Source</a>
   </div>
   <div>
      <a href="functions.html#repl">Replication</a>
   </div>
   <div>
      <a href="functions.html#soap">SOAP</a>
   </div>
   <div>
      <a href="functions.html#sql">SQL</a>
   </div>
   <div>
      <a href="functions.html#string">String</a>
   </div>
   <div>
      <a href="functions.html#txn">Transaction</a>
   </div>
   <div>
      <a href="functions.html#type">Type Mapping</a>
   </div>
   <div>
      <a href="functions.html#uddi">UDDI</a>
   </div>
   <div>
      <a href="functions.html#udt">User Defined Types &amp; The CLR</a>
   </div>
   <div>
      <a href="functions.html#vad">VAD</a>
   </div>
   <div>
      <a href="functions.html#jvmpl">Virtuoso Java PL API</a>
   </div>
   <div>
      <a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
   </div>
   <div>
      <a href="functions.html#ws">Web &amp; Internet</a>
   </div>
   <div>
      <a href="functions.html#xml">XML</a>
   </div>
   <div>
      <a href="functions.html#XPATH">XPATH &amp; XQUERY</a>
   </div>
    <br />
   <div>
      <a href="functionidx.html">Functions Index</a>
   </div>
    <br />
  </div>
  <div id="text">
    <h2>DB.DBA.RDF_AUDIT_METADATA</h2>
    <div class="refpurpose">Fix RDF metadata corruption.</div>
    <div class="funcsynopsis">
        <span class="funcdef">
     <span class="function">DB.DBA.RDF_AUDIT_METADATA</span>
     </span>
        (<span class="paramdefoptional">[in <span class="optional">audit_mode</span> integer]</span>, 
        <span class="paramdefoptional">[in <span class="optional">str_value</span> varchar]</span>, 
        <span class="paramdefoptional">[in <span class="optional">graph_iri</span> varchar]</span>);
      </div>
  
  
  
  <div class="refsect1">
      <div class="refsect1title">Description</div>
    <p>This function can detect and automatically fix most popular sorts of metadata corruption.</p>
  </div>
  <div class="refsect1">
    <div class="refsect1title">Parameters</div>
    <div class="refsect2">
      <span class="refsect2title">audit_mode – </span>
      (0|1|2 default 0) - 0 = read-only audit operation; 1 = audit and fix; 2 = audit, fix and garbage collection for all incomplete declarations
    </div>
    <div class="refsect2">
      <span class="refsect2title">str_value – </span>
      Default &#39;&#39; is to stop if the metadata graph contains marks that some storages are being edited.
      &#39;*&#39; is to remove such marks.
      Other values will be suggested by the error dump when appropriate.
    </div>
    <div class="refsect2">
      <span class="refsect2title">graph_iri – </span>
      Default is system metadata graph.
      If specified then it should be a name of graph created by
        <a href="fn_rdf_backup_metadata.html">DB.DBA.RDF_BACKUP_METADATA</a>.
It is possible to make the backup to a graph, test and maybe fix that backup and finally restore metadata from the fixed backup.
The disadvantage is that DB.DBA.RDF_AUDIT_METADATA() may detect and fix more errors on &quot;active&quot; metadata than on their backup.
The possible approach is to make backup, test and maybe fix it (after fix it can be tested one more time).
If the backup was successfully fixed then the DB.DBA.RDF_AUDIT_METADATA() is used to fix the &quot;active&quot; metadata, not the copy.
In any case, if one makes a backup to fix it then it&#39;s worth to make and keep another &#39;untouched&#39; backup, just to stay on safe side.
    </div>
  </div>
  <div class="refsect1">
    <div class="refsect1title">Examples</div>
    <a name="ex_rdf_audit_metadata" />
      <div class="example">
      <div class="exampletitle">Simple example</div>
      <p>Automatically fix the corrupted metadata:</p>
      <div>
          <pre class="screen">
        SQL&gt; DB.DBA.RDF_AUDIT_METADATA(1, &#39;*&#39;);
      </pre>
        </div>
    </div>
  </div>
  <div class="refsect1">
    <div class="refsect1title">See Also</div>
    <p>
        <a href="fn_rdf_backup_metadata.html">DB.DBA.RDF_BACKUP_METADATA</a>
      </p>
    <p>
        <a href="fn_rdf_restore_metadata.html">DB.DBA.RDF_RESTORE_METADATA</a>
      </p>
  </div>
</div>
  <div id="footer">
    <div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
   <div id="validation">
    <a href="http://validator.w3.org/check/referer">
        <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
    </a>
    <a href="http://jigsaw.w3.org/css-validator/">
        <img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
    </a>
   </div>
  </div>
 </body>
</html>