Skip to main content
SpringerLink
Log in

Conceiving Hybrid What-If Scenarios Based on Usage Preferences

  • Conference paper
  • First Online:
Decision Support Systems VII. Data, Information and Knowledge Visualization in Decision Support Systems (ICDSST 2017)

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 282))

Included in the following conference series:

  • 893 Accesses

Abstract

Nowadays, enterprise managers involved with decision-making processes struggle with numerous problems related to market position or business reputation of their companies. Owning the right and high quality set of information is a crucial factor for developing business activities and gaining competitive advantages on business arenas. However, today retrieving information is not enough anymore. The possibility to simulate hypothetical scenarios without harming the business using What-If analysis tools and to retrieve highly refined information is an interesting way for achieving such business advantages. In a previous work, we introduced a hybridization model that combines What-If analysis and OLAP usage preferences, which helps filter the information and meet the users’ needs and business requirements without losing data quality. The main advantage is to provide the user with a way to overcome the difficulties that arise when dealing with the conventional What-If analysis scenario process. In this paper, we show an application of this methodology using a sample database, and compare the results of a conventional What-if process and our methodology. We designed and developed a specific piece of software, which aims to discover the best recommendations for What-If analysis scenarios’ parameters using OLAP usage preferences, which incorporates user experience in the definition and analysis of a target decision-making scenario.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Agrawal, R., Srikant, R.: Fast algorithms for mining association rules. In: Proceeding 20th International Conference Very Large Data Bases, VLDB, vol. 1215, pp. 487–499 (1994)

    Google Scholar 

  2. Agrawal, R., Wimmers E.: A framework for expressing and combining preferences. ACM SIGMOD Record 29(2) (2000)

    Google Scholar 

  3. Angelini, M., Ferro, N., Santucci, G., Silvello, G.: A visual analytics approach for what-if analysis of information retrieval systems. In: Proceeding 39th Annual International ACM SIGIR Conference on Research and Development in Information Retrieval (SIGIR 2016). ACM Press, New York, USA (2016)

    Google Scholar 

  4. Bärgman, J., Lisovskaja, V., Victor, T., Flannagan, C., Dozza, M.: How does glance behavior influence crash and injury risk? A ‘what-if’ counterfactual simulation using crashes and near-crashes from SHRP2. Transp. Res. Part F: Traffic Psychol. Behav. 35, 152–169 (2015)

    Article  Google Scholar 

  5. Carvalho, M., Belo, O.: Enriching what-if scenarios with OLAP usage preferences. In: 8th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management, vol. 1, pp. 213–220 (2016)

    Google Scholar 

  6. Chomicki, J.: Preference formulas in relational queries. ACM Trans. Database Syst. (TODS) 28(4), 427–466 (2003)

    Article  Google Scholar 

  7. De Maio, C., Botti, A., Fenza, G., Loia, V., Tommasetti, A., Troisi, O. Vesci, M.: What-if analysis combining fuzzy cognitive map and structural equation modeling. In: 2015 Conference on Technologies and Applications of Artificial Intelligence (TAAI) pp. 89–96 (2015)

    Google Scholar 

  8. Deutch, D., Ives, Z. G., Milo, T., Tannen, V.: Caravan: provisioning for what-if analysis. In: CIDR (2013)

    Google Scholar 

  9. Golfarelli, M., Rizzi, S. Proli, A.: Designing what-if analysis: towards a methodology. In: DOLAP 2006, Arlington, Virginia, USA, pp. 51–58 (2006)

    Google Scholar 

  10. Golfarelli, M., Rizzi, S.: Expressing OLAP preferences. In: Winslett, M. (ed.) SSDBM 2009. LNCS, vol. 5566, pp. 83–91. Springer, Heidelberg (2009). doi:10.1007/978-3-642-02279-1_7

    Chapter  Google Scholar 

  11. Hadjali, A., Kaci, S., Prade, H.: Database preferences queries – a possibilistic logic approach with symbolic priorities. In: Hartmann, S., Kern-Isberner, G. (eds.) FoIKS 2008. LNCS, vol. 4932, pp. 291–310. Springer, Heidelberg (2008). doi:10.1007/978-3-540-77684-0_20

    Chapter  Google Scholar 

  12. Han, J.: OLAP mining: an integration of OLAP with data mining. In: Proceedings of the 7th IFIP, pp. 1–9 (1997)

    Google Scholar 

  13. Harinarayan, V., Rajaraman, A. Ullman, J.: Implementing data cubes efficiently. ACM SIGMOD Record. 25(2) (1996)

    Google Scholar 

  14. Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: Preference-based recommendations for OLAP analysis. In: Pedersen, T.B., Mohania, Mukesh K., Tjoa, A.M. (eds.) DaWaK 2009. LNCS, vol. 5691, pp. 467–478. Springer, Heidelberg (2009). doi:10.1007/978-3-642-03730-6_37

    Chapter  Google Scholar 

  15. Jiang, Y., Sivalingam, L. R., Nath, S., Govindan, R.: WebPerf: evaluating what-if scenarios for cloud-hosted web applications. In: Proceedings of the 2016 conference on ACM SIGCOMM 2016 Conference, pp. 258–271 (2016)

    Google Scholar 

  16. Klauck, S., Butzmann, L., Müller, S., Faust, M., Schwalb, D., Uflacker, M., Sinzig, W., Plattner, H.: Interactive, flexible, and generic what-if analyses using in-memory column stores. In: Renz, M., Shahabi, C., Zhou, X., Cheema, M.A. (eds.) DASFAA 2015. LNCS, vol. 9050, pp. 488–497. Springer, Cham (2015). doi:10.1007/978-3-319-18123-3_29

    Google Scholar 

  17. Kellner, M.I., Madachy, R., Raffo, D.: Software process simulation modeling: Why? What? How? J. Syst. Softw. 46(2), 91–105 (1999)

    Article  Google Scholar 

  18. Kießling, W.: Foundations of preferences in database systems. In: Proceedings of the 28th International Conference on Very Large Data Bases, VLDB Endowment, pp. 311–322 (2002)

    Google Scholar 

  19. Kimball, R., Ross, M.: The data warehouse toolkit: the complete guide to dimensional modeling. Wiley (2011)

    Google Scholar 

  20. Lacroix, M., Lavency P.: Preferences: putting more knowledge into queries. In: VLDB 1987 (1987)

    Google Scholar 

  21. Letchner, J., Krumm J., Horvitz E.: Trip router with individualized preferences (trip): incorporating personalization into route planning. In: Proceedings of the National Conference on Artificial Intelligence, vol. 21, no. 2, p. 1795 (2006)

    Google Scholar 

  22. McGarvey, R.G., Matisziw, T., Noble, J.S., Nemmers, C.J., Karakose, G., Krause, C.: Improving Striping Operations through System Optimization-Phase 2 (2016)

    Google Scholar 

  23. Meurice, L., Nagy, C., Cleve, A.: Detecting and preventing program inconsistencies under database schema evolution. In: IEEE International Conference Software Quality, Reliability and Security (QRS), pp. 262–273 (2016)

    Google Scholar 

  24. Microsoft SQL Server Product Samples: Database (2015). http://msftdbprodsamples.codeplex.com/, Accessed 13 Feb 2016

  25. Ore, O., Ore, Y.: Theory of Graphs, vol. 38. American Mathematical Society, Providence (1962)

    Google Scholar 

  26. Rozema, L.: Extending the control tower at ShipitSmarter: designing a tool to analyse carrier performance and perform what-if analyses (Master’s thesis, University of Twente) (2016)

    Google Scholar 

Download references

Acknowledgments

This work has been supported by COMPETE: POCI-01-0145-FEDER-007043 and FCT - Fundação para a Ciência e Tecnologia within the Project Scope: UID/CEC/00319/2013.

Author information

Authors and Affiliations

  1. ALGORITMI R&D Center, Department of Informatics, School of Engineering, University of Minho, 4710-057, Braga, Portugal

    Mariana Carvalho & Orlando Belo

Authors
  1. Mariana Carvalho
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Orlando Belo
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Orlando Belo .

Editor information

Editors and Affiliations

  1. Department of Business Administration, University of Namur, Namur, Belgium

    Isabelle Linden

  2. Graduate School of Management, University of Plymouth, Plymouth, United Kingdom

    Shaofeng Liu

  3. Department of Business Administration, University of Namur, Namur, Belgium

    Christian Colot

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Carvalho, M., Belo, O. (2017). Conceiving Hybrid What-If Scenarios Based on Usage Preferences. In: Linden, I., Liu, S., Colot, C. (eds) Decision Support Systems VII. Data, Information and Knowledge Visualization in Decision Support Systems. ICDSST 2017. Lecture Notes in Business Information Processing, vol 282. Springer, Cham. https://doi.org/10.1007/978-3-319-57487-5_9

Download citation

Publish with us

Policies and ethics

Search

Navigation