Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Comment:
Published by Scroll Versions from space WINSTALLATION and version 24.0
The analytic analytical database of Scheer PAS Process AnalyticsMining is composed by two parts:
- some work tables only used during the ETL process and
- public tables that can be queried by any kind of analytic service to display meaningful data.
Public Schema: Snowflake Schema
The public schema of the analytic analytical database is a snowflake schema. That means that there are fact tables representing the instances (names starting by Fact_) and dimension tables representing the data (names starting by Dim_). It is a snowflake and not a simple star, because there are relations between the facts.
Figure: Tables, Columns and Relations of the Public Schema
Image RemovedImage Added
otp
Floating false maxHLevel 2
Panel |
---|
| ||
|
Overview
Content Tools