On 01/03/2012 13:54, aliki aliki wrote:
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?
Aliki,
You will need to restart Virtuoso for the changes to take effect.
Cheers,
Yrjänä
Sorry for any inconvenience and thank you for your time,
Aliki
------------------------------------------------------------------------
Subject: Re: [Virtuoso-users] Problem concenring deleting triples
From: [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 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 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] <mailto:[email protected]>
Date: Wed, 29 Feb 2012 12:58:26 +0000
CC:[email protected]
<mailto:[email protected]>
To:[email protected] <mailto:[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 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]
<mailto:[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]
<mailto:[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
--
Mr. Yrjana Rankka | [email protected]
Developer, Virtuoso Team | http://www.openlinksw.com
| Making Technology Work For You
