Multidimensional Data Modeling for Business Process Analysis
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.
KeywordsBusiness Process Data Cube Fact Schema Work Step Dimension Hierarchy
Unable to display preview. Download preview PDF.
- 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
- 3.Smith, M.: Business process intelligence. Intelligent Enterprise, Online (December 2002), http://www.intelligententerprise.com/021205/601feat2_1.jhtml
- 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.OMG (Object Management Group): BPMN (Business Process Modeling Notation) 1.0: OMG Final Adopted Specification, Online (February 2006), http://www.bpmn.org
- 7.WfMC (Workflow Management Coalition): WfMC Standards: The Workflow Reference Model, Version 1.1, Online (January 1995), http://www.wfmc.org/standards/docs/tc003v11.pdf
- 9.Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, Inc., New York (1998)Google Scholar
- 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.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.Matousek, P.: Verification of Business Process Models. PhD thesis, Technical University of Ostrava (2003)Google Scholar
- 13.Jablonski, S., Bussler, C.: Workflow Management. Modeling Concepts, Architecture and Implementation. International Thomson Computer Press (1996)Google Scholar
- 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.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.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