The business context layer for data and AI

Magnowlia uses a four-layer ontology framework to give your data a clear business meaning. Define metrics, dimensions, and relationships in business terms — then let any AI system use that context: analytics agents, customer support bots, coding assistants, or ops automation. Your ontology is the single source of truth that keeps every consumer consistent.

One definition, everywhere

Define each metric once — formula, grain, filters — and every dashboard, AI answer, and ad-hoc query resolves to the same number. No more reconciliation across teams.

Context for any AI agent

Your ontology is a machine-readable business map. Analytics agents use it for SQL generation. Support agents use it for product relationships. Coding agents use it to understand your domain model.

Governance in Git

Ontologies are Turtle text files in Git. Branch, diff, review, merge — the same workflow your engineers already use. Every change is auditable without a heavyweight catalog tool.

The four-layer architecture

Each layer has a clear responsibility. Business concepts sit at the top, physical tables at the bottom, and the mapping and vocabulary layers bridge between them.

b:

Business Domain

Your actual business entities: customers, orders, products, campaigns. Defined as OWL classes with properties and relationships that mirror how your business thinks about data.

bv:

Business Vocabulary

Framework types for defining metrics (e.g. Total Revenue, Conversion Rate), time dimensions, business constants, and access control policies. This is where metric expressions, SQL templates, and data governance rules live. View vocabulary →

m:

Mapping

Links business concepts to the physical database: mapsToTable, mapsToColumn, join conditions. This is what makes every metric traceable to its source. View vocabulary →

t:

Technical

The physical database schema: tables and columns in your data warehouse (BigQuery, Snowflake, PostgreSQL, Redshift). Imported automatically when you connect a data source.

Visualize your ontology

Explore your business domain as an interactive graph. Classes, properties, metrics, and their relationships are rendered as color-coded nodes and edges — making it easy to understand how your data connects.

Interactive ontology graph showing business entities, metrics, and their relationships

AI-powered ontology editing

Magnus, Magnowlia's built-in AI agent, helps you build and refine your ontology. Describe what you want to model in plain English and Magnus generates valid Turtle syntax, suggests metrics, and maps business concepts to your database schema — all in a three-panel editor with live validation. The ontology you build powers Magnowlia's analytics today and is reusable by any AI system that needs to understand your business.

Magnowlia ontology editor with AI assistant, entity browser, and code editor

Learn more

Understanding

Comparisons

AI & Technical

Technical documentation

Vocabularies and sample ontologies in OWL/Turtle for implementers and developers. Use these when building or extending ontologies that integrate with Magnowlia.

Example: Acme Shop ontology

See how a real ontology looks. The Acme Shop example models an e-commerce platform with all four layers.

b:Order a owl:Class ;
    rdfs:label "Order" ;
    rdfs:comment "A customer purchase transaction" ;
    m:mapsToTable t:public.orders .

b:totalRevenueMetric a bv:Metric ;
    rdfs:label "Total Revenue" ;
    bv:metricExpression "SUM(b:orderTotal)" ;
    bv:timeDimension b:orderDate ;
    bv:sourceEntity b:Order ;
    bv:metricCategory "Revenue" .

The business class b:Order maps to a physical table, and the metric b:totalRevenueMetric defines exactly how revenue is calculated. View the full Acme Shop ontology →

Frequently asked questions

What is a business ontology?+
A business ontology is a formal model that defines your domain's concepts, metrics, dimensions, and relationships in a way both people and systems can use. Unlike a data dictionary (which describes columns), an ontology connects business meaning to database schema so analytics stay consistent.
How is an ontology different from a data dictionary?+
A data dictionary describes tables and column types. A business ontology adds metrics, dimensions, relationships, alternative labels, and explicit mappings to the database. It gives your data a business vocabulary that AI and BI tools can reason about.
What format does Magnowlia use?+
Magnowlia ontologies use OWL (Web Ontology Language) serialized in Turtle format — both are W3C standards widely used in knowledge engineering. The format is human-readable and version-controllable in Git.
Do I need to know Turtle syntax?+
No. Magnus, Magnowlia's built-in AI ontology agent, does the heavy lifting: he analyzes your schema, proposes business concepts, and generates valid Turtle syntax. Your job is to review that Magnus understood your domain correctly and apply the changes with a single click.
Can I use my existing semantic layer?+
Yes. If you already use dbt, Cube, or another semantic layer tool, you can complement it with a Magnowlia ontology. The ontology adds formal relationships, business context, and AI-readability on top of your existing metric definitions.
Can the ontology be used by AI systems other than Magnowlia?+
Yes. The ontology is stored as standard OWL/Turtle, which any system that reads RDF can consume. While Magnowlia uses it for analytics today, the same ontology can provide context to customer support agents, coding assistants, ops automation, or any AI that needs to understand your business domain.
What data sources are supported?+
Magnowlia connects to BigQuery, Snowflake, PostgreSQL, and Redshift. When you connect a data source, the technical layer (tables and columns) is imported automatically, giving you a head start on building the ontology.

Built on open standards

Magnowlia ontologies use W3C standards: OWL for classes and relationships, RDFS for labels and descriptions, SKOS for alternative labels, and Turtle as the serialization format.

W3C OWLRDF/TurtleRDFSSKOS

Give your business a shared language

Define your business ontology once. Use it for analytics today, and for any AI agent tomorrow. No credit card required.

Get Started Free
Business Ontology — The Context Layer for Data & AI | Magnowlia | Magnowlia