Multidimensional Data Modeling for Business Process Analysis

  • Svetlana Mansmann
  • Thomas Neumuth
  • Marc H. Scholl
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4801)


The emerging area of business process intelligence attempts to enhance the analytical capabilities of business process management systems by employing data warehousing and mining technologies. This paper presents an approach to re-engineering the business process modeling in conformity with the multidimensional data model. Since the business process and the multidimensional model are driven by rather different objectives and assumptions, there is no straightforward solution to converging these models.

Our case study is concerned with Surgical Process Modeling which is a new and promising subdomain of business process modeling. We formulate the requirements of an adequate multidimensional presentation of process data, introduce the necessary model extensions and propose the structure of the data cubes resulting from applying vertical decomposition into flow objects, such as events and activities, and from the dimensional decomposition according to the factual perspectives, such as function, organization, and operation. The feasibility of the presented approach is exemplified by demonstrating how the resulting multidimensional views of surgical workflows enable various perspectives on the data and build a basis for supporting a wide range of analytical queries of virtually arbitrary complexity.


Business Process Data Cube Fact Schema Work Step Dimension Hierarchy 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Dayal, U., Hsu, M., Ladin, R.: Business process coordination: State of the art, trends, and open issues. In: VLDB 2001: Proc. 27th Int.Conf. on Very Large Data Bases, pp. 3–13 (2001)Google Scholar
  2. 2.
    Grigori, D., Casati, F., Castellanos, M., Dayal, U., Sayal, M., Shan, M.-C.: Business process intelligence. Computers in Industry 53(3), 321–343 (2004)CrossRefGoogle Scholar
  3. 3.
    Smith, M.: Business process intelligence. Intelligent Enterprise, Online (December 2002),
  4. 4.
    Neumuth, T., Strauß, G., Meixensberger, J., Lemke, H.U., Burgert, O.: Acquisition of process descriptions from surgical interventions. In: Bressan, S., Küng, J., Wagner, R. (eds.) DEXA 2006. LNCS, vol. 4080, pp. 602–611. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  5. 5.
    Neumuth, T., Trantakis, C., Eckhardt, F., Dengl, M.: Supporting the analysis of intervention courses with surgical process models on the example of fourteen microsurgical lumbar discectomies. International Journal of Computer Assisted Radiology and Surgery 2(1), 436–438 (2007)Google Scholar
  6. 6.
    OMG (Object Management Group): BPMN (Business Process Modeling Notation) 1.0: OMG Final Adopted Specification, Online (February 2006),
  7. 7.
    WfMC (Workflow Management Coalition): WfMC Standards: The Workflow Reference Model, Version 1.1, Online (January 1995),
  8. 8.
    Pedersen, T.B., Jensen, C.S.: Multidimensional database technology. IEEE Computer 34(12), 40–46 (2001)CrossRefGoogle Scholar
  9. 9.
    Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, Inc., New York (1998)Google Scholar
  10. 10.
    Jung, J.: Meta-modelling support for a general process modelling tool. In: DSM 2005: Proc. 5th OOPSLA Workshop on Domain-Specific Modeling, pp. 602–611 (2005)Google Scholar
  11. 11.
    Muth, P., Wodtke, D., Wei§enfels, J., Weikum, G., Kotz-Dittrich, A.: Enterprise-wide workflow management based on state and activity charts. In: Proc. NATO Advanced Study Institute on Workflow Management Systems and Interoperability, pp. 281–303 (1997)Google Scholar
  12. 12.
    Matousek, P.: Verification of Business Process Models. PhD thesis, Technical University of Ostrava (2003)Google Scholar
  13. 13.
    Jablonski, S., Bussler, C.: Workflow Management. Modeling Concepts, Architecture and Implementation. International Thomson Computer Press (1996)Google Scholar
  14. 14.
    Hao, M.C, Keim, D.A, Dayal, U.: Business process impact visualization and anomaly detection. Information Visualization 5, 15–27 (2006)CrossRefGoogle Scholar
  15. 15.
    Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)CrossRefzbMATHGoogle Scholar
  16. 16.
    Jensen, C.S., Kligys, A., Pedersen, T.B., Timko, I.: Multidimensional data modeling for location-based services. The VLDB Journal 13(1), 1–21 (2004)CrossRefGoogle Scholar
  17. 17.
    Mansmann, S., Scholl, M.H.: Empowering the OLAP technology to support complex dimension hierarchies. International Journal of Data Warehousing and Mining 3(4), 31–50 (2007)CrossRefGoogle Scholar
  18. 18.
    Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering 59(2), 348–377 (2006)CrossRefGoogle Scholar
  19. 19.
    Hruby, P.: Structuring specification of business systems with UML (with an emphasis on workflow management systems). In: Proc. OOPSLA’98 Business Object Workshop IV, Springer, Heidelberg (1998)Google Scholar
  20. 20.
    Luján-Mora, S., Trujillo, J., Vassiliadis, P.: Advantages of uml for multidimensional modeling. In: ICEIS 2004: Proc. 6th Int. Conf. on Enterprise Information Systems, pp. 298–305 (2004)Google Scholar
  21. 21.
    Lenz, H.-J., Shoshani, A.: Summarizability in OLAP and statistical data bases. In: SSDBM 1997: Proc. of 9th Int. Conf. on Scientific and Statistical Database Management, pp. 132–143 (1997)Google Scholar
  22. 22.
    Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: A conceptual model for data warehouses. International Journal of Cooperative Information Systems 7(2-3), 215–247 (1998)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • Svetlana Mansmann
    • 1
  • Thomas Neumuth
    • 2
  • Marc H. Scholl
    • 1
  1. 1.University of Konstanz, P.O.Box D188, 78457 KonstanzGermany
  2. 2.University of Leipzig, Innovation Center Computer Assisted Surgery (ICCAS), Philipp-Rosenthal-Str. 55, 04103 LeipzigGermany

Personalised recommendations