Encyclopedia of Database Systems

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

What-If Analysis

  • Stefano RizziEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_466


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

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 the 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 the 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.zbMATHCrossRefGoogle 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. In: Hameurlain A, Küng J, Wagner R, Cuzzocrea A, Dayal U, editors. Transactions on large-scale data- and knowledge-centered systems VIII. Berlin/Heidelberg: Springer; 2013. p. 32–52.Google Scholar
  8. 8.
    Khalefa M, Fischer U, Pedersen TB, Lehner W. Model-based integration of past & future in TimeTravel. Proc VLDB Endow. 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.zbMATHGoogle 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, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.DISIUniversity of BolognaBolognaItaly

Section editors and affiliations

  • Torben Bach Pedersen
    • 1
  • Stefano Rizzi
    • 2
  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark
  2. 2.DISIUniv. of BolognaBolognaItaly