Script for building Linked Data Views for the DB2 tables

-- ABox Mappings:

grant select on "DB2"."db2ma"."CL_SCHED" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."DEPARTMENT" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."EMPLOYEE" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."EMP_ACT" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."EMP_PHOTO" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."EMP_RESUME" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."IN_TRAY" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."ORG" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."PROJECT" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."SALES" to SPARQL_SELECT;
grant select on "DB2"."db2ma"."STAFF" to SPARQL_SELECT;


SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:cl_sched "http://^{URIQADefaultHost}^/db2views/cl_sched/CLASS_CODE/%U#this" (in _CLASS_CODE varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:department "http://^{URIQADefaultHost}^/db2views/department/DEPTNO/%U#this" (in _DEPTNO varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:employee "http://^{URIQADefaultHost}^/db2views/employee/EMPNO/%U#this" (in _EMPNO varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:emp_act "http://^{URIQADefaultHost}^/db2views/emp_act/EMPNO/%U/PROJNO/%U/ACTNO/%d#this" (in _EMPNO varchar not null,in _PROJNO varchar not null,in _ACTNO integer not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:emp_photo "http://^{URIQADefaultHost}^/db2views/emp_photo/EMPNO/%U/PHOTO_FORMAT/%U#this" (in _EMPNO varchar not null,in _PHOTO_FORMAT varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:emp_photo_picture "http://^{URIQADefaultHost}^/db2views/objects/emp_photo/EMPNO/%U/PHOTO_FORMAT/%U/PICTURE.jpe" (in _EMPNO varchar not null,in _PHOTO_FORMAT varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:emp_resume "http://^{URIQADefaultHost}^/db2views/emp_resume/EMPNO/%U/RESUME_FORMAT/%U#this" (in _EMPNO varchar not null,in _RESUME_FORMAT varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:in_tray "http://^{URIQADefaultHost}^/db2views/in_tray/RECEIVED/%1D/SOURCE/%U/SUBJECT/%U/NOTE_TEXT/%U#this" (in _RECEIVED datetime not null,in _SOURCE varchar not null,in _SUBJECT varchar not null,in _NOTE_TEXT varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:org "http://^{URIQADefaultHost}^/db2views/org/DEPTNUMB/%d/MANAGER/%d#this" (in _DEPTNUMB integer not null,in _MANAGER integer not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:project "http://^{URIQADefaultHost}^/db2views/project/PROJNO/%U#this" (in _PROJNO varchar not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:sales "http://^{URIQADefaultHost}^/db2views/sales/SALES_DATE/%1D/SALES_PERSON/%U/REGION/%U/SALES/%d#this" (in _SALES_DATE date not null,in _SALES_PERSON varchar not null,in _REGION varchar not null,in _SALES integer not null) . ;
SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
create iri class db2views:staff "http://^{URIQADefaultHost}^/db2views/staff/ID/%d#this" (in _ID integer not null) . ;


drop view "DB2"."db2ma"."db2views__Total";
create view "DB2"."db2ma"."db2views__Total" as select (cnt0*cnt1)+(cnt2*cnt3)+(cnt4*cnt5)+(cnt6*cnt7)+(cnt8*cnt9)+(cnt10*cnt11)+(cnt12*cnt13)+(cnt14*cnt15)+(cnt16*cnt17)+(cnt18*cnt19)+(cnt20*cnt21) AS cnt from
(select count(*) cnt0 from "DB2"."db2ma"."CL_SCHED") tb0,
(select count(*)+1 as cnt1 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.CL_SCHED') tb1,
(select count(*) cnt2 from "DB2"."db2ma"."DEPARTMENT") tb2,
(select count(*)+1 as cnt3 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.DEPARTMENT') tb3,
(select count(*) cnt4 from "DB2"."db2ma"."EMPLOYEE") tb4,
(select count(*)+1 as cnt5 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.EMPLOYEE') tb5,
(select count(*) cnt6 from "DB2"."db2ma"."EMP_ACT") tb6,
(select count(*)+1 as cnt7 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.EMP_ACT') tb7,
(select count(*) cnt8 from "DB2"."db2ma"."EMP_PHOTO") tb8,
(select count(*)+1 as cnt9 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.EMP_PHOTO') tb9,
(select count(*) cnt10 from "DB2"."db2ma"."EMP_RESUME") tb10,
(select count(*)+1 as cnt11 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.EMP_RESUME') tb11,
(select count(*) cnt12 from "DB2"."db2ma"."IN_TRAY") tb12,
(select count(*)+1 as cnt13 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.IN_TRAY') tb13,
(select count(*) cnt14 from "DB2"."db2ma"."ORG") tb14,
(select count(*)+1 as cnt15 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.ORG') tb15,
(select count(*) cnt16 from "DB2"."db2ma"."PROJECT") tb16,
(select count(*)+1 as cnt17 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.PROJECT') tb17,
(select count(*) cnt18 from "DB2"."db2ma"."SALES") tb18,
(select count(*)+1 as cnt19 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.SALES') tb19,
(select count(*) cnt20 from "DB2"."db2ma"."STAFF") tb20,
(select count(*)+1 as cnt21 from DB.DBA.TABLE_COLS where "TABLE" = 'DB2.db2ma.STAFF') tb21
;
grant select on "DB2"."db2ma"."db2views__Total" to SPARQL_SELECT;


SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."CL_SCHED" as cl_sched_s
{
   create db2views:qm-cl_sched as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.CL_SCHED"
      db2views:cl_sched (cl_sched_s."CLASS_CODE")  a db2views:CL_SCHED ;
      db2views:class_code cl_sched_s."CLASS_CODE" as db2views:db2ma-cl_sched-class_code ;
      db2views:day cl_sched_s."DAY" as db2views:db2ma-cl_sched-day ;
      db2views:starting cl_sched_s."STARTING" as db2views:db2ma-cl_sched-starting ;
      db2views:ending cl_sched_s."ENDING" as db2views:db2ma-cl_sched-ending .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."DEPARTMENT" as department_s
{
   create db2views:qm-department as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.DEPARTMENT"
      db2views:department (department_s."DEPTNO")  a db2views:DEPARTMENT ;
      db2views:deptno department_s."DEPTNO" as db2views:db2ma-department-deptno ;
      db2views:deptname department_s."DEPTNAME" as db2views:db2ma-department-deptname ;
      db2views:mgrno department_s."MGRNO" as db2views:db2ma-department-mgrno ;
      db2views:admrdept department_s."ADMRDEPT" as db2views:db2ma-department-admrdept ;
      db2views:location department_s."LOCATION" as db2views:db2ma-department-location .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."EMPLOYEE" as employee_s
{
   create db2views:qm-employee as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.EMPLOYEE"
      db2views:employee (employee_s."EMPNO")  a db2views:EMPLOYEE ;
       a foaf:Person ;
      db2views:empno employee_s."EMPNO" as db2views:db2ma-employee-empno ;
      db2views:firstnme employee_s."FIRSTNME" as db2views:db2ma-employee-firstnme ;
      db2views:midinit employee_s."MIDINIT" as db2views:db2ma-employee-midinit ;
      db2views:lastname employee_s."LASTNAME" as db2views:db2ma-employee-lastname ;
      db2views:workdept employee_s."WORKDEPT" as db2views:db2ma-employee-workdept ;
      db2views:phoneno employee_s."PHONENO" as db2views:db2ma-employee-phoneno ;
      db2views:hiredate employee_s."HIREDATE" as db2views:db2ma-employee-hiredate ;
      db2views:job employee_s."JOB" as db2views:db2ma-employee-job ;
      db2views:edlevel employee_s."EDLEVEL" as db2views:db2ma-employee-edlevel ;
      db2views:sex employee_s."SEX" as db2views:db2ma-employee-sex ;
      db2views:birthdate employee_s."BIRTHDATE" as db2views:db2ma-employee-birthdate ;
      db2views:salary employee_s."SALARY" as db2views:db2ma-employee-salary ;
      db2views:bonus employee_s."BONUS" as db2views:db2ma-employee-bonus ;
      db2views:comm employee_s."COMM" as db2views:db2ma-employee-comm .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."EMP_ACT" as emp_act_s
{
   create db2views:qm-emp_act as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.EMP_ACT"
      db2views:emp_act (emp_act_s."EMPNO",emp_act_s."PROJNO",emp_act_s."ACTNO")  a db2views:EMP_ACT ;
      db2views:empno emp_act_s."EMPNO" as db2views:db2ma-emp_act-empno ;
      db2views:projno emp_act_s."PROJNO" as db2views:db2ma-emp_act-projno ;
      db2views:actno emp_act_s."ACTNO" as db2views:db2ma-emp_act-actno ;
      db2views:emptime emp_act_s."EMPTIME" as db2views:db2ma-emp_act-emptime ;
      db2views:emstdate emp_act_s."EMSTDATE" as db2views:db2ma-emp_act-emstdate ;
      db2views:emendate emp_act_s."EMENDATE" as db2views:db2ma-emp_act-emendate .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."EMP_PHOTO" as emp_photo_s
{
   create db2views:qm-emp_photo as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.EMP_PHOTO"
      db2views:emp_photo (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT")  a db2views:EMP_PHOTO ;
      db2views:empno emp_photo_s."EMPNO" as db2views:db2ma-emp_photo-empno ;
      db2views:photo_format emp_photo_s."PHOTO_FORMAT" as db2views:db2ma-emp_photo-photo_format ;
      db2views:picture db2views:emp_photo_picture (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT")  as db2views:db2ma-emp_photo-picture .
      db2views:emp_photo_picture (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT")  a aowl:Content ; aowl:body emp_photo_s."PICTURE" as db2views:db2ma-emp_photo-picture-content ; aowl:type "image/jpeg" .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."EMP_RESUME" as emp_resume_s
{
   create db2views:qm-emp_resume as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.EMP_RESUME"
      db2views:emp_resume (emp_resume_s."EMPNO",emp_resume_s."RESUME_FORMAT")  a db2views:EMP_RESUME ;
      db2views:empno emp_resume_s."EMPNO" as db2views:db2ma-emp_resume-empno ;
      db2views:resume_format emp_resume_s."RESUME_FORMAT" as db2views:db2ma-emp_resume-resume_format ;
      db2views:resume emp_resume_s."RESUME" as db2views:db2ma-emp_resume-resume .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."IN_TRAY" as in_tray_s
{
   create db2views:qm-in_tray as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.IN_TRAY"
      db2views:in_tray (in_tray_s."RECEIVED",in_tray_s."SOURCE",in_tray_s."SUBJECT",in_tray_s."NOTE_TEXT")  a db2views:IN_TRAY ;
      db2views:received in_tray_s."RECEIVED" as db2views:db2ma-in_tray-received ;
      db2views:source in_tray_s."SOURCE" as db2views:db2ma-in_tray-source ;
      db2views:subject in_tray_s."SUBJECT" as db2views:db2ma-in_tray-subject ;
      db2views:note_text in_tray_s."NOTE_TEXT" as db2views:db2ma-in_tray-note_text .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."ORG" as org_s
{
   create db2views:qm-org as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.ORG"
      db2views:org (org_s."DEPTNUMB",org_s."MANAGER")  a db2views:ORG ;
      db2views:deptnumb org_s."DEPTNUMB" as db2views:db2ma-org-deptnumb ;
      db2views:deptname org_s."DEPTNAME" as db2views:db2ma-org-deptname ;
      db2views:manager org_s."MANAGER" as db2views:db2ma-org-manager ;
      db2views:division org_s."DIVISION" as db2views:db2ma-org-division ;
      db2views:location org_s."LOCATION" as db2views:db2ma-org-location .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."PROJECT" as project_s
{
   create db2views:qm-project as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.PROJECT"
      db2views:project (project_s."PROJNO")  a db2views:PROJECT ;
      db2views:projno project_s."PROJNO" as db2views:db2ma-project-projno ;
      db2views:projname project_s."PROJNAME" as db2views:db2ma-project-projname ;
      db2views:deptno project_s."DEPTNO" as db2views:db2ma-project-deptno ;
      db2views:respemp project_s."RESPEMP" as db2views:db2ma-project-respemp ;
      db2views:prstaff project_s."PRSTAFF" as db2views:db2ma-project-prstaff ;
      db2views:prstdate project_s."PRSTDATE" as db2views:db2ma-project-prstdate ;
      db2views:prendate project_s."PRENDATE" as db2views:db2ma-project-prendate ;
      db2views:majproj project_s."MAJPROJ" as db2views:db2ma-project-majproj .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."SALES" as sales_s
{
   create db2views:qm-sales as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.SALES"
      db2views:sales (sales_s."SALES_DATE",sales_s."SALES_PERSON",sales_s."REGION",sales_s."SALES")  a db2views:SALES ;
      db2views:sales_date sales_s."SALES_DATE" as db2views:db2ma-sales-sales_date ;
      db2views:sales_person sales_s."SALES_PERSON" as db2views:db2ma-sales-sales_person ;
      db2views:region sales_s."REGION" as db2views:db2ma-sales-region ;
      db2views:sales sales_s."SALES" as db2views:db2ma-sales-sales .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."STAFF" as staff_s
{
   create db2views:qm-staff as graph iri ("http://^{URIQADefaultHost}^/db2views#")
    {
      # Maps from columns of "DB2.db2ma.STAFF"
      db2views:staff (staff_s."ID")  a db2views:STAFF ;
      db2views:id staff_s."ID" as db2views:db2ma-staff-id ;
      db2views:name staff_s."NAME" as db2views:db2ma-staff-name ;
      db2views:dept staff_s."DEPT" as db2views:db2ma-staff-dept ;
      db2views:job staff_s."JOB" as db2views:db2ma-staff-job ;
      db2views:years staff_s."YEARS" as db2views:db2ma-staff-years ;
      db2views:salary staff_s."SALARY" as db2views:db2ma-staff-salary ;
      db2views:comm staff_s."COMM" as db2views:db2ma-staff-comm .

    }
}

;

SPARQL
prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>
prefix db2views-stat:<http://demo.openlinksw.com/db2views/stat#>
prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix void:<http://rdfs.org/ns/void#>
prefix scovo:<http://purl.org/NET/scovo#>
prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>
prefix foaf:<http://xmlns.com/foaf/0.1/>
alter quad storage virtrdf:DefaultQuadStorage
from "DB2"."db2ma"."CL_SCHEDCount" as cl_schedcount_s
from "DB2"."db2ma"."DEPARTMENTCount" as departmentcount_s
from "DB2"."db2ma"."EMPLOYEECount" as employeecount_s
from "DB2"."db2ma"."EMP_ACTCount" as emp_actcount_s
from "DB2"."db2ma"."EMP_PHOTOCount" as emp_photocount_s
from "DB2"."db2ma"."EMP_RESUMECount" as emp_resumecount_s
from "DB2"."db2ma"."IN_TRAYCount" as in_traycount_s
from "DB2"."db2ma"."ORGCount" as orgcount_s
from "DB2"."db2ma"."PROJECTCount" as projectcount_s
from "DB2"."db2ma"."SALESCount" as salescount_s
from "DB2"."db2ma"."STAFFCount" as staffcount_s
from "DB2"."db2ma"."db2views__Total" as db2views__total_s
{
   create db2views:qm-VoidStatistics as graph iri ("http://^{URIQADefaultHost}^/db2views#") option (exclusive)
    {
      # voID Statistics
      db2views-stat: a void:Dataset as db2views:dataset-db2 ;
       void:sparqlEndpoint<http://demo.openlinksw.com/sparql>   as db2views:dataset-sparql-db2 ;
      void:statItem db2views-stat:Stat .
      db2views-stat:Stat a scovo:Item ;
       rdf:value db2views__total_s.cnt as db2views:stat-decl-db2 ;
       scovo:dimension void:numOfTriples .

      db2views-stat: void:statItem db2views-stat:CL_SCHEDStat as db2views:statitem-db2-cl_sched .
      db2views-stat:CL_SCHEDStat a scovo:Item as db2views:statitem-decl-db2-cl_sched ;
      rdf:value cl_schedcount_s.cnt as db2views:statitem-cnt-db2-cl_sched ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-cl_sched ;
      scovo:dimension db2views:CL_SCHED as db2views:statitem-type-2-db2-cl_sched .

      db2views-stat: void:statItem db2views-stat:DEPARTMENTStat as db2views:statitem-db2-department .
      db2views-stat:DEPARTMENTStat a scovo:Item as db2views:statitem-decl-db2-department ;
      rdf:value departmentcount_s.cnt as db2views:statitem-cnt-db2-department ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-department ;
      scovo:dimension db2views:DEPARTMENT as db2views:statitem-type-2-db2-department .

      db2views-stat: void:statItem db2views-stat:EMPLOYEEStat as db2views:statitem-db2-employee .
      db2views-stat:EMPLOYEEStat a scovo:Item as db2views:statitem-decl-db2-employee ;
      rdf:value employeecount_s.cnt as db2views:statitem-cnt-db2-employee ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-employee ;
      scovo:dimension db2views:EMPLOYEE as db2views:statitem-type-2-db2-employee .

      db2views-stat: void:statItem db2views-stat:EMP_ACTStat as db2views:statitem-db2-emp_act .
      db2views-stat:EMP_ACTStat a scovo:Item as db2views:statitem-decl-db2-emp_act ;
      rdf:value emp_actcount_s.cnt as db2views:statitem-cnt-db2-emp_act ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-emp_act ;
      scovo:dimension db2views:EMP_ACT as db2views:statitem-type-2-db2-emp_act .

      db2views-stat: void:statItem db2views-stat:EMP_PHOTOStat as db2views:statitem-db2-emp_photo .
      db2views-stat:EMP_PHOTOStat a scovo:Item as db2views:statitem-decl-db2-emp_photo ;
      rdf:value emp_photocount_s.cnt as db2views:statitem-cnt-db2-emp_photo ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-emp_photo ;
      scovo:dimension db2views:EMP_PHOTO as db2views:statitem-type-2-db2-emp_photo .

      db2views-stat: void:statItem db2views-stat:EMP_RESUMEStat as db2views:statitem-db2-emp_resume .
      db2views-stat:EMP_RESUMEStat a scovo:Item as db2views:statitem-decl-db2-emp_resume ;
      rdf:value emp_resumecount_s.cnt as db2views:statitem-cnt-db2-emp_resume ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-emp_resume ;
      scovo:dimension db2views:EMP_RESUME as db2views:statitem-type-2-db2-emp_resume .

      db2views-stat: void:statItem db2views-stat:IN_TRAYStat as db2views:statitem-db2-in_tray .
      db2views-stat:IN_TRAYStat a scovo:Item as db2views:statitem-decl-db2-in_tray ;
      rdf:value in_traycount_s.cnt as db2views:statitem-cnt-db2-in_tray ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-in_tray ;
      scovo:dimension db2views:IN_TRAY as db2views:statitem-type-2-db2-in_tray .

      db2views-stat: void:statItem db2views-stat:ORGStat as db2views:statitem-db2-org .
      db2views-stat:ORGStat a scovo:Item as db2views:statitem-decl-db2-org ;
      rdf:value orgcount_s.cnt as db2views:statitem-cnt-db2-org ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-org ;
      scovo:dimension db2views:ORG as db2views:statitem-type-2-db2-org .

      db2views-stat: void:statItem db2views-stat:PROJECTStat as db2views:statitem-db2-project .
      db2views-stat:PROJECTStat a scovo:Item as db2views:statitem-decl-db2-project ;
      rdf:value projectcount_s.cnt as db2views:statitem-cnt-db2-project ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-project ;
      scovo:dimension db2views:PROJECT as db2views:statitem-type-2-db2-project .

      db2views-stat: void:statItem db2views-stat:SALESStat as db2views:statitem-db2-sales .
      db2views-stat:SALESStat a scovo:Item as db2views:statitem-decl-db2-sales ;
      rdf:value salescount_s.cnt as db2views:statitem-cnt-db2-sales ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-sales ;
      scovo:dimension db2views:SALES as db2views:statitem-type-2-db2-sales .

      db2views-stat: void:statItem db2views-stat:STAFFStat as db2views:statitem-db2-staff .
      db2views-stat:STAFFStat a scovo:Item as db2views:statitem-decl-db2-staff ;
      rdf:value staffcount_s.cnt as db2views:statitem-cnt-db2-staff ;
      scovo:dimension void:numberOfResources as db2views:statitem-type-1-db2-staff ;
      scovo:dimension db2views:STAFF as db2views:statitem-type-2-db2-staff .

    }
}
;



-- Virtual directories for instance data
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_rule2',
1,
'(/[^#]*)',
vector('path'),
1,
'/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%23this%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/db2views%%23%%3E&format=%U',
vector('path', '*accept*'),
null,
'(text/rdf.n3)|(application/rdf.xml)|(text/n3)|(application/json)',
2,
null
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_rule4',
1,
'/db2views/stat([^#]*)',
vector('path'),
1,
'/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^/db2views/stat%%23%%3E+%%3Fo+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/db2views%%23%%3E+WHERE+{+%%3Chttp%%3A//^{URIQADefaultHost}^/db2views/stat%%23%%3E+%%3Fp+%%3Fo+}&format=%U',
vector('*accept*'),
null,
'(text/rdf.n3)|(application/rdf.xml)|(text/n3)|(application/json)',
2,
null
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_rule6',
1,
'/db2views/objects/([^#]*)',
vector('path'),
1,
'/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^/db2views/objects/%U%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/db2views%%23%%3E&format=%U',
vector('path', '*accept*'),
null,
'(text/rdf.n3)|(application/rdf.xml)|(text/n3)|(application/json)',
2,
null
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_rule1',
1,
'([^#]*)',
vector('path'),
1,
'/describe/?url=http%%3A//^{URIQADefaultHost}^%U%%23this&graph=http%%3A//^{URIQADefaultHost}^/db2views%%23',
vector('path'),
null,
null,
2,
303
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_rule7',
1,
'/db2views/stat([^#]*)',
vector('path'),
1,
'/describe/?url=http%%3A//^{URIQADefaultHost}^/db2views/stat%%23&graph=http%%3A//^{URIQADefaultHost}^/db2views%%23',
vector('path'),
null,
null,
2,
303
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_rule5',
1,
'/db2views/objects/(.*)',
vector('path'),
1,
'/services/rdf/object.binary?path=%%2Fdb2views%%2Fobjects%%2F%U&accept=%U',
vector('path', '*accept*'),
null,
null,
2,
null
);
DB.DBA.URLREWRITE_CREATE_RULELIST ( 'db2views_rule_list1', 1, vector ( 'db2views_rule1', 'db2views_rule7', 'db2views_rule5', 'db2views_rule2', 'db2views_rule4', 'db2views_rule6'));
DB.DBA.VHOST_REMOVE (lpath=>'/db2views');
DB.DBA.VHOST_DEFINE (lpath=>'/db2views', ppath=>'/', vsp_user=>'dba', is_dav=>0,
is_brws=>0, opts=>vector ('url_rewrite', 'db2views_rule_list1')
);

-- Virtual directories for ontology
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_owl_rule2',
1,
'(/[^#]*)',
vector('path'),
1,
'/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/schemas/db2views%%23%%3E&format=%U',
vector('path', '*accept*'),
null,
'(text/rdf.n3)|(application/rdf.xml)|(text/n3)|(application/json)',
2,
null
);
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'db2views_owl_rule1',
1,
'([^#]*)',
vector('path'),
1,
'/describe/?url=http://^{URIQADefaultHost}^%U',
vector('path'),
null,
null,
2,
303
);
DB.DBA.URLREWRITE_CREATE_RULELIST ( 'db2views_owl_rule_list1', 1, vector ( 'db2views_owl_rule1', 'db2views_owl_rule2'));
DB.DBA.VHOST_REMOVE (lpath=>'/schemas/db2views');
DB.DBA.VHOST_DEFINE (lpath=>'/schemas/db2views', ppath=>'/', vsp_user=>'dba', is_dav=>0,
is_brws=>0, opts=>vector ('url_rewrite', 'db2views_owl_rule_list1')
);

-- TBox Mappings:

@prefix owl:<http://www.w3.org/2002/07/owl#>   .
@prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>   .
@prefix rdfs:<http://www.w3.org/2000/01/rdf-schema#>   .
@prefix xsd:<http://www.w3.org/2001/XMLSchema#>   .
@prefix aowl:<http://bblfish.net/work/atom-owl/2006-06-06/>   .
@prefix virtrdf:<http://www.openlinksw.com/schemas/virtrdf#>   .
@prefix db2views:<http://demo.openlinksw.com/schemas/db2views/>   .
@prefix foaf:<http://xmlns.com/foaf/0.1/>   .

db2views: a owl:Ontology .

# DB2.db2ma.CL_SCHED
db2views:CL_SCHED a rdfs:Class .
db2views:CL_SCHED rdfs:isDefinedBy db2views: .
db2views:CL_SCHED rdfs:label "DB2.db2ma.CL_SCHED" .
db2views:class_code a owl:DatatypeProperty .
db2views:class_code rdfs:range xsd:string .
db2views:class_code rdfs:domain db2views:CL_SCHED .
db2views:class_code rdfs:isDefinedBy db2views: .
db2views:class_code rdfs:label "CLASS_CODE" .
db2views:day a owl:DatatypeProperty .
db2views:day rdfs:range xsd:int .
db2views:day rdfs:domain db2views:CL_SCHED .
db2views:day rdfs:isDefinedBy db2views: .
db2views:day rdfs:label "DAY" .
db2views:starting a owl:DatatypeProperty .
db2views:starting rdfs:range xsd:time .
db2views:starting rdfs:domain db2views:CL_SCHED .
db2views:starting rdfs:isDefinedBy db2views: .
db2views:starting rdfs:label "STARTING" .
db2views:ending a owl:DatatypeProperty .
db2views:ending rdfs:range xsd:time .
db2views:ending rdfs:domain db2views:CL_SCHED .
db2views:ending rdfs:isDefinedBy db2views: .
db2views:ending rdfs:label "ENDING" .

# DB2.db2ma.DEPARTMENT
db2views:DEPARTMENT a rdfs:Class .
db2views:DEPARTMENT rdfs:isDefinedBy db2views: .
db2views:DEPARTMENT rdfs:label "DB2.db2ma.DEPARTMENT" .
db2views:deptno a owl:DatatypeProperty .
db2views:deptno rdfs:range xsd:string .
db2views:deptno rdfs:domain db2views:DEPARTMENT .
db2views:deptno rdfs:isDefinedBy db2views: .
db2views:deptno rdfs:label "DEPTNO" .
db2views:deptname a owl:DatatypeProperty .
db2views:deptname rdfs:range xsd:string .
db2views:deptname rdfs:domain db2views:DEPARTMENT .
db2views:deptname rdfs:isDefinedBy db2views: .
db2views:deptname rdfs:label "DEPTNAME" .
db2views:mgrno a owl:DatatypeProperty .
db2views:mgrno rdfs:range xsd:string .
db2views:mgrno rdfs:domain db2views:DEPARTMENT .
db2views:mgrno rdfs:isDefinedBy db2views: .
db2views:mgrno rdfs:label "MGRNO" .
db2views:admrdept a owl:DatatypeProperty .
db2views:admrdept rdfs:range xsd:string .
db2views:admrdept rdfs:domain db2views:DEPARTMENT .
db2views:admrdept rdfs:isDefinedBy db2views: .
db2views:admrdept rdfs:label "ADMRDEPT" .
db2views:location a owl:DatatypeProperty .
db2views:location rdfs:range xsd:string .
db2views:location rdfs:domain db2views:DEPARTMENT .
db2views:location rdfs:isDefinedBy db2views: .
db2views:location rdfs:label "LOCATION" .

# DB2.db2ma.EMPLOYEE
db2views:EMPLOYEE a rdfs:Class .
db2views:EMPLOYEE rdfs:isDefinedBy db2views: .
db2views:EMPLOYEE rdfs:label "DB2.db2ma.EMPLOYEE" .
db2views:EMPLOYEE rdfs:subClassOf foaf:Person .
db2views:empno a owl:DatatypeProperty .
db2views:empno rdfs:range xsd:string .
db2views:empno rdfs:domain db2views:EMPLOYEE .
db2views:empno rdfs:isDefinedBy db2views: .
db2views:empno rdfs:label "EMPNO" .
db2views:firstnme a owl:DatatypeProperty .
db2views:firstnme rdfs:range xsd:string .
db2views:firstnme rdfs:domain db2views:EMPLOYEE .
db2views:firstnme rdfs:isDefinedBy db2views: .
db2views:firstnme rdfs:label "FIRSTNME" .
db2views:midinit a owl:DatatypeProperty .
db2views:midinit rdfs:range xsd:string .
db2views:midinit rdfs:domain db2views:EMPLOYEE .
db2views:midinit rdfs:isDefinedBy db2views: .
db2views:midinit rdfs:label "MIDINIT" .
db2views:lastname a owl:DatatypeProperty .
db2views:lastname rdfs:range xsd:string .
db2views:lastname rdfs:domain db2views:EMPLOYEE .
db2views:lastname rdfs:isDefinedBy db2views: .
db2views:lastname rdfs:label "LASTNAME" .
db2views:workdept a owl:DatatypeProperty .
db2views:workdept rdfs:range xsd:string .
db2views:workdept rdfs:domain db2views:EMPLOYEE .
db2views:workdept rdfs:isDefinedBy db2views: .
db2views:workdept rdfs:label "WORKDEPT" .
db2views:phoneno a owl:DatatypeProperty .
db2views:phoneno rdfs:range xsd:string .
db2views:phoneno rdfs:domain db2views:EMPLOYEE .
db2views:phoneno rdfs:isDefinedBy db2views: .
db2views:phoneno rdfs:label "PHONENO" .
db2views:hiredate a owl:DatatypeProperty .
db2views:hiredate rdfs:range xsd:date .
db2views:hiredate rdfs:domain db2views:EMPLOYEE .
db2views:hiredate rdfs:isDefinedBy db2views: .
db2views:hiredate rdfs:label "HIREDATE" .
db2views:job a owl:DatatypeProperty .
db2views:job rdfs:range xsd:string .
db2views:job rdfs:domain db2views:EMPLOYEE .
db2views:job rdfs:isDefinedBy db2views: .
db2views:job rdfs:label "JOB" .
db2views:edlevel a owl:DatatypeProperty .
db2views:edlevel rdfs:range xsd:int .
db2views:edlevel rdfs:domain db2views:EMPLOYEE .
db2views:edlevel rdfs:isDefinedBy db2views: .
db2views:edlevel rdfs:label "EDLEVEL" .
db2views:sex a owl:DatatypeProperty .
db2views:sex rdfs:range xsd:string .
db2views:sex rdfs:domain db2views:EMPLOYEE .
db2views:sex rdfs:isDefinedBy db2views: .
db2views:sex rdfs:label "SEX" .
db2views:birthdate a owl:DatatypeProperty .
db2views:birthdate rdfs:range xsd:date .
db2views:birthdate rdfs:domain db2views:EMPLOYEE .
db2views:birthdate rdfs:isDefinedBy db2views: .
db2views:birthdate rdfs:label "BIRTHDATE" .
db2views:salary a owl:DatatypeProperty .
db2views:salary rdfs:range xsd:numeric .
db2views:salary rdfs:domain db2views:EMPLOYEE .
db2views:salary rdfs:isDefinedBy db2views: .
db2views:salary rdfs:label "SALARY" .
db2views:bonus a owl:DatatypeProperty .
db2views:bonus rdfs:range xsd:numeric .
db2views:bonus rdfs:domain db2views:EMPLOYEE .
db2views:bonus rdfs:isDefinedBy db2views: .
db2views:bonus rdfs:label "BONUS" .
db2views:comm a owl:DatatypeProperty .
db2views:comm rdfs:range xsd:numeric .
db2views:comm rdfs:domain db2views:EMPLOYEE .
db2views:comm rdfs:isDefinedBy db2views: .
db2views:comm rdfs:label "COMM" .

# DB2.db2ma.EMP_ACT
db2views:EMP_ACT a rdfs:Class .
db2views:EMP_ACT rdfs:isDefinedBy db2views: .
db2views:EMP_ACT rdfs:label "DB2.db2ma.EMP_ACT" .
db2views:empno a owl:DatatypeProperty .
db2views:empno rdfs:range xsd:string .
db2views:empno rdfs:domain db2views:EMP_ACT .
db2views:empno rdfs:isDefinedBy db2views: .
db2views:empno rdfs:label "EMPNO" .
db2views:projno a owl:DatatypeProperty .
db2views:projno rdfs:range xsd:string .
db2views:projno rdfs:domain db2views:EMP_ACT .
db2views:projno rdfs:isDefinedBy db2views: .
db2views:projno rdfs:label "PROJNO" .
db2views:actno a owl:DatatypeProperty .
db2views:actno rdfs:range xsd:int .
db2views:actno rdfs:domain db2views:EMP_ACT .
db2views:actno rdfs:isDefinedBy db2views: .
db2views:actno rdfs:label "ACTNO" .
db2views:emptime a owl:DatatypeProperty .
db2views:emptime rdfs:range xsd:numeric .
db2views:emptime rdfs:domain db2views:EMP_ACT .
db2views:emptime rdfs:isDefinedBy db2views: .
db2views:emptime rdfs:label "EMPTIME" .
db2views:emstdate a owl:DatatypeProperty .
db2views:emstdate rdfs:range xsd:date .
db2views:emstdate rdfs:domain db2views:EMP_ACT .
db2views:emstdate rdfs:isDefinedBy db2views: .
db2views:emstdate rdfs:label "EMSTDATE" .
db2views:emendate a owl:DatatypeProperty .
db2views:emendate rdfs:range xsd:date .
db2views:emendate rdfs:domain db2views:EMP_ACT .
db2views:emendate rdfs:isDefinedBy db2views: .
db2views:emendate rdfs:label "EMENDATE" .

# DB2.db2ma.EMP_PHOTO
db2views:EMP_PHOTO a rdfs:Class .
db2views:EMP_PHOTO rdfs:isDefinedBy db2views: .
db2views:EMP_PHOTO rdfs:label "DB2.db2ma.EMP_PHOTO" .
db2views:empno a owl:DatatypeProperty .
db2views:empno rdfs:range xsd:string .
db2views:empno rdfs:domain db2views:EMP_PHOTO .
db2views:empno rdfs:isDefinedBy db2views: .
db2views:empno rdfs:label "EMPNO" .
db2views:photo_format a owl:DatatypeProperty .
db2views:photo_format rdfs:range xsd:string .
db2views:photo_format rdfs:domain db2views:EMP_PHOTO .
db2views:photo_format rdfs:isDefinedBy db2views: .
db2views:photo_format rdfs:label "PHOTO_FORMAT" .
db2views:picture a owl:ObjectProperty .
db2views:picture rdfs:range aowl:Content .
db2views:picture rdfs:domain db2views:EMP_PHOTO .
db2views:picture rdfs:isDefinedBy db2views: .
db2views:picture rdfs:label "PICTURE" .

# DB2.db2ma.EMP_RESUME
db2views:EMP_RESUME a rdfs:Class .
db2views:EMP_RESUME rdfs:isDefinedBy db2views: .
db2views:EMP_RESUME rdfs:label "DB2.db2ma.EMP_RESUME" .
db2views:empno a owl:DatatypeProperty .
db2views:empno rdfs:range xsd:string .
db2views:empno rdfs:domain db2views:EMP_RESUME .
db2views:empno rdfs:isDefinedBy db2views: .
db2views:empno rdfs:label "EMPNO" .
db2views:resume_format a owl:DatatypeProperty .
db2views:resume_format rdfs:range xsd:string .
db2views:resume_format rdfs:domain db2views:EMP_RESUME .
db2views:resume_format rdfs:isDefinedBy db2views: .
db2views:resume_format rdfs:label "RESUME_FORMAT" .
db2views:resume a owl:DatatypeProperty .
db2views:resume rdfs:range xsd:string .
db2views:resume rdfs:domain db2views:EMP_RESUME .
db2views:resume rdfs:isDefinedBy db2views: .
db2views:resume rdfs:label "RESUME" .

# DB2.db2ma.IN_TRAY
db2views:IN_TRAY a rdfs:Class .
db2views:IN_TRAY rdfs:isDefinedBy db2views: .
db2views:IN_TRAY rdfs:label "DB2.db2ma.IN_TRAY" .
db2views:received a owl:DatatypeProperty .
db2views:received rdfs:range xsd:dateTime .
db2views:received rdfs:domain db2views:IN_TRAY .
db2views:received rdfs:isDefinedBy db2views: .
db2views:received rdfs:label "RECEIVED" .
db2views:source a owl:DatatypeProperty .
db2views:source rdfs:range xsd:string .
db2views:source rdfs:domain db2views:IN_TRAY .
db2views:source rdfs:isDefinedBy db2views: .
db2views:source rdfs:label "SOURCE" .
db2views:subject a owl:DatatypeProperty .
db2views:subject rdfs:range xsd:string .
db2views:subject rdfs:domain db2views:IN_TRAY .
db2views:subject rdfs:isDefinedBy db2views: .
db2views:subject rdfs:label "SUBJECT" .
db2views:note_text a owl:DatatypeProperty .
db2views:note_text rdfs:range xsd:string .
db2views:note_text rdfs:domain db2views:IN_TRAY .
db2views:note_text rdfs:isDefinedBy db2views: .
db2views:note_text rdfs:label "NOTE_TEXT" .

# DB2.db2ma.ORG
db2views:ORG a rdfs:Class .
db2views:ORG rdfs:isDefinedBy db2views: .
db2views:ORG rdfs:label "DB2.db2ma.ORG" .
db2views:deptnumb a owl:DatatypeProperty .
db2views:deptnumb rdfs:range xsd:int .
db2views:deptnumb rdfs:domain db2views:ORG .
db2views:deptnumb rdfs:isDefinedBy db2views: .
db2views:deptnumb rdfs:label "DEPTNUMB" .
db2views:deptname a owl:DatatypeProperty .
db2views:deptname rdfs:range xsd:string .
db2views:deptname rdfs:domain db2views:ORG .
db2views:deptname rdfs:isDefinedBy db2views: .
db2views:deptname rdfs:label "DEPTNAME" .
db2views:manager a owl:DatatypeProperty .
db2views:manager rdfs:range xsd:int .
db2views:manager rdfs:domain db2views:ORG .
db2views:manager rdfs:isDefinedBy db2views: .
db2views:manager rdfs:label "MANAGER" .
db2views:division a owl:DatatypeProperty .
db2views:division rdfs:range xsd:string .
db2views:division rdfs:domain db2views:ORG .
db2views:division rdfs:isDefinedBy db2views: .
db2views:division rdfs:label "DIVISION" .
db2views:location a owl:DatatypeProperty .
db2views:location rdfs:range xsd:string .
db2views:location rdfs:domain db2views:ORG .
db2views:location rdfs:isDefinedBy db2views: .
db2views:location rdfs:label "LOCATION" .

# DB2.db2ma.PROJECT
db2views:PROJECT a rdfs:Class .
db2views:PROJECT rdfs:isDefinedBy db2views: .
db2views:PROJECT rdfs:label "DB2.db2ma.PROJECT" .
db2views:projno a owl:DatatypeProperty .
db2views:projno rdfs:range xsd:string .
db2views:projno rdfs:domain db2views:PROJECT .
db2views:projno rdfs:isDefinedBy db2views: .
db2views:projno rdfs:label "PROJNO" .
db2views:projname a owl:DatatypeProperty .
db2views:projname rdfs:range xsd:string .
db2views:projname rdfs:domain db2views:PROJECT .
db2views:projname rdfs:isDefinedBy db2views: .
db2views:projname rdfs:label "PROJNAME" .
db2views:deptno a owl:DatatypeProperty .
db2views:deptno rdfs:range xsd:string .
db2views:deptno rdfs:domain db2views:PROJECT .
db2views:deptno rdfs:isDefinedBy db2views: .
db2views:deptno rdfs:label "DEPTNO" .
db2views:respemp a owl:DatatypeProperty .
db2views:respemp rdfs:range xsd:string .
db2views:respemp rdfs:domain db2views:PROJECT .
db2views:respemp rdfs:isDefinedBy db2views: .
db2views:respemp rdfs:label "RESPEMP" .
db2views:prstaff a owl:DatatypeProperty .
db2views:prstaff rdfs:range xsd:numeric .
db2views:prstaff rdfs:domain db2views:PROJECT .
db2views:prstaff rdfs:isDefinedBy db2views: .
db2views:prstaff rdfs:label "PRSTAFF" .
db2views:prstdate a owl:DatatypeProperty .
db2views:prstdate rdfs:range xsd:date .
db2views:prstdate rdfs:domain db2views:PROJECT .
db2views:prstdate rdfs:isDefinedBy db2views: .
db2views:prstdate rdfs:label "PRSTDATE" .
db2views:prendate a owl:DatatypeProperty .
db2views:prendate rdfs:range xsd:date .
db2views:prendate rdfs:domain db2views:PROJECT .
db2views:prendate rdfs:isDefinedBy db2views: .
db2views:prendate rdfs:label "PRENDATE" .
db2views:majproj a owl:DatatypeProperty .
db2views:majproj rdfs:range xsd:string .
db2views:majproj rdfs:domain db2views:PROJECT .
db2views:majproj rdfs:isDefinedBy db2views: .
db2views:majproj rdfs:label "MAJPROJ" .

# DB2.db2ma.SALES
db2views:SALES a rdfs:Class .
db2views:SALES rdfs:isDefinedBy db2views: .
db2views:SALES rdfs:label "DB2.db2ma.SALES" .
db2views:sales_date a owl:DatatypeProperty .
db2views:sales_date rdfs:range xsd:date .
db2views:sales_date rdfs:domain db2views:SALES .
db2views:sales_date rdfs:isDefinedBy db2views: .
db2views:sales_date rdfs:label "SALES_DATE" .
db2views:sales_person a owl:DatatypeProperty .
db2views:sales_person rdfs:range xsd:string .
db2views:sales_person rdfs:domain db2views:SALES .
db2views:sales_person rdfs:isDefinedBy db2views: .
db2views:sales_person rdfs:label "SALES_PERSON" .
db2views:region a owl:DatatypeProperty .
db2views:region rdfs:range xsd:string .
db2views:region rdfs:domain db2views:SALES .
db2views:region rdfs:isDefinedBy db2views: .
db2views:region rdfs:label "REGION" .
db2views:sales a owl:DatatypeProperty .
db2views:sales rdfs:range xsd:int .
db2views:sales rdfs:domain db2views:SALES .
db2views:sales rdfs:isDefinedBy db2views: .
db2views:sales rdfs:label "SALES" .

# DB2.db2ma.STAFF
db2views:STAFF a rdfs:Class .
db2views:STAFF rdfs:isDefinedBy db2views: .
db2views:STAFF rdfs:label "DB2.db2ma.STAFF" .
db2views:id a owl:DatatypeProperty .
db2views:id rdfs:range xsd:int .
db2views:id rdfs:domain db2views:STAFF .
db2views:id rdfs:isDefinedBy db2views: .
db2views:id rdfs:label "ID" .
db2views:name a owl:DatatypeProperty .
db2views:name rdfs:range xsd:string .
db2views:name rdfs:domain db2views:STAFF .
db2views:name rdfs:isDefinedBy db2views: .
db2views:name rdfs:label "NAME" .
db2views:dept a owl:DatatypeProperty .
db2views:dept rdfs:range xsd:int .
db2views:dept rdfs:domain db2views:STAFF .
db2views:dept rdfs:isDefinedBy db2views: .
db2views:dept rdfs:label "DEPT" .
db2views:job a owl:DatatypeProperty .
db2views:job rdfs:range xsd:string .
db2views:job rdfs:domain db2views:STAFF .
db2views:job rdfs:isDefinedBy db2views: .
db2views:job rdfs:label "JOB" .
db2views:years a owl:DatatypeProperty .
db2views:years rdfs:range xsd:int .
db2views:years rdfs:domain db2views:STAFF .
db2views:years rdfs:isDefinedBy db2views: .
db2views:years rdfs:label "YEARS" .
db2views:salary a owl:DatatypeProperty .
db2views:salary rdfs:range xsd:numeric .
db2views:salary rdfs:domain db2views:STAFF .
db2views:salary rdfs:isDefinedBy db2views: .
db2views:salary rdfs:label "SALARY" .
db2views:comm a owl:DatatypeProperty .
db2views:comm rdfs:range xsd:numeric .
db2views:comm rdfs:domain db2views:STAFF .
db2views:comm rdfs:isDefinedBy db2views: .
db2views:comm rdfs:label "COMM" .

Related

• Troubleshooting Linked Data Views generated from a Relational Database
• Virtuoso Tips and Tricks Collection
• "Generate RDB2RDF triggers" and "Enable Data Syncs with Physical Quad Store" Linked Data Views options
• Generate Transient and/or Persistent Linked Data Views atop ODBC or JDBC accessible Relational Data Sources
• Using OWL based inference to exploit the power of Linked Vocabularies
• Import Linked Data using the Briefcase "Create" feature
• Simple Linked Data Deployment using Virtuoso's HTTP Re-write Rules
• Reification alternatives usage for Linked Data publishing
• Virtuoso Linked Data Deployment In 3 Simple Steps
• Expose Linked Data View URIs associated with "References" on a given Table
• Manage Linked (Open) Data