"VirtRDFViewsSybasePubs2DbScript" . . "VirtRDFViewsSybasePubs2DbScript" . . . . . . "---++ Sybase PUBS2 Linked Data Views Script to set up your own instance\n\n\n\n-- Setup script for Linked Data Views of Sybase 15 PUBS2 Sample Database --\n\nGRANT SELECT ON pubs2.syb.au_pix TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.authors TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.discounts TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.publishers TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.roysched TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.sales TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.salesdetail TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.stores TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.titleauthor TO \"SPARQL\", \"SPARQL_UPDATE\";\nGRANT SELECT ON pubs2.syb.titles TO \"SPARQL\", \"SPARQL_UPDATE\";\n\n-------------------------------------------------------------------\n\n-------- Create rdfs:Class definitions ----------------------------\n\nttlp (\n'\n@prefix rdf: .\n@prefix rdfs: .\n@prefix xsd: .\n\n@prefix syb: .\n\nsyb:titles a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"titles\" ;\n\trdfs:comment \"Sybase Pubs2 titles table\" .\n\t\nsyb:title_id a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:string ;\n\trdfs:label \"title id\" .\n\t\nsyb:title a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:string ;\n\trdfs:label \"title\" .\n\t\nsyb:type a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:string ;\n\trdfs:label \"type\" .\n\t\nsyb:pub_id a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range syb:publishers ;\n\trdfs:label \"pub_id\" .\n\t\nsyb:advance a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:decimal ;\n\trdfs:label \"advance\" .\n\nsyb:price a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:decimal ;\n\trdfs:label \"price\" .\n\nsyb:total_sales a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"total_sales\" .\n\nsyb:notes a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:string ;\n\trdfs:label \"notes\" .\n\nsyb:contract a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"contract\" .\n\nsyb:pubdate a rdf:Property ;\n\trdfs:domain syb:titles ;\n\trdfs:range xsd:dateTime ;\n\trdfs:label \"publish date\" .\n\nsyb:authors a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"authors\" ;\n\trdfs:comment \"Sybase Pubs2 authors table\" .\n\t\nsyb:au_id a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"author id\" .\n\t\nsyb:au_lname a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"author last name\" .\n\t\nsyb:au_fname a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"author first name\" .\n\t\nsyb:phone a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"phone number\" .\n\t\nsyb:address a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"address\" .\n\nsyb:city a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"city\" .\n\nsyb:state a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"state\" .\n\nsyb:country a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"country\" .\n\nsyb:postalcode a rdf:Property ;\n\trdfs:domain syb:authors ;\n\trdfs:range xsd:string ;\n\trdfs:label \"postalcode\" .\n\nsyb:stores a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"stores\" ;\n\trdfs:comment \"Sybase Pubs2 stores table\" .\n\nsyb:stor_id a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"store id\" .\n\nsyb:stor_name a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"store name\" .\n\nsyb:stor_address a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"store address\" .\n\nsyb:city a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"city\" .\n\nsyb:state a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"state\" .\n\nsyb:country a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"country\" .\n\nsyb:postalcode a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"postal code\" .\n\nsyb:payterms a rdf:Property ;\n\trdfs:domain syb:stores ;\n\trdfs:range xsd:string ;\n\trdfs:label \"payment terms\" .\n\nsyb:au_pix a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"authors pictures\" ;\n\trdfs:comment \"Sybase Pubs2 au_pix table\" .\n\nsyb:au_id a rdf:Property ;\n\trdfs:domain syb:au_pix ;\n\trdfs:range syb:authors ;\n\trdfs:label \"author id\" .\n\nsyb:format_type a rdf:Property ;\n\trdfs:domain syb:au_pix ;\n\trdfs:range xsd:string ;\n\trdfs:label \"format type\" .\n\nsyb:bytesize a rdf:Property ;\n\trdfs:domain syb:au_pix ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"byte size\" .\n\nsyb:pixwidth_hor a rdf:Property ;\n\trdfs:domain syb:au_pix ;\n\trdfs:range xsd:string ;\n\trdfs:label \"picture horizontal width\" .\n\nsyb:pixwidth_vert a rdf:Property ;\n\trdfs:domain syb:au_pix ;\n\trdfs:range xsd:string ;\n\trdfs:label \"picture vertical width\" .\n\nsyb:discounts a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"discounts\" ;\n\trdfs:comment \"Sybase Pubs2 discount table\" .\n\nsyb:discounttype a rdf:Property ;\n\trdfs:domain syb:discounts ;\n\trdfs:range xsd:string ;\n\trdfs:label \"discounttype\" .\n\nsyb:stor_id a rdf:Property ;\n\trdfs:domain syb:discounts ;\n\trdfs:range syb:stores ;\n\trdfs:label \"store id\" .\n\nsyb:lowqty a rdf:Property ;\n\trdfs:domain syb:discounts ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"min quantity\" .\n\nsyb:highqty a rdf:Property ;\n\trdfs:domain syb:discounts ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"max quantity\" .\n\nsyb:discount a rdf:Property ;\n\trdfs:domain syb:discounts ;\n\trdfs:range xsd:decimal ;\n\trdfs:label \"min quantity\" .\n\nsyb:salesdetail a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"sales details\" ;\n\trdfs:comment \"Sybase Pubs2 sales detail table\" .\n\nsyb:store_id a rdf:Property ;\n\trdfs:domain syb:salesdetail ;\n\trdfs:range syb:stores ;\n\trdfs:label \"store id\" .\n\nsyb:ord_num a rdf:Property ;\n\trdfs:domain syb:salesdetail ;\n\trdfs:range syb:sales ;\n\trdfs:label \"order number\" .\n\nsyb:title_id a rdf:Property ;\n\trdfs:domain syb:salesdetail ;\n\trdfs:range syb:titles ;\n\trdfs:label \"title id\" .\n\nsyb:qty a rdf:Property ;\n\trdfs:domain syb:salesdetail ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"quantity\" .\n\nsyb:discount a rdf:Property ;\n\trdfs:domain syb:salesdetail ;\n\trdfs:range xsd:decimal ;\n\trdfs:label \"discount\" .\n\nsyb:publishers a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"Publishers\" ;\n\trdfs:comment \"Sybase Pubs2 publishers table\" .\n\nsyb:pub_id a rdf:Property ;\n\trdfs:domain syb:publishers ;\n\trdfs:range xsd:string ;\n\trdfs:label \"publisher id\" .\n\nsyb:pub_name a rdf:Property ;\n\trdfs:domain syb:publishers ;\n\trdfs:range xsd:string ;\n\trdfs:label \"publisher name\" .\n\nsyb:city a rdf:Property ;\n\trdfs:domain syb:publishers ;\n\trdfs:range xsd:string ;\n\trdfs:label \"city\" .\n\nsyb:state a rdf:Property ;\n\trdfs:domain syb:publishers ;\n\trdfs:range xsd:string ;\n\trdfs:label \"state\" .\n\nsyb:titleauthor a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"title author\" ;\n\trdfs:comment \"Sybase Pubs2 titleauthor table\" .\n\nsyb:au_id a rdf:Property ;\n\trdfs:domain syb:titleauthor ;\n\trdfs:range syb:authors ;\n\trdfs:label \"author id\" .\n\nsyb:title_id a rdf:Property ;\n\trdfs:domain syb:titleauthor ;\n\trdfs:range syb:titles ;\n\trdfs:label \"title id\" .\n\nsyb:au_ord a rdf:Property ;\n\trdfs:domain syb:titleauthor ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"author order\" .\n\nsyb:royaltyper a rdf:Property ;\n\trdfs:domain syb:titleauthor ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"royalty per book\" .\n\nsyb:roysched a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"Royalty Schedule\" ;\n\trdfs:comment \"Sybase Pubs2 roysched table\" .\n\nsyb:title_id a rdf:Property ;\n\trdfs:domain syb:roysched ;\n\trdfs:range syb:titles ;\n\trdfs:label \"title id\" .\n\nsyb:lorange a rdf:Property ;\n\trdfs:domain syb:roysched ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"low range\" .\n\nsyb:hirange a rdf:Property ;\n\trdfs:domain syb:roysched ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"high range\" .\n\nsyb:royalty a rdf:Property ;\n\trdfs:domain syb:roysched ;\n\trdfs:range xsd:integer ;\n\trdfs:label \"royalty\" .\n\nsyb:sales a rdfs:Class ;\n\trdfs:isDefinedBy ;\n\trdfs:label \"Sales\" ;\n\trdfs:comment \"Sybase Pubs2 sales table\" .\n\nsyb:stor_id a rdf:Property ;\n\trdfs:domain syb:sales ;\n\trdfs:range xsd:string ;\n\trdfs:label \"store id\" .\n\nsyb:ord_num a rdf:Property ;\n\trdfs:domain syb:sales ;\n\trdfs:range xsd:string ;\n\trdfs:label \"order number\" .\n\nsyb:date a rdf:Property ;\n\trdfs:domain syb:sales ;\n\trdfs:range xsd:dateTime ;\n\trdfs:label \"date\" .\n', '', 'http://localhost:8890/schemas/sybasepubs2', 0);\n\n---------------------------------------------------------------\n\n----------- Create IRI Classes -------------\n\nsparql\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/titles/%s_%s#this\"\n \t(in title_id varchar not null, in title varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/authors/%s#this\"\n \t(in au_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/stores/%s#this\"\n \t(in stor_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/au_pix/%s#this\"\n \t(in au_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/discounts/%s#this\"\n \t(in discounttype varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/salesdetail/%s_%s_%s#this\"\n \t(in stor_id varchar not null, in ord_num varchar not null, in title_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/publishers/%s#this\"\n \t(in pub_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/titleauthor/%s_%s#this\"\n \t(in au_id varchar not null, in title_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/roysched/%s#this\"\n \t(in title_id varchar not null) .\n\n\tcreate iri class \n\t\"http://^{URIQADefaultHost}^/sybasepubs2/sales/%s_%s#this\"\n \t(in stor_id varchar not null, in ord_num varchar not null) .\n\n;\n\n--------------------------------------------------------------------\n\n------------- Create Quad Store ------------------------------------\n\nsparql\n\nprefix syb: \n\nalter quad storage virtrdf:DefaultQuadStorage \n from pubs2.syb.au_pix as au_pix_tbl \n from pubs2.syb.authors as authors_tbl\n from pubs2.syb.discounts as discounts_tbl\n from pubs2.syb.publishers as publishers_tbl \n from pubs2.syb.roysched as roysched_tbl\n from pubs2.syb.sales as sales_tbl\n from pubs2.syb.salesdetail as salesdetail_tbl\n from pubs2.syb.stores as stores_tbl\n from pubs2.syb.titleauthor as titleauthor_tbl\n from pubs2.syb.titles as titles_tbl\n{\n create virtrdf:sybasepubs2 as \n graph \n {\n\tsyb:au_pix_iri (au_pix_tbl.au_id) a syb:au_pix as virtrdf:au_pix_id;\n\tsyb:au_id au_pix_tbl.au_id as virtrdf:au_pix_au_id;\n\tsyb:format_type au_pix_tbl.format_type as virtrdf:au_pix_format_type;\n\tsyb:bytesize au_pix_tbl.bytesize as virtrdf:au_pix_bytesize;\n\tsyb:pixwidth_hor au_pix_tbl.pixwidth_hor as virtrdf:au_pix_pixwidth_hor;\n\tsyb:pixwidth_vert au_pix_tbl.pixwidth_vert as virtrdf:au_pix_pixwidth_vert ;\n \tsyb: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 .\n\n syb:authors_iri (authors_tbl.au_id) a syb:authors as virtrdf:authors_pk ;\n\tsyb:au_id authors_tbl.au_id as virtrdf:authors_au_id;\n \tsyb:au_lname authors_tbl.au_lname as virtrdf:authors_au_lname;\n \tsyb:au_fname authors_tbl.au_fname as virtrdf:authors_au_fname;\n \tsyb:phone authors_tbl.phone as virtrdf:authors_phone;\n \tsyb:address authors_tbl.address as virtrdf:authors_address;\n \tsyb:city authors_tbl.city as virtrdf:authors_city;\n \tsyb:state authors_tbl.state as virtrdf:authors_state;\n \tsyb:country authors_tbl.country as virtrdf:authors_country;\n \tsyb:postalcode authors_tbl.postalcode as virtrdf:authors_postalcode;\n \tsyb: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;\n \tsyb: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 .\n\n\tsyb:discounts_iri (discounts_tbl.stor_id) a syb:discounts as virtrdf:discounts_pk;\n\tsyb:discounttype discounts_tbl.discounttype as virtrdf:discounts_discounttype;\n\tsyb:stor_id syb:stores_iri(stores_tbl.stor_id) where (^{stores_tbl.}^.stor_id = ^{stores_tbl.}^.stor_id) as virtrdf:discounts_stor_id;\n\tsyb:lowqty discounts_tbl.lowqty as virtrdf:discounts_lowqty;\n\tsyb:highqty discounts_tbl.highqty as virtrdf:discounts_highqty;\n\tsyb:discount discounts_tbl.discount as virtrdf:discounts_discount .\n\n\tsyb:publishers_iri (publishers_tbl.pub_id) a syb:publishers as virtrdf:publishers_pk;\n\tsyb: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;\n\tsyb:pub_name publishers_tbl.pub_name as virtrdf:publisherss_pub_name;\n\tsyb:city publishers_tbl.city as virtrdf:publisherss_city;\n\tsyb:state publishers_tbl.state as virtrdf:publisherss_state .\n\n\tsyb:roysched_iri (roysched_tbl.title_id) a syb:roysched as virtrdf:roysched_pk;\n \tsyb: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;\n\tsyb:lorange roysched_tbl.lorange as virtrdf:roysched_lorange;\n\tsyb:hirange roysched_tbl.hirange as virtrdf:roysched_hirange;\n\tsyb:royalty roysched_tbl.royalty as virtrdf:roysched_royalty .\n\n\tsyb:sales_iri (sales_tbl.stor_id, sales_tbl.ord_num) a syb:sales as virtrdf:sales_pk;\n\tsyb:stor_id sales_tbl.stor_id as virtrdf:sales_stor_id;\n\tsyb:ord_num sales_tbl.ord_num as virtrdf:sales_ord_num;\n\tsyb:date sales_tbl.date as virtrdf:sales_date;\n \tsyb: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;\n \tsyb:has_stores syb:stores_iri(stores_tbl.stor_id) where (^{stores_tbl.}^.stor_id = ^{sales_tbl.}^.stor_id) as virtrdf:sales_has_stores .\n\n\tsyb:salesdetail_iri (salesdetail_tbl.stor_id, salesdetail_tbl.ord_num, salesdetail_tbl.title_id) a syb:salesdetail as virtrdf:salesdetail_pk;\n\tsyb:stor_id salesdetail_tbl.stor_id as virtrdf:salesdetail_stor_id;\n\tsyb:ord_num salesdetail_tbl.ord_num as virtrdf:salesdetail_ord_num;\n\tsyb:title_id salesdetail_tbl.title_id as virtrdf:salesdetail_title_id;\n\tsyb:qty salesdetail_tbl.qty as virtrdf:salesdeail_qty;\n\tsyb:discount salesdetail_tbl.discount as virtrdf:salesdetail_discount;\n\tsyb: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;\n \tsyb: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 .\n\n\tsyb:stores_iri (stores_tbl.stor_id) a syb:stores as virtrdf:stores_pk;\n \tsyb:stor_id stores_tbl.stor_id as virtrdf:stores_stor_id;\n\tsyb:stor_name stores_tbl.stor_name as virtrdf:stores_stor_name;\n\tsyb:stor_address stores_tbl.stor_address as virtrdf:stores_stor_address;\n\tsyb:city stores_tbl.city as virtrdf:stores_city;\n\tsyb:state stores_tbl.state as virtrdf:stores_state;\n\tsyb:country stores_tbl.country as virtrdf:stores_country;\n\tsyb:postalcode stores_tbl.postalcode as virtrdf:stores_postalcode;\n\tsyb:payterms stores_tbl.payterms as virtrdf:stores_payterms;\n \tsyb: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 .\n\n\tsyb:titleauthor_iri (titleauthor_tbl.au_id, titleauthor_tbl.title_id) a syb:titleauthor as virtrdf:titleauthor_pk;\n\tsyb:au_id titleauthor_tbl.au_id as virtrdf:titleauthor_au_id;\n\tsyb:title_id titleauthor_tbl.title_id as virtrdf:titleauthor_title_id;\n\tsyb:au_ord titleauthor_tbl.au_ord as virtrdf:titleauthor_au_ord;\n\tsyb:royaltyper titleauthor_tbl.royaltyper as virtrdf:titleauthor_royaltyper;\n\tsyb:has_author syb:authors_iri(authors_tbl.au_id) where (^{authors_tbl.}^.au_id = ^{titleauthor_tbl.}^.au_id) as virtrdf:titleauthor_has_author; \n\tsyb: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 .\n\n\tsyb:titles_iri (titles_tbl.title_id, titles_tbl.pub_id) a syb:titles as virtrdf:titles_pk;\n\tsyb:title_id titles_tbl.title_id as virtrdf:titles_title_idd;\n\tsyb:title titles_tbl.title as virtrdf:titles_title;\n\tsyb:type titles_tbl.type as virtrdf:titles_type;\n\tsyb:pub_id titles_tbl.pub_id as virtrdf:titles_pub_id;\n\tsyb:price titles_tbl.price as virtrdf:titles_price;\n\tsyb:advance titles_tbl.advance as virtrdf:titles_advance;\n\tsyb:total_sales titles_tbl.total_sales as virtrdf:titles_total_sales;\n\tsyb:notes titles_tbl.notes as virtrdf:titles_notes;\n\tsyb:pubdate titles_tbl.pubdate as virtrdf:titles_pubdate;\n\tsyb:contract titles_tbl.contract as virtrdf:titles_contract;\n \tsyb: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;\n \tsyb: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 .\n\n } .\n} .\n;\n\ndelete from db.dba.url_rewrite_rule_list where urrl_list like 'sybasepubs2_rule%';\ndelete from db.dba.url_rewrite_rule where urr_rule like 'sybasepubs2_rule%';\n\nDB.DBA.URLREWRITE_CREATE_REGEX_RULE (\n 'sybasepubs2_rule1',\n 1,\n '(/[^#]*)',\n vector('path'),\n 1,\n '/about/html/http://^{URIQADefaultHost}^%s',\n vector('path'),\n null,\n '(text/html)|(\\\\*/\\\\*)',\n 0,\n 303\n );\n\n\nDB.DBA.URLREWRITE_CREATE_REGEX_RULE (\n 'sybasepubs2_rule2',\n 1,\n '(/[^#]*)',\n vector('path'),\n 1,\n '/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',\n vector('path', 'path', '*accept*'),\n null,\n '(text/rdf.n3)|(application/rdf.xml)',\n 0,\n null\n );\n\nDB.DBA.URLREWRITE_CREATE_RULELIST (\n 'sybasepubs2_rule_list1',\n 1,\n vector (\n \t \t'sybasepubs2_rule1',\n \t \t'sybasepubs2_rule2'\n\t ));\n\n-- ensure a VD for the IRIs which begins with /\nVHOST_REMOVE (lpath=>'/sybasepubs2');\n\nVHOST_DEFINE (\n\tlpath=>'/sybasepubs2', \n\tppath=>'/DAV/sybasepubs2/', \n \tis_dav=>1, \n\tvsp_user=>'dba', \n\tis_brws=>0, \n\topts=>vector ('url_rewrite', 'sybasepubs2_rule_list1') \n\t);\n\ndelete from db.dba.url_rewrite_rule_list where urrl_list like 'sybase_schemas_rule%';\ndelete from db.dba.url_rewrite_rule where urr_rule like 'sybase_schemas_rule%';\n\nDB.DBA.URLREWRITE_CREATE_REGEX_RULE (\n 'sybase_schemas_rule1',\n 1,\n '(/[^#]*)',\n vector('path'),\n 1,\n '/about/html/http://^{URIQADefaultHost}^%s',\n vector('path'),\n null,\n '(text/html)|(\\\\*/\\\\*)',\n 0,\n 303\n );\n\nDB.DBA.URLREWRITE_CREATE_REGEX_RULE (\n 'sybase_schemas_rule2',\n 1,\n '(/[^#]*)',\n vector('path'),\n 1,\n '/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',\n vector('path','path','*accept*'),\n null,\n '(text/rdf.n3)|(application/rdf.xml)',\n 0,\n null\n );\n\nDB.DBA.URLREWRITE_CREATE_RULELIST (\n 'sybase_schemas_rule_list1',\n 1,\n vector (\n \t \t'sybase_schemas_rule1',\n \t \t'sybase_schemas_rule2'\n\t ));\n\n-- ensure a VD for the IRIs which begins with /\nVHOST_REMOVE (lpath=>'/schema/sybasepubs2');\n\nVHOST_DEFINE (\n\tlpath=>'/schemas/sybasepubs2', \n\tppath=>'/DAV/schemas/sybasepubs2/', \n \tis_dav=>1, \n\tvsp_user=>'dba', \n\tis_brws=>0, \n\topts=>vector ('url_rewrite', 'sybase_schemas_rule_list1') \n\t);\n\nDB.DBA.XML_SET_NS_DECL ('hr', 'http://^{URIQADefaultHost}^/schemas/sybasepubs2', 2);\n\n" . . . . "2017-06-13T05:38:12.979551"^^ . "0df47fa0080174ddc8656b84b27acbb6" . "2017-06-13T05:38:12.979551"^^ . . "2017-06-13T05:38:12Z" . . . . "2017-06-13T05:38:12Z" . "VirtRDFViewsSybasePubs2DbScript" .