Context Engines and Loose Coupling

PREFIX skg:    <http://demo.openlinksw.com/schemas/ScaleKG/>
PREFIX schema: <http://schema.org/>
SELECT ?tenantIri ?tenant ?workloadIri ?workload ?tableIri ?tableName ?source
FROM <http://demo.openlinksw.com/ScaleKG#>
WHERE {
  ?tenantIri   a skg:Tenant ; schema:name ?tenant .
  ?workloadIri skg:forTenant ?tenantIri ; schema:name ?workload ; skg:readsFrom ?tableIri .
  ?tableIri    schema:name ?tableName ; skg:inSource ?sourceIri .
  ?sourceIri   schema:name ?source .
}
ORDER BY ?tenant ?workload ?tableName

Live result: 9 rows — tenants (Acme Retail, Borealis Bank, Cobalt Health, Dunmore Logistics) linked to workloads and tables sourced from Snowflake, Databricks, and BigQuery.

PREFIX skg:    <http://demo.openlinksw.com/schemas/ScaleKG/>
PREFIX schema: <http://schema.org/>
SELECT ?linkIri ?sourceDb ?fromRegion ?targetDb ?toRegion ?syncMode ?rbacReplicated
FROM <http://demo.openlinksw.com/ScaleKG#>
WHERE {
  ?linkIri a skg:ReplicationLink ;
           skg:replicatesFrom ?sourceIri ; skg:replicatesTo ?targetIri ;
           skg:syncMode ?syncMode ; skg:rbacReplicated ?rbacReplicated .
  ?sourceIri schema:name ?sourceDb ; skg:hostedOn/skg:inRegion/schema:name ?fromRegion .
  ?targetIri schema:name ?targetDb ; skg:hostedOn/skg:inRegion/schema:name ?toRegion .
}
ORDER BY ?sourceDb

Live result: 3 replication links (acme, borealis, cobalt production → replicas), all flagged rbacReplicated = 0 — the access-control gap a context engine must not silently inherit.

PREFIX nw: <http://demo.openlinksw.com/schemas/Northwind/>
SELECT ?product ?name ?unitsInStock ?unitPrice
FROM <http://demo.openlinksw.com/Northwind#>
WHERE {
  ?product a nw:Products ;
           nw:productname ?name ; nw:unitsinstock ?unitsInStock ; nw:unitprice ?unitPrice .
}
ORDER BY DESC(?unitsInStock)
LIMIT 10

Live result: 10 rows — Rhönbräu Klosterbier (125), Boston Crab Meat (123), Grandma's Boysenberry Spread (120), and seven more.

PREFIX ns: <http://demo.openlinksw.com/schemas/northwind-sqlserver/>
SELECT ?customer ?customer_id ?company_name
FROM <http://demo.openlinksw.com/northwind-sqlserver#>
WHERE {
  ?customer a ns:customers ;
            ns:customerid ?customer_id ; ns:companyname ?company_name .
}
ORDER BY ?customer_id
LIMIT 10

Live result: 10 rows — ALFKI "Alfreds Futterkiste", ANATR "Ana Trujillo Emparedados y helados", and eight more, each linked to a description page.

SELECT ?type (COUNT(?s) AS ?n)
FROM <http://demo.openlinksw.com/databricks-bakehouse-r2rml#>
WHERE { ?s a ?type }
GROUP BY ?type
ORDER BY DESC(?n)

Live result: 5 entity types — Transaction (3,333), Customer (300), CustomerReview (204), Franchise (48), Supplier (27).

SELECT DISTINCT ?generatedClass ?sharedClass
WHERE {
  ?generatedClass rdfs:subClassOf ?sharedClass .
  FILTER(STRSTARTS(STR(?generatedClass), "http://demo.openlinksw.com/schemas/"))
  FILTER(!STRSTARTS(STR(?sharedClass), "http://demo.openlinksw.com/"))
}
ORDER BY ?sharedClass ?generatedClass
LIMIT 25

Live result: 25 alignments — MovieKG/Movie → dbpedia:Film, ScaleKG/Concept → schema:DefinedTerm, ScaleKG/ReplicationLink → schema:Intangible.