OpenLink Virtuoso SPARQL Query Editor RDF Views

How To Let Virtuoso Render Relational Data As RDF?

By default, Virtuoso stores all RDF data in a single "RDF Storage" that consists of one four-column relational table containing all triples of all graphs.

System Adminstrator can extend this basic schema with more storages and more groups of triples to represent variety of SQL tables and views stored in Virtuoso or in attached data sources.

Storage <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadStorage>

This pre-defined storage is used by default by all SPARQL queries.

It contains 7 top-level quad maps ("RDF Views"):

  1. Top-level quad map ("RDF View") <urn:qm:9c4aafd744dd18ab9cfd93e579605ebe1c638834>
    The quad map provides triples for graph <http://demo.openlinksw.com/acme-insurance-test#>.
    The data come from "Demo"."acme"."claim", /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.loss_payment lp ON ca.claim_amount_identifier = lp.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT geographic_location_identifier, line_1_address, line_2_address, municipality_name, location_address.state_code, postal_code, country_code, latitude_value, longitude_value FROM demo.acme.geographic_location JOIN demo.acme.location_address ON geographic_location.location_address_identifier = location_address.location_address_identifier JOIN demo.acme.physical_location ON geographic_location.physical_location_identifier = physical_location.physical_location_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.expense_payment ep ON ca.claim_amount_identifier = ep.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.expense_reserve er ON ca.claim_amount_identifier = er.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.loss_reserve lr ON ca.claim_amount_identifier = lr.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount_identifier, policy_amount.policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium ) /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount.policy_amount_identifier, policy_amount.policy_amount, policy_amount.amount_type_code , CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy.policy_identifier, assessment.assessment_identifier FROM demo.acme.agreement_assessment JOIN demo.acme.policy ON policy.policy_identifier = agreement_assessment.agreement_identifier JOIN demo.acme.assessment ON assessment.assessment_identifier = agreement_assessment.assessment_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy.policy_identifier, party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'PH' /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy.policy_identifier, party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'AG' /*]sqlquery]*/, "Demo"."acme"."catastrophe", "Demo"."acme"."insurable_object", "Demo"."acme"."policy_coverage_detail", "Demo"."acme"."policy", /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'AG' /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_identifier = policy_identifier WHERE agreement_party_role.party_role_code = 'AG' /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'PH' /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount.policy_amount_identifier, policy_amount.policy_amount, policy_amount.amount_type_code, CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount.policy_amount_identifier, policy_amount.policy_amount , policy_amount.amount_type_code , CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role WHERE demo.acme.assessment_party_role.party_role_code = 'UW' /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role WHERE assessment_party_role.party_role_code = 'UW' /*]sqlquery]*/, /*[sqlquery[*/ SELECT assessment.assessment_identifier, assessment_description, assessment.begin_date, assessment.end_date, assessment_result_type_code FROM demo.acme.assessment_result ar JOIN demo.acme.underwriting_assessment ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment ON ar.assessment_identifier = assessment.assessment_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT assessment.assessment_identifier, assessment_party_role.party_identifier FROM demo.acme.assessment_result ar JOIN demo.acme.underwriting_assessment ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment ON ar.assessment_identifier = assessment.assessment_identifier JOIN demo.acme.assessment_party_role ON assessment_party_role.assessment_identifier = assessment.assessment_identifier WHERE assessment_party_role.party_role_code = 'UW' /*]sqlquery]*/, "Demo"."acme"."claim_coverage", (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.loss_payment lp ON ca.claim_amount_identifier = lp.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT geographic_location_identifier, line_1_address, line_2_address, municipality_name, location_address.state_code, postal_code, country_code, latitude_value, longitude_value FROM demo.acme.geographic_location JOIN demo.acme.location_address ON geographic_location.location_address_identifier = location_address.location_address_identifier JOIN demo.acme.physical_location ON geographic_location.physical_location_identifier = physical_location.physical_location_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.expense_payment ep ON ca.claim_amount_identifier = ep.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.expense_reserve er ON ca.claim_amount_identifier = er.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount ca JOIN demo.acme.loss_reserve lr ON ca.claim_amount_identifier = lr.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount_identifier, policy_amount.policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium ) /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount.policy_amount_identifier, policy_amount.policy_amount, policy_amount.amount_type_code , CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy.policy_identifier, assessment.assessment_identifier FROM demo.acme.agreement_assessment JOIN demo.acme.policy ON policy.policy_identifier = agreement_assessment.agreement_identifier JOIN demo.acme.assessment ON assessment.assessment_identifier = agreement_assessment.assessment_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy.policy_identifier, party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'PH' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy.policy_identifier, party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'AG' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'AG' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_identifier = policy_identifier WHERE agreement_party_role.party_role_code = 'AG' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role JOIN demo.acme.policy ON agreement_party_role.agreement_identifier = policy.policy_identifier WHERE agreement_party_role.party_role_code = 'PH' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount.policy_amount_identifier, policy_amount.policy_amount, policy_amount.amount_type_code, CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount.policy_amount_identifier, policy_amount.policy_amount , policy_amount.amount_type_code , CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount, policy_amount.policy_coverage_detail_identifier FROM demo.acme.policy_amount JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role WHERE demo.acme.assessment_party_role.party_role_code = 'UW' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role WHERE assessment_party_role.party_role_code = 'UW' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT assessment.assessment_identifier, assessment_description, assessment.begin_date, assessment.end_date, assessment_result_type_code FROM demo.acme.assessment_result ar JOIN demo.acme.underwriting_assessment ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment ON ar.assessment_identifier = assessment.assessment_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT assessment.assessment_identifier, assessment_party_role.party_identifier FROM demo.acme.assessment_result ar JOIN demo.acme.underwriting_assessment ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment ON ar.assessment_identifier = assessment.assessment_identifier JOIN demo.acme.assessment_party_role ON assessment_party_role.assessment_identifier = assessment.assessment_identifier WHERE assessment_party_role.party_role_code = 'UW' /*]sqlquery]*/)
  2. Top-level quad map ("RDF View") <urn:qm:e2bd0f47f73ed3429e8b0a4cd181165ab96c8479>
    The quad map provides triples for graph <http://demo.openlinksw.com/acme-insurance-test-attached#>.
    The data come from /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.loss_payment_attached lp ON ca.claim_amount_identifier = lp.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT geographic_location_identifier, line_1_address, line_2_address, municipality_name, location_address_attached.state_code, postal_code, country_code, latitude_value, longitude_value FROM demo.acme.geographic_location_attached JOIN demo.acme.location_address_attached ON geographic_location_attached.location_address_identifier = location_address_attached.location_address_identifier JOIN demo.acme.physical_location_attached ON geographic_location_attached.physical_location_identifier = physical_location_attached.physical_location_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'AG' /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_identifier = policy_identifier WHERE agreement_party_role_attached.party_role_code = 'AG' /*]sqlquery]*/, "Demo"."acme"."catastrophe_attached", "Demo"."acme"."claim_attached", /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.expense_payment_attached ep ON ca.claim_amount_identifier = ep.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.expense_reserve_attached er ON ca.claim_amount_identifier = er.claim_amount_identifier /*]sqlquery]*/, "Demo"."acme"."insurable_object_attached", /*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.loss_reserve_attached lr ON ca.claim_amount_identifier = lr.claim_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount_identifier, policy_amount_attached.policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium_attached ) /*]sqlquery]*/, "Demo"."acme"."policy_coverage_detail_attached", "Demo"."acme"."policy_attached", /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'PH' /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount_attached.policy_amount_identifier, policy_amount_attached.policy_amount, policy_amount_attached.amount_type_code , CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount_attached.policy_amount_identifier, policy_amount_attached.policy_amount, policy_amount_attached.amount_type_code, CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_amount_attached.policy_amount_identifier, policy_amount_attached.policy_amount , policy_amount_attached.amount_type_code , CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role_attached WHERE demo.acme.assessment_party_role_attached.party_role_code = 'UW' /*]sqlquery]*/, /*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role_attached WHERE assessment_party_role_attached.party_role_code = 'UW' /*]sqlquery]*/, /*[sqlquery[*/ SELECT assessment_attached.assessment_identifier, assessment_description, assessment_attached.begin_date, assessment_attached.end_date, assessment_result_type_code FROM demo.acme.assessment_result_attached ar JOIN demo.acme.underwriting_assessment_attached ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment_attached ON ar.assessment_identifier = assessment_attached.assessment_identifier /*]sqlquery]*/, "Demo"."acme"."claim_coverage_attached", /*[sqlquery[*/ SELECT assessment_attached.assessment_identifier, assessment_party_role_attached.party_identifier FROM demo.acme.assessment_result_attached ar JOIN demo.acme.underwriting_assessment_attached ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment_attached ON ar.assessment_identifier = assessment_attached.assessment_identifier JOIN demo.acme.assessment_party_role_attached ON assessment_party_role_attached.assessment_identifier = assessment_attached.assessment_identifier WHERE assessment_party_role_attached.party_role_code = 'UW' /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_attached.policy_identifier, assessment_attached.assessment_identifier FROM demo.acme.agreement_assessment_attached JOIN demo.acme.policy_attached ON policy_attached.policy_identifier = agreement_assessment_attached.agreement_identifier JOIN demo.acme.assessment_attached ON assessment_attached.assessment_identifier = agreement_assessment_attached.assessment_identifier /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_attached.policy_identifier, party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'PH' /*]sqlquery]*/, /*[sqlquery[*/ SELECT policy_attached.policy_identifier, party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'AG' /*]sqlquery]*/, (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.loss_payment_attached lp ON ca.claim_amount_identifier = lp.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT geographic_location_identifier, line_1_address, line_2_address, municipality_name, location_address_attached.state_code, postal_code, country_code, latitude_value, longitude_value FROM demo.acme.geographic_location_attached JOIN demo.acme.location_address_attached ON geographic_location_attached.location_address_identifier = location_address_attached.location_address_identifier JOIN demo.acme.physical_location_attached ON geographic_location_attached.physical_location_identifier = physical_location_attached.physical_location_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'AG' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_identifier = policy_identifier WHERE agreement_party_role_attached.party_role_code = 'AG' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.expense_payment_attached ep ON ca.claim_amount_identifier = ep.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.expense_reserve_attached er ON ca.claim_amount_identifier = er.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT ca.claim_identifier, ca.claim_amount_identifier, ca.claim_amount FROM demo.acme.claim_amount_attached ca JOIN demo.acme.loss_reserve_attached lr ON ca.claim_amount_identifier = lr.claim_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount_identifier, policy_amount_attached.policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium_attached ) /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'PH' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount_attached.policy_amount_identifier, policy_amount_attached.policy_amount, policy_amount_attached.amount_type_code , CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount_attached.policy_amount_identifier, policy_amount_attached.policy_amount, policy_amount_attached.amount_type_code, CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_amount_attached.policy_amount_identifier, policy_amount_attached.policy_amount , policy_amount_attached.amount_type_code , CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, policy_amount_attached.policy_coverage_detail_identifier FROM demo.acme.policy_amount_attached JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role_attached WHERE demo.acme.assessment_party_role_attached.party_role_code = 'UW' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT DISTINCT party_identifier FROM demo.acme.assessment_party_role_attached WHERE assessment_party_role_attached.party_role_code = 'UW' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT assessment_attached.assessment_identifier, assessment_description, assessment_attached.begin_date, assessment_attached.end_date, assessment_result_type_code FROM demo.acme.assessment_result_attached ar JOIN demo.acme.underwriting_assessment_attached ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment_attached ON ar.assessment_identifier = assessment_attached.assessment_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT assessment_attached.assessment_identifier, assessment_party_role_attached.party_identifier FROM demo.acme.assessment_result_attached ar JOIN demo.acme.underwriting_assessment_attached ua ON ar.assessment_result_identifier = ua.assessment_result_identifier JOIN demo.acme.assessment_attached ON ar.assessment_identifier = assessment_attached.assessment_identifier JOIN demo.acme.assessment_party_role_attached ON assessment_party_role_attached.assessment_identifier = assessment_attached.assessment_identifier WHERE assessment_party_role_attached.party_role_code = 'UW' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_attached.policy_identifier, assessment_attached.assessment_identifier FROM demo.acme.agreement_assessment_attached JOIN demo.acme.policy_attached ON policy_attached.policy_identifier = agreement_assessment_attached.agreement_identifier JOIN demo.acme.assessment_attached ON assessment_attached.assessment_identifier = agreement_assessment_attached.assessment_identifier /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_attached.policy_identifier, party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'PH' /*]sqlquery]*/), (/*[sqlquery[*/ SELECT policy_attached.policy_identifier, party_identifier FROM demo.acme.agreement_party_role_attached JOIN demo.acme.policy_attached ON agreement_party_role_attached.agreement_identifier = policy_attached.policy_identifier WHERE agreement_party_role_attached.party_role_code = 'AG' /*]sqlquery]*/)
  3. Top-level quad map ("RDF View") <urn:qm:2ff4bf5613e8fa0cf36317a800d7bf9038fbaf85>
    The quad map provides triples for graph <http://demo.openlinksw.com/NorthwindDemo#>.
    The data come from /*[sqlquery[*/ SELECT "CategoryID", "CategoryName", "Description" FROM "Demo"."demo"."categories" /*]sqlquery]*/, , /*[sqlquery[*/ SELECT "CustomerID", "CompanyName", "ContactName", "ContactTitle", "Address", "City", "Region", "PostalCode", "Country", "CountryCode", "Phone", "Fax" FROM "Demo"."demo"."customers" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "EmployeeID", "LastName", "FirstName", "Title", "TitleOfCourtesy", "HireDate", "BirthDate", "Address", "City", "Region", "PostalCode", "Country", "CountryCode", "HomePhone", "Extension", "Notes", "ReportsTo" FROM "Demo"."demo"."employees" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "OrderID", "ProductID", "UnitPrice", "Quantity", "Discount" FROM "Demo"."demo"."order_details" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "OrderID", "EmployeeID", "CustomerID", "ShipVia", "OrderDate", "RequiredDate", "ShippedDate", "ShipAddress", "Freight", "ShipName", "ShipCity", "ShipRegion", "ShipPostalCode", "ShipCountry", "ShipCountryCode" FROM "Demo"."demo"."orders" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "ProductID", "CategoryID", "SupplierID", "ProductName", "QuantityPerUnit", "UnitPrice", "UnitsInStock", "UnitsOnOrder","ReorderLevel", "Discontinued" FROM "Demo"."demo"."products" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "ShipperID", "CompanyName", "Phone" FROM "Demo"."demo"."shippers" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "SupplierID", "CompanyName", "ContactName", "ContactTitle", "Address", "City", "Region","PostalCode", "Country", "CountryCode", "Phone", "Fax", "HomePage" FROM "Demo"."demo"."suppliers" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "Name", "Code", "Lat", "Lng", "SmallFlagDAVResourceName", "LargeFlagDAVResourceName", "SmallFlagDAVResourceURI", "LargeFlagDAVResourceURI" FROM "Demo"."demo"."countries" /*]sqlquery]*/, /*[sqlquery[*/ SELECT "Province", "CountryCode" FROM "Demo"."demo"."provinces" /*]sqlquery]*/, (/*[sqlquery[*/ SELECT "CategoryID", "CategoryName", "Description" FROM "Demo"."demo"."categories" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "ProductID", "CategoryID", "SupplierID", "ProductName", "QuantityPerUnit", "UnitPrice", "UnitsInStock", "UnitsOnOrder","ReorderLevel", "Discontinued" FROM "Demo"."demo"."products" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "CustomerID", "CompanyName", "ContactName", "ContactTitle", "Address", "City", "Region", "PostalCode", "Country", "CountryCode", "Phone", "Fax" FROM "Demo"."demo"."customers" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "OrderID", "EmployeeID", "CustomerID", "ShipVia", "OrderDate", "RequiredDate", "ShippedDate", "ShipAddress", "Freight", "ShipName", "ShipCity", "ShipRegion", "ShipPostalCode", "ShipCountry", "ShipCountryCode" FROM "Demo"."demo"."orders" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "EmployeeID", "LastName", "FirstName", "Title", "TitleOfCourtesy", "HireDate", "BirthDate", "Address", "City", "Region", "PostalCode", "Country", "CountryCode", "HomePhone", "Extension", "Notes", "ReportsTo" FROM "Demo"."demo"."employees" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "OrderID", "ProductID", "UnitPrice", "Quantity", "Discount" FROM "Demo"."demo"."order_details" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "ShipperID", "CompanyName", "Phone" FROM "Demo"."demo"."shippers" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "SupplierID", "CompanyName", "ContactName", "ContactTitle", "Address", "City", "Region","PostalCode", "Country", "CountryCode", "Phone", "Fax", "HomePage" FROM "Demo"."demo"."suppliers" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "Name", "Code", "Lat", "Lng", "SmallFlagDAVResourceName", "LargeFlagDAVResourceName", "SmallFlagDAVResourceURI", "LargeFlagDAVResourceURI" FROM "Demo"."demo"."countries" /*]sqlquery]*/), (/*[sqlquery[*/ SELECT "Province", "CountryCode" FROM "Demo"."demo"."provinces" /*]sqlquery]*/)
  4. Top-level quad map ("RDF View") <urn:qm:7fdc3bb66e08d47dfb3ae04cfe2d66a392a923cb>
    The quad map provides triples for graph <http://demo.openlinksw.com/kg-demo#>.
    The data come from "Demo"."kg"."physical"
  5. Top-level quad map ("RDF View") <http://demo.openlinksw.com/schemas/sql-fed-northwind/qm-data>
    The quad map provides triples for graph <http://demo.openlinksw.com/sql-fed-northwind#>.
    The data come from "Demo"."sql_federation"."data"
  6. Top-level quad map ("RDF View") <http://demo.openlinksw.com/schemas/sql-fed-northwind/qm-VoidStatistics>
    The quad map provides triples for graph <http://demo.openlinksw.com/sql-fed-northwind#>.
    The data come from "Demo"."sql_federation"."sql-fed-northwind__Total", "Demo"."sql_federation"."dataCount"
  7. Top-level quad map ("RDF View") <urn:qm:0585993d5191dbdd2c565ce28abb82abfcfdaf64>
    The quad map provides triples for graph <http://demo.openlinksw.com/fint#>.
    The data come from "Demo"."fint"."customer", "Demo"."fint"."account", "Demo"."fint"."fraud_label", "Demo"."fint"."transaction"

The storage has a default quad map <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap>
The quad map provides triples for various graphs named by format <http://www.openlinksw.com/virtrdf-data-formats#default-iid-nonblank>.
The data come from DB.DBA.RDF_QUAD

Storage <http://www.openlinksw.com/schemas/virtrdf#DefaultServiceStorage>

This pre-defined storage is used internally for SERVICE {...} clauses of SPARQL queries; not for regular use.

The storage contains no RDF Views.

The storage has a default quad map <http://www.openlinksw.com/schemas/virtrdf#DefaultServiceMap>
The quad map provides triples for various graphs named by format <http://www.openlinksw.com/virtrdf-data-formats#default-iid-nonblank>.
The data come from system procedure views that compose and send HTTP requests to remote SPARQL service endpoints and then parse answers

Storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads>

This pre-defined storage is to enumerate quad maps mentioned by triggers based on RDF Views; these triggers track changes in source tables of RDF Views and materialize updated content of views as "physical" triples.

It contains 2 top-level quad maps ("RDF Views"):

  1. Top-level quad map ("RDF View") <urn:qm:7fdc3bb66e08d47dfb3ae04cfe2d66a392a923cb>
    The quad map provides triples for graph <http://demo.openlinksw.com/kg-demo#>.
    The data come from "Demo"."kg"."physical"
  2. Top-level quad map ("RDF View") <urn:qm:0585993d5191dbdd2c565ce28abb82abfcfdaf64>
    The quad map provides triples for graph <http://demo.openlinksw.com/fint#>.
    The data come from "Demo"."fint"."customer", "Demo"."fint"."account", "Demo"."fint"."fraud_label", "Demo"."fint"."transaction"

The storage has no default quad map.

Storage <http://www.openlinksw.com/schemas/virtrdf#TmpQuadStorage>

This storage is created by some application or by system administrator.

The storage contains no RDF Views.

The storage has a default quad map <http://www.openlinksw.com/schemas/virtrdf#TmpQuadMap>
The quad map provides triples for various graphs named by format <http://www.openlinksw.com/virtrdf-data-formats#default-iid-blank>.
The data come from DB.DBA.RDF_QUAD_TMP