Towards Development of Solution for Business Process-Oriented Data Analysis

Authors: M. Klimavicius

Abstract:

This paper proposes a modeling methodology for the development of data analysis solution. The Author introduce the approach to address data warehousing issues at the at enterprise level. The methodology covers the process of the requirements eliciting and analysis stage as well as initial design of data warehouse. The paper reviews extended business process model, which satisfy the needs of data warehouse development. The Author considers that the use of business process models is necessary, as it reflects both enterprise information systems and business functions, which are important for data analysis. The Described approach divides development into three steps with different detailed elaboration of models. The Described approach gives possibility to gather requirements and display them to business users in easy manner.

Keywords: Data warehouse, data analysis, business processmanagement.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1333602

References:

[1] W. H Inmon, R. D.Hackethorn, Using the Data Warehouse. New York: John Wiley & Sons (1994).
[2] P. Vassiliadis, C. Quix, Y. Vassiliou, M. Jarke. Data Warehouse Process Management, Information Systems, Vol. 26, No. 3, 2001.
[3] M.Klimavicius, U.Sukovskis, Business process driven data warehouse development, Scien-tific Proceedings of Riga Technical University, Computer Science Series, Applied computer Systems, 6th issue, Vol. 22, Riga, Latvia, RTU(2005).
[4] M.Klimavicius, U.Sukovskis, Risk management methodology for data warehousing projects, ISD-2005 Proceedings of the Fourteenth International Conference on Information Systems Development: Pre- Conference, Karlstad, Sweden, Karlstad University Studies (2005).
[5] V. Stefanov, B. List and J. Schiefer: Bridging the Gap between Data Warehouses and Busi-ness Processes - A Business Intelligence Perspective for Event-Driven Process Chains, Pro-ceedings of the 9th International Enterprise Distributed Object Computing Conference (EDOC 2005), Enschede, The Netherlands, IEEE Press (2005).
[6] V.Stefanov, B. List and B. Korherr: Extending UML 2 Activity Diagrams with Business Intelligence Objects, Proceedings of the 7th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2005), Copenhagen, Denmark, Lecture Notes in Com-puter Science, Springer Verlag (2005).
[7] Michael Boehnlein, Achim Ulbrich-vom Ende, Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems, DOLAP 1999, ACM Second International Workshop on Data Warehousing and OLAP, Kansas City, Missouri, USA, ACM(1999).
[8] Kevin McDonald, Andreas Wilmsmeier, David C. Dixon, W.H. Inmon, Mastering the SAP Business Information Warehouse, New York, Wiley Publishing (2002).
[9] IDS Scheer AG, ARIS Methods manual, IDS Scheer (2004).
[10] Vaclav Repa, Business Processes Based Information Systems Development, BIS99 Confer-ence, Proceedings of the 3rd International Conference on Business Informaiton Systems, Poznan, Poland, Springer- Verlag (1999).
[11] Sergio Lujan-Mora, Panos Vassiliadis, Juan Trujillo, Data Mapping Diagrams for Data Warehouse Design with UML, Conceptual Modeling - ER 2004, 23rd International Confer-ence on Conceptual Modeling, Shanghai, China, Lecture Notes in Computer Science, Springer (2004)
[12] W. H. Inmon, Building the Data Warehouse, Fourth Edition, Indianapolis, Indiana, USA, Wiley Publishing (2005).
[13] R.Kimball, L.Reeves, M.Ross, W.Thornthwaite - The Data Warehouse Lifecycle Toolkit, John Wiley & Sons (1998).
[14] P.Ponniah, Data Warehousing Fundamentals: A Comprehensive Guide for IT Profes-sionals, John Wiley & Sons(2001).
[15] Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual Modeling for ETL Processes. In: Proc. of 5th Intl. Workshop on Data Warehousing and OLAP (DOLAP 2002), McLean, USA (2002).
[16] Luján-Mora, S., Trujillo, J., Song, I.: Extending UML for Multidimensional Modeling. In: Proc. of the 5th Intl. Conf. on the Unified Modeling Language (UML-02). Volume 2460 of LNCS., Dresden, Germany (2002).
[17] Stefanov, V., List, B. and Korherr, B., Extending UML 2 Activity Diagrams with Business Intelligence Objects, Proceedings DaWaK, Springer Verlag, (2005).
[18] Mazon, J.-N., Trujillo, J., Serrano, M. and Piattini, M. Applying MDA to the development of data warehouses. In Proceedings DOLAP-05, New York, NY, USA. ACM Press, (2005).
[19] Breton E. and Bézivin J. Weaving Definition and Execution Aspects of Process Meta-models. In 35th Hawaii Int. Conf. on System Sciences, (2002).