Magnowlia Mapping Vocabulary

m:BusinessView Class

https://magnowlia.com/ontology/mapping#BusinessView

Logical business view over one or two technical tables. With one table, m:joinCondition acts as a WHERE filter (filtered BV). With two tables, m:joinCondition is the ON clause of an INNER JOIN linking them.

m:Table Class

https://magnowlia.com/ontology/mapping#Table

Physical database table or persisted view.

m:Column Class

https://magnowlia.com/ontology/mapping#Column

Physical database column used for mapping business attributes and metrics.

m:mapsToTable ObjectProperty

https://magnowlia.com/ontology/mapping#mapsToTable

Links a business class or view to one or more underlying physical tables.

Domain: owl:Class

Range: m:Table

m:mapsToColumn ObjectProperty

https://magnowlia.com/ontology/mapping#mapsToColumn

Links a business attribute to the physical column(s) that realize it.

Domain: owl:DatatypeProperty

Range: m:Column

m:belongsToTable ObjectProperty

https://magnowlia.com/ontology/mapping#belongsToTable

Links a physical database column to its containing table.

Domain: m:Column

Range: m:Table

m:joinCondition DatatypeProperty

https://magnowlia.com/ontology/mapping#joinCondition

For a single-table m:BusinessView, a SQL WHERE-style filter applied to that table. For a two-table m:BusinessView, the ON condition of the INNER JOIN linking the primary table to the secondary table listed in m:mapsToTable (e.g. "primary.id = secondary.fk").

Domain: owl:Class

Range: xsd:string

m:unionOfTables DatatypeProperty

https://magnowlia.com/ontology/mapping#unionOfTables

SQL-like UNION rule describing a business union view.

Domain: owl:Class

Range: xsd:string

m:realizedBy DatatypeProperty

https://magnowlia.com/ontology/mapping#realizedBy

SQL join condition realizing a relationship via technical tables. Bare table.column references; SQL functions, ::casts and string literals are allowed; multi-table joins through bridge tables are supported as a single linear equality chain from the domain table to the range table.

Domain: owl:ObjectProperty

Range: xsd:string

m:relationshipRole DatatypeProperty

https://magnowlia.com/ontology/mapping#relationshipRole

Semantic role of a relationship for path-enumeration filtering: Membership, Transactional, Audit, Self, Denormalized, or Polymorphic.

Domain: owl:ObjectProperty

Range: xsd:string

m:tablePrefix DatatypeProperty

https://magnowlia.com/ontology/mapping#tablePrefix

Schema prefix for SQL table references. Composed with the table URI fragment to form the qualified SQL table name.

Domain: m:Table

Range: xsd:string

m:tableName DatatypeProperty

https://magnowlia.com/ontology/mapping#tableName

Raw SQL table identifier. When present on m:Table, takes precedence over the URI fragment for SQL composition. Lets disambiguated URIs (e.g. t:orders_db1) coexist with the raw SQL identifier (orders). SEE: ADR-050.

Domain: m:Table

Range: xsd:string

Related resources

Ontology overview What is a business ontology? Mapping vocabulary Business vocabulary Acme Shop sample

Build your own ontology with Magnowlia