Hi The best methods for deleted graphs in Virtuoso, particularly large ones are detailed at:
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs
The best methods for deleting all graphs which includes the RDF_GLOBAL_REST()
method is detailed at:
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRemoveTriples
This will not remove anything from the load_list table which is just a
reference for loaded datasets and should be cleaned manually before the
rdf_loader_run() is run if no longer valid.
When you say triples are still returned are these from those you know have been
loaded with rdf_loader_run() or other method or are these just the default
system graphs Virtuoso maintains ? What is the actual triple count after
deleting all the graphs ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 29 Feb 2012, at 10:58, aliki aliki wrote:
> Hello!
>
> I have great trouble while trying to delete data (rdf triples) from my
> virtuoso database. First I tried to delete everything by using the
> RDF_GLOBAL_RESET() function. When finished, I searched for the remaining
> graphs using the sparql command:
>
> select distinct ?g
> from <http://localhost:1111/> {graph ?g {?s a ?t} };
>
> which gave the result: http://www.openlinksw.com/schemas/virtrdf#
>
>
> However, the db.dba.load_list was still full with all the graphs I had
> previously loaded. So I deleted everything from the load_list thinking that
> the data had been erased from the database and not from the load_list. Then I
> performed the query:
>
> select distinct ?r from {?u ?r ?s}
>
> hoping not to find any of the triples deleted. Unfortunately some of the
> triples are still loaded and probably not belonging to any graph as there is
> no graph loaded on the system.
>
> I'm not quite sure that I understand how virtuoso works and I cannot find any
> logical explanation on my own. Could you please tell me how can I solve the
> problem? And if I manage to solve it, which is the right way to delete data
> from graphs or to delete entire graphs?
>
> Thanks in advance!!
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
