%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%

---++How to rename a RDF Graph in the Virtuoso Quad Store


---+++Rename RDF Graph
A RDF Graph in the Virtuoso Quad Store can be renamed without copying each assertion from the old graph to the new graph using a SQL statement, this being what the Conductor "rename" option does, which is:

<verbatim>
UPDATE DB.DBA.RDF_QUAD TABLE OPTION (index RDF_QUAD_GS) 
   SET g = iri_to_id ('new') 
 WHERE g = iri_to_id ('old', 0);  
</verbatim>

<b>Note</b>: this operation must be run in <i>row-autocommit</i> mode i.e. <code>log_enable (3)</code>, and then restore back to the default logging mode of 1.


---+++Rename RDF Graph Group

For Virtuoso Graph Groups two tables need to be updated:

<verbatim>
UPDATE DB.DBA.RDF_GRAPH_GROUP_MEMBER 
   SET RGGM_GROUP_IID = iri_to_id ('new') 
 WHERE RGGM_GROUP_IID = iri_to_id (old)
</verbatim>

and  

<verbatim>
UPDATE DB.DBA.RDF_GRAPH_GROUP 
   SET RGG_IID = iri_to_id ('new') , RGG_IRI = 'new' 
 WHERE RGG_IRI = 'old'  
</verbatim>


---+++Related
   
   * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
   * [[http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html][RDF Performance Tuning]]