Warning:
This wiki has been archived and is now read-only.

View source for Example of SQL-Query based Approach (Part 3: Query): SPARQL Query and its SQL translation

← Example of SQL-Query based Approach (Part 3: Query): SPARQL Query and its SQL translation

Jump to: navigation, search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in one of the groups: Users, 106, 43889-chairs.

You can view and copy the source of this page.

'''SPARQL graph-pattern'''

  { 
    ?x emp:Name    ?ename . 
    ?x emp:deptNum ?dno . 
    ?d dept:deptno ?dno . 
    ?d dept:Name   ?dname
  }

'''Generated SQL query'''

Note: We have not shown transformation of column values to RDF terms.

  WITH
  DEPT_VW AS (
  Select 
     '<xyz.com/dept/' || deptno || '>' AS deptURI
   , deptno
   , dname
   , loc 
   from dept
  ),
  EMP_VW AS (
  Select 
     '<xyz.com/emp/' || empno || '>' AS empURI
   , empno
   , ename
   , '<xyz.com/emp/job/'|| job || '>' AS jobTypeURI
   , job
   , deptno
   , '<xyz.com/emp/etype/'|| etype || '>' AS empTypeURI
   , etype
   , '<xyz.com/graph/'|| job || '/' || etype || '>' AS graphURI 
   from emp
  )
  SELECT   T1.DNAME as DNAME,T0.ENAME as ENAME
  FROM EMP_VW T0, DEPT_VW T1 
  WHERE T0.DEPTNO = T1.DEPTNO
  ;

Return to Example of SQL-Query based Approach (Part 3: Query): SPARQL Query and its SQL translation.

Retrieved from "https://www.w3.org/2001/sw/rdb2rdf/wiki/Example_of_SQL-Query_based_Approach_(Part_3:_Query):_SPARQL_Query_and_its_SQL_translation"

View source for Example of SQL-Query based Approach (Part 3: Query): SPARQL Query and its SQL translation

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Navigation

Tools