Building an Operational Ontology

Demonstrates how disparate order feeds (north.tbl_order and south.SALES_ORDER) are queried as unified Order objects across regional boundaries.

PREFIX post: <https://www.dataengineeringweekly.com/p/building-an-operational-ontology#>
PREFIX schema: <http://schema.org/>

SELECT ?order ?sourceSystem ?customerName ?orderStatus ?total ?isShipped
FROM <https://linkeddata.uriburner.com/DAV/demos/daas/building-an-operational-ontology-gemini_3_7_flash-1.ttl>
WHERE {
  ?order a post:Order ;
         post:sourceSystem ?sys ;
         post:hasCustomer ?cust ;
         post:orderStatus ?orderStatus ;
         post:orderTotal ?total ;
         post:isShipped ?isShipped .
  ?sys schema:name ?sourceSystem .
  ?cust schema:name ?customerName .
}
ORDER BY ?order

Answers the cross-system question 'Which orders contain this product and who bought them?' via multi-hop link traversal.

PREFIX post: <https://www.dataengineeringweekly.com/p/building-an-operational-ontology#>
PREFIX schema: <http://schema.org/>

SELECT ?customerName ?order ?productName ?sku ?price
FROM <https://linkeddata.uriburner.com/DAV/demos/daas/building-an-operational-ontology-gemini_3_7_flash-1.ttl>
WHERE {
  ?cust a post:Customer ;
        schema:name ?customerName .
  ?order a post:Order ;
         post:hasCustomer ?cust ;
         post:containsProduct ?prod .
  ?prod schema:name ?productName ;
        post:sku ?sku ;
        schema:price ?price .
}
ORDER BY ?customerName ?order

Evaluates the cancelOrder precondition across all orders, determining which orders can be canceled and identifying the refusal error code for shipped orders.

PREFIX post: <https://www.dataengineeringweekly.com/p/building-an-operational-ontology#>
PREFIX schema: <http://schema.org/>

SELECT ?order ?orderStatus ?isShipped 
       (IF(?isShipped = true, "REFUSED: SHIPPED_ORDER_CANNOT_BE_CANCELLED", "ALLOWED: Can Invoke cancelOrder") AS ?actionEvaluation)
FROM <https://linkeddata.uriburner.com/DAV/demos/daas/building-an-operational-ontology-gemini_3_7_flash-1.ttl>
WHERE {
  ?order a post:Order ;
         post:orderStatus ?orderStatus ;
         post:isShipped ?isShipped .
}
ORDER BY ?isShipped ?order

Inspects the triple-tier authority classification for Order attributes, illustrating source-backed, ontology-owned, and derived fields.

PREFIX post: <https://www.dataengineeringweekly.com/p/building-an-operational-ontology#>
PREFIX schema: <http://schema.org/>

SELECT ?authorityTier ?description (SAMPLE(?exampleField) AS ?exampleAttribute)
FROM <https://linkeddata.uriburner.com/DAV/demos/daas/building-an-operational-ontology-gemini_3_7_flash-1.ttl>
WHERE {
  VALUES (?authorityTier ?description ?exampleField) {
    ("Source-Backed" "SSoT resides in upstream DB; write-back required" "post:orderStatus, post:orderTotal")
    ("Ontology-Owned" "SSoT resides in ontology store; overlay preserved" "post:assignee, post:triageNote")
    ("Derived" "Computed dynamically; read-only and never written" "post:itemCount, post:taxEstimate")
  }
}
GROUP BY ?authorityTier ?description
ORDER BY ?authorityTier

Explores immutable audit log records, reviewing applied and refused action invocations, timestamps, agents, and error codes.

PREFIX post: <https://www.dataengineeringweekly.com/p/building-an-operational-ontology#>
PREFIX schema: <http://schema.org/>

SELECT ?auditEntry ?timestamp ?invokedBy ?order ?actionOutcome ?refusalCode ?message
FROM <https://linkeddata.uriburner.com/DAV/demos/daas/building-an-operational-ontology-gemini_3_7_flash-1.ttl>
WHERE {
  ?auditEntry a post:AuditLogEntry ;
              post:timestamp ?timestamp ;
              post:invokedBy ?invokedBy ;
              post:targetOrder ?order ;
              post:executionOutcome ?actionOutcome ;
              post:auditMessage ?message .
  OPTIONAL { ?auditEntry post:refusalErrorCode ?refusalCode . }
}
ORDER BY DESC(?timestamp)

Queries the named graph for all declared entity types, providing instance counts and sample entity IRIs.

SELECT ?entityType (COUNT(?s) AS ?entityCount) (SAMPLE(?s) AS ?sampleEntity)
FROM <https://linkeddata.uriburner.com/DAV/demos/daas/building-an-operational-ontology-gemini_3_7_flash-1.ttl>
WHERE {
  ?s a ?entityType .
}
GROUP BY ?entityType
ORDER BY DESC(?entityCount)