Encyclopedia of Database Systems

Living Edition
| Editors: Ling Liu, M. Tamer Özsu

What-If Analysis

Living reference work entry
DOI: https://doi.org/10.1007/978-1-4899-7993-3_466-2


In order to be able to evaluate beforehand the impact of a strategic or tactical move so as to plan optimal strategies to reach their goals, decision makers need reliable predictive systems. What-if analysis is a data-intensive simulation whose goal is to inspect the behavior of a complex system, such as the corporate business or a part of it, under some given hypotheses called scenarios. In particular, what-if analysis measures how changes in a set of independent variables impact a set of dependent variables with reference to a given simulation model. This model is a simplified representation of the business, tuned according to the historical corporate data. In practice, formulating a scenario enables the building of a hypothetical world that the analyst can then query and navigate.

Historical Background

Though what-if analysis can be considered as a relatively recent discipline, its background is rooted at the confluence of different research areas, some of which date back...


Source Variable Activity Diagram Business Intelligence Scenario Parameter Business Variable 
This is a preview of subscription content, log in to check access

Recommended Reading

  1. 1.
    Armstrong S, Brodie R. Forecasting for marketing. In: Hooley G, Hussey M, editors. Quantitative methods in marketing. London: International Thompson Business Press; 1999. p. 92–119.Google Scholar
  2. 2.
    Balmin A, Papadimitriou T, Papakonstantinou Y. Hypothetical queries in an OLAP environment. In: Proceedings of 26th International Conference on Very Large Data Bases; 2000. p. 220–31.Google Scholar
  3. 3.
    Chen B, Chen L, Lin Y, Ramakrishnan R. Prediction cubes. In: Proceedings of 31st International Conference on Very Large Data Bases; 2005. p. 982–93.Google Scholar
  4. 4.
    Coyle RG. System dynamics modeling: a practical approach. London: Chapman and Hall; 1996.CrossRefMATHGoogle Scholar
  5. 5.
    Fossett C, Harrison D, Weintrob H. An assessment procedure for simulation models: a case study. Oper Res. 1991;39(5):710–23.CrossRefGoogle Scholar
  6. 6.
    Golfarelli M, Rizzi S. What-if simulation modeling in business intelligence. Int J Data Warehous Min. 2009;5(4):24–43.CrossRefGoogle Scholar
  7. 7.
    Jaecksch B, Lehner W. The planning OLAP model – a multidimensional model with planning support. Trans Large-Scale Data- Knowl-Centered Syst. 2013;8:32–52.Google Scholar
  8. 8.
    Khalefa M, Fischer U, Pedersen TB, Lehner W. Model-based integration of past & future in TimeTravel. PVLDB. 2012;5(12):1974–7.Google Scholar
  9. 9.
    Koutsoukis NS, Mitra G, Lucas C. Adapting on-line analytical processing for decision modeling: the interaction of information and decision technologies. Decis Support Syst. 1999;26(1):1–30.CrossRefGoogle Scholar
  10. 10.
    Kreutzer W. System simulation – programming styles and languages. Reading: Addison Wesley; 1986.Google Scholar
  11. 11.
    Law AM, Kelton WD. Simulation modeling and analysis. Boston: McGraw-Hill Higher Education; 1999.MATHGoogle Scholar
  12. 12.
    Lee C, Huang HC, Liu B, Xu Z. Development of timed colour Petri net simulation models for air cargo terminal operations. Comput Ind Eng. 2006;51(1):102–10.CrossRefGoogle Scholar
  13. 13.
    Roberts EB. Managerial applications of system dynamics. Waltham: Pegasus Communications; 1999.Google Scholar

Copyright information

© Springer Science+Business Media New York 2016

Authors and Affiliations

  1. 1.DISIUniversity of BolognaBolognaItaly