[Virtuoso-users] RDF Views: Defining quad storage, joins?

[Alex B. <ale...@te...>]

Hi,
=20
I'm just getting started with Virtuoso, attempting to create an RDF view
for a relational database I have in SQL Server.
=20
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.
=20
I have two tables I am trying to join:=20
=20
1. Concept=20
    PK_ConceptID
2. Label=20
    PK_LabelID,=20
    FK_ConceptID,
    Name
=20
I'd like to get triples like:
=20
<ConceptIRI> skos:altLabel Name
=20
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"
=20
sparql
=20
 prefix qs: <http://adb/quad_storage/>
 prefix skos: <http://www.w3.org/2004/02/skos/core#>
=20
 create quad storage qs:default
   from Source.Source.vwConcept as concept
   from Source.Source.vwLabel as label
  where (^{label.}^.FK_ConceptID =3D ^{concept.}^.PK_ConceptID)
 {
   create qs:concepts as=20
    graph <http://adb/source/data/concepts#>
   {
  conceptSchema:iri_concept(concept.PK_ConceptID)=20
       a conceptSchema:Concept;
       skos:altLabel label.Name.
   } .
=20
 } .
;
=20
=20
Thanks!
=20
- Alex