Skip to main content

Towards Introducing User Preferences in OLAP Reporting Tool

  • Conference paper
Workshops on Business Informatics Research (BIR 2011)

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

Included in the following conference series:

  • 493 Accesses

Abstract

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.

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 54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.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

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. 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), http://ceur-ws.org/Vol-256/submission_4.pdf

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

    Chapter  Google Scholar 

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

    Chapter  Google Scholar 

  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. 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. 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. Object Management Group: Common Warehouse Metamodel Specification, v1.1, http://www.omg.org/cgi-bin/doc?formal/03-03-02

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

    Chapter  Google Scholar 

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

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Kozmina, N., Solodovnikova, D. (2012). Towards Introducing User Preferences in OLAP Reporting Tool. In: Niedrite, L., Strazdina, R., Wangler, B. (eds) Workshops on Business Informatics Research. BIR 2011. Lecture Notes in Business Information Processing, vol 106. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-29231-6_17

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-29231-6_17

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-29230-9

  • Online ISBN: 978-3-642-29231-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics