Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, This is the beginning of the file: # Dump of graph , as of 2010-06-13 16:21:27 @prefix rdf: . @prefix mo: . < http://musicbrainz.org/music/performance/0001cce4-caaa-4ee3-acef-baa18abf2

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi Hugh, It doesn't load in v5 either. Here's what it contains: 64740608 dc:title "Voice for a Generation" ; 64740609 mo:produced_sound < http://musicbrainz.org/music/sound/8fab7a02-7044-446d-90af-92f44f6d14a8> ; 64740610 mo:performer ns3:bd5280cb-5bbd-45c8-9891-a963692c1890 ; 64740611 mo:perform

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I've also tried to load the dump into vos 6.1.1 this way, but I get the error ERRS_0 37000 SP029 TURTLE RDF loader, line 64740610: syntax error PL LOG: Error in graph01_01.ttl Any ideas? Cheers, Mats On Wed, Jun 2, 2010 at 9:23 AM, Bob Ferris wrote: > > 1. Create a dump graph of t

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, How can I list the names of the triggers on these tables? Cheers, Mats On Thu, Jun 3, 2010 at 1:47 AM, Hugh Williams wrote: > Hi Mats, > > Looks like the same problem as we saw before, which we got around by > dropping all the triggers on the tables WS.WS.SYS_DAV_* > > Best Regards > Hugh W

Re: [Virtuoso-users] Best way to Create a RDF Dump File from Virtuoso?

Maybe this will work you http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfdumpandreloadgraphs On Wed, Jun 2, 2010 at 10:55 PM, Peter DeVries wrote: > I have been working to get up to speed with Virtuoso and would like to > create RDF dump files of the triples I have loaded on

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

It looks like the MusicBrainz dump makes it try to call a replication procedure. With fn_trace it shows the additional error ERRS_0 42001 SR185 Undefined procedure DB.DBA.REPL_GETDATE Cheers, Mats On Wed, Jun 2, 2010 at 3:37 PM, Hugh Williams wrote: > Hi Mat/Bob, > > Can you please enable the Vi

Re: [Virtuoso-users] Deploying MusicBrainz backup for EC2 AMI locally

Hi, I also tried this, but after the restore I'm getting "Error 42000 DA010: Can't store the file '/DAV/VAD/conductor/main_tabs.vspx-m': DAV error -29" when I try to access the conductor. Cheers, Mats On Wed, Jun 2, 2010 at 2:51 AM, Hugh Williams wrote: > Hi Bob, > > Yes, you can just copy the

Re: [Virtuoso-users] Full text matching score interpretation

There is some info on how the hit scores are calculated here http://docs.openlinksw.com/virtuoso/creatingtxtidxs.html#hitscores On Wed, May 26, 2010 at 10:27 AM, Sebastian Trüg wrote: > Hello everybody, > > using "?r bif:contains "foobar" OPTION (score ?s)" one can retrieve the > full text match

Re: [Virtuoso-users] full-text search

I decided to use CONSTRUCT to make a new predicate with the search terms, that can be inserted with SPARUL. In case anyone's interested, example for albums that can be looked up by artist and/or album name. It seems to work ok with CONSTRUCT { ?s `bif:concat(?o, "

Re: [Virtuoso-users] full-text search

So then, to make for example an index for an album that includes artist name and album name, I would need to use something along the lines of this? create procedure upd_index(in subject varchar, in _g iri_id, in _s iri_id, in _p iri_id, in _o any) { declare vtb, subject; declare text_to_index

Re: [Virtuoso-users] full-text search

Can I use it with multiple search terms then? I tried with this where leonardo is in dbpedia-owl:starring and gangs is in dbpprop:name, but it doesn't return any results. SELECT DISTINCT ?s ?p ?o ?mscore WHERE { ?s ?p ?o . ?s rdf:type dbpedia-owl:Film . FILTER( ?p in ( dbpedia-owl:starring, dbppr

Re: [Virtuoso-users] full-text search

Well then I guess it should be possible to make this kind of indexes with Virtuoso. I found what looks like a way to do it in the SQL docs[1]. I'm a bit unsure about how to apply the SQL methods described to RDF data though. 1. http://docs.openlinksw.com/virtuoso/creatingtxtidxs.html#preprocessing

Re: [Virtuoso-users] full-text search

Not sure if that will help do what I want. I'd like something that can be used with a search box that can be used for free-text queries to find items of a specific class. For example to look for movies it could set to find items of rdf:type http://freebase.com/film/film, where the search terms cou

Re: [Virtuoso-users] full-text search

Okay, that could for work for some blogs. Something similar though is looking up an album. For example if I want to find "Great Eagle Flying With the Wind" by Wayra, and I type in "wayra great eagle flying with the wind" in lod.openlinksw.com, it doesn't find anything. In this case the album has d

Re: [Virtuoso-users] full-text search

I tried some queries on the sites on those links, and it looks to me like it only compares the query to each single text field. If I for example have a blog post with the author "John Doe" and title "Hello World", and then want to find this blog post with the query "john hello world". Then there i

[Virtuoso-users] full-text search

When using bif:contains in Virtuoso, from what I've seen, you an only query a single property. In many cases it's more useful to query multiple properties, for example if you have a blog and want to do a single query that searches through both author and title and perhaps even the contents of the b

Re: [Virtuoso-users] linking datasets with virtuoso

Great. I'll try that. I also just found an RDF linking framwork called Silk which looks pretty good. 1. http://code.google.com/p/silk/ On Wed, May 19, 2010 at 11:02 PM, Kingsley Idehen wrote: > mats@gmail.com wrote: > >> If I have two datasets in RDF with some common entries, how can I gene

[Virtuoso-users] linking datasets with virtuoso

If I have two datasets in RDF with some common entries, how can I generate owl:sameAs links? Is there a way to do this within Virtuoso, or do I have to make a separate program? I would guess in either case it would be done by selecting all entries from one of the datasets, and then for each entry d

Re: [Virtuoso-users] query musicbrainz

Thanks Bob, that got rid of the error message at least :) I'm running my own instance of the MusicBrainz EC2 AMI because the endpoint on dbtune doesn't run on Virtuoso and I want to use bif:contains to use full-text search. I still haven't been able to get any data out though, when I try some que

[Virtuoso-users] query musicbrainz

I'm trying to query a MusicBrainz EC2 AMI, but I'm getting an error. Can anyone tell me what's wrong with this query? PREFIX rdf: PREFIX foaf: PREFIX mo: PREFIX dc: