Sybase PUBS2 Linked Data Views Script to set up your own instance -- Setup script for Linked Data Views of Sybase 15 PUBS2 Sample Database -- GRANT SELECT ON pubs2.syb.au_pix TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.authors TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.discounts TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.publishers TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.roysched TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.sales TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.salesdetail TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.stores TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.titleauthor TO "SPARQL", "SPARQL_UPDATE"; GRANT SELECT ON pubs2.syb.titles TO "SPARQL", "SPARQL_UPDATE"; ------------------------------------------------------------------- -------- Create rdfs:Class definitions ---------------------------- ttlp ( ' @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> . @prefix xsd: <http://www.w3.org/2001/XMLSchema#> . @prefix syb: <http://localhost:8890/schemas/sybasepubs2/> . syb:titles a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "titles" ; rdfs:comment "Sybase Pubs2 titles table" . syb:title_id a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:string ; rdfs:label "title id" . syb:title a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:string ; rdfs:label "title" . syb:type a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:string ; rdfs:label "type" . syb:pub_id a rdf:Property ; rdfs:domain syb:titles ; rdfs:range syb:publishers ; rdfs:label "pub_id" . syb:advance a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:decimal ; rdfs:label "advance" . syb:price a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:decimal ; rdfs:label "price" . syb:total_sales a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:integer ; rdfs:label "total_sales" . syb:notes a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:string ; rdfs:label "notes" . syb:contract a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:integer ; rdfs:label "contract" . syb:pubdate a rdf:Property ; rdfs:domain syb:titles ; rdfs:range xsd:dateTime ; rdfs:label "publish date" . syb:authors a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "authors" ; rdfs:comment "Sybase Pubs2 authors table" . syb:au_id a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "author id" . syb:au_lname a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "author last name" . syb:au_fname a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "author first name" . syb:phone a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "phone number" . syb:address a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "address" . syb:city a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "city" . syb:state a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "state" . syb:country a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "country" . syb:postalcode a rdf:Property ; rdfs:domain syb:authors ; rdfs:range xsd:string ; rdfs:label "postalcode" . syb:stores a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "stores" ; rdfs:comment "Sybase Pubs2 stores table" . syb:stor_id a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "store id" . syb:stor_name a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "store name" . syb:stor_address a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "store address" . syb:city a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "city" . syb:state a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "state" . syb:country a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "country" . syb:postalcode a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "postal code" . syb:payterms a rdf:Property ; rdfs:domain syb:stores ; rdfs:range xsd:string ; rdfs:label "payment terms" . syb:au_pix a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "authors pictures" ; rdfs:comment "Sybase Pubs2 au_pix table" . syb:au_id a rdf:Property ; rdfs:domain syb:au_pix ; rdfs:range syb:authors ; rdfs:label "author id" . syb:format_type a rdf:Property ; rdfs:domain syb:au_pix ; rdfs:range xsd:string ; rdfs:label "format type" . syb:bytesize a rdf:Property ; rdfs:domain syb:au_pix ; rdfs:range xsd:integer ; rdfs:label "byte size" . syb:pixwidth_hor a rdf:Property ; rdfs:domain syb:au_pix ; rdfs:range xsd:string ; rdfs:label "picture horizontal width" . syb:pixwidth_vert a rdf:Property ; rdfs:domain syb:au_pix ; rdfs:range xsd:string ; rdfs:label "picture vertical width" . syb:discounts a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "discounts" ; rdfs:comment "Sybase Pubs2 discount table" . syb:discounttype a rdf:Property ; rdfs:domain syb:discounts ; rdfs:range xsd:string ; rdfs:label "discounttype" . syb:stor_id a rdf:Property ; rdfs:domain syb:discounts ; rdfs:range syb:stores ; rdfs:label "store id" . syb:lowqty a rdf:Property ; rdfs:domain syb:discounts ; rdfs:range xsd:integer ; rdfs:label "min quantity" . syb:highqty a rdf:Property ; rdfs:domain syb:discounts ; rdfs:range xsd:integer ; rdfs:label "max quantity" . syb:discount a rdf:Property ; rdfs:domain syb:discounts ; rdfs:range xsd:decimal ; rdfs:label "min quantity" . syb:salesdetail a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "sales details" ; rdfs:comment "Sybase Pubs2 sales detail table" . syb:store_id a rdf:Property ; rdfs:domain syb:salesdetail ; rdfs:range syb:stores ; rdfs:label "store id" . syb:ord_num a rdf:Property ; rdfs:domain syb:salesdetail ; rdfs:range syb:sales ; rdfs:label "order number" . syb:title_id a rdf:Property ; rdfs:domain syb:salesdetail ; rdfs:range syb:titles ; rdfs:label "title id" . syb:qty a rdf:Property ; rdfs:domain syb:salesdetail ; rdfs:range xsd:integer ; rdfs:label "quantity" . syb:discount a rdf:Property ; rdfs:domain syb:salesdetail ; rdfs:range xsd:decimal ; rdfs:label "discount" . syb:publishers a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "Publishers" ; rdfs:comment "Sybase Pubs2 publishers table" . syb:pub_id a rdf:Property ; rdfs:domain syb:publishers ; rdfs:range xsd:string ; rdfs:label "publisher id" . syb:pub_name a rdf:Property ; rdfs:domain syb:publishers ; rdfs:range xsd:string ; rdfs:label "publisher name" . syb:city a rdf:Property ; rdfs:domain syb:publishers ; rdfs:range xsd:string ; rdfs:label "city" . syb:state a rdf:Property ; rdfs:domain syb:publishers ; rdfs:range xsd:string ; rdfs:label "state" . syb:titleauthor a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "title author" ; rdfs:comment "Sybase Pubs2 titleauthor table" . syb:au_id a rdf:Property ; rdfs:domain syb:titleauthor ; rdfs:range syb:authors ; rdfs:label "author id" . syb:title_id a rdf:Property ; rdfs:domain syb:titleauthor ; rdfs:range syb:titles ; rdfs:label "title id" . syb:au_ord a rdf:Property ; rdfs:domain syb:titleauthor ; rdfs:range xsd:integer ; rdfs:label "author order" . syb:royaltyper a rdf:Property ; rdfs:domain syb:titleauthor ; rdfs:range xsd:integer ; rdfs:label "royalty per book" . syb:roysched a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "Royalty Schedule" ; rdfs:comment "Sybase Pubs2 roysched table" . syb:title_id a rdf:Property ; rdfs:domain syb:roysched ; rdfs:range syb:titles ; rdfs:label "title id" . syb:lorange a rdf:Property ; rdfs:domain syb:roysched ; rdfs:range xsd:integer ; rdfs:label "low range" . syb:hirange a rdf:Property ; rdfs:domain syb:roysched ; rdfs:range xsd:integer ; rdfs:label "high range" . syb:royalty a rdf:Property ; rdfs:domain syb:roysched ; rdfs:range xsd:integer ; rdfs:label "royalty" . syb:sales a rdfs:Class ; rdfs:isDefinedBy <http://localhost:8890/schemas/sybasepubs2> ; rdfs:label "Sales" ; rdfs:comment "Sybase Pubs2 sales table" . syb:stor_id a rdf:Property ; rdfs:domain syb:sales ; rdfs:range xsd:string ; rdfs:label "store id" . syb:ord_num a rdf:Property ; rdfs:domain syb:sales ; rdfs:range xsd:string ; rdfs:label "order number" . syb:date a rdf:Property ; rdfs:domain syb:sales ; rdfs:range xsd:dateTime ; rdfs:label "date" . ', '', 'http://localhost:8890/schemas/sybasepubs2', 0); --------------------------------------------------------------- ----------- Create IRI Classes ------------- sparql create iri class <http://localhost:8890/schemas/sybasepubs2/titles_iri> "http://^{URIQADefaultHost}^/sybasepubs2/titles/%s_%s#this" (in title_id varchar not null, in title varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/authors_iri> "http://^{URIQADefaultHost}^/sybasepubs2/authors/%s#this" (in au_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/stores_iri> "http://^{URIQADefaultHost}^/sybasepubs2/stores/%s#this" (in stor_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/au_pix_iri> "http://^{URIQADefaultHost}^/sybasepubs2/au_pix/%s#this" (in au_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/discounts_iri> "http://^{URIQADefaultHost}^/sybasepubs2/discounts/%s#this" (in discounttype varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/salesdetail_iri> "http://^{URIQADefaultHost}^/sybasepubs2/salesdetail/%s_%s_%s#this" (in stor_id varchar not null, in ord_num varchar not null, in title_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/publishers_iri> "http://^{URIQADefaultHost}^/sybasepubs2/publishers/%s#this" (in pub_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/titleauthor_iri> "http://^{URIQADefaultHost}^/sybasepubs2/titleauthor/%s_%s#this" (in au_id varchar not null, in title_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/roysched_iri> "http://^{URIQADefaultHost}^/sybasepubs2/roysched/%s#this" (in title_id varchar not null) . create iri class <http://localhost:8890/schemas/sybasepubs2/sales_iri> "http://^{URIQADefaultHost}^/sybasepubs2/sales/%s_%s#this" (in stor_id varchar not null, in ord_num varchar not null) . ; -------------------------------------------------------------------- ------------- Create Quad Store ------------------------------------ sparql prefix syb: <http://localhost:8890/schemas/sybasepubs2/> alter quad storage virtrdf:DefaultQuadStorage from pubs2.syb.au_pix as au_pix_tbl from pubs2.syb.authors as authors_tbl from pubs2.syb.discounts as discounts_tbl from pubs2.syb.publishers as publishers_tbl from pubs2.syb.roysched as roysched_tbl from pubs2.syb.sales as sales_tbl from pubs2.syb.salesdetail as salesdetail_tbl from pubs2.syb.stores as stores_tbl from pubs2.syb.titleauthor as titleauthor_tbl from pubs2.syb.titles as titles_tbl { create virtrdf:sybasepubs2 as graph <http://localhost:8890/sybasepubs2> { syb:au_pix_iri (au_pix_tbl.au_id) a syb:au_pix as virtrdf:au_pix_id; syb:au_id au_pix_tbl.au_id as virtrdf:au_pix_au_id; syb:format_type au_pix_tbl.format_type as virtrdf:au_pix_format_type; syb:bytesize au_pix_tbl.bytesize as virtrdf:au_pix_bytesize; syb:pixwidth_hor au_pix_tbl.pixwidth_hor as virtrdf:au_pix_pixwidth_hor; syb:pixwidth_vert au_pix_tbl.pixwidth_vert as virtrdf:au_pix_pixwidth_vert ; syb:has_author syb:authors_iri(authors_tbl.au_id) where (^{authors_tbl.}^.au_id = ^{au_pix_tbl.}^.au_id) as virtrdf:au_pix_has_author . syb:authors_iri (authors_tbl.au_id) a syb:authors as virtrdf:authors_pk ; syb:au_id authors_tbl.au_id as virtrdf:authors_au_id; syb:au_lname authors_tbl.au_lname as virtrdf:authors_au_lname; syb:au_fname authors_tbl.au_fname as virtrdf:authors_au_fname; syb:phone authors_tbl.phone as virtrdf:authors_phone; syb:address authors_tbl.address as virtrdf:authors_address; syb:city authors_tbl.city as virtrdf:authors_city; syb:state authors_tbl.state as virtrdf:authors_state; syb:country authors_tbl.country as virtrdf:authors_country; syb:postalcode authors_tbl.postalcode as virtrdf:authors_postalcode; syb:has_title syb:titleauthor_iri(titleauthor_tbl.au_id, titleauthor_tbl.title_id) where (^{titleauthor_tbl.}^.au_id = ^{authors_tbl.}^.au_id) as virtrdf:authors_has_title; syb:has_pix syb:au_pix_iri(au_pix_tbl.au_id) where (^{au_pix_tbl.}^.au_id = ^{authors_tbl.}^.au_id) as virtrdf:authors_has_pix . syb:discounts_iri (discounts_tbl.stor_id) a syb:discounts as virtrdf:discounts_pk; syb:discounttype discounts_tbl.discounttype as virtrdf:discounts_discounttype; syb:stor_id syb:stores_iri(stores_tbl.stor_id) where (^{stores_tbl.}^.stor_id = ^{stores_tbl.}^.stor_id) as virtrdf:discounts_stor_id; syb:lowqty discounts_tbl.lowqty as virtrdf:discounts_lowqty; syb:highqty discounts_tbl.highqty as virtrdf:discounts_highqty; syb:discount discounts_tbl.discount as virtrdf:discounts_discount . syb:publishers_iri (publishers_tbl.pub_id) a syb:publishers as virtrdf:publishers_pk; syb:pub_id syb:titles_iri(titles_tbl.title_id, titles_tbl.pub_id) where (^{titles_tbl.}^.pub_id = ^{titles_tbl.}^.pub_id) as virtrdf:publisherss_pub_id; syb:pub_name publishers_tbl.pub_name as virtrdf:publisherss_pub_name; syb:city publishers_tbl.city as virtrdf:publisherss_city; syb:state publishers_tbl.state as virtrdf:publisherss_state . syb:roysched_iri (roysched_tbl.title_id) a syb:roysched as virtrdf:roysched_pk; syb:title_id syb:titleauthor_iri(titleauthor_tbl.au_id, titleauthor_tbl.title_id) where (^{titleauthor_tbl.}^.title_id = ^{roysched_tbl.}^.title_id) as virtrdf:roysched_title_id; syb:lorange roysched_tbl.lorange as virtrdf:roysched_lorange; syb:hirange roysched_tbl.hirange as virtrdf:roysched_hirange; syb:royalty roysched_tbl.royalty as virtrdf:roysched_royalty . syb:sales_iri (sales_tbl.stor_id, sales_tbl.ord_num) a syb:sales as virtrdf:sales_pk; syb:stor_id sales_tbl.stor_id as virtrdf:sales_stor_id; syb:ord_num sales_tbl.ord_num as virtrdf:sales_ord_num; syb:date sales_tbl.date as virtrdf:sales_date; syb:has_salesdetail syb:salesdetail_iri(salesdetail_tbl.stor_id, salesdetail_tbl.ord_num, salesdetail_tbl.title_id) where (^{salesdetail_tbl.}^.stor_id = ^{sales_tbl.}^.stor_id and ^{salesdetail_tbl.}^.ord_num = ^{sales_tbl.}^.ord_num) as virtrdf:sales_has_salesdetail; syb:has_stores syb:stores_iri(stores_tbl.stor_id) where (^{stores_tbl.}^.stor_id = ^{sales_tbl.}^.stor_id) as virtrdf:sales_has_stores . syb:salesdetail_iri (salesdetail_tbl.stor_id, salesdetail_tbl.ord_num, salesdetail_tbl.title_id) a syb:salesdetail as virtrdf:salesdetail_pk; syb:stor_id salesdetail_tbl.stor_id as virtrdf:salesdetail_stor_id; syb:ord_num salesdetail_tbl.ord_num as virtrdf:salesdetail_ord_num; syb:title_id salesdetail_tbl.title_id as virtrdf:salesdetail_title_id; syb:qty salesdetail_tbl.qty as virtrdf:salesdeail_qty; syb:discount salesdetail_tbl.discount as virtrdf:salesdetail_discount; syb:has_title syb:titles_iri (titles_tbl.title_id, titles_tbl.pub_id) where (^{titles_tbl.}^.title_id = ^{salesdetail_tbl.}^.title_id) as virtrdf:salesdetail_has_title; syb:has_sales syb:sales_iri(sales_tbl.stor_id, sales_tbl.ord_num) where (^{salesdetail_tbl.}^.stor_id = ^{sales_tbl.}^.stor_id and ^{salesdetail_tbl.}^.ord_num = ^{sales_tbl.}^.ord_num ) as virtrdf:salesdetail_has_sales . syb:stores_iri (stores_tbl.stor_id) a syb:stores as virtrdf:stores_pk; syb:stor_id stores_tbl.stor_id as virtrdf:stores_stor_id; syb:stor_name stores_tbl.stor_name as virtrdf:stores_stor_name; syb:stor_address stores_tbl.stor_address as virtrdf:stores_stor_address; syb:city stores_tbl.city as virtrdf:stores_city; syb:state stores_tbl.state as virtrdf:stores_state; syb:country stores_tbl.country as virtrdf:stores_country; syb:postalcode stores_tbl.postalcode as virtrdf:stores_postalcode; syb:payterms stores_tbl.payterms as virtrdf:stores_payterms; syb:has_sales syb:sales_iri(sales_tbl.stor_id, sales_tbl.ord_num) where (^{sales_tbl.}^.stor_id = ^{stores_tbl.}^.stor_id) as virtrdf:stores_has_sales . syb:titleauthor_iri (titleauthor_tbl.au_id, titleauthor_tbl.title_id) a syb:titleauthor as virtrdf:titleauthor_pk; syb:au_id titleauthor_tbl.au_id as virtrdf:titleauthor_au_id; syb:title_id titleauthor_tbl.title_id as virtrdf:titleauthor_title_id; syb:au_ord titleauthor_tbl.au_ord as virtrdf:titleauthor_au_ord; syb:royaltyper titleauthor_tbl.royaltyper as virtrdf:titleauthor_royaltyper; syb:has_author syb:authors_iri(authors_tbl.au_id) where (^{authors_tbl.}^.au_id = ^{titleauthor_tbl.}^.au_id) as virtrdf:titleauthor_has_author; syb:has_titles syb:titles_iri(titles_tbl.title_id, titles_tbl.pub_id) where (^{titles_tbl.}^.title_id = ^{titleauthor_tbl.}^.title_id) as virtrdf:titleauthor_has_titles . syb:titles_iri (titles_tbl.title_id, titles_tbl.pub_id) a syb:titles as virtrdf:titles_pk; syb:title_id titles_tbl.title_id as virtrdf:titles_title_idd; syb:title titles_tbl.title as virtrdf:titles_title; syb:type titles_tbl.type as virtrdf:titles_type; syb:pub_id titles_tbl.pub_id as virtrdf:titles_pub_id; syb:price titles_tbl.price as virtrdf:titles_price; syb:advance titles_tbl.advance as virtrdf:titles_advance; syb:total_sales titles_tbl.total_sales as virtrdf:titles_total_sales; syb:notes titles_tbl.notes as virtrdf:titles_notes; syb:pubdate titles_tbl.pubdate as virtrdf:titles_pubdate; syb:contract titles_tbl.contract as virtrdf:titles_contract; syb:has_titleauthor syb:titleauthor_iri(titleauthor_tbl.au_id, titleauthor_tbl.title_id) where (^{titleauthor_tbl.}^.title_id = ^{titles_tbl.}^.title_id) as virtrdf:titles_has_titleauthor; syb:has_salesdetail syb:salesdetail_iri (salesdetail_tbl.stor_id, salesdetail_tbl.ord_num, salesdetail_tbl.title_id) where (^{salesdetail_tbl.}^.title_id = ^{titles_tbl.}^.title_id) as virtrdf:titles_has_salesdetail . } . } . ; delete from db.dba.url_rewrite_rule_list where urrl_list like 'sybasepubs2_rule%'; delete from db.dba.url_rewrite_rule where urr_rule like 'sybasepubs2_rule%'; DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'sybasepubs2_rule1', 1, '(/[^#]*)', vector('path'), 1, '/about/html/http://^{URIQADefaultHost}^%s', vector('path'), null, '(text/html)|(\\*/\\*)', 0, 303 ); DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'sybasepubs2_rule2', 1, '(/[^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//localhost%%3A8890%U%%23this%%3E+%%3Chttp%%3A//localhost%%3A8890%U%%23this%%3E+FROM+%%3Chttp%%3A//localhost%%3A8890/sybasepubs2%%3E&format=%U', vector('path', 'path', '*accept*'), null, '(text/rdf.n3)|(application/rdf.xml)', 0, null ); DB.DBA.URLREWRITE_CREATE_RULELIST ( 'sybasepubs2_rule_list1', 1, vector ( 'sybasepubs2_rule1', 'sybasepubs2_rule2' )); -- ensure a VD for the IRIs which begins with / VHOST_REMOVE (lpath=>'/sybasepubs2'); VHOST_DEFINE ( lpath=>'/sybasepubs2', ppath=>'/DAV/sybasepubs2/', is_dav=>1, vsp_user=>'dba', is_brws=>0, opts=>vector ('url_rewrite', 'sybasepubs2_rule_list1') ); delete from db.dba.url_rewrite_rule_list where urrl_list like 'sybase_schemas_rule%'; delete from db.dba.url_rewrite_rule where urr_rule like 'sybase_schemas_rule%'; DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'sybase_schemas_rule1', 1, '(/[^#]*)', vector('path'), 1, '/about/html/http://^{URIQADefaultHost}^%s', vector('path'), null, '(text/html)|(\\*/\\*)', 0, 303 ); DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'sybase_schemas_rule2', 1, '(/[^#]*)', vector('path'), 1, '/sparql?query=CONSTRUCT+{+%%3Chttp%%3A//localhost%%3A8890%U%%3E+%%3Fp+%%3Fo+}%%0D%%0AFROM+%%3Chttp%%3A//localhost%%3A8890/schemas/sybasepubs2%%3E+%%0D%%0AWHERE+{+%%3Chttp%%3A//localhost%%3A8890%U%%3E+%%3Fp+%%3Fo+}&format=%U', vector('path','path','*accept*'), null, '(text/rdf.n3)|(application/rdf.xml)', 0, null ); DB.DBA.URLREWRITE_CREATE_RULELIST ( 'sybase_schemas_rule_list1', 1, vector ( 'sybase_schemas_rule1', 'sybase_schemas_rule2' )); -- ensure a VD for the IRIs which begins with / VHOST_REMOVE (lpath=>'/schema/sybasepubs2'); VHOST_DEFINE ( lpath=>'/schemas/sybasepubs2', ppath=>'/DAV/schemas/sybasepubs2/', is_dav=>1, vsp_user=>'dba', is_brws=>0, opts=>vector ('url_rewrite', 'sybase_schemas_rule_list1') ); DB.DBA.XML_SET_NS_DECL ('hr', 'http://^{URIQADefaultHost}^/schemas/sybasepubs2', 2);