Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Inmon, W.H.: Building the data warehouse. 4th edn. Wiley Publishing Inc, USA (1992).
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).
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).
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).
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).
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).
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).
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).
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).
Prakash, N., Gosain, A.: Requirements driven data warehouse development. CAiSE Short Paper Proceedings, Vol. 252. Springer (2003).
Parimala, N., Ranjan, R.K.: Mapping extended rationale diagrams to olap queries. ACM SIGSOFT Software Engineering Notes, vol. 38, no. 3, 1–6 (2013).
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).
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).
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).
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).
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).
Aligon, J., Golfarelli, M., Marcel, P., Rizzi, S., Turricchia, E.: Similarity measures for olap sessions. Knowledge and Information Systems, 39(2), 463–489 (2014).
Smith, B., Clay, C.: Microsoft sql server 2008 mdx step by step. Pearson Education, Washington, USA (2009).
Microsoft SQL Server 2012. https://www.microsoft.com/en-in/download/details.aspx?id=29062, last accessed 2016/08/01.
AdventureWorksDW: Microsoft sql server. https://msftdbprodsamples.codeplex.com, last accessed 2016/08/01.
Acknowledgements
This research was supported by Department of Science and Technology, Govt. of India, under the project “DST-PURSE Program, Phase- II”.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Parimala, N., Ranjan, R.K. (2018). Identifying Dissimilar OLAP Query Session for Building Goal Hierarchy. In: Pattnaik, P., Rautaray, S., Das, H., Nayak, J. (eds) Progress in Computing, Analytics and Networking. Advances in Intelligent Systems and Computing, vol 710. Springer, Singapore. https://doi.org/10.1007/978-981-10-7871-2_29
Download citation
DOI: https://doi.org/10.1007/978-981-10-7871-2_29
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-7870-5
Online ISBN: 978-981-10-7871-2
eBook Packages: EngineeringEngineering (R0)