@prefix rr: . @prefix SQLServer: . @prefix sqlserver-stat: . @prefix rdf: . @prefix void: . @prefix scovo: . @prefix aowl: . <#TriplesMapCategories> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Categories" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/categories/CategoryID={CategoryID}"; rr:class SQLServer:Categories; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:categoryid ] ; rr:objectMap [ rr:column "CategoryID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:categoryname ] ; rr:objectMap [ rr:column "CategoryName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:description ] ; rr:objectMap [ rr:column "Description" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:picture ] ; rr:objectMap [ rr:column "Picture" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:categories_of_products ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapProducts>; rr:joinCondition [ rr:child "CategoryID" ; rr:parent "CategoryID" ] ; ]; ] . <#TriplesMapCountries> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Countries" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/countries/Name={Name}"; rr:class SQLServer:Countries; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:name ] ; rr:objectMap [ rr:column "Name" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:code ] ; rr:objectMap [ rr:column "Code" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:smallflagdavresourcename ] ; rr:objectMap [ rr:column "SmallFlagDAVResourceName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:largeflagdavresourcename ] ; rr:objectMap [ rr:column "LargeFlagDAVResourceName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:smallflagdavresourceuri ] ; rr:objectMap [ rr:column "SmallFlagDAVResourceURI" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:largeflagdavresourceuri ] ; rr:objectMap [ rr:column "LargeFlagDAVResourceURI" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:lat ] ; rr:objectMap [ rr:column "Lat" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:lng ] ; rr:objectMap [ rr:column "Lng" ]; ] . <#TriplesMapCustomers> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Customers" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/customers/CustomerID={CustomerID}"; rr:class SQLServer:Customers; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:customerid ] ; rr:objectMap [ rr:column "CustomerID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:companyname ] ; rr:objectMap [ rr:column "CompanyName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:contactname ] ; rr:objectMap [ rr:column "ContactName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:contacttitle ] ; rr:objectMap [ rr:column "ContactTitle" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:address ] ; rr:objectMap [ rr:column "Address" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:city ] ; rr:objectMap [ rr:column "City" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:region ] ; rr:objectMap [ rr:column "Region" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:postalcode ] ; rr:objectMap [ rr:column "PostalCode" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:country ] ; rr:objectMap [ rr:column "Country" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:phone ] ; rr:objectMap [ rr:column "Phone" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:fax ] ; rr:objectMap [ rr:column "Fax" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:customers_of_orders ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapOrders>; rr:joinCondition [ rr:child "CustomerID" ; rr:parent "CustomerID" ] ; ]; ] . <#TriplesMapEmployees> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Employees" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/employees/EmployeeID={EmployeeID}"; rr:class SQLServer:Employees; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:employeeid ] ; rr:objectMap [ rr:column "EmployeeID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:lastname ] ; rr:objectMap [ rr:column "LastName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:firstname ] ; rr:objectMap [ rr:column "FirstName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:title ] ; rr:objectMap [ rr:column "Title" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:titleofcourtesy ] ; rr:objectMap [ rr:column "TitleOfCourtesy" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:birthdate ] ; rr:objectMap [ rr:column "BirthDate" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:hiredate ] ; rr:objectMap [ rr:column "HireDate" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:address ] ; rr:objectMap [ rr:column "Address" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:city ] ; rr:objectMap [ rr:column "City" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:region ] ; rr:objectMap [ rr:column "Region" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:postalcode ] ; rr:objectMap [ rr:column "PostalCode" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:country ] ; rr:objectMap [ rr:column "Country" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:homephone ] ; rr:objectMap [ rr:column "HomePhone" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:extension ] ; rr:objectMap [ rr:column "Extension" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:photo ] ; rr:objectMap [ rr:column "Photo" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:notes ] ; rr:objectMap [ rr:column "Notes" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:photopath ] ; rr:objectMap [ rr:column "PhotoPath" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:employees_has_employees ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/employees/ReportsTo={ReportsTo}" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:employees_of_orders ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapOrders>; rr:joinCondition [ rr:child "EmployeeID" ; rr:parent "EmployeeID" ] ; ]; ] . <#TriplesMapEnrolmentSource> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "EnrolmentSource" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/enrolmentsource/id={id}"; rr:class SQLServer:EnrolmentSource; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:id ] ; rr:objectMap [ rr:column "id" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:provider ] ; rr:objectMap [ rr:column "provider" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:providerlocation ] ; rr:objectMap [ rr:column "providerLocation" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:session ] ; rr:objectMap [ rr:column "session" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:studentid ] ; rr:objectMap [ rr:column "studentID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:legalstatus ] ; rr:objectMap [ rr:column "legalStatus" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:currentstatus ] ; rr:objectMap [ rr:column "currentStatus" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:registrationstatus ] ; rr:objectMap [ rr:column "registrationStatus" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:registrationtype ] ; rr:objectMap [ rr:column "registrationType" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:programid ] ; rr:objectMap [ rr:column "programID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:specializationid ] ; rr:objectMap [ rr:column "specializationID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:yearofstudy ] ; rr:objectMap [ rr:column "yearofStudy" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:instructionalhours ] ; rr:objectMap [ rr:column "instructionalHours" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:practicumhours ] ; rr:objectMap [ rr:column "practicumHours" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:completionstatus ] ; rr:objectMap [ rr:column "completionStatus" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:gender ] ; rr:objectMap [ rr:column "gender" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:birthdate ] ; rr:objectMap [ rr:column "birthdate" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:language ] ; rr:objectMap [ rr:column "language" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:countryofcitizenship ] ; rr:objectMap [ rr:column "countryOfCitizenship" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:sourcecountry ] ; rr:objectMap [ rr:column "sourceCountry" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:postalcode ] ; rr:objectMap [ rr:column "postalCode" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:admissionstatus ] ; rr:objectMap [ rr:column "admissionStatus" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:attainment ] ; rr:objectMap [ rr:column "attainment" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:gradecompleted ] ; rr:objectMap [ rr:column "gradeCompleted" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:gradecompletedyear ] ; rr:objectMap [ rr:column "gradeCompletedYear" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:gradecompletedschool ] ; rr:objectMap [ rr:column "gradeCompletedSchool" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:academicyear ] ; rr:objectMap [ rr:column "academicYear" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:albertastudentnumber ] ; rr:objectMap [ rr:column "albertaStudentNumber" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:aboriginalindicator ] ; rr:objectMap [ rr:column "aboriginalIndicator" ]; ] . <#TriplesMapOrder%20Details> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Order Details" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/order_details/OrderID={OrderID}/ProductID={ProductID}"; rr:class SQLServer:Order_Details; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:unitprice ] ; rr:objectMap [ rr:column "UnitPrice" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:quantity ] ; rr:objectMap [ rr:column "Quantity" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:discount ] ; rr:objectMap [ rr:column "Discount" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:order_details_has_orders ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/orders/OrderID={OrderID}" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:order_details_has_products ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/products/ProductID={ProductID}" ]; ] . <#TriplesMapOrders> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Orders" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/orders/OrderID={OrderID}"; rr:class SQLServer:Orders; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:orderid ] ; rr:objectMap [ rr:column "OrderID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:orderdate ] ; rr:objectMap [ rr:column "OrderDate" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:requireddate ] ; rr:objectMap [ rr:column "RequiredDate" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shippeddate ] ; rr:objectMap [ rr:column "ShippedDate" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shipvia ] ; rr:objectMap [ rr:column "ShipVia" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:freight ] ; rr:objectMap [ rr:column "Freight" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shipname ] ; rr:objectMap [ rr:column "ShipName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shipaddress ] ; rr:objectMap [ rr:column "ShipAddress" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shipcity ] ; rr:objectMap [ rr:column "ShipCity" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shipregion ] ; rr:objectMap [ rr:column "ShipRegion" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shippostalcode ] ; rr:objectMap [ rr:column "ShipPostalCode" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:shipcountry ] ; rr:objectMap [ rr:column "ShipCountry" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:orders_has_customers ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/customers/CustomerID={CustomerID}" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:orders_has_employees ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/employees/EmployeeID={EmployeeID}" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapOrder%20Details>; rr:joinCondition [ rr:child "OrderID" ; rr:parent "OrderID" ] ; ]; ] . <#TriplesMapProducts> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Products" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/products/ProductID={ProductID}"; rr:class SQLServer:Products; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:productid ] ; rr:objectMap [ rr:column "ProductID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:productname ] ; rr:objectMap [ rr:column "ProductName" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:supplierid ] ; rr:objectMap [ rr:column "SupplierID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:quantityperunit ] ; rr:objectMap [ rr:column "QuantityPerUnit" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:unitprice ] ; rr:objectMap [ rr:column "UnitPrice" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:unitsinstock ] ; rr:objectMap [ rr:column "UnitsInStock" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:unitsonorder ] ; rr:objectMap [ rr:column "UnitsOnOrder" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:reorderlevel ] ; rr:objectMap [ rr:column "ReorderLevel" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:discontinued ] ; rr:objectMap [ rr:column "Discontinued" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:products_has_categories ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/categories/CategoryID={CategoryID}" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapOrder%20Details>; rr:joinCondition [ rr:child "ProductID" ; rr:parent "ProductID" ] ; ]; ] . <#TriplesMapRegion> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Region" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/region/RegionID={RegionID}"; rr:class SQLServer:Region; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:regionid ] ; rr:objectMap [ rr:column "RegionID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:regiondescription ] ; rr:objectMap [ rr:column "RegionDescription" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:region_of_territories ] ; rr:objectMap [ rr:parentTriplesMap <#TriplesMapTerritories>; rr:joinCondition [ rr:child "RegionID" ; rr:parent "RegionID" ] ; ]; ] . <#TriplesMapTerritories> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "SQLServer" ; rr:tableOwner "Northwind" ; rr:tableName "Territories" ]; rr:subjectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/territories/TerritoryID={TerritoryID}"; rr:class SQLServer:Territories; rr:graph ]; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:territoryid ] ; rr:objectMap [ rr:column "TerritoryID" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:territorydescription ] ; rr:objectMap [ rr:column "TerritoryDescription" ]; ] ; rr:predicateObjectMap [ rr:predicateMap [ rr:constant SQLServer:territories_has_region ] ; rr:objectMap [ rr:termType rr:IRI ; rr:template "http://demo.openlinksw.com/SQLServer/region/RegionID={RegionID}" ]; ] .