Magnowlia

Magnowlia Mapping Vocabulary

Vocabulary for mapping business concepts to physical database structures in the Magnowlia ontology framework.

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

Prefix: m:

Download as Turtle (.ttl)

Terms (10)

m:BusinessViewm:Tablem:Columnm:mapsToTablem:mapsToColumnm:belongsToTablem:joinConditionm:unionOfTablesm:realizedBym:tablePrefix

Classes

m:BusinessView Class
https://magnowlia.com/ontology/mapping#BusinessView
Logical business view that may combine or filter one or more technical tables.
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.

Object Properties

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

Datatype Properties

m:joinCondition DatatypeProperty
https://magnowlia.com/ontology/mapping#joinCondition
SQL-like join/filter rule for composite or filtered business views.
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-like realization of a business relationship via technical tables.
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
Related resources
Ontology overview What is a business ontology? Mapping vocabulary Business vocabulary Acme Shop sample
Build your own ontology with Magnowlia

Connect your data, define metrics, and start asking questions in plain English.

Get Started Free