Semantic Layer Modeling - Chasm trap Issue

Star Schema

About

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 entity occurrences.

This modelling issue is the result of a failure to capture all the relationships that exist in the real world in the model.

Example

  • A Building has one-or-more Rooms, that hold zero-or-more Computers.
  • You would expect to be able to query the model to see all the Computers in the Building.
  • However, Computers not currently assigned to a Room (because they are under repair or somewhere else) are not shown on the list.
  • You need another relation between Building and Computers to capture all the computers in the building.

Documentation / Reference




Discover More
Bobj Chasm Trap
BOBJ - Chasm Traps (converging many to one joins)

Chasm Traps is see as a Join Path problem or data modeling issue (convergence type ) which returns more data than expected by returning a cartesian product. A chasm trap is a type of join path...
Data System Architecture
SQL - Joins (Home)

in SQL. A join is a SQL clause statement which define the set operation such as: intersection, union, that the database must perform between two or more relation (table, view, query, ...). The...
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 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...



Share this page:
Follow us:
Task Runner