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: <http://demo.openlinksw.com:8890/schemas/DB/> 
create iri class DB:act "http://^{URIQADefaultHost}^/DB/act/ACTNO/%d#this" (in _ACTNO integer not null) . ;
SPARQL
prefix DB: <http://demo.openlinksw.com:8890/schemas/DB/> 
create iri class DB:catalog "http://^{URIQADefaultHost}^/DB/catalog/NAME/%U#this" (in _NAME varchar not null) . ;
SPARQL
prefix DB: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/DB/> 
create iri class DB:customer "http://^{URIQADefaultHost}^/DB/customer/CID/%d#this" (in _CID numeric not null) . ;
SPARQL
prefix DB: <http://demo.openlinksw.com:8890/schemas/DB/> 
create iri class DB:department "http://^{URIQADefaultHost}^/DB/department/DEPTNO/%U#this" (in _DEPTNO varchar not null) . ;
SPARQL
prefix DB: <http://demo.openlinksw.com:8890/schemas/DB/> 
create iri class DB:employee "http://^{URIQADefaultHost}^/DB/employee/EMPNO/%U#this" (in _EMPNO varchar not null) . ;
SPARQL
prefix DB: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/DB/> 
create iri class DB:inventory "http://^{URIQADefaultHost}^/DB/inventory/PID/%U#this" (in _PID varchar not null) . ;
SPARQL
prefix DB: <http://demo.openlinksw.com:8890/schemas/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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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: <http://demo.openlinksw.com:8890/schemas/DB/> 
prefix db-stat: <http://demo.openlinksw.com:8890/DB/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/> 
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 <http://demo.openlinksw.com:8890/sparql> 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')
);