What-if Simulation Modeling in Business Intelligence

Optimizing decisions has become a vital factor for companies. In order to be able to evaluate beforehand the impact of a decision, managers need reliable provisional systems. Though data warehouses enable analysis of past data, they are not capable of giving anticipations of future trends. What-if analysis fills this gap by enabling users to simulate and inspect the behavior of a complex system under some given hypotheses. A crucial issue in the design of what-if applications is to find an adequate formalism to conceptually express the underlying simulation model. In this paper the authors report on how, within the framework of a comprehensive design methodology, this can be accomplished by extending UML 2 with a set of stereotypes. Their proposal is centered on the use of activity diagrams enriched with object flows, aimed at expressing functional, dynamic, and static aspects in an integrated fashion. The paper is completed by examples taken from a real case study in the commercial area.

[1]  David Kotz,et al.  A Detailed Simulation Model of the HP 97560 Disk Drive , 1994 .

[2]  J. Scott Armstrong,et al.  Forecasting for Marketing , 2005 .

[3]  Stephen J. Andriole.  Who's Here? , 2005 .

[4]  Hemant K. Bhargava,et al.  Electronic Commerce in Decision Technologies: A Business Cycle Analysis , 1997, Int. J. Electron. Commer..

[5]  Il-Yeol Song,et al.  A UML profile for multidimensional modeling in data warehouses , 2006, Data Knowl. Eng..

[6]  Paul Baybutt.  MAJOR HAZARDS ANALYSIS - AN IMPROVED PROCESS HAZARD ANALYSIS METHOD , 2003 .

[7]  Richard E. Klosterman,et al.  The What If? Collaborative Planning Support System , 1999 .

[8]  In Lee.  Selected Readings on Information Technology and Business Systems Management , 2008 .

[9]  Juan Trujillo,et al.  A UML Based Approach for Modeling ETL Processes in Data Warehouses , 2003, ER.

[10]  B. Shorrocks,et al.  Competition on a Divided and Ephemeral Resource: A Simulation Model , 1981 .

[11]  Markus Grünwald,et al.  Business Intelligence , 2009, Informatik-Spektrum.

[12]  Alexander Felfernig.  Knowledge-Based Recommender Technologies Supporting the Interactive Selling of Financial Services , 2007 .

[13]  Matteo Golfarelli,et al.  Designing what-if analysis: towards a methodology , 2006, DOLAP '06.

[14]  Efraim Turban,et al.  Business Intelligence: Second European Summer School, eBISS 2012, Brussels, Belgium, July 15-21, 2012, Tutorial Lectures , 2013 .

[15]  José Samos,et al.  YAM2: a multidimensional conceptual model extending UML , 2006, Inf. Syst..

[16]  Saul I. Gass,et al.  An Assessment Procedure for Simulation Models: A Case Study , 1991, Oper. Res..

[17]  Bin Liu,et al.  Development of timed Colour Petri net simulation models for air cargo terminal operations , 2006, Comput. Ind. Eng..

[18]  Emad M. Kamhawi.  System Characteristics, Perceived Benefits, Individual Differences and Use Intentions: A Survey of Decision Support Tools of ERP Systems , 2008, Inf. Resour. Manag. J..

[19]  Stefano Rizzi,et al.  What-If Analysis , 2009, Encyclopedia of Database Systems.

[20]  Vassilios Peristeras,et al.  Application of Semantic Web Technology in E-Business: Case Studies in Public Domain Data Knowledge Representation , 2010 .

[21]  Yannis Papakonstantinou,et al.  Hypothetical Queries in an OLAP Environment , 2000, VLDB.

[22]  Peter Rittgen,et al.  Handbook of Ontologies for Business Interaction , 2007 .

[23]  Sean B. Eom.  Inter-organizational information systems in the Internet age , 2005 .

[24]  Stephen J. Andriole.  The Convergence Conversation - We're Finally Ready , 2005 .

[25]  Osman Balci.  Principles and techniques of simulation validation, verification, and testing , 1995, WSC '95.

[26]  Ling Liu,et al.  Encyclopedia of Database Systems , 2009, Encyclopedia of Database Systems.

[27]  Paul Baybutt,et al.  Major hazards analysis: An improved method for process hazard analysis , 2003 .

[28]  Petter Gottschalk,et al.  Business Dynamics in Information Technology , 2007 .

[29]  A Min Tjoa,et al.  Process-Oriented Requirement Analysis Supporting the Data Warehouse Design Process - A Use Case Driven Approach , 2000, DEXA.

[30]  Panos Vassiliadis,et al.  Conceptual modeling for ETL processes , 2002, DOLAP '02.

[31]  Surajit Chaudhuri,et al.  AutoAdmin “what-if” index analysis utility , 1998, SIGMOD '98.

[32]  Yanqing Duan,et al.  E-Business Adoption in SMEs: Some Preliminary Findings from Electronic Components Industry , 2007, Int. J. E Bus. Res..

[33]  Gautam Mitra,et al.  Adapting on-line analytical processing for decision modelling: the interaction of information and decision technologies , 1999, Decis. Support Syst..

[34]  Raymond J. Madachy,et al.  Software process simulation modeling: Why? What? How? , 1999, J. Syst. Softw..

[35]  Gerhard Friedrich,et al.  Mass Customization Information Systems in Business , 2007 .