postgres_postgres_jdbc_mt_codex_20260403 Knowledge Graph

A virtual RDF Knowledge Graph generated from postgres.postgres_jdbc_mt via Virtuoso RDF Views, demonstrating Linked Data principles for entity, entity type, and relationship naming.

16 Entity Types

134 Properties

Graph IRI: demo.openlinksw.com/postgres_postgres_jdbc_mt_codex_20260403#

Ontology: demo.openlinksw.com/schemas/postgres_postgres_jdbc_mt_codex_20260403/

Virtual RDF View

🔗 The Four Linked Data Principles

1

🌐

Use HTTP URIs as Names

Every entity, class, and property in the Knowledge Graph is identified by a dereferenceable HTTP IRI, using the generated path segment from this session rather than local identifiers.

http://demo.openlinksw.com/postgres_postgres_jdbc_mt_codex_20260403/clients/clientid/CLI001#this

2

🔍

Make URIs Dereferenceable

The generated rewrite-rule script is meant to route entity lookups into SPARQL DESCRIBE responses so generated rows behave like first-class web resources.

GET /postgres_postgres_jdbc_mt_codex_20260403/banks/bankid/BNK001
→ 303 → SPARQL DESCRIBE

3

📦

Return Useful Information

Each dereference is expected to return typed RDF triples: class membership, column values as typed literals, and links to related entities where foreign keys are mapped as object properties.

ns1:this rdf:type postgres_postgres_jdbc_mt_codex_20260403:clients ;
postgres_postgres_jdbc_mt_codex_20260403:clientname "Alice Cooper" .

4

🔀

Link to Other URIs

Foreign-key relationships are materialized as RDF object properties linking to fully dereferenceable related resources, using the same generated IRI family.

postgres_postgres_jdbc_mt_codex_20260403:has_countries
<…/countries/countryid/US#this> .

🧬 Entity IRI Anatomy

Every entity IRI follows the same deterministic pattern as the reference document, but with this session's generated path segment and templates:

http://demo.openlinksw.com/postgres_postgres_jdbc_mt_codex_20260403/clients/clientid/CLI001#this ← click to dereference

http:// — Protocol

demo.openlinksw.com — Host

postgres_postgres_jdbc_mt_codex_20260403 — Graph path segment

clients — Table name

clientid — PK column

CLI001 — PK value

#this — Resource fragment

🏷️ Naming Patterns — Entity Types, Properties & Relationships

Entity Type IRIs (Classes)

Pattern<ontology-ns>/{table}

clientspostgres_postgres_jdbc_mt_codex_20260403:clients

salespostgres_postgres_jdbc_mt_codex_20260403:sales

productspostgres_postgres_jdbc_mt_codex_20260403:products

employeespostgres_postgres_jdbc_mt_codex_20260403:employees

countriespostgres_postgres_jdbc_mt_codex_20260403:countries

supplierspostgres_postgres_jdbc_mt_codex_20260403:suppliers

Datatype Property IRIs

Pattern<ontology-ns>/{column}

clientnamepostgres_postgres_jdbc_mt_codex_20260403:clientname

salesamountpostgres_postgres_jdbc_mt_codex_20260403:salesamount

salesdatepostgres_postgres_jdbc_mt_codex_20260403:salesdate

unitpricepostgres_postgres_jdbc_mt_codex_20260403:unitprice

banknamepostgres_postgres_jdbc_mt_codex_20260403:bankname

balanceamtpostgres_postgres_jdbc_mt_codex_20260403:balanceamt

Object Property IRIs

Pattern<ontology-ns>/{relation}

clients → countriespostgres_postgres_jdbc_mt_codex_20260403:has_countries

countries → clientspostgres_postgres_jdbc_mt_codex_20260403:countries_of

FK targetFull entity IRI

InverseAuto-generated

Quad mapqm-{table}

Graphpostgres_postgres_jdbc_mt_codex_20260403#

🕸️ Entity Relationship Graph (Key Tables)

📋 All 16 Quad Maps — Entity Type & IRI Template

Table	Entity Type IRI	Entity IRI Template	PK Column(s)	Type
acctbal	postgres_postgres_jdbc_mt_codex_20260403:acctbal	/postgres_postgres_jdbc_mt_codex_20260403/acctbal/accountid/ACC001#this	accountid	entity
banks	postgres_postgres_jdbc_mt_codex_20260403:banks	/postgres_postgres_jdbc_mt_codex_20260403/banks/bankid/BNK001#this	bankid	entity
calendar	postgres_postgres_jdbc_mt_codex_20260403:calendar	/postgres_postgres_jdbc_mt_codex_20260403/calendar/date/2024-01-01#this	date	entity
channels	postgres_postgres_jdbc_mt_codex_20260403:channels	/postgres_postgres_jdbc_mt_codex_20260403/channels/channelid/CH001#this	channelid	entity
clientcomplaints	postgres_postgres_jdbc_mt_codex_20260403:clientcomplaints	/postgres_postgres_jdbc_mt_codex_20260403/clientcomplaints/complid/COMP001#this	complid	entity
clients	postgres_postgres_jdbc_mt_codex_20260403:clients	/postgres_postgres_jdbc_mt_codex_20260403/clients/clientid/CLI001#this	clientid	linked
countries	postgres_postgres_jdbc_mt_codex_20260403:countries	/postgres_postgres_jdbc_mt_codex_20260403/countries/countryid/US#this	countryid	linked
employees	postgres_postgres_jdbc_mt_codex_20260403:employees	/postgres_postgres_jdbc_mt_codex_20260403/employees/employeeid/EMP001#this	employeeid	entity
products	postgres_postgres_jdbc_mt_codex_20260403:products	/postgres_postgres_jdbc_mt_codex_20260403/products/productid/PRD001#this	productid	entity
purchases	postgres_postgres_jdbc_mt_codex_20260403:purchases	/postgres_postgres_jdbc_mt_codex_20260403/purchases/purchaseid/PUR001#this	purchaseid	entity
regions	postgres_postgres_jdbc_mt_codex_20260403:regions	/postgres_postgres_jdbc_mt_codex_20260403/regions/regionid/REG001#this	regionid	entity
returns	postgres_postgres_jdbc_mt_codex_20260403:returns	/postgres_postgres_jdbc_mt_codex_20260403/returns/returnid/RET001#this	returnid	entity
sales	postgres_postgres_jdbc_mt_codex_20260403:sales	/postgres_postgres_jdbc_mt_codex_20260403/sales/salesid/SAL001#this	salesid	entity
shipments	postgres_postgres_jdbc_mt_codex_20260403:shipments	/postgres_postgres_jdbc_mt_codex_20260403/shipments/shipmentid/SHP001#this	shipmentid	entity
suppliers	postgres_postgres_jdbc_mt_codex_20260403:suppliers	/postgres_postgres_jdbc_mt_codex_20260403/suppliers/supplierid/SUP001#this	supplierid	entity
v_unified_star_schema	postgres_postgres_jdbc_mt_codex_20260403:v_unified_star_schema	/postgres_postgres_jdbc_mt_codex_20260403/v_unified_star_schema/fact_type/sale/transaction_id/TX001/sales_id/SAL001/purchase_id/PUR001/shipment_id/SHP001/return_id/RET001#this	fact_type, transaction_id, sales_id, purchase_id, shipment_id, return_id	view