VirtTipsAndTricksLinkedDataViewsDB2ScriptScript for building Linked Data Views for the DB2 tablesScript 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