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
> 
> 
> 

Reply via email to