semantic layer

Database
Enthusiast

semantic layer

What is the purpose of the semantic layer?
2 REPLIES
Enthusiast

Re: semantic layer

Semantic layer consist of views with some logic: for example, in WHERE clause, some joins etc...
Enthusiast

Re: semantic layer

Typically, a semantic layer is where you expose your data to downstream applications. Depending on your architecture you may apply business rules, denormalizations, transformations, calculations, etc. in the semantic layer. Reporting tools will typically connect to the semantic layer and ETL extracts for downstream systems often pull from the semantic layer.

SomeTeradata customers will have a single semantic layer for the warehouse while others may have multiple semantic layers either by subject area, accessing application, etc. They will all utilize the same set of data from the warehouse but may apply slightly different rules/transformations as needed.