What is a Semantic Layer? (Dimensional Data Modeling)

Star Schema


A semantic layer is a semantic data model that shows to the business user:

It will create/model a logical star schema by:

Once the semantic layer has been build, the business user will see a logical star schema that it can query (business query). This query is called a semantic query.

The semantic layer will translate:

It's a key components of business intelligence / data analysis application because it provides a translation of the underlying database structures into business user oriented terms (such as revenue by year, …)


Data Modeling Issue

While modeling the semantic layer, the developer can fall in different issues. See Semantic Layer Modeling - Issues (SQL Trap)


Discover More
Data System Architecture
Multidimensional Data (Cube)

A cube can be thought of as extensions to the two-dimensional array of a spreadsheet. A cube is also known as: a multidimensional cube or a hypercube It consists of numeric facts called measures...
Star Schema
Semantic Layer - Join Path (or Query Path)

In a semantic layer, a join path is a series of joins that a semantic query can use to access data in the tables linked by the joins. Join Path problems can arise from the limited way that lookup...
Star Schema
Semantic Layer - Semantic query (Business Query)

A semantic query is a business query that runs against the logical star schema of a semantic layer. The semantic layer translates this query to a SQL query in order to query the underlying database and...
Star Schema
Semantic Layer Modeling - Chasm trap Issue

Chasm trap is a semantic data modeling issue. A chasm trap occurs when a semantic layer model suggests the existence of a relationship between entity types, but the pathway does not exist between certain...
Star Schema
Semantic Layer Modeling - Issues (SQL Trap)

When modeling a semantic layer, you can encounter issues that impact the results obtained from semantic queries. You may need to resolve join problems such as : loops, missing data traps, chasm...
Card Puncher Data Processing
Software Design - Principles

When a trade off must be made then the design principles help guide the decision in choosing between competing alternatives. Java: principles circa 2005. Reading is more important than writing ...

Share this page:
Follow us:
Task Runner