%VOSNAV%

#NorthwindDatabase
---++ <nowiki>NorthWind</nowiki> SPARQL Reference

%TOC%

Note: Default Graph URI value used in the queries below is: http://demo.openlinksw.com/Northwind

---+++Key Northwind Data Space to Northwind schema Mappings

|Key|Northwind|Sample Value|
|Class|Product|ndw:Order|
|Property|productName|ndw:productName|
|Property|unitPrice|ndw:unitPrice|
|Attribute|has_category|ndw:has_category|
|Attribute|has_supplier|ndw:has_supplier|

   * [[NorthWindREFExample1][Dump of Orders with details for customers, company name, country, employee, etc.]]
   * [[NorthWindREFExample2][Dump of Products with details for product name; category; supplier; supplier company name and phone, for all categories with name containing "Sea".]]
   * [[NorthWindREFExample3][Dump all Suppliers with their details.]]
   * [[NorthWindREFExample4][Dump all Categories containing in their description "reads"]]
   * [[NorthWindREFExample5][Dump all People which are contacts of customers and show customer company details.]]
   * [[NorthWindREFExample6][Dump all Employees including hire date timestamps accurate to the second (as opposed to millisecond) ]]
   * [[NorthWindREFExample7][Dump all Customers (subclass of Organizations) ]]
   * [[NorthWindREFExample8][Dump all Provinces]]
   * [[NorthWindREFExample9][Dump all <nowiki>OrderLines</nowiki>  including order date timestamps accurate to the second (as opposed to millisecond) and quantity expression.]]
   * [[NorthWindREFExample10][Dump all Countries containing in their name "United".]]
   
---+++Learn More 
   * [[VirtRDFViewNorthwindScript][ Virtuoso NorthWind RDF Views Deployment Script]]
   * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSSIOCRef][ODS SIOC reference]]
   * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSAtomOWLRef][Query ODS Data Spaces using SPARQL and Atom OWL Ontology]]
   * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSSKOSRef][Query ODS Data Spaces using SPARQL and SKOS Ontology]]
   * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSFOAFRef][Query ODS Data Spaces using SPARQL and FOAF Ontology]]
   * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSAnnoteaRef][Query ODS Data Spaces using SPARQL and Annotea Ontology]]
   * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/VOSODSSparqlSamples][ODS SPARQL Samples]]
   * [[SIOCRefTutorial][Query Virtuoso Tutorials using SPARQL]]
   * [[SIOCRefDocs][Query Virtuoso Documentation using SPARQL]]
   * [[WordPressSIOCRef][WordPress SIOC Reference]]
   * [[MediaWikiSIOCRef][MedaWiki SIOC Reference]]
   * [[PHPBB3SIOCRef][PHPBB SIOC Reference]]
   * [[DrupalSIOCRef][Drupal SIOC Reference]]

CategoryRDF CategoryVirtuoso CategorySPARQL

%VOSCOPY%