2. Setting up a database

Jump to bottom Edit New page

Jannik Arndt edited this page Apr 6, 2014 · 1 revision

There is an example script for a MySQL-database that makes use of all concepts the Process Cube Explorer supports. You can (and probably want to) create your own schema by following these rules:

You need (at least) three tables: FACT, CASE (referencing FACT) and EVENT (referencing CASE)
FACT and EVENT can reference dimension-tables as in a data-warehouse-structure
EVENT needs a classifier-column (can be chosen in the metadata-view) and an “order by” column called timestamp

Here is an example schema: