Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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)
Grigori, D., Casati, F., Castellanos, M., Dayal, U., Sayal, M., Shan, M.-C.: Business process intelligence. Computers in Industry 53(3), 321–343 (2004)
Smith, M.: Business process intelligence. Intelligent Enterprise, Online (December 2002), http://www.intelligententerprise.com/021205/601feat2_1.jhtml
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)
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)
OMG (Object Management Group): BPMN (Business Process Modeling Notation) 1.0: OMG Final Adopted Specification, Online (February 2006), http://www.bpmn.org
WfMC (Workflow Management Coalition): WfMC Standards: The Workflow Reference Model, Version 1.1, Online (January 1995), http://www.wfmc.org/standards/docs/tc003v11.pdf
Pedersen, T.B., Jensen, C.S.: Multidimensional database technology. IEEE Computer 34(12), 40–46 (2001)
Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, Inc., New York (1998)
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)
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)
Matousek, P.: Verification of Business Process Models. PhD thesis, Technical University of Ostrava (2003)
Jablonski, S., Bussler, C.: Workflow Management. Modeling Concepts, Architecture and Implementation. International Thomson Computer Press (1996)
Hao, M.C, Keim, D.A, Dayal, U.: Business process impact visualization and anomaly detection. Information Visualization 5, 15–27 (2006)
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)
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)
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)
Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data & Knowledge Engineering 59(2), 348–377 (2006)
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)
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)
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)
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)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mansmann, S., Neumuth, T., Scholl, M.H. (2007). Multidimensional Data Modeling for Business Process Analysis. In: Parent, C., Schewe, KD., Storey, V.C., Thalheim, B. (eds) Conceptual Modeling - ER 2007. ER 2007. Lecture Notes in Computer Science, vol 4801. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-75563-0_4
Download citation
DOI: https://doi.org/10.1007/978-3-540-75563-0_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-75562-3
Online ISBN: 978-3-540-75563-0
eBook Packages: Computer ScienceComputer Science (R0)