Semantic Layer Modeling - Chasm trap Issue

Data System Architecture

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




Recommended Pages
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...
Data System Architecture
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...
Data System Architecture
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