Towards Development of Solution for Business Process-Oriented Data Analysis

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.

Authors:

• M. Klimavicius

Keywords:

• Data warehouse
• data analysis
• business processmanagement.

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).