Towards Introducing User Preferences in OLAP Reporting Tool

  • Natalija Kozmina
  • Darja Solodovnikova
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 106)


This paper presents an OLAP reporting tool and an approach for determining and processing user OLAP preferences, which are useful for generating recommendations on potentially interesting reports. We discuss the metadata layers of the reporting tool including our proposed OLAP preferences metamodel, which supports various scenarios of formulating preferences of two different types: schema-specific and report-specific. The process of semantic metadata usage at the stage of formulating user preferences is also considered. The methods for processing schema-specific and report-specific OLAP preferences are outlined.


Data warehouse user preferences business metadata reports 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Solodovnikova, D., Kozmina, N.: On Implicitly Discovered OLAP Schema-Specific Preferences in Reporting Tool. In: Proceedings of the 10th Int. Conf. on Perspectives in Business Informatics Research (BIR 2011) (2011); Scientific Journal or Riga Technical University. Computer Science: Applied Computer Systems 46, 35–42 (2011) Google Scholar
  2. 2.
    Solodovnikova, D.: Data Warehouse Evolution Framework. In: Proceedings of the Spring Young Researcher’s Colloquium On Database and Information Systems (SYRCoDIS 2007), Moscow, Russia (2007),
  3. 3.
    Koutrika, G., Ioannidis, Y.E.: Personalization of queries in database systems. In: Proceedings of 20th Int. Conf. on Data Engineering (ICDE 2004), Boston, MA, USA, pp. 597–608 (2004)Google Scholar
  4. 4.
    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)CrossRefGoogle Scholar
  5. 5.
    Biondi, P., Golfarelli, M., Rizzi, S.: Preference-Based Datacube Analysis with MyOLAP. In: Proceedings of the 27th Int. Conf. on Data Engineering (ICDE 2011), Hannover, Germany, pp. 1328–1331 (2011)Google Scholar
  6. 6.
    Giacometti, A., Marcel, P., Negre, E., Soulet, A.: Query Recommendations for OLAP Discovery Driven Analysis. In: Proceedings of 12th ACM Int. Workshop on Data Warehousing and OLAP (DOLAP 2009), Hong Kong, pp. 81–88 (2009)Google Scholar
  7. 7.
    Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: Preference-Based Recommendations for OLAP Analysis. In: Pedersen, T.B., Mohania, M.K., Tjoa, A.M. (eds.) DaWaK 2009. LNCS, vol. 5691, pp. 467–478. Springer, Heidelberg (2009)CrossRefGoogle Scholar
  8. 8.
    Mansmann, S., Scholl, M.H.: Visual OLAP: A New Paradigm for Exploring Multidimensonal Aggregates. In: Proceedings of IADIS Int. Conf. on Computer Graphics and Visualization (MCCSIS 2008), Amsterdam, The Netherlands, pp. 59–66 (2008)Google Scholar
  9. 9.
    Kozmina, N., Niedrite, L.: Research Directions of OLAP Personalization. In: Proceedings of the 19th Int. Conf. on Information Systems Development (ISD 2010), Prague, Czech Republic (2010)Google Scholar
  10. 10.
    Marcel, P., Negre, E.: A Survey of Query Recommendation Techniques for Data Warehouse Exploration. In: 7èmes Journées Francophones sur les Entrepôts de Données et l’Analyse en ligne (EDA 2011), Clermont-Ferrand, France, vol. B-7, pp. 119–134 (June 2011)Google Scholar
  11. 11.
    Object Management Group: Common Warehouse Metamodel Specification, v1.1,
  12. 12.
    Solodovnikova, D.: Metadata to Support Data Warehouse Evolution. In: Proceedings of the 17th Int. Conf. on Information Systems Development (ISD 2008), Paphos, Cyprus, pp. 627–635 (2008)Google Scholar
  13. 13.
    Solodovnikova, D.: Building Queries on Multiple Versions of Data Warehouse. In: Haav, H.-M., Kalja, A. (eds.) Databases and Information Systems V - Selected Papers from the 8th Int. Baltic Conference, DBIS 2008, pp. 75–86. IOS Press (2008)Google Scholar
  14. 14.
    Kozmina, N., Niedrite, L.: OLAP Personalization with User-Describing Profiles. In: Forbrig, P., Günther, H. (eds.) BIR 2010. LNBIP, vol. 64, pp. 188–202. Springer, Heidelberg (2010)CrossRefGoogle Scholar
  15. 15.
    Solodovnikova, D., Kozmina, N.: Determining Preferences from Semantic Metadata in OLAP Reporting Tool. In: Local Proceedings of the 10th Int. Conf. on Perspectives in Business Informatics Research (BIR 2011), Associated Workshops and Doctoral Consortium, Riga, Latvia, pp. 363–370 (2011)Google Scholar
  16. 16.
    Maidel, V., Shoval, P., Shapira, B., Taieb-Maimon, M.: Ontological Content-based Filtering for Personalised Newspapers: A Method and its Evaluation. Online Information Review 34(5), 729–756 (2010)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2012

Authors and Affiliations

  • Natalija Kozmina
    • 1
  • Darja Solodovnikova
    • 1
  1. 1.Faculty of ComputingUniversity of LatviaRigaLatvia

Personalised recommendations