This HTML5 document contains 30 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

PrefixNamespace IRI
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n14http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n7http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n13http://rdfs.org/sioc/services#
n12http://vos.openlinksw.com/dataspace/person/dav#
siocthttp://rdfs.org/sioc/types#
n11http://vos.openlinksw.com/dataspace/owiki/wiki/
n17http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtRDFViewNorthwindScript/sioc.
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n15http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n10http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
Subject Item
n12:this
foaf:made
n2:VirtRDFViewNorthwindScript
Subject Item
n7:this
sioc:creator_of
n2:VirtRDFViewNorthwindScript
Subject Item
n14:item
n13:services_of
n2:VirtRDFViewNorthwindScript
Subject Item
n15:this
sioc:creator_of
n2:VirtRDFViewNorthwindScript
Subject Item
n11:VOS
sioc:container_of
n2:VirtRDFViewNorthwindScript
atom:entry
n2:VirtRDFViewNorthwindScript
atom:contains
n2:VirtRDFViewNorthwindScript
Subject Item
n2:VirtRDFViewNorthwindScript
rdf:type
sioct:Comment atom:Entry
dcterms:created
2017-06-13T05:45:20.728172
dcterms:modified
2017-06-29T07:39:48.976771
rdfs:label
VirtRDFViewNorthwindScript
foaf:maker
n10:this n12:this
dc:title
VirtRDFViewNorthwindScript
opl:isDescribedUsing
n17:rdf
sioc:has_creator
n15:this n7:this
sioc:content
---++Virtuoso Northwind Linked Data Views Script to set up your own instance <verbatim> use DB; DB.DBA.exec_stmt ('UPDATE WS.WS.SYS_DAV_RES set RES_TYPE=\'image/jpeg\' where RES_FULL_PATH like \'/DAV/VAD/demo/sql/CAT%\'', 0) ; DB.DBA.exec_stmt ('UPDATE WS.WS.SYS_DAV_RES set RES_TYPE=\'image/jpeg\' where RES_FULL_PATH like \'/DAV/VAD/demo/sql/EMP%\'', 0) ; GRANT SELECT ON "Demo"."demo"."Products" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Suppliers" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Shippers" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Categories" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Customers" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Employees" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Orders" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Order_Details" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Countries" TO "SPARQL"; GRANT SELECT ON "Demo"."demo"."Provinces" TO "SPARQL"; --SPARQL drop quad map graph iri("http://^{URIQADefaultHost}^/Northwind") . --; SPARQL drop silent quad map virtrdf:NorthwindDemo . ; SPARQL prefix northwind: <http://demo.openlinksw.com/schemas/northwind#> drop iri class northwind:Category . drop iri class northwind:CategoryDoc . drop iri class northwind:Shipper . drop iri class northwind:ShipperDoc . drop iri class northwind:Supplier . drop iri class northwind:SupplierDoc . drop iri class northwind:Product . drop iri class northwind:ProductDoc . drop iri class northwind:Customer . drop iri class northwind:CustomerDoc . drop iri class northwind:Employee . drop iri class northwind:EmployeeDoc . drop iri class northwind:Order . drop iri class northwind:OrderDoc . drop iri class northwind:CustomerContact . drop iri class northwind:CustomerContactDoc . drop iri class northwind:OrderLine . drop iri class northwind:OrderLineDoc . drop iri class northwind:Province . drop iri class northwind:ProvinceDoc . drop iri class northwind:Country . drop iri class northwind:CountryDoc . drop iri class northwind:Flag . drop iri class northwind:FlagDoc . drop iri class northwind:dbpedia_iri2 . drop iri class northwind:EmployeePhoto . drop iri class northwind:CategoryPhoto . drop iri class northwind:category_iri . drop iri class northwind:categorydoc_iri . drop iri class northwind:shipper_iri . drop iri class northwind:shipperdoc_iri . drop iri class northwind:supplier_iri . drop iri class northwind:supplierdoc_iri . drop iri class northwind:product_iri . drop iri class northwind:productdoc_iri . drop iri class northwind:customer_iri . drop iri class northwind:customerdoc_iri . drop iri class northwind:employee_iri . drop iri class northwind:employeedoc_iri . drop iri class northwind:order_iri . drop iri class northwind:orderdoc_iri . drop iri class northwind:customercontact_iri . drop iri class northwind:customercontactdoc_iri . drop iri class northwind:orderline_iri . drop iri class northwind:orderlinedoc_iri . drop iri class northwind:province_iri . drop iri class northwind:provincedoc_iri . drop iri class northwind:country_iri . drop iri class northwind:countrydoc_iri . drop iri class northwind:employeephoto_iri . drop iri class northwind:categoryphoto_iri . drop iri class northwind:flag_iri . drop iri class northwind:flagdoc_iri . ; SPARQL prefix northwind: <http://demo.openlinksw.com/schemas/northwind#> create iri class northwind:Category "http://^{URIQADefaultHost}^/Northwind/Category/%d#this" (in category_id integer not null) . create iri class northwind:Shipper "http://^{URIQADefaultHost}^/Northwind/Shipper/%d#this" (in shipper_id integer not null) . create iri class northwind:Supplier "http://^{URIQADefaultHost}^/Northwind/Supplier/%d#this" (in supplier_id integer not null) . create iri class northwind:Product "http://^{URIQADefaultHost}^/Northwind/Product/%d#this" (in product_id integer not null) . create iri class northwind:Customer "http://^{URIQADefaultHost}^/Northwind/Customer/%U#this" (in customer_id varchar not null) . create iri class northwind:Employee "http://^{URIQADefaultHost}^/Northwind/Employee/%U_%U_%d#this" (in employee_firstname varchar not null, in employee_lastname varchar not null, in employee_id integer not null) . create iri class northwind:Order "http://^{URIQADefaultHost}^/Northwind/Order/%d#this" (in order_id integer not null) . create iri class northwind:CustomerContact "http://^{URIQADefaultHost}^/Northwind/CustomerContact/%U#this" (in customer_id varchar not null) . create iri class northwind:OrderLine "http://^{URIQADefaultHost}^/Northwind/OrderLine/%d/%d#this" (in order_id integer not null, in product_id integer not null) . create iri class northwind:Province "http://^{URIQADefaultHost}^/Northwind/Province/%U/%U#this" (in country_name varchar not null, in province_name varchar not null) . create iri class northwind:Country "http://^{URIQADefaultHost}^/Northwind/Country/%U#this" (in country_name varchar not null) . create iri class northwind:Flag "http://^{URIQADefaultHost}^%U#this" (in flag_path varchar not null) . create iri class northwind:dbpedia_iri2 "http://dbpedia.org/resource/%U" (in uname varchar not null) . create iri class northwind:EmployeePhoto "http://^{URIQADefaultHost}^/DAV/VAD/demo/sql/EMP%d#this" (in emp_id varchar not null) . create iri class northwind:CategoryPhoto "http://^{URIQADefaultHost}^/DAV/VAD/demo/sql/CAT%d#this" (in category_id varchar not null) . create iri class northwind:Phone "tel:%s" (in phone_number varchar) . create iri class northwind:Fax "fax:%s" (in fax_number varchar) . ; SPARQL prefix northwind: <http://demo.openlinksw.com/schemas/northwind#> prefix oplsioc: <http://www.openlinksw.com/schemas/oplsioc#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix sioc: <http://rdfs.org/sioc/ns#> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#> prefix ore: <http://www.openarchives.org/ore/terms/> prefix opl: <http://www.openlinksw.com/schema/attribution#> alter quad storage virtrdf:DefaultQuadStorage from Demo.demo.Products as products from Demo.demo.Suppliers as suppliers from Demo.demo.Shippers as shippers from Demo.demo.Categories as categories from Demo.demo.Customers as customers from Demo.demo.Employees as employees from Demo.demo.Orders as orders from Demo.demo.Order_Details as order_lines from Demo.demo.Countries as countries from Demo.demo.Provinces as provinces where (^{suppliers.}^.Country = ^{countries.}^.Name) where (^{customers.}^.Country = ^{countries.}^.Name) where (^{employees.}^.Country = ^{countries.}^.Name) where (^{orders.}^.ShipCountry = ^{countries.}^.Name) { create virtrdf:NorthwindDemo as graph iri ("http://^{URIQADefaultHost}^/Northwind") option (exclusive) { northwind:CustomerContact (customers.CustomerID) a foaf:Person as virtrdf:CustomerContact-foaf_Person . northwind:CustomerContact (customers.CustomerID) a northwind:CustomerContact as virtrdf:CustomerContact-CustomerContact; foaf:name customers.ContactName as virtrdf:CustomerContact-contact_name ; foaf:phone northwind:Phone (customers.Phone) as virtrdf:CustomerContact-foaf_phone ; northwind:is_contact_at northwind:Customer (customers.CustomerID) as virtrdf:CustomerContact-is_contact_at ; northwind:country northwind:Country (customers.Country) as virtrdf:CustomerContact-country ; opl:isDescribedUsing northwind: . northwind:Country (customers.Country) northwind:is_country_of northwind:CustomerContact (customers.CustomerID) as virtrdf:CustomerContact-is_country_of . northwind:Product (products.ProductID) a northwind:Product as virtrdf:Product-ProductID ; northwind:has_category northwind:Category (products.CategoryID) as virtrdf:Product-product_has_category ; northwind:has_supplier northwind:Supplier (products.SupplierID) as virtrdf:Product-product_has_supplier ; northwind:productName products.ProductName as virtrdf:Product-name_of_product ; northwind:quantityPerUnit products.QuantityPerUnit as virtrdf:Product-quantity_per_unit ; northwind:unitPrice products.UnitPrice as virtrdf:Product-unit_price ; northwind:unitsInStock products.UnitsInStock as virtrdf:Product-units_in_stock ; northwind:unitsOnOrder products.UnitsOnOrder as virtrdf:Product-units_on_order ; northwind:reorderLevel products.ReorderLevel as virtrdf:Product-reorder_level ; northwind:discontinued products.Discontinued as virtrdf:Product-discontinued ; opl:isDescribedUsing northwind: . northwind:Category (products.CategoryID) northwind:category_of northwind:Product (products.ProductID) as virtrdf:Product-category_of . northwind:Supplier (products.SupplierID) northwind:supplier_of northwind:Product (products.ProductID) as virtrdf:Product-supplier_of . northwind:Supplier (suppliers.SupplierID) a northwind:Supplier as virtrdf:Supplier-SupplierID ; northwind:companyName suppliers.CompanyName as virtrdf:Supplier-company_name ; northwind:contactName suppliers.ContactName as virtrdf:Supplier-contact_name ; northwind:contactTitle suppliers.ContactTitle as virtrdf:Supplier-contact_title ; northwind:address suppliers.Address as virtrdf:Supplier-address ; northwind:city northwind:dbpedia_iri2(suppliers.City) as virtrdf:Supplier-dbpediacity ; northwind:region suppliers.Region as virtrdf:Supplier-region ; northwind:postalCode suppliers.PostalCode as virtrdf:Supplier-postal_code ; northwind:country northwind:Country(suppliers.Country) as virtrdf:Supplier-country ; northwind:phone northwind:Phone (suppliers.Phone) as virtrdf:Supplier-phone ; northwind:fax northwind:Fax (suppliers.Fax) as virtrdf:Supplier-fax ; northwind:homePage suppliers.HomePage as virtrdf:Supplier-home_page ; opl:isDescribedUsing northwind: . northwind:Country (suppliers.Country) northwind:is_country_of northwind:Supplier (suppliers.SupplierID) as virtrdf:Supplier-is_country_of . northwind:Category (categories.CategoryID) a northwind:Category as virtrdf:Category-CategoryID ; northwind:categoryName categories.CategoryName as virtrdf:Category-home_page ; northwind:description categories.Description as virtrdf:Category-description ; foaf:img northwind:CategoryPhoto(categories.CategoryID) as virtrdf:Category-categories.CategoryPhoto ; opl:isDescribedUsing northwind: . northwind:CategoryPhoto(categories.CategoryID) a northwind:CategoryPhoto as virtrdf:Category-categories.CategoryPhotoID ; opl:isDescribedUsing northwind: . northwind:Shipper (shippers.ShipperID) a northwind:Shipper as virtrdf:Shipper-ShipperID ; northwind:companyName shippers.CompanyName as virtrdf:Shipper-company_name ; northwind:phone northwind:Phone (shippers.Phone) as virtrdf:Shipper-phone ; opl:isDescribedUsing northwind: . northwind:Customer (customers.CustomerID) a northwind:Customer as virtrdf:Customer-CustomerID2 ; a foaf:Organization as virtrdf:Customer-CustomerID ; foaf:name customers.CompanyName as virtrdf:Customer-foaf_name ; northwind:companyName customers.CompanyName as virtrdf:Customer-company_name ; northwind:has_contact northwind:CustomerContact (customers.CustomerID) as virtrdf:Customer-contact ; northwind:country northwind:Country (customers.Country) as virtrdf:Customer-country ; northwind:contactName customers.ContactName as virtrdf:Customer-contact_name ; northwind:contactTitle customers.ContactTitle as virtrdf:Customer-contact_title ; northwind:address customers.Address as virtrdf:Customer-address ; northwind:city northwind:dbpedia_iri2(customers.City) as virtrdf:Customer-dbpediacity ; northwind:region customers.Region as virtrdf:Customer-region ; northwind:PostalCode customers.PostalCode as virtrdf:Customer-postal_code ; foaf:phone northwind:Phone (customers.Phone) as virtrdf:Customer-foaf_phone ; northwind:phone northwind:Phone (customers.Phone) as virtrdf:Customer-phone ; northwind:fax northwind:Fax (customers.Fax) as virtrdf:Customer-fax ; opl:isDescribedUsing northwind: . northwind:Country (customers.Country) northwind:is_country_of northwind:Customer (customers.CustomerID) as virtrdf:Customer-is_country_of . northwind:Employee (employees.FirstName, employees.LastName, employees.EmployeeID) a northwind:Employee as virtrdf:Employee-EmployeeID2 ; a foaf:Person as virtrdf:Employee-EmployeeID ; foaf:surname employees.LastName as virtrdf:Employee-foaf_last_name ; northwind:lastName employees.LastName as virtrdf:Employee-last_name ; foaf:firstName employees.FirstName as virtrdf:Employee-foaf_first_name ; northwind:firstName employees.FirstName as virtrdf:Employee-first_name ; foaf:title employees.Title as virtrdf:Employee-title ; northwind:titleOfCourtesy employees.TitleOfCourtesy as virtrdf:Employee-title_of_courtesy ; foaf:birthday employees.BirthDate as virtrdf:Employee-foaf_birth_date ; northwind:birthday employees.BirthDate as virtrdf:Employee-birth_date ; northwind:hireDate employees.HireDate as virtrdf:Employee-hire_date ; northwind:address employees.Address as virtrdf:Employee-address ; northwind:city northwind:dbpedia_iri2(employees.City) as virtrdf:Employee-dbpediacity ; northwind:region employees.Region as virtrdf:Employee-region ; northwind:postalCode employees.PostalCode as virtrdf:Employee-postal_code ; northwind:country northwind:Country(employees.Country) as virtrdf:Employee-country ; foaf:phone employees.HomePhone as virtrdf:Employee-home_phone ; northwind:extension employees.Extension as virtrdf:Employee-extension ; northwind:notes employees.Notes as virtrdf:Employee-notes ; northwind:reportsTo northwind:Employee(employees.FirstName, employees.LastName, employees.ReportsTo) where (^{employees.}^.ReportsTo = ^{employees.}^.EmployeeID) as virtrdf:Employee-reports_to ; foaf:img northwind:EmployeePhoto(employees.EmployeeID) as virtrdf:Employee-employees.EmployeePhoto ; opl:isDescribedUsing northwind: . northwind:EmployeePhoto(employees.EmployeeID) a northwind:EmployeePhoto as virtrdf:Employee-employees.EmployeePhotoId ; opl:isDescribedUsing northwind: . northwind:Employee (employees.FirstName, employees.LastName, orders.EmployeeID) northwind:is_salesrep_of northwind:Order (orders.OrderID) where (^{orders.}^.EmployeeID = ^{employees.}^.EmployeeID) as virtrdf:Order-is_salesrep_of . northwind:Country (employees.Country) northwind:is_country_of northwind:Employee (employees.FirstName, employees.LastName, employees.EmployeeID) as virtrdf:Employee-is_country_of . northwind:Order (orders.OrderID) a northwind:Order as virtrdf:Order-Order ; northwind:has_customer northwind:Customer (orders.CustomerID) as virtrdf:Order-order_has_customer ; northwind:has_salesrep northwind:Employee (employees.FirstName, employees.LastName, orders.EmployeeID) where (^{orders.}^.EmployeeID = ^{employees.}^.EmployeeID) as virtrdf:Customer-has_salesrep ; northwind:has_employee northwind:Employee (employees.FirstName, employees.LastName, orders.EmployeeID) where (^{orders.}^.EmployeeID = ^{employees.}^.EmployeeID) as virtrdf:Order-order_has_employee ; northwind:orderDate orders.OrderDate as virtrdf:Order-order_date ; northwind:requiredDate orders.RequiredDate as virtrdf:Order-required_date ; northwind:shippedDate orders.ShippedDate as virtrdf:Order-shipped_date ; northwind:order_ship_via northwind:Shipper (orders.ShipVia) as virtrdf:Order-order_ship_via ; northwind:freight orders.Freight as virtrdf:Order-freight ; northwind:shipName orders.ShipName as virtrdf:Order-ship_name ; northwind:shipAddress orders.ShipAddress as virtrdf:Order-ship_address ; northwind:shipCity northwind:dbpedia_iri2(orders.ShipCity) as virtrdf:Order-dbpediaship_city ; northwind:shipRegion orders.ShipRegion as virtrdf:Order-ship_region ; northwind:shipPostal_code orders.ShipPostalCode as virtrdf:Order-ship_postal_code ; northwind:shipCountry northwind:Country(orders.ShipCountry) as virtrdf:ship_country ; opl:isDescribedUsing northwind: . northwind:Country (orders.ShipCountry) northwind:is_ship_country_of northwind:Order (orders.OrderID) as virtrdf:Order-is_country_of . northwind:Customer (orders.CustomerID) northwind:has_order northwind:Order (orders.OrderID) as virtrdf:Order-has_order . northwind:Shipper (orders.ShipVia) northwind:ship_order northwind:Order (orders.OrderID) as virtrdf:Order-ship_order . northwind:OrderLine (order_lines.OrderID, order_lines.ProductID) a northwind:OrderLine as virtrdf:OrderLine-OrderLines ; northwind:has_order_id northwind:Order (order_lines.OrderID) as virtrdf:order_lines_has_order_id ; northwind:has_product_id northwind:Product (order_lines.ProductID) as virtrdf:order_lines_has_product_id ; northwind:unitPrice order_lines.UnitPrice as virtrdf:OrderLine-unit_price ; northwind:quantity order_lines.Quantity as virtrdf:OrderLine-quantity ; northwind:discount order_lines.Discount as virtrdf:OrderLine-discount ; opl:isDescribedUsing northwind: . northwind:Order (orders.OrderID) northwind:is_order_of northwind:OrderLine (order_lines.OrderID, order_lines.ProductID) where (^{orders.}^.OrderID = ^{order_lines.}^.OrderID) as virtrdf:Order-is_order_of . northwind:Product (products.ProductID) northwind:is_product_of northwind:OrderLine (order_lines.OrderID, order_lines.ProductID) where (^{products.}^.ProductID = ^{order_lines.}^.ProductID) as virtrdf:Product-is_product_of . northwind:Country (countries.Name) a northwind:Country as virtrdf:Country-Type2 ; a wgs:SpatialThing as virtrdf:Country-Type ; owl:sameAs northwind:dbpedia_iri2 (countries.Name) ; northwind:name countries.Name as virtrdf:Country-Name ; northwind:code countries.Code as virtrdf:Country-Code ; northwind:smallFlagDAVResourceName countries.SmallFlagDAVResourceName as virtrdf:Country-SmallFlagDAVResourceName ; northwind:largeFlagDAVResourceName countries.LargeFlagDAVResourceName as virtrdf:Country-LargeFlagDAVResourceName ; northwind:smallFlagDAVResourceURI northwind:Flag(countries.SmallFlagDAVResourceURI) as virtrdf:Country-SmallFlagDAVResourceURI ; northwind:largeFlagDAVResourceURI northwind:Flag(countries.LargeFlagDAVResourceURI) as virtrdf:Country-LargeFlagDAVResourceURI ; wgs:lat countries.Lat as virtrdf:Country-Lat ; wgs:long countries.Lng as virtrdf:Country-Lng ; opl:isDescribedUsing northwind: . northwind:Country (countries.Name) northwind:has_province northwind:Province (provinces.CountryCode, provinces.Province) where (^{provinces.}^.CountryCode = ^{countries.}^.Code) as virtrdf:Country-has_province . northwind:Province (provinces.CountryCode, provinces.Province) a northwind:Province as virtrdf:Province-Provinces ; owl:sameAs northwind:dbpedia_iri2 (provinces.Province) ; northwind:has_country_code provinces.CountryCode as virtrdf:has_country_code ; northwind:provinceName provinces.Province as virtrdf:Province-ProvinceName ; opl:isDescribedUsing northwind: . northwind:Province (provinces.CountryCode, provinces.Province) northwind:is_province_of northwind:Country (countries.Name) where (^{countries.}^.Code = ^{provinces.}^.CountryCode) as virtrdf:Province-country_of . }. }. ; delete from DB.DBA.URL_REWRITE_RULE_LIST where urrl_list like 'demo_nw%'; delete from DB.DBA.URL_REWRITE_RULE where urr_rule like 'demo_nw%'; DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'demo_nw_rule2', 1, '(/[^#]*)', vector('path'), 1, '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%23this%%3E+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/Northwind%%3E&format=%U', vector('path', 'path', '*accept*'), null, '(text/rdf.n3)|(application/rdf.xml)', 0, null ); DB.DBA.URLREWRITE_CREATE_REGEX_RULE ( 'demo_nw_rule1', 1, '(/[^#]*)', vector('path'), 1, '/about/html/http/^{URIQADefaultHost}^%s', vector('path'), null, '(text/html)|(\\*/\\*)', 0, 303 ); DB.DBA.URLREWRITE_CREATE_RULELIST ( 'demo_nw_rule_list1', 1, vector ( 'demo_nw_rule1', 'demo_nw_rule2' )); VHOST_REMOVE (lpath=>'/Northwind'); DB.DBA.VHOST_DEFINE (lpath=>'/Northwind', ppath=>'/DAV/home/demo/', vsp_user=>'dba', is_dav=>1, is_brws=>0, opts=>vector ('url_rewrite', 'demo_nw_rule_list1')); create procedure DB.DBA.LOAD_NW_ONTOLOGY_FROM_DAV() { declare content1, urihost varchar; select cast (RES_CONTENT as varchar) into content1 from WS.WS.SYS_DAV_RES where RES_FULL_PATH = '/DAV/VAD/demo/sql/nw.owl'; DB.DBA.RDF_LOAD_RDFXML (content1, 'http://demo.openlinksw.com/schemas/northwind#', 'http://demo.openlinksw.com/schemas/NorthwindOntology/1.0/'); urihost := cfg_item_value(virtuoso_ini_path(), 'URIQA','DefaultHost'); if (urihost = 'demo.openlinksw.com') { DB.DBA.VHOST_REMOVE (lpath=>'/schemas/northwind'); DB.DBA.VHOST_DEFINE (lpath=>'/schemas/northwind', ppath=>'/DAV/VAD/demo/sql/nw.owl', vsp_user=>'dba', is_dav=>1, is_brws=>0); DB.DBA.VHOST_REMOVE (lpath=>'/schemas/northwind#'); DB.DBA.VHOST_DEFINE (lpath=>'/schemas/northwind#', ppath=>'/DAV/VAD/demo/sql/nw.owl', vsp_user=>'dba', is_dav=>1, is_brws=>0); } }; DB.DBA.LOAD_NW_ONTOLOGY_FROM_DAV(); drop procedure DB.DBA.LOAD_NW_ONTOLOGY_FROM_DAV; DB.DBA.XML_SET_NS_DECL ('northwind', 'http://demo.openlinksw.com/schemas/northwind#', 2); </verbatim> ---+++References * [[NorthWindREF][Virtuoso NorthWind SPARQL Reference Collection]]
sioc:id
bcdf6beeb34eb2015acd5ffce9f5bee5
sioc:link
n2:VirtRDFViewNorthwindScript
sioc:has_container
n11:VOS
n13:has_services
n14:item
atom:title
VirtRDFViewNorthwindScript
sioc:links_to
n2:NorthWindREF
atom:source
n11:VOS
atom:author
n12:this
atom:published
2017-06-13T05:45:20Z
atom:updated
2017-06-29T07:39:48Z
sioc:topic
n11:VOS