An Empirical Study of Recommendations in OLAP Reporting Tool

Natalija Kozmina

2015

Abstract

This paper presents the results of the experimental study that was performed in laboratory settings in the context of the OLAP reporting tool developed and put to operation at the University. The study was targeted to explore which of the modes for generating recommendations in the OLAP reporting tool has a deeper impact on users (i.e. produces more accurate recommendations). Each of the modes of the recommendation component – report structure, user activity, and semantic – employs a separate content-based method that takes advantage of OLAP schema metadata and aggregate functions. Gained data are assessed (i) quantitatively by means of the precision/recall and other metrics from the log-table analysis and certain statistical tools, and (ii) qualitatively by means of the user survey and feedback given in a free form.

References

  1. Aligon J., Golfarelli M., Marcel P., Rizzi S., Turricchia E. 2014. Similarity Measures for OLAP Sessions. Knowledge and Information Systems, 39(2): 463-489.
  2. Aligon J., Gallinucci E., Golfarelli M., Marcel P., Rizzi S. 2015. A Collaborative Filtering Approach for Recommending OLAP Sessions. Decision Support Systems, 69(2015):20-30.
  3. Basili V. 1992. Software Modeling and Measurement: The Goal/Question/Metric Paradigm. CS-TR(2956), University of Maryland, 24p.
  4. Chaibi N., Gouider M.S. 2013. Personalization and Recommendation of Queries in Multidimensional Data Base. International Journal of Engineering Science Invention (IJESI), 2(5):74-80.
  5. Giacometti A., Marcel P., Negre E., Soulet A. 2009. Query Recommendations for OLAP Discovery Driven Analysis. In: Proc. of 12th ACM Int. Workshop on Data Warehousing and OLAP (DOLAP'09), Hong Kong, pp 81-88.
  6. Giacometti A., Marcel P. Negre E. Soulet A. 2011. Query Recommendations for OLAP Discovery-driven Analysis. Data Warehouse Mining, 7(2):1-25.
  7. Golfarelli M., Rizzi S. 2009. Expressing OLAP Preferences. In: Winslett M. (ed.) SSDBM 2009. LNCS, Springer, 5566:83-91.
  8. Jerbi H., Ravat F., Teste O., Zurfluh G. 2009. PreferenceBased Recommendations for OLAP Analysis. In: Proc. of 11th Int. Conf. on Data Warehousing and Knowledge Discovery (DaWaK'09), Linz, Austria, pp 467-478.
  9. Khemiri R., Bentayeb F. 2012. Interactive Query Recommendation Assistant. In: Proc. of 23rd Int. Workshop on Database and Expert Systems Applications (DEXA'12), IEEE, Vienna, Austria, pp 93-97.
  10. Kitchenham B.A., Pfleeger S.L., Pickard L.M., Jones P.W., Hoaglin D.C., El Emam K., Rosenberg J. 2002. Preliminary Guidelines for Empirical Research in Software Engineering. IEEE Transactions on Software Engineering, 28(8): 721-734.
  11. Marcel P. 2014. Log-driven User-centric OLAP. In: Proc. of 37th Int. Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO'2014), Opatija, Croatia, IEEE, pp 1446-1451.
  12. Park Y.-J., Tuzhilin A. 2008. The Long Tail of Recommender Systems and How to Leverage It. In: Proc. of the ACM Conf. on Rec. Systems (RecSys'08), Lausanne, Switzerland, pp 11-18.
  13. Poole J., Chang D., Tolbert D., Mellor D. 2003. Common Warehouse Metamodel Developers Guide. Wiley Publishing, 704p.
  14. Kozmina, N. 2013. Adding Recommendations to OLAP Reporting Tool. In: Proc. of the 15th Int. Conf. on Enterprise Information Systems (ICEIS'13), Angers, France, vol. 1, pp 238-245.
  15. Kozmina N., Solodovnikova D. 2011. On Implicitly Discovered OLAP Schema-specific Preferences in Reporting Tool. Applied Computer Systems, 46:35- 42.
  16. Kozmina N., Solodovnikova D. 2012. Towards Introducing User Preferences in OLAP Reporting Tool. In: Niedrite L, et al. (eds.) BIR 2011 Workshops. LNBIP, Springer, 106:209-222.
  17. Roscoe J. T. 1975. Fundamental Research Statistics for the Behavioral Sciences, 2nd ed. New York: Holt Rinehart & Winston, 483p.
  18. Schroder G., Thiele M., Lehner W. 2011. Setting Goals and Choosing Metrics for Recommender System Evaluation. In: Proc. of UCERSTI-2 at the 5th ACM Conf. on Rec. Systems, Chicago, USA, pp 78-85.
  19. Solodovnikova D. 2010. Data Warehouse Schema Evolution-oriented Reports Definition and Execution Tool. Summary of PhD Thesis [online] http://blogi.lu.lv/solodovnikova/files/2011/04/kopsavil kums_eng.pdf
Download


Paper Citation


in Harvard Style

Kozmina N. (2015). An Empirical Study of Recommendations in OLAP Reporting Tool . In Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-096-3, pages 303-312. DOI: 10.5220/0005374503030312


in Bibtex Style

@conference{iceis15,
author={Natalija Kozmina},
title={An Empirical Study of Recommendations in OLAP Reporting Tool},
booktitle={Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2015},
pages={303-312},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005374503030312},
isbn={978-989-758-096-3},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 17th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - An Empirical Study of Recommendations in OLAP Reporting Tool
SN - 978-989-758-096-3
AU - Kozmina N.
PY - 2015
SP - 303
EP - 312
DO - 10.5220/0005374503030312