Because attributes of an event log may have a specific meaning, Interactive PMCube Explorer provides a framework to annotate the attributes of the data cube (dimensions as well as simple attributes) with semantics. For example, it is possible to mark an attribute as the start time-stamp of an event. These semantic annotations are used by Interactive PMCube Explorer to process the data, e.g. the event start time-stamp can be used to order the events in a trace. The following table gives on overview of all semantic annotations that are defined by default. However, it is possible to extend the semantics framework by providing further annotations integrated as plug-ins (see the plug-in page for a list of provided plug-ins).


Semantic NameDescription
Identifier Semantics
Case IDMarks an attribute as the (unique) identifier for cases, or a candidate for case identifiers if the data cube model allows for more than one case attribute
Event IDMarks an attribute as the (unique) identifier for events
Event Log IDMarks an attribute as the (unique) identifier for the event log
Time Semantics
Event start timestampRepresents the point in time, when the event starts
Event end timestampRepresents the point in time, when the event ends
Event durationRepresents the time-span from the start to the end of the event (i.e., the difference between start and end time-stamp of the event)
Case start timestampRepresents the point in time, when the case starts (i.e., its first activity starts)
Case end timestampRepresents the point in time, when the case ends (i.e., its last activity ends)
Case durationRepresents the time-span from the start to the end of the case (i.e., the difference between start and end time-stamp of the case)



In some data cube models (e.g. Direct Access and PMC), it is possible to use different attributes as case id. In a hospital log for example, the stay of a patient in the hospital as well as the patient himself (having multiple stays in hospital) may be used as case id. In this case, both candidate attributes need to be annotated as case id in the meta-data. The case id which should be used is then selected in the OLAP query. However, some data cube models like the default PMCube model are restricted to a single case id due to the database structure. In that case, exactly one attribute must be annotated as case id which is automatically selected in the OLAP query.




  • No labels