{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,5,2]],"date-time":"2023-05-02T00:35:09Z","timestamp":1682987709567},"reference-count":27,"publisher":"IGI Global","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2011,4,1]]},"abstract":"
Recommending database queries is an emerging and promising field of research and is of particular interest in the domain of OLAP systems, where the user is left with the tedious process of navigating large datacubes. In this paper, the authors present a framework for a recommender system for OLAP users that leverages former users\u2019 investigations to enhance discovery-driven analysis. This framework recommends the discoveries detected in former sessions that investigated the same unexpected data as the current session. This task is accomplished by (1) analysing the query log to discover pairs of cells at various levels of detail for which the measure values differ significantly, and (2) analysing a current query to detect if a particular pair of cells for which the measure values differ significantly can be related to what is discovered in the log. This framework is implemented in a system that uses the open source Mondrian server and recommends MDX queries. Preliminary experiments were conducted to assess the quality of the recommendations in terms of precision and recall, as well as the efficiency of their on-line computation.<\/p>","DOI":"10.4018\/jdwm.2011040101","type":"journal-article","created":{"date-parts":[[2011,10,19]],"date-time":"2011-10-19T16:11:25Z","timestamp":1319040685000},"page":"1-25","source":"Crossref","is-referenced-by-count":27,"title":["Query Recommendations for OLAP Discovery-Driven Analysis"],"prefix":"10.4018","volume":"7","author":[{"given":"Arnaud","family":"Giacometti","sequence":"first","affiliation":[{"name":"Universit\u00e9 Fran\u00e7ois Rabelais Tours, France"}]},{"given":"Patrick","family":"Marcel","sequence":"additional","affiliation":[{"name":"Universit\u00e9 Fran\u00e7ois Rabelais Tours, France"}]},{"given":"Elsa","family":"Negre","sequence":"additional","affiliation":[{"name":"Universit\u00e9 Fran\u00e7ois Rabelais Tours, France"}]},{"given":"Arnaud","family":"Soulet","sequence":"additional","affiliation":[{"name":"Universit\u00e9 Fran\u00e7ois Rabelais Tours, France"}]}],"member":"2432","reference":[{"key":"jdwm.2011040101-0","author":"S.Abiteboul","year":"1995","journal-title":"Foundations of Databases"},{"key":"jdwm.2011040101-1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2005.99"},{"key":"jdwm.2011040101-2","doi-asserted-by":"crossref","unstructured":"Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., & Laurent, D. (2005). A personalization framework for OLAP queries. In Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP (pp. 9\u201318). New York, NY: ACM.","DOI":"10.1145\/1097002.1097005"},{"key":"jdwm.2011040101-3","doi-asserted-by":"crossref","unstructured":"Cariou, V., Cubill\u00e9, J., Derquenne, C., Goutier, S., Guisnel, F., & Klajnmic, H. (2007). Built-in indicators to automatically detect interesting cells in a cube. In Proceedings of the 9th International Conference on Data Warehousing and Knowledge Discovery (LNCS 4654, pp. 123\u2013134).","DOI":"10.1007\/978-3-540-74553-2_12"},{"key":"jdwm.2011040101-4","doi-asserted-by":"crossref","unstructured":"Cariou, V., Cubill\u00e9, J., Derquenne, C., Goutier, S., Guisnel, F., & Klajnmic, H. (2008). Built-in indicators to discover interesting drill paths in a cube. In Proceedings of the 10th International Conference on Data Warehousing and Knowledge Discovery (LNCS 5182, pp. 33\u201344).","DOI":"10.1007\/978-3-540-85836-2_4"},{"key":"jdwm.2011040101-5","doi-asserted-by":"crossref","unstructured":"Chatzopoulou, G., Eirinaki, M., & Polyzotis, N. (2009). Query recommendations for interactive database exploration. In Proceedings of the 21st International Conference on Scientific and Statistical Database Management (LNCS 5566, pp. 3\u201318).","DOI":"10.1007\/978-3-642-02279-1_2"},{"key":"jdwm.2011040101-6","doi-asserted-by":"crossref","unstructured":"Downey, D., Dumais, S. T., Liebling, D. J., & Horvitz, E. (2008). Understanding the relationship between searchers\u2019queries and information goals. In Proceedings of the 17th ACM Conference on Information and Knowledge Management (pp. 449\u2013458). New York, NY: ACM.","DOI":"10.1145\/1458082.1458143"},{"key":"jdwm.2011040101-7","doi-asserted-by":"crossref","unstructured":"Giacometti, A., Marcel, P., & Negre, E. (2008). A framework for recommending OLAP queries. In Proceedings of the 11th ACM International Workshop on Data Warehousing and OLAP (pp. 73\u201380). New York, NY: ACM.","DOI":"10.1145\/1458432.1458446"},{"key":"jdwm.2011040101-8","doi-asserted-by":"crossref","unstructured":"Giacometti, A., Marcel, P., & Negre, E. (2009a). Recommending multidimensional queries. In Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery (LNCS 5691, pp. 453\u2013466).","DOI":"10.1007\/978-3-642-03730-6_36"},{"key":"jdwm.2011040101-9","doi-asserted-by":"crossref","unstructured":"Giacometti, A., Marcel, P., & Negre, E. (2009b). Query recommendation for OLAP discovery driven analysis. In Proceedings of the 12th ACM International Workshop on Data Warehousing and OLAP (pp. 81\u201388). New York, NY: ACM.","DOI":"10.1145\/1651291.1651306"},{"key":"jdwm.2011040101-10","doi-asserted-by":"crossref","unstructured":"Golfarelli, M., & Rizzi, S. (2009). Expressing OLAP preferences. In Proceedings of the 22th International Conference on Scientific and Statistical Database Management (LNCS 5566, pp. 83\u201391).","DOI":"10.1007\/978-3-642-02279-1_7"},{"key":"jdwm.2011040101-11","doi-asserted-by":"publisher","DOI":"10.1023\/A:1009726021843"},{"key":"jdwm.2011040101-12","doi-asserted-by":"crossref","unstructured":"Jerbi, H., Ravat, F., Teste, O., & Zurfluh, G. (2009). Preference-based recommendations for olap analysis. In Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery (LNCS 5691, pp. 467\u2013478).","DOI":"10.1007\/978-3-642-03730-6_37"},{"key":"jdwm.2011040101-13","unstructured":"Khoussainova, N., Balazinska, M., Gatterbauer, W., Kwon, Y., & Suciu, D. (2009). A case for a collaborative query management system. In Proceedings of 4th Biennial Conference on Innovative Data Systems Research. Retrieved from http:\/\/ www.cidrdb.org"},{"key":"jdwm.2011040101-14","doi-asserted-by":"crossref","unstructured":"Lakshmanan, L., Pei, J., & Zhao, Y. (2003). QC-Trees: An efficient summary structure for semantic OLAP. In Proceedings of the 2003 ACM International Conference on Management of Data (pp. 64\u201375). New York, NY: ACM.","DOI":"10.1145\/872757.872768"},{"key":"jdwm.2011040101-15","unstructured":"Microsoft. (2008). Multidimensional expressions (MDX) reference. Retrieved September 23, 2010, from http:\/\/ msdn.microsoft.com\/ en-us\/library\/ ms145506.aspx"},{"key":"jdwm.2011040101-16","doi-asserted-by":"publisher","DOI":"10.1109\/TITB.2008.926989"},{"key":"jdwm.2011040101-17","doi-asserted-by":"crossref","unstructured":"Parikh, N., & Sundaresan, N. (2008). Inferring semantic query relations from collective user behavior. In Proceedings of the 17th ACM Conference on Information and Knowledge Management (pp. 349\u2013358). New York, NY: ACM.","DOI":"10.1145\/1458082.1458130"},{"key":"jdwm.2011040101-18","unstructured":"Pentaho. (2009). Mondrian open source OLAP engine. Retrieved September 23, 2010, from http:\/\/ mondrian.pentaho.org\/"},{"key":"jdwm.2011040101-19","unstructured":"Sapia, C. (1999). On modeling and predicting query behaviour in OLAP systems. In Proceedings of the International Workshop on Design and Management of Data Warehouses (pp. 2.1\u20132.10). CEUR-WS.org."},{"key":"jdwm.2011040101-20","doi-asserted-by":"crossref","unstructured":"Sapia, C. (2000). Promise: Predicting query behavior to enable predictive caching strategies for OLAP systems. In Proceedings of the International Conference on Data Warehousing and Knowledge Discovery (LNCS 1874, pp. 224\u2013233).","DOI":"10.1007\/3-540-44466-1_22"},{"key":"jdwm.2011040101-21","unstructured":"Sarawagi, S. (1999). Explaining differences in multidimensional aggregates. In Proceedings of the 25th International Conference on Very Large Data Bases (pp. 42\u201353). San Francisco, CA: Morgan Kaufmann."},{"key":"jdwm.2011040101-22","unstructured":"Sarawagi, S. (2009). I3: Intelligent, interactive inspection of cubes. Retrieved September 23, 2010, from http:\/\/ www.cse.iitb.ac.in\/ ~sunita\/icube\/"},{"key":"jdwm.2011040101-23","doi-asserted-by":"crossref","unstructured":"Sarawagi, S., Agrawal, R., & Megiddo, N. (1998). Discovery-driven exploration of OLAP data cubes. In Proceedings of the 6th International Conference on Extending Database Technology (LNCS 1377, pp. 168\u2013182).","DOI":"10.1007\/BFb0100984"},{"key":"jdwm.2011040101-24","unstructured":"Sathe, G., & Sarawagi, S. (2001). Intelligent rollups in multidimensional OLAP data. In Proceedings of the 27th International Conference on Very Large Data Bases (pp. 531\u2013540). San Francisco, CA: Morgan Kaufmann."},{"issue":"2","key":"jdwm.2011040101-25","first-page":"106","article-title":"Web mining for e-commerce.","volume":"2","author":"M.Spiliopoulou","year":"2000","journal-title":"SIGKDD Explorations"},{"key":"jdwm.2011040101-26","unstructured":"Stefanidis, K., Drosou, M., & Pitoura, E. (2009). \u00ab You may also like \u00bb results in relational databases. In Proceedings of the 3rd International Workshop on Personalized Access, Profile Management and Context Awareness in Databases (pp. 37\u201342). New York, NY: ACM."}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=53037","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:12:35Z","timestamp":1654114355000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdwm.2011040101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2011,4,1]]},"references-count":27,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2011,4]]}},"URL":"http:\/\/dx.doi.org\/10.4018\/jdwm.2011040101","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":["Hardware and Architecture","Software"],"published":{"date-parts":[[2011,4,1]]}}}