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
