grant select on "db2"."demo"."ACT" to SPARQL_SELECT; grant select on "db2"."demo"."CATALOG" to SPARQL_SELECT; grant select on "db2"."demo"."CL_SCHED" to SPARQL_SELECT; grant select on "db2"."demo"."CUSTOMER" to SPARQL_SELECT; grant select on "db2"."demo"."DEPARTMENT" to SPARQL_SELECT; grant select on "db2"."demo"."EMPLOYEE" to SPARQL_SELECT; grant select on "db2"."demo"."EMPMDC" to SPARQL_SELECT; grant select on "db2"."demo"."EMPPROJACT" to SPARQL_SELECT; grant select on "db2"."demo"."EMP_PHOTO" to SPARQL_SELECT; grant select on "db2"."demo"."EMP_RESUME" to SPARQL_SELECT; grant select on "db2"."demo"."INVENTORY" to SPARQL_SELECT; grant select on "db2"."demo"."IN_TRAY" to SPARQL_SELECT; SPARQL prefix DB: create iri class DB:act "http://^{URIQADefaultHost}^/DB/act/ACTNO/%d#this" (in _ACTNO integer not null) . ; SPARQL prefix DB: create iri class DB:catalog "http://^{URIQADefaultHost}^/DB/catalog/NAME/%U#this" (in _NAME varchar not null) . ; SPARQL prefix DB: create iri class DB:cl_sched "http://^{URIQADefaultHost}^/DB/cl_sched/CLASS_CODE/%U#this" (in _CLASS_CODE varchar not null) . ; SPARQL prefix DB: create iri class DB:customer "http://^{URIQADefaultHost}^/DB/customer/CID/%d#this" (in _CID numeric not null) . ; SPARQL prefix DB: create iri class DB:department "http://^{URIQADefaultHost}^/DB/department/DEPTNO/%U#this" (in _DEPTNO varchar not null) . ; SPARQL prefix DB: create iri class DB:employee "http://^{URIQADefaultHost}^/DB/employee/EMPNO/%U#this" (in _EMPNO varchar not null) . ; SPARQL prefix DB: create iri class DB:empmdc "http://^{URIQADefaultHost}^/DB/empmdc/EMPNO/%d/DEPT/%d/DIV/%d#this" (in _EMPNO integer not null,in _DEPT integer not null,in _DIV integer not null) . ; SPARQL prefix DB: create iri class DB:empprojact "http://^{URIQADefaultHost}^/DB/empprojact/EMPNO/%U/PROJNO/%U/ACTNO/%d#this" (in _EMPNO varchar not null,in _PROJNO varchar not null,in _ACTNO integer not null) . ; SPARQL prefix DB: create iri class DB:emp_photo "http://^{URIQADefaultHost}^/DB/emp_photo/EMPNO/%U/PHOTO_FORMAT/%U#this" (in _EMPNO varchar not null,in _PHOTO_FORMAT varchar not null) . ; SPARQL prefix DB: create iri class DB:emp_photo_picture "http://^{URIQADefaultHost}^/DB/objects/emp_photo/EMPNO/%U/PHOTO_FORMAT/%U/PICTURE.jpe" (in _EMPNO varchar not null,in _PHOTO_FORMAT varchar not null) . ; SPARQL prefix DB: create iri class DB:emp_resume "http://^{URIQADefaultHost}^/DB/emp_resume/EMPNO/%U/RESUME_FORMAT/%U#this" (in _EMPNO varchar not null,in _RESUME_FORMAT varchar not null) . ; SPARQL prefix DB: create iri class DB:inventory "http://^{URIQADefaultHost}^/DB/inventory/PID/%U#this" (in _PID varchar not null) . ; SPARQL prefix DB: create iri class DB:in_tray "http://^{URIQADefaultHost}^/DB/in_tray/RECEIVED/%U/SOURCE/%U/SUBJECT/%U#this" (in _RECEIVED varchar not null,in _SOURCE varchar not null,in _SUBJECT varchar not null) . ; create view "db2"."demo"."ACTCount" as select count (*) as cnt from "db2"."demo"."ACT"; grant select on "db2"."demo"."ACTCount" to SPARQL_SELECT; create view "db2"."demo"."CATALOGCount" as select count (*) as cnt from "db2"."demo"."CATALOG"; grant select on "db2"."demo"."CATALOGCount" to SPARQL_SELECT; create view "db2"."demo"."CL_SCHEDCount" as select count (*) as cnt from "db2"."demo"."CL_SCHED"; grant select on "db2"."demo"."CL_SCHEDCount" to SPARQL_SELECT; create view "db2"."demo"."CUSTOMERCount" as select count (*) as cnt from "db2"."demo"."CUSTOMER"; grant select on "db2"."demo"."CUSTOMERCount" to SPARQL_SELECT; create view "db2"."demo"."DEPARTMENTCount" as select count (*) as cnt from "db2"."demo"."DEPARTMENT"; grant select on "db2"."demo"."DEPARTMENTCount" to SPARQL_SELECT; create view "db2"."demo"."EMPLOYEECount" as select count (*) as cnt from "db2"."demo"."EMPLOYEE"; grant select on "db2"."demo"."EMPLOYEECount" to SPARQL_SELECT; create view "db2"."demo"."EMPMDCCount" as select count (*) as cnt from "db2"."demo"."EMPMDC"; grant select on "db2"."demo"."EMPMDCCount" to SPARQL_SELECT; create view "db2"."demo"."EMPPROJACTCount" as select count (*) as cnt from "db2"."demo"."EMPPROJACT"; grant select on "db2"."demo"."EMPPROJACTCount" to SPARQL_SELECT; create view "db2"."demo"."EMP_PHOTOCount" as select count (*) as cnt from "db2"."demo"."EMP_PHOTO"; grant select on "db2"."demo"."EMP_PHOTOCount" to SPARQL_SELECT; create view "db2"."demo"."EMP_RESUMECount" as select count (*) as cnt from "db2"."demo"."EMP_RESUME"; grant select on "db2"."demo"."EMP_RESUMECount" to SPARQL_SELECT; create view "db2"."demo"."INVENTORYCount" as select count (*) as cnt from "db2"."demo"."INVENTORY"; grant select on "db2"."demo"."INVENTORYCount" to SPARQL_SELECT; create view "db2"."demo"."IN_TRAYCount" as select count (*) as cnt from "db2"."demo"."IN_TRAY"; grant select on "db2"."demo"."IN_TRAYCount" to SPARQL_SELECT; drop view "db2"."demo"."DB__Total"; create view "db2"."demo"."DB__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)+(cnt22*cnt23) AS cnt from (select count(*) cnt0 from "db2"."demo"."ACT") tb0, (select count(*)+1 as cnt1 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.ACT' and "COLUMN" <> '_IDN') tb1, (select count(*) cnt2 from "db2"."demo"."CATALOG") tb2, (select count(*)+1 as cnt3 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.CATALOG' and "COLUMN" <> '_IDN') tb3, (select count(*) cnt4 from "db2"."demo"."CL_SCHED") tb4, (select count(*)+1 as cnt5 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.CL_SCHED' and "COLUMN" <> '_IDN') tb5, (select count(*) cnt6 from "db2"."demo"."CUSTOMER") tb6, (select count(*)+1 as cnt7 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.CUSTOMER' and "COLUMN" <> '_IDN') tb7, (select count(*) cnt8 from "db2"."demo"."DEPARTMENT") tb8, (select count(*)+1 as cnt9 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.DEPARTMENT' and "COLUMN" <> '_IDN') tb9, (select count(*) cnt10 from "db2"."demo"."EMPLOYEE") tb10, (select count(*)+1 as cnt11 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.EMPLOYEE' and "COLUMN" <> '_IDN') tb11, (select count(*) cnt12 from "db2"."demo"."EMPMDC") tb12, (select count(*)+1 as cnt13 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.EMPMDC' and "COLUMN" <> '_IDN') tb13, (select count(*) cnt14 from "db2"."demo"."EMPPROJACT") tb14, (select count(*)+1 as cnt15 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.EMPPROJACT' and "COLUMN" <> '_IDN') tb15, (select count(*) cnt16 from "db2"."demo"."EMP_PHOTO") tb16, (select count(*)+1 as cnt17 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.EMP_PHOTO' and "COLUMN" <> '_IDN') tb17, (select count(*) cnt18 from "db2"."demo"."EMP_RESUME") tb18, (select count(*)+1 as cnt19 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.EMP_RESUME' and "COLUMN" <> '_IDN') tb19, (select count(*) cnt20 from "db2"."demo"."INVENTORY") tb20, (select count(*)+1 as cnt21 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.INVENTORY' and "COLUMN" <> '_IDN') tb21, (select count(*) cnt22 from "db2"."demo"."IN_TRAY") tb22, (select count(*)+1 as cnt23 from DB.DBA.TABLE_COLS where "TABLE" = 'db2.demo.IN_TRAY' and "COLUMN" <> '_IDN') tb23 ; grant select on "db2"."demo"."DB__Total" to SPARQL_SELECT; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."ACT" as act_s { create DB:qm-act as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.ACT" DB:act (act_s."ACTNO") a DB:ACT ; DB:actno act_s."ACTNO" as DB:demo-act-actno ; DB:actkwd act_s."ACTKWD" as DB:demo-act-actkwd ; DB:actdesc act_s."ACTDESC" as DB:demo-act-actdesc . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."CATALOG" as catalog_s { create DB:qm-catalog as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.CATALOG" DB:catalog (catalog_s."NAME") a DB:CATALOG ; DB:name catalog_s."NAME" as DB:demo-catalog-name ; DB:catlog catalog_s."CATLOG" as DB:demo-catalog-catlog . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."CL_SCHED" as cl_sched_s { create DB:qm-cl_sched as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.CL_SCHED" DB:cl_sched (cl_sched_s."CLASS_CODE") a DB:CL_SCHED ; DB:class_code cl_sched_s."CLASS_CODE" as DB:demo-cl_sched-class_code ; DB:day cl_sched_s."DAY" as DB:demo-cl_sched-day ; DB:starting cl_sched_s."STARTING" as DB:demo-cl_sched-starting ; DB:ending cl_sched_s."ENDING" as DB:demo-cl_sched-ending . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."CUSTOMER" as customer_s { create DB:qm-customer as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.CUSTOMER" DB:customer (customer_s."CID") a DB:CUSTOMER ; DB:cid customer_s."CID" as DB:demo-customer-cid ; DB:info customer_s."INFO" as DB:demo-customer-info ; DB:history customer_s."HISTORY" as DB:demo-customer-history . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."DEPARTMENT" as department_s from "db2"."demo"."EMPLOYEE" as employee_s where (^{department_s.}^."MGRNO" = ^{employee_s.}^."EMPNO") where (^{employee_s.}^."WORKDEPT" = ^{department_s.}^."DEPTNO") { create DB:qm-department as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.DEPARTMENT" DB:department (department_s."DEPTNO") a DB:DEPARTMENT ; DB:deptno department_s."DEPTNO" as DB:demo-department-deptno ; DB:deptname department_s."DEPTNAME" as DB:demo-department-deptname ; DB:mgrno department_s."MGRNO" as DB:demo-department-mgrno ; DB:admrdept department_s."ADMRDEPT" as DB:demo-department-admrdept ; DB:location department_s."LOCATION" as DB:demo-department-location ; # Maps from foreign-key relations of "db2.demo.DEPARTMENT" DB:has_employee DB:employee (employee_s."EMPNO") as DB:department_has_employee ; DB:department_of DB:employee (employee_s."EMPNO") as DB:department_employee_of . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."EMPLOYEE" as employee_s from "db2"."demo"."DEPARTMENT" as department_s where (^{department_s.}^."MGRNO" = ^{employee_s.}^."EMPNO") where (^{employee_s.}^."WORKDEPT" = ^{department_s.}^."DEPTNO") from "db2"."demo"."EMP_PHOTO" as emp_photo_s where (^{emp_photo_s.}^."EMPNO" = ^{employee_s.}^."EMPNO") from "db2"."demo"."EMP_RESUME" as emp_resume_s where (^{emp_resume_s.}^."EMPNO" = ^{employee_s.}^."EMPNO") { create DB:qm-employee as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.EMPLOYEE" DB:employee (employee_s."EMPNO") a DB:EMPLOYEE ; DB:empno employee_s."EMPNO" as DB:demo-employee-empno ; DB:firstnme employee_s."FIRSTNME" as DB:demo-employee-firstnme ; DB:midinit employee_s."MIDINIT" as DB:demo-employee-midinit ; DB:lastname employee_s."LASTNAME" as DB:demo-employee-lastname ; DB:workdept employee_s."WORKDEPT" as DB:demo-employee-workdept ; DB:phoneno employee_s."PHONENO" as DB:demo-employee-phoneno ; DB:hiredate employee_s."HIREDATE" as DB:demo-employee-hiredate ; DB:job employee_s."JOB" as DB:demo-employee-job ; DB:edlevel employee_s."EDLEVEL" as DB:demo-employee-edlevel ; DB:sex employee_s."SEX" as DB:demo-employee-sex ; DB:birthdate employee_s."BIRTHDATE" as DB:demo-employee-birthdate ; DB:salary employee_s."SALARY" as DB:demo-employee-salary ; DB:bonus employee_s."BONUS" as DB:demo-employee-bonus ; DB:comm employee_s."COMM" as DB:demo-employee-comm ; # Maps from foreign-key relations of "db2.demo.EMPLOYEE" DB:has_department DB:department (department_s."DEPTNO") as DB:employee_has_department ; DB:employee_of DB:department (department_s."DEPTNO") as DB:employee_department_of ; DB:employee_of DB:emp_photo (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT") as DB:employee_emp_photo_of ; DB:employee_of DB:emp_resume (emp_resume_s."EMPNO",emp_resume_s."RESUME_FORMAT") as DB:employee_emp_resume_of . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."EMPMDC" as empmdc_s { create DB:qm-empmdc as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.EMPMDC" DB:empmdc (empmdc_s."EMPNO",empmdc_s."DEPT",empmdc_s."DIV") a DB:EMPMDC ; DB:empno empmdc_s."EMPNO" as DB:demo-empmdc-empno ; DB:dept empmdc_s."DEPT" as DB:demo-empmdc-dept ; DB:div empmdc_s."DIV" as DB:demo-empmdc-div . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."EMPPROJACT" as empprojact_s { create DB:qm-empprojact as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.EMPPROJACT" DB:empprojact (empprojact_s."EMPNO",empprojact_s."PROJNO",empprojact_s."ACTNO") a DB:EMPPROJACT ; DB:empno empprojact_s."EMPNO" as DB:demo-empprojact-empno ; DB:projno empprojact_s."PROJNO" as DB:demo-empprojact-projno ; DB:actno empprojact_s."ACTNO" as DB:demo-empprojact-actno ; DB:emptime empprojact_s."EMPTIME" as DB:demo-empprojact-emptime ; DB:emstdate empprojact_s."EMSTDATE" as DB:demo-empprojact-emstdate ; DB:emendate empprojact_s."EMENDATE" as DB:demo-empprojact-emendate . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."EMP_PHOTO" as emp_photo_s from "db2"."demo"."EMPLOYEE" as employee_s where (^{emp_photo_s.}^."EMPNO" = ^{employee_s.}^."EMPNO") { create DB:qm-emp_photo as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.EMP_PHOTO" DB:emp_photo (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT") a DB:EMP_PHOTO ; DB:empno emp_photo_s."EMPNO" as DB:demo-emp_photo-empno ; DB:photo_format emp_photo_s."PHOTO_FORMAT" as DB:demo-emp_photo-photo_format ; DB:picture DB:emp_photo_picture (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT") as DB:demo-emp_photo-picture ; # Maps from foreign-key relations of "db2.demo.EMP_PHOTO" DB:has_employee DB:employee (employee_s."EMPNO") as DB:emp_photo_has_employee . DB:emp_photo_picture (emp_photo_s."EMPNO",emp_photo_s."PHOTO_FORMAT") a aowl:Content ; aowl:body emp_photo_s."PICTURE" as DB:demo-emp_photo-picture-content ; aowl:type "image/jpeg" . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."EMP_RESUME" as emp_resume_s from "db2"."demo"."EMPLOYEE" as employee_s where (^{emp_resume_s.}^."EMPNO" = ^{employee_s.}^."EMPNO") { create DB:qm-emp_resume as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.EMP_RESUME" DB:emp_resume (emp_resume_s."EMPNO",emp_resume_s."RESUME_FORMAT") a DB:EMP_RESUME ; DB:empno emp_resume_s."EMPNO" as DB:demo-emp_resume-empno ; DB:resume_format emp_resume_s."RESUME_FORMAT" as DB:demo-emp_resume-resume_format ; DB:resume emp_resume_s."RESUME" as DB:demo-emp_resume-resume ; # Maps from foreign-key relations of "db2.demo.EMP_RESUME" DB:has_employee DB:employee (employee_s."EMPNO") as DB:emp_resume_has_employee . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."INVENTORY" as inventory_s { create DB:qm-inventory as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.INVENTORY" DB:inventory (inventory_s."PID") a DB:INVENTORY ; DB:pid inventory_s."PID" as DB:demo-inventory-pid ; DB:quantity inventory_s."QUANTITY" as DB:demo-inventory-quantity ; DB:location inventory_s."LOCATION" as DB:demo-inventory-location . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."IN_TRAY" as in_tray_s { create DB:qm-in_tray as graph iri ("http://^{URIQADefaultHost}^/DB#") { # Maps from columns of "db2.demo.IN_TRAY" DB:in_tray (in_tray_s."RECEIVED",in_tray_s."SOURCE",in_tray_s."SUBJECT") a DB:IN_TRAY ; DB:received in_tray_s."RECEIVED" as DB:demo-in_tray-received ; DB:source in_tray_s."SOURCE" as DB:demo-in_tray-source ; DB:subject in_tray_s."SUBJECT" as DB:demo-in_tray-subject ; DB:note_text in_tray_s."NOTE_TEXT" as DB:demo-in_tray-note_text . } } ; SPARQL prefix DB: prefix db-stat: prefix rdf: prefix void: prefix scovo: prefix aowl: alter quad storage virtrdf:DefaultQuadStorage from "db2"."demo"."ACTCount" as actcount_s from "db2"."demo"."CATALOGCount" as catalogcount_s from "db2"."demo"."CL_SCHEDCount" as cl_schedcount_s from "db2"."demo"."CUSTOMERCount" as customercount_s from "db2"."demo"."DEPARTMENTCount" as departmentcount_s from "db2"."demo"."EMPLOYEECount" as employeecount_s from "db2"."demo"."EMPMDCCount" as empmdccount_s from "db2"."demo"."EMPPROJACTCount" as empprojactcount_s from "db2"."demo"."EMP_PHOTOCount" as emp_photocount_s from "db2"."demo"."EMP_RESUMECount" as emp_resumecount_s from "db2"."demo"."INVENTORYCount" as inventorycount_s from "db2"."demo"."IN_TRAYCount" as in_traycount_s from "db2"."demo"."DB__Total" as db__total_s { create DB:qm-VoidStatistics as graph iri ("http://^{URIQADefaultHost}^/DB#") option (exclusive) { # voID Statistics db-stat: a void:Dataset as DB:dataset-db2 ; void:sparqlEndpoint as DB:dataset-sparql-db2 ; void:statItem db-stat:Stat . db-stat:Stat a scovo:Item ; rdf:value db__total_s.cnt as DB:stat-decl-db2 ; scovo:dimension void:numOfTriples . db-stat: void:statItem db-stat:ACTStat as DB:statitem-db2-act . db-stat:ACTStat a scovo:Item as DB:statitem-decl-db2-act ; rdf:value actcount_s.cnt as DB:statitem-cnt-db2-act ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-act ; scovo:dimension DB:ACT as DB:statitem-type-2-db2-act . db-stat: void:statItem db-stat:CATALOGStat as DB:statitem-db2-catalog . db-stat:CATALOGStat a scovo:Item as DB:statitem-decl-db2-catalog ; rdf:value catalogcount_s.cnt as DB:statitem-cnt-db2-catalog ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-catalog ; scovo:dimension DB:CATALOG as DB:statitem-type-2-db2-catalog . db-stat: void:statItem db-stat:CL_SCHEDStat as DB:statitem-db2-cl_sched . db-stat:CL_SCHEDStat a scovo:Item as DB:statitem-decl-db2-cl_sched ; rdf:value cl_schedcount_s.cnt as DB:statitem-cnt-db2-cl_sched ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-cl_sched ; scovo:dimension DB:CL_SCHED as DB:statitem-type-2-db2-cl_sched . db-stat: void:statItem db-stat:CUSTOMERStat as DB:statitem-db2-customer . db-stat:CUSTOMERStat a scovo:Item as DB:statitem-decl-db2-customer ; rdf:value customercount_s.cnt as DB:statitem-cnt-db2-customer ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-customer ; scovo:dimension DB:CUSTOMER as DB:statitem-type-2-db2-customer . db-stat: void:statItem db-stat:DEPARTMENTStat as DB:statitem-db2-department . db-stat:DEPARTMENTStat a scovo:Item as DB:statitem-decl-db2-department ; rdf:value departmentcount_s.cnt as DB:statitem-cnt-db2-department ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-department ; scovo:dimension DB:DEPARTMENT as DB:statitem-type-2-db2-department . db-stat: void:statItem db-stat:EMPLOYEEStat as DB:statitem-db2-employee . db-stat:EMPLOYEEStat a scovo:Item as DB:statitem-decl-db2-employee ; rdf:value employeecount_s.cnt as DB:statitem-cnt-db2-employee ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-employee ; scovo:dimension DB:EMPLOYEE as DB:statitem-type-2-db2-employee . db-stat: void:statItem db-stat:EMPMDCStat as DB:statitem-db2-empmdc . db-stat:EMPMDCStat a scovo:Item as DB:statitem-decl-db2-empmdc ; rdf:value empmdccount_s.cnt as DB:statitem-cnt-db2-empmdc ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-empmdc ; scovo:dimension DB:EMPMDC as DB:statitem-type-2-db2-empmdc . db-stat: void:statItem db-stat:EMPPROJACTStat as DB:statitem-db2-empprojact . db-stat:EMPPROJACTStat a scovo:Item as DB:statitem-decl-db2-empprojact ; rdf:value empprojactcount_s.cnt as DB:statitem-cnt-db2-empprojact ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-empprojact ; scovo:dimension DB:EMPPROJACT as DB:statitem-type-2-db2-empprojact . db-stat: void:statItem db-stat:EMP_PHOTOStat as DB:statitem-db2-emp_photo . db-stat:EMP_PHOTOStat a scovo:Item as DB:statitem-decl-db2-emp_photo ; rdf:value emp_photocount_s.cnt as DB:statitem-cnt-db2-emp_photo ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-emp_photo ; scovo:dimension DB:EMP_PHOTO as DB:statitem-type-2-db2-emp_photo . db-stat: void:statItem db-stat:EMP_RESUMEStat as DB:statitem-db2-emp_resume . db-stat:EMP_RESUMEStat a scovo:Item as DB:statitem-decl-db2-emp_resume ; rdf:value emp_resumecount_s.cnt as DB:statitem-cnt-db2-emp_resume ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-emp_resume ; scovo:dimension DB:EMP_RESUME as DB:statitem-type-2-db2-emp_resume . db-stat: void:statItem db-stat:INVENTORYStat as DB:statitem-db2-inventory . db-stat:INVENTORYStat a scovo:Item as DB:statitem-decl-db2-inventory ; rdf:value inventorycount_s.cnt as DB:statitem-cnt-db2-inventory ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-inventory ; scovo:dimension DB:INVENTORY as DB:statitem-type-2-db2-inventory . db-stat: void:statItem db-stat:IN_TRAYStat as DB:statitem-db2-in_tray . db-stat:IN_TRAYStat a scovo:Item as DB:statitem-decl-db2-in_tray ; rdf:value in_traycount_s.cnt as DB:statitem-cnt-db2-in_tray ; scovo:dimension void:numberOfResources as DB:statitem-type-1-db2-in_tray ; scovo:dimension DB:IN_TRAY as DB:statitem-type-2-db2-in_tray . } } ; -- Virtual directories for instance data DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'db_rule2', 1, '(/[^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%23this%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/DB%%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 ( 'db_rule4', 1, '/DB/stat([^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^/DB/stat%%23%%3E+%%3Fo+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/DB%%23%%3E+WHERE+{+%%3Chttp%%3A//^{URIQADefaultHost}^/DB/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 ( 'db_rule6', 1, '/DB/objects/([^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^/DB/objects/%U%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/DB%%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 ( 'db_rule1', 1, '([^#]*)', vector('path'), 1, '/describe/?url=http%%3A//^{URIQADefaultHost}^%U%%23this&graph=http%%3A//^{URIQADefaultHost}^/DB%%23&distinct=0', vector('path'), null, null, 2, 303 ); DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'db_rule7', 1, '/DB/stat([^#]*)', vector('path'), 1, '/describe/?url=http%%3A//^{URIQADefaultHost}^/DB/stat%%23&graph=http%%3A//^{URIQADefaultHost}^/DB%%23', vector('path'), null, null, 2, 303 ); DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'db_rule5', 1, '/DB/objects/(.*)', vector('path'), 1, '/services/rdf/object.binary?path=%%2FDB%%2Fobjects%%2F%U&accept=%U', vector('path', '*accept*'), null, null, 2, null ); DB.DBA.URLREWRITE_CREATE_RULELIST ( 'db_rule_list1', 1, vector ( 'db_rule1', 'db_rule7', 'db_rule5', 'db_rule2', 'db_rule4', 'db_rule6')); DB.DBA.VHOST_REMOVE (lpath=>'/DB'); DB.DBA.VHOST_DEFINE (lpath=>'/DB', ppath=>'/', vsp_user=>'dba', is_dav=>0, is_brws=>0, opts=>vector ('url_rewrite', 'db_rule_list1') ); -- Virtual directories for ontology DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'db_owl_rule2', 1, '(/[^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/schemas/DB%%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 ( 'db_owl_rule1', 1, '([^#]*)', vector('path'), 1, '/describe/?url=http://^{URIQADefaultHost}^%U', vector('path'), null, null, 2, 303 ); DB.DBA.URLREWRITE_CREATE_RULELIST ( 'db_owl_rule_list1', 1, vector ( 'db_owl_rule1', 'db_owl_rule2')); DB.DBA.VHOST_REMOVE (lpath=>'/schemas/DB'); DB.DBA.VHOST_DEFINE (lpath=>'/schemas/DB', ppath=>'/', vsp_user=>'dba', is_dav=>0, is_brws=>0, opts=>vector ('url_rewrite', 'db_owl_rule_list1') );