Skip to main content

Discovering Analytical Preferences for Personalizing What-If Scenarios

  • Conference paper
  • First Online:
Progress in Artificial Intelligence (EPIA 2019)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 11805))

Included in the following conference series:

  • 1606 Accesses

Abstract

In this paper, we expose a hybridization methodology for helping to overcome the pitfalls of conventional What-If analysis process design and development by discovering the best recommendations for What-If analysis scenarios’ parameters using OLAP preferences. The hybridization process aims at assisting users during the decision-making processes by suggesting the most adequate scenario parameters according to their needs, making What-If scenarios more valuable, helping them during decision-making processes. The hybridization process provides several advantages to companies by making possible to study the behavior of a system without building it or creating the circumstances to make it happen in a business real-world system. Thus, knowing existing approaches for extracting preferences when dealing with OLAP application environments has clear business advantages. This work is about this, with a particular focus on discovering analytical preferences for personalizing What-If application scenarios.

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

Access this chapter

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. Harinarayan, V., Rajaraman, A., Ullman, J.D.: Implementing data cubes efficiently. In: ACM SIGMOD Record, vol. 25, no. 2, pp. 205–216. ACM (1996)

    Google Scholar 

  2. Golfarelli, M., Rizzi, S., Proli, A.: Designing What-If analysis: towards a methodology. In: Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 51–58. ACM (2006)

    Google Scholar 

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

    Chapter  Google Scholar 

  4. Carvalho, M., Belo, O.: Enriching What-If scenarios with OLAP usage preferences. In: Proceedings of the 8th International Conference on Knowledge Discovery and Information Retrieval (KDIR 2016), Porto, Portugal, 9–11 November 2016, pp. 213–220 (2016)

    Google Scholar 

  5. Lu, J., Wu, D., Mao, M., Wang, W., Zhang, G.: Recommender system application developments: a survey. Decis. Support Syst. 74, 12–32 (2015)

    Article  Google Scholar 

  6. Ricci, F., Rokach, L., Shapira, B.: Recommender systems: introduction and challenges. In: Ricci, F., Rokach, L., Shapira, B. (eds.) Recommender Systems Handbook, pp. 1–34. Springer, Boston, MA (2015). https://doi.org/10.1007/978-1-4899-7637-6_1

    Chapter  MATH  Google Scholar 

  7. Beel, J., Gipp, B., Langer, S., Breitinger, C.: Paper recommender systems: a literature survey. Int. J. Digit. Libr. 17(4), 305–338 (2016)

    Article  Google Scholar 

  8. Aligon, J., Golfarelli, M., Marcel, P., Rizzi, S., Turricchia, E.: Mining preferences from OLAP query logs for proactive personalization. In: Eder, J., Bielikova, M., Tjoa, A.M. (eds.) ADBIS 2011. LNCS, vol. 6909, pp. 84–97. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-23737-9_7

    Chapter  Google Scholar 

  9. Golfarelli, M., Rizzi, S., Biondi, P.: myOLAP: an approach to express and evaluate OLAP preferences. IEEE Trans. Knowl. Data Eng. 23(7), 1050–1064 (2011)

    Article  Google Scholar 

  10. Kozmina, N., Niedrite, L.: Research directions of OLAP personalization. In: Pokorny, J., et al. (eds.) Information Systems Development, pp. 345–356. Springer, New York (2011). https://doi.org/10.1007/978-1-4419-9790-6_28

    Chapter  Google Scholar 

  11. Garrigós, I., Pardillo, J., Mazón, J.-N., Trujillo, J.: A conceptual modeling approach for OLAP personalization. In: Laender, A.H.F., Castano, S., Dayal, U., Casati, F., de Oliveira, J.P.M. (eds.) ER 2009. LNCS, vol. 5829, pp. 401–414. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-04840-1_30

    Chapter  Google Scholar 

  12. Ravat, F., Teste, O.: Personalization and OLAP databases. In: Kozielski, S., Wrembel, R. (eds.) New Trends in Data Warehousing and Data Analysis. Annals of Information Systems, vol. 3, pp. 1–22. Springer, Boston (2009). https://doi.org/10.1007/978-0-387-87431-9_4

    Chapter  Google Scholar 

  13. Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query recommendations for OLAP discovery driven analysis. In: Proceedings of 12th ACM International Workshop on Data Warehousing and OLAP (DOLAP 2009), Hong Kong, 6 November 2009, pp. 81–88 (2009)

    Google Scholar 

  14. Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: Applying recommendation technology in OLAP systems. In: Filipe, J., Cordeiro, J. (eds.) ICEIS 2009. LNBIP, vol. 24, pp. 220–233. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-01347-8_19

    Chapter  Google Scholar 

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

    Chapter  Google Scholar 

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

    Google Scholar 

  17. Quinlan, J.R.: C4.5: Programs for empirical learning (1993)

    Google Scholar 

  18. Carvalho, M., Macedo, N., Belo, O.: Checking the correctness of What-If scenarios. In: 11th IFIP WG 8.9 Working Conference – CONFENIS 2017. Crowne Plaza Shanghai Fudan, Shanghai, China, 18th–20th October 2017

    Google Scholar 

  19. Alloytools.org. http://alloytools.org/. Accessed 24 Apr 2019

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

    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

Authors

Corresponding author

Correspondence to Orlando Belo .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Carvalho, M., Belo, O. (2019). Discovering Analytical Preferences for Personalizing What-If Scenarios. In: Moura Oliveira, P., Novais, P., Reis, L. (eds) Progress in Artificial Intelligence. EPIA 2019. Lecture Notes in Computer Science(), vol 11805. Springer, Cham. https://doi.org/10.1007/978-3-030-30244-3_35

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-30244-3_35

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-30243-6

  • Online ISBN: 978-3-030-30244-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics