Identifying Dissimilar OLAP Query Session for Building Goal Hierarchy

  • N. Parimala
  • Ranjeet Kumar Ranjan
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 710)


Traditionally, a goal-oriented approach follows the goal decomposition technique to build a goal hierarchy in order to identify the schema for a data warehouse. In our earlier work, using reverse engineering approach, a goal hierarchy was built for an existing data warehouse schema using a single query session. The tasks of this hierarchy address some part of the warehouse. In this paper, we address the issue of identifying the next session to build a goal hierarchy. The sessions which provide the tasks and information goals distinct from existing goal hierarchy are desirable. To identify such a session, we define distance between sessions. The session whose distance from the current session is maximum is picked up.


Data analysis Data warehousing Goal decomposition Goal hierarchy OLAP OLAP query OLAP sessions Session distance MDX 



This research was supported by Department of Science and Technology, Govt. of India, under the project “DST-PURSE Program, Phase- II”.


  1. 1.
    Inmon, W.H.: Building the data warehouse. 4th edn. Wiley Publishing Inc, USA (1992).Google Scholar
  2. 2.
    Mazón, J.N., Pardillo, J., Trujillo, J.: A model-driven goal-oriented requirement engineering approach for data warehouses. In: ER Workshops 2007, LNCS, vol. 4802, pp. 255–264. Springer, Heidelberg (2007).Google Scholar
  3. 3.
    Salinesi, C., Gam, I.: A requirement-driven approach for designing data warehouses. In: Requirements Engineering: Foundations for Software Quality (REFSQ”06), p. 1. Luxembourg (2006).Google Scholar
  4. 4.
    Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP (DOLAPʹ05), pp. 47–56. Germany (2005).Google Scholar
  5. 5.
    Giorgini, P., Rizzi, S., Garzetti, M. (2008): GRAnD: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems, vol. 45, no. 1, 4–21 (2005).Google Scholar
  6. 6.
    Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems, 7(02n03), 215–247 (1998).Google Scholar
  7. 7.
    Ranjan R.K., Parimala N.: A bottom-up approach for creating goal hierarchy using olap query recommendation technique, Int. J. Business Information Systems (Accepted 2017).Google Scholar
  8. 8.
    Aligon, J., Gallinucci, E., Golfarelli, M., Marcel, P., Rizzi, S.: A collaborative filtering approach for recommending olap sessions. Decision Support Systems, 69, 20–30 (2015).Google Scholar
  9. 9.
    Jensen, M., Holmgren, T., Pedersen, T.: Discovering multidimensional structure in relational data. In: Proceedings of International Conference on Data Warehousing and Knowledge Discovery, pp. 138–148. Zaragoza, Spain (2004).Google Scholar
  10. 10.
    Prakash, N., Gosain, A.: Requirements driven data warehouse development. CAiSE Short Paper Proceedings, Vol. 252. Springer (2003).Google Scholar
  11. 11.
    Parimala, N., Ranjan, R.K.: Mapping extended rationale diagrams to olap queries. ACM SIGSOFT Software Engineering Notes, vol. 38, no. 3, 1–6 (2013).Google Scholar
  12. 12.
    Adomavicius, G., Tuzhilin, A.: Toward the next generation of recommender systems: a survey of the state-of-the-art and possible extensions. IEEE Transactions on Knowledge and Data Engineering, vol. 17, no. 6, 734–749 (2005).Google Scholar
  13. 13.
    Aligon, J., Golfarelli, M., Marcel, P., Rizzi, S., Turricchia, E.: Mining preferences from olap query logs for proactive personalization. In: Proceedings ADBIS, pp. 84–97. Vienna, Austria, (2011).Google Scholar
  14. 14.
    Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: Preference-based recommendations for olpa analysis. In: Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery (DaWaKʹ09), pp. 467–478. Springer-Verlag, Berlin, Heidelberg (2009).Google Scholar
  15. 15.
    Giacometti, A., Marcel, P., Negre, E.: A framework for recommending olap queries. In: Proceedings of the ACM 11th international workshop on Data warehousing and OLAP, pp. 73–80. ACM (2008).Google Scholar
  16. 16.
    Aissa, S., Gouider, M.S.: A new similairty measure for spatial personalization. International Journal of Database Management System, vol. 4, no. 4, 1–12 (2012).Google Scholar
  17. 17.
    Aligon, J., Golfarelli, M., Marcel, P., Rizzi, S., Turricchia, E.: Similarity measures for olap sessions. Knowledge and Information Systems, 39(2), 463–489 (2014).Google Scholar
  18. 18.
    Smith, B., Clay, C.: Microsoft sql server 2008 mdx step by step. Pearson Education, Washington, USA (2009).Google Scholar
  19. 19.
    Microsoft SQL Server 2012., last accessed 2016/08/01.
  20. 20.
    AdventureWorksDW: Microsoft sql server., last accessed 2016/08/01.

Copyright information

© Springer Nature Singapore Pte Ltd. 2018

Authors and Affiliations

  1. 1.School of Computer and Systems SciencesJawaharlal Nehru UniversityNew DelhiIndia

Personalised recommendations