%META:TOPICPARENT{name="VirtTipsAndTricksGuideTrblLinkedDataViews"}% ---+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: create iri class db2views:cl_sched "http://^{URIQADefaultHost}^/db2views/cl_sched/CLASS_CODE/%U#this" (in _CLASS_CODE varchar not null) . ; SPARQL prefix db2views: create iri class db2views:department "http://^{URIQADefaultHost}^/db2views/department/DEPTNO/%U#this" (in _DEPTNO varchar not null) . ; SPARQL prefix db2views: create iri class db2views:employee "http://^{URIQADefaultHost}^/db2views/employee/EMPNO/%U#this" (in _EMPNO varchar not null) . ; SPARQL prefix 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: 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: 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: 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: 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: 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: create iri class db2views:project "http://^{URIQADefaultHost}^/db2views/project/PROJNO/%U#this" (in _PROJNO varchar not null) . ; SPARQL prefix 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: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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: prefix db2views-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: prefix foaf: 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 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: . @prefix rdf: . @prefix rdfs: . @prefix xsd: . @prefix aowl: . @prefix virtrdf: . @prefix db2views: . @prefix foaf: . 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 * [[VirtTipsAndTricksGuideTrblLinkedDataViews][Troubleshooting Linked Data Views generated from a Relational Database]] * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[VirtTipsAndTricksRDFTriggers]["Generate RDB2RDF triggers" and "Enable Data Syncs with Physical Quad Store" Linked Data Views options]] * [[VirtTipsAndTricksGuideConductorR2RML][Generate Transient and/or Persistent Linked Data Views atop ODBC or JDBC accessible Relational Data Sources]] * [[VirtTipsAndTricksGuideOWLIinfLinkedVocab][Using OWL based inference to exploit the power of Linked Vocabularies]] * [[VirtTipsAndTricksImportLinkedDataCreateFeature][Import Linked Data using the Briefcase "Create" feature]] * [[VirtTipsAndTricksInstallPattern][Simple Linked Data Deployment using Virtuoso's HTTP Re-write Rules]] * [[VirtTipsAndTricksGuideReificationAltern][Reification alternatives usage for Linked Data publishing]] * [[VirtTipsAndTricksGuideLinkedDataSimpleGuide][Virtuoso Linked Data Deployment In 3 Simple Steps]] * [[VirtXMLAODBCExplorerLinkedDataViews][Expose Linked Data View URIs associated with "References" on a given Table]] * [[VirtLinkedDataPresCollection][Manage Linked (Open) Data]]