Not logged in : Login

About: VirtRemoveTriples     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

AttributesValues
type
Date Created
Date Modified
label
  • VirtRemoveTriples
maker
Title
  • VirtRemoveTriples
isDescribedUsing
has creator
content
  • ---+Removing all triples from a Virtuoso Server instance There are times it can be useful to remove all triples from Virtuoso Server. There are a few ways to accomplish this. %TOC% ---++Remove all triples including those in the the system graphs Use *iSQL*, either on the command-line or through the *Virtuoso Conductor* -> *Database* -> *Interactive SQL*, to execute this SQL query -- SQL> DELETE FROM DB.DBA.RDF_QUAD ; ---++Remove all triples except those in the system graphs ---+++ Use the built-in RDF_GLOBAL_RESET procedure 1 When removing large graphs or numbers of triples it is advised/required to change the transaction log mode to autocommit with no transaction logging on each operation, deleting the graph(s) or triples, and then setting the log mode back to its original setting. This is easily done using the Virtuoso [[http://docs.openlinksw.com/virtuoso/fn_log_enable.html][log_enable]] function, with the settings log_enable(3,1). 1 Use *iSQL*, either on the command-line or through the *Virtuoso Conductor* -> *Database* -> *Interactive SQL*, to execute this SQL query -- SQL> RDF_GLOBAL_RESET (); 1 Now selecting all graphs from your db should return only the system graphs, like so -- SQL> SPARQL SELECT DISTINCT ?g FROM { GRAPH ?g { ?s a ?t } } ; g ANY http://www.openlinksw.com/schemas/virtrdf# No. of rows in result: 1 ---+++ Write your own procedure Take all non-system graphs, and for each of them execute: SPARQL CLEAR GRAPH ;
id
  • 3e97a3ef23edfdfe5980a055194bfbe0
link
has container
http://rdfs.org/si...ices#has_services
atom:title
  • VirtRemoveTriples
links to
atom:source
atom:author
atom:published
  • 2017-06-13T05:36:56Z
atom:updated
  • 2017-06-13T05:36:56Z
topic
is made of
is container of of
is link of
is http://rdfs.org/si...vices#services_of of
is links to of
is creator of of
is atom:entry of
is atom:contains of
Faceted Search & Find service v1.17_git132 as of May 12 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3238 as of May 23 2023, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 3 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software