Thanks Hugh, Ted (Openlink) actually pointed me to that new build earlier today to solve another issue I had (the virtuoso service on Windows was stopping when I logged off the user who started it), I will try it out!
- Alex > -----Original Message----- > From: Hugh Williams [mailto:hwilli...@openlinksw.com] > Sent: Friday, April 27, 2007 11:55 AM > To: Alex Black; Imikhailov@Openlinksw. Com; > virtuoso-users@lists.sourceforge.net > Subject: Re: [Virtuoso-users] RDF Views: Defining quad storage, joins? > > Hi Alex, > > The installer you are using currently is probably build # > 3004, but an newer installer was uploaded to the OpenLink > Download site > (http://download.openlinksw.com) today which is build # 3009 > and should function in the manner described by Ivan ... > > Best Regards > Hugh Williams > OpenLink Software > > > On 27/4/07 16:22, "Alex Black" <alex.bl...@terapath.net> wrote: > > > Hi Ivan, > > > > I am running Virtuoso 5 on Windows, I downloaded it just last week. > > > > Yes, that IRI class is declared before use. > > > > However, that code below still doesn't work for me, I > instead create a > > view joining the two tables, and use that one view in my > quad storage > > creation. > > > > - Alex > > > >> -----Original Message----- > >> From: imikhailov [mailto:imikhai...@openlinksw.com] > >> Sent: Friday, April 27, 2007 11:20 AM > >> To: Alex Black; virtuoso-users@lists.sourceforge.net > >> Subject: RE: [Virtuoso-users] RDF Views: Defining quad > storage, joins? > >> > >> Alex, > >> > >> Fred's blog entry refer to a version that is now obsolete. > >> First of all, try to update to a recent version. > >> If IRI class conceptSchema:iri_concept declared before use in this > >> declaration then the declaration seemes OK for me. > >> > >> Best Regards, > >> Ivan Mikhailov. > >> > >> > >> ________________________________ > >> > >> From: virtuoso-users-boun...@lists.sourceforge.net > >> [mailto:virtuoso-users-boun...@lists.sourceforge.net] On Behalf Of > >> Alex Black > >> Sent: Friday, April 27, 2007 9:35 PM > >> To: virtuoso-users@lists.sourceforge.net > >> Subject: Re: [Virtuoso-users] RDF Views: Defining quad > storage, joins? > >> > >> > >> I found a solution, I created views beforehand that performed the > >> joins, and then used those joined views instead of the tables. > >> > >> I got this idea from Frederick Giasson's blog entry about creating > >> RDF views for WordPress and MediaWiki: > >> > >> http://fgiasson.com/blog/index.php/2007/04/24/converting-your- > >> wordpress-and- > >> mediawiki-data-into-rdf-on-the-fly/ > >> > >> > >> > >> > >> ________________________________ > >> > >> From: virtuoso-users-boun...@lists.sourceforge.net > >> [mailto:virtuoso-users-boun...@lists.sourceforge.net] On Behalf Of > >> Alex Black > >> Sent: Thursday, April 26, 2007 4:47 PM > >> To: virtuoso-users@lists.sourceforge.net > >> Subject: [Virtuoso-users] RDF Views: Defining quad storage, joins? > >> > >> > >> Hi, > >> > >> I'm just getting started with Virtuoso, attempting to > create an RDF > >> view for a relational database I have in SQL Server. > >> > >> I got a basic view setup, where columns map to predicates etc, but > >> now I want to setup a view that transforms the data into the RDF > >> graph I want. > >> > >> I have two tables I am trying to join: > >> > >> 1. Concept > >> PK_ConceptID > >> 2. Label > >> PK_LabelID, > >> FK_ConceptID, > >> Name > >> > >> I'd like to get triples like: > >> > >> <ConceptIRI> skos:altLabel Name > >> > >> How would I do this? I've tried to do it like this, but I get an > >> error saying "At least one field of a quad map should be > map value, > >> not a constant" > >> > >> sparql > >> > >> prefix qs: <http://adb/quad_storage/> prefix skos: > >> <http://www.w3.org/2004/02/skos/core#> > >> > >> create quad storage qs:default > >> from Source.Source.vwConcept as concept > >> from Source.Source.vwLabel as label where > (^{label.}^.FK_ConceptID > >> = ^{concept.}^.PK_ConceptID) { > >> create qs:concepts as > >> graph <http://adb/source/data/concepts#> > >> { > >> conceptSchema:iri_concept(concept.PK_ConceptID) > >> a conceptSchema:Concept; > >> skos:altLabel label.Name. > >> } . > >> > >> } . > >> ; > >> > >> Thanks! > >> > >> - Alex > >> > >> > >> > > > > > ---------------------------------------------------------------------- > > --- This SF.net email is sponsored by DB2 Express Download > DB2 Express > > C - the FREE version of DB2 express and take control of > your XML. No > > limits. Just data. Click to get it now. > > http://sourceforge.net/powerbar/db2/ > > _______________________________________________ > > Virtuoso-users mailing list > > Virtuoso-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > Best Regards, > Hugh Williams > VP Product Development > OpenLink Software > Tel: +44 (0) 8681 7701 > Web: http://www.openlinksw.com > Universal Data Access & Data Integration Technology Providers > > >
