Process mining on databases : unearthing historical data from redo logs

E. González-López de Murillas, W.M.P. van der Aalst, H.A. Reijers

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

44 Citations (Scopus)
8 Downloads (Pure)


Process Mining techniques rely on the existence of event data. However, in many cases it is far from trivial to obtain such event data. Considerable efforts may need to be spent on making IT systems record historic data at all. But even if such records are available, it may not be possible to derive an event log for the case notion one is interested in, i.e., correlating events to form process instances may be challenging. This paper proposes an approach that exploits a commonly available and versatile source of data, i.e. database redo logs. Such logs record the writing operations performed in a general-purpose database for a range of objects, which constitute a collection of events. By using the relations between objects as specified in the associated data model, it is possible to turn such events into an event log for a wide range of case types. The resulting logs can be analyzed using existing process mining techniques. Keywords: Process mining; Database; Redo log; Historical data; Trace creation; Transitive relations; Data model
Original languageEnglish
Title of host publicationBusiness Process Management (13th International Conference, BPM 2015, Innsbruck, Austria, August 31-September 3, 2015)
EditorsH.R. Motahari-Nezhad, J. Recker, M. Weidlich
Place of PublicationBerlin
ISBN (Print)978-3-319-23062-7
Publication statusPublished - 2015

Publication series

NameLecture Notes in Computer Science
ISSN (Print)0302-9743


Dive into the research topics of 'Process mining on databases : unearthing historical data from redo logs'. Together they form a unique fingerprint.

Cite this