The analytical database of Scheer PAS Process Mining 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 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