I cannot perform that query anymore, since I reinstalled the database prior to
receiving your message. I try to load the triples again but it takes too long.
Searching the mailing list I found a reply about changing the default memory
usage and in particular the NumberOfBuffers and the MaxDirtyBuffers value in
the virtuoso.in file in order to improve performance. Should I do something
more apart from simply changing and saving the file for the changes to be
applied?
Sorry for any inconvenience and thank you for your time,Aliki
Subject: Re: [Virtuoso-users] Problem concenring deleting triples
From: [email protected]
List-Post: [email protected]
Date: Wed, 29 Feb 2012 18:13:01 +0000
CC: [email protected]
To: [email protected]
Hi
Please confirm the version of Virtuoso you are using by running the command
β./virtuoso-t -?β from you βbinβ directory of Virtuoso installation directory.
Also, what is the name of the graph it reports these unexpected triples that
should have been removed to be in, using the following corrected and amended
query you were running below:
select distinct ?g ?r where { graph ?g {?u ?r ?s}}
pointing out which triple(s) should have been removed, as I am curious to know
where they are located ?
Best RegardsHugh WilliamsProfessional ServicesOpenLink Software, Inc. //
http://www.openlinksw.com/10 Burlington Mall Road, Suite 265,
Burlington MA 01803Weblog -- http://www.openlinksw.com/blogs/LinkedIn --
http://www.linkedin.com/company/openlink-software/Twitter --
http://twitter.com/OpenLinkGoogle+ --
http://plus.google.com/100570109519069333827/Facebook --
http://www.facebook.com/OpenLinkSoftwareUniversal Data Access, Integration, and
Management Technology Providers
On 29 Feb 2012, at 14:28, aliki aliki wrote:Thank you for the replies.
The triples returned are some of the ones I have loaded with rdf_loader_run()
(Triples from dbpedia dumps). I can also see the ones from the system graphs
but not only them.
Subject: Re: [Virtuoso-users] Problem concenring deleting triples
From: [email protected]
List-Post: [email protected]
Date: Wed, 29 Feb 2012 12:58:26 +0000
CC: [email protected]
To: [email protected]
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 RegardsHugh WilliamsProfessional ServicesOpenLink Software, Inc. //
http://www.openlinksw.com/10 Burlington Mall Road, Suite 265,
Burlington MA 01803Weblog -- http://www.openlinksw.com/blogs/LinkedIn --
http://www.linkedin.com/company/openlink-software/Twitter --
http://twitter.com/OpenLinkGoogle+ --
http://plus.google.com/100570109519069333827/Facebook --
http://www.facebook.com/OpenLinkSoftwareUniversal 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
------------------------------------------------------------------------------
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
