A Data Warehouse for Workflow Logs

  • Johann Eder
  • Georg E. Olivotto
  • Wolfgang Gruber
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2480)


Workflow Logs provide a very valuable source of information about the actual execution of business processes in organizations. We propose to use data warehouse technology to exploit this information resources for organizational developments, monitoring and process improvements. We introduce a general data warehouse design for workflow warehouses and discuss the results from an industrial case study showing the validity of this approach.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Work Group 1. Glossary: A workflow management coalition specification. Workflow Management Coalition, Brussels, Belgium, V 1.1 Final, 1994.Google Scholar
  2. [2]
    Work Group 1. Interface 1: Process definition interchange. Workflow Management Coalition, V 1.1 Final(WfMC-TC-1016-P), October 1999.Google Scholar
  3. [3]
    Rakesh Agrawal, Dimitrios Gunopulos, and Frank Leymann. Mining process models from workflow logs. In Hans-Jörg Schek, Fèlix Saltor, Isidro Ramos, and Gustovo Alonso, editors, Advances in Database Technology-EDBT’98, 6th International Conference on Extending Database Technology, Valencia, Spain, March 23-27, 1998, Proceedings, volume 1377 of Lecture Notes in Computer Science, pages 469–483. Springer, 1998.Google Scholar
  4. [4]
    Angela Bonifati, Fabio Casati, Umeshwar Dayal, and Ming-Chien Shan. Warehousing workflow data: Challenges and opportunities. In The VLDB Journal, pages 649–652, 2001.Google Scholar
  5. [5]
    Jonathan E. Cook and Alexander L. Wolf. Discovering models of software processes from event-based data. ACM Transactions on Software Engineering and Methodology, 7(3):215–249, 1998.CrossRefGoogle Scholar
  6. [6]
    J. Eder and W. Gruber. A Meta Model for Structured Workflows Supporting Workflow Transformations. In Yannis Manolopoulos and Pavol Navrat, editors, Sixth East-European Conference on Advances in Databases and Information Systems, ADBIS 2002, Bratislava, Slovakia, September 8–11, 2002, Proceedings. Springer, 2002.Google Scholar
  7. [7]
    Johann Eder, Herbert Groiss, and Walter Liebhart. The workflow management system panta rhei. In Asuman Dogac, Leonid Kalinichenko, M. Tamer Ozsu, and Amit Sheth, editors, Advances in Workflow Management Systems and Interoperability, 1997, pages 129–144.Google Scholar
  8. [8]
    Dimitrios Georgakopoulos, Mark F. Hornick, and Amit P. Sheth. An overview of workflow management: From process modeling to workflow automation infrastructure. Distributed and Parallel Databases, 3(2):119–153, 1995.CrossRefGoogle Scholar
  9. [9]
    Joachim Herbst and Dimitris Karagiannis. Integrating machine learning and workflow management to support acquisition and adaption of workflow models. In DEXA Workshop, pages 745–752, 1998.Google Scholar
  10. [10]
    B. Hüsemann, J. Lechtenbörger, and G. Vossen. Conceptual Data Warehouse Design. In Proc. of the International Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm, 2000.Google Scholar
  11. [11]
    W. Inmon. Building the Data Warehouse. John Wiley and Sons, New York, 1 edition, 1992.Google Scholar
  12. [12]
    M. Jarke, M. Lenzerini, Y. Vassiliou, and P. Vassiliadis. Fundamentals of Data Warehouses. Springer-Verlag, 2000.Google Scholar
  13. [13]
    C. Jensen. A consensus glossary of temporal database concepts. In S. Jajodia O. Etzion and S. Sripada, editors, Temporal Databases: Research and Practice, pages 367–405, 1998.Google Scholar
  14. [14]
    Pinar Koksal, Sena Nural Arpinar, and Asuman Dogac. Workflow history management. SIGMOD Record, 27(1):67–75, 1998.CrossRefGoogle Scholar
  15. [15]
    P. Lawrence. Workflow Handbook. John Wiley and Sons, New York, 1997.Google Scholar
  16. [16]
    W. Liebhart. Fehler-und Ausnahmebehandlung im Workflow Management. Dissertation, Klagenfurt, 1998.Google Scholar
  17. [17]
    Peter Muth, Jeanine Weisenfels, Michael Gillmann, and Gerhard Weikum. Workflow history management in virtual enterprises using a light-weight workflow management system. In RIDE, pages 148–155, 1999.Google Scholar
  18. [18]
    G. Olivotto. Ein Data Warehouse zur Analyse von Workflows. Master Thesis, University of Klagenfurt-Department of Informatics-Systems, 2002.Google Scholar
  19. [19]
    A.J.M.M. Weijters and W.M.P. van der Aalst. Process mining. discovering workflow models from event-based data. In Krse, B., De Rijke, M., Schreiber, G, and Someren, M. van (Eds.), Proceedings of the 13th Belgium-Netherlands Conference on Artificial Intelligence, pages 283–290, 2001.Google Scholar
  20. [20]
    A.J.M.M. Weijters and W.M.P. van der Aalst. Rediscovering workflow models from event-based data. In Hoste, V., and De Pauw, G. (Eds.), Proceedings of the Eleventh Belgian-Dutch Conference on Machine Learning, pages 93–100, 2001.Google Scholar
  21. [21]
    Workflow Management Coalition. The Workflow Reference Model, 1995.Google Scholar
  22. [22]
    M. Wu and A. Buchmann. Research Issues in Data Warehousing. BTW’97, 1997.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2002

Authors and Affiliations

  • Johann Eder
    • 1
  • Georg E. Olivotto
    • 1
  • Wolfgang Gruber
    • 1
  1. 1.Department of Informatics-SystemsUniversity of KlagenfurtKlagenfurtAustria

Personalised recommendations