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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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)
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
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)
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)
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)
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)
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)
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)
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)
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)
Object Management Group: Common Warehouse Metamodel Specification, v1.1, http://www.omg.org/cgi-bin/doc?formal/03-03-02
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)
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)
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)
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)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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)