DOI QR코드

DOI QR Code

OLAP4R: A Top-K Recommendation System for OLAP Sessions

  • Yuan, Youwei (School of Computer Science and Technology, Hangzhou Dianzi University) ;
  • Chen, Weixin (School of Computer Science and Technology, Hangzhou Dianzi University) ;
  • Han, Guangjie (Department of Information and Communication Systems, Hohai University) ;
  • Jia, Gangyong (School of Computer Science and Technology, Hangzhou Dianzi University)
  • Received : 2017.02.22
  • Accepted : 2017.04.02
  • Published : 2017.06.30

Abstract

The Top-K query is currently played a key role in a wide range of road network, decision making and quantitative financial research. In this paper, a Top-K recommendation algorithm is proposed to solve the cold-start problem and a tag generating method is put forward to enhance the semantic understanding of the OLAP session. In addition, a recommendation system for OLAP sessions called "OLAP4R" is designed using collaborative filtering technique aiming at guiding the user to find the ultimate goals by interactive queries. OLAP4R utilizes a mixed system architecture consisting of multiple functional modules, which have a high extension capability to support additional functions. This system structure allows the user to configure multi-dimensional hierarchies and desirable measures to analyze the specific requirement and gives recommendations with forthright responses. Experimental results show that our method has raised 20% recall of the recommendations comparing the traditional collaborative filtering and a visualization tag of the recommended sessions will be provided with modified changes for the user to understand.

Keywords

References

  1. S. Laraichi, A. Hammani, A. Bouignane, "Data integration as the key to building a decision support system for groundwater management: Case of Saiss aquifers, Morocco," Groundwater for Sustainable Development, vol. 2-3, pp. 7-15, August-September, 2016. https://doi.org/10.1016/j.gsd.2016.04.003
  2. W. Jakkhupan, S. Kajkamhaeng, "Movie Recommendation Using OLAP and Multidimensional Data Model," in Proc .of International Conference on Computer Information Systems and Industrial Management, pp. 209-218, November, 2014.
  3. P. Marcel, "Log-driven user-centric OLAP," International Convention on Information and Communication Technology, Electronics and Microelectronics, pp. 1446-1451, May, 2014.
  4. L. Sautot, B. Faivre, L. Journaux, P. Molin, "The hierarchical agglomerative clustering with Gower index: A methodology for automatic design of OLAP cube in ecological data processing context," Ecological Informatics, vol. 26, pp. 217-230,March, 2015. https://doi.org/10.1016/j.ecoinf.2014.07.011
  5. J. Wei, J. He, K. Chen, Y. Zhou, Z. Tang, "Collaborative filtering and deep learning based recommendation system for cold start items," Expert Systems with Applications, vol. 69, pp. 29-39, March, 2017. https://doi.org/10.1016/j.eswa.2016.09.040
  6. L. Zhu, C. Xu, J. Guan, H. Zhang, "SEM-PPA: A semantical pattern and preference-aware service mining method for personalized point of interest recommendation," Journal of Network and Computer Applications, vol. 82, pp. 35-46, March, 2017. https://doi.org/10.1016/j.jnca.2016.12.033
  7. A. Singh, N. Parimala, "Recommending Next Query in an OLAP Session," International Symposium on Computational & Business Intelligence, pp. 73-80, December, 2014.
  8. S. Ali, O. Boussaid and F. Bentayeb, "Towards Collaborative Multidimensional Query Recommendation with Triadic Association Rules," Decision Support Systems, vol. 7, no. 3, pp. 17-35, July-September, 2015. https://doi.org/10.4018/ijdsst.2015070102
  9. S. Rizzi, E. Gallinucci, "CubeLoad: A Parametric Generator of Realistic OLAP Workloads," in Proc .of Conference on Advanced Information Systems Engineering, pp. 610-624, June. 16-20, 2014.
  10. J. Aligon, E. Gallinucci, M. Golfarelli, P. Marcel, S. Rizzi, "A collaborative filtering approach for recommending OLAP sessions," Decision Support Systems, vol. 69, pp. 20-30, January, 2015. https://doi.org/10.1016/j.dss.2014.11.003
  11. D. Vandic, JWV. Dam, F. Frasincar, "A semantic-based approach for searching and browsing tag spaces," Decision Support Systems, vol. 54, pp. 644-654, December, 2012. https://doi.org/10.1016/j.dss.2012.08.010
  12. Y. Zuo, J. Zeng, M. Gong, L. Jiao, "Tag-aware recommender systems based on deep neural networks," Neurocomputing, vol. 204, pp. 51-60, September, 2016. https://doi.org/10.1016/j.neucom.2015.10.134
  13. Y. Li, G. Li, L. Shu, Q. Huang, and H. Jiang, "Continuous Monitoring of Top-k Spatial Keyword Queries in Road Networks," Journal of Information Science and Engineering, vol. 31, no. 6, pp. 1831-1848, November, 2015.
  14. D. Liu, "Novel Semantics of the Top-k Queries on Uncertainly Fused Multi-Sensory Data," Journ al of Information Science and Engineering, vol. 31, no 1, pp. 179-205, January, 2015.
  15. J. Aligon, M. Golfarelli, P. Marcel, S. Rizzi, E. Turricchia, "Similarity measures for OLAP sessions," Knowledge and Information Systems, vol. 39, no. 2, pp. 463-489, May, 2014. https://doi.org/10.1007/s10115-013-0614-1
  16. J. Song, C. Guo, Z. Wang, Y. Zhang, G. Yu and J. M. Pierson, "HaoLap: A Hadoop based OLAP s ystem for big data," The Journal of Systems and Software, vol. 102, pp. 167-181, April, 2015. https://doi.org/10.1016/j.jss.2014.09.024
  17. L. Safoury, A. Salah, "Exploiting user demographic attributes for solving cold-start problem in re commender system," Lecture Notes on Software Engineering, vol. 1, pp. 303-307, January, 2013.
  18. D. Gkesoulis, P. Vassiliadis, P. Manousis, "CineCubes: Aiding data workers gain insights from OLAP queries," Information Systems, vol. 53, pp. 60-86, October-November, 2015. https://doi.org/10.1016/j.is.2014.12.006
  19. M.Y.H. Al-Shamri, "User profiling approaches for demographic recommender systems," Knowledge-Based Systems, vol. 100, pp. 175-187,March, 2016. https://doi.org/10.1016/j.knosys.2016.03.006
  20. M.Y.H. Al-Shamri, "Power coefficent as a similarity measure for collaborative recommender system," Expert Systems with Applications, vol. 41, no. 13, pp. 5680-5688, October, 2014. https://doi.org/10.1016/j.eswa.2014.03.025
  21. S. Xie, Y. Wang, "Construction of Tree Network with Limited Delivery Latency in Homogeneous Wireless Sensor Networks," Wireless Personal Communications, vol. 78, no. 1, pp. 231-246, April, 2014. https://doi.org/10.1007/s11277-014-1748-5
  22. J. Shen, H. Tan, J. Wang, J. Wang, S. Lee, "A Novel Routing Protocol Providing Good Transmission Reliability in Underwater Sensor Networks," Journal of Internet Technology, vol. 16, no. 1, pp. 171-178, January, 2015.
  23. Y. Zhang, X. Sun, B. Wang, "Efficient Algorithm for K-Barrier Coverage Based on Integer Linear Programming," China Communications, vol. 13, no. 7, pp. 16-23, July, 2016. https://doi.org/10.1109/CC.2016.7559071
  24. P. Guo, J. Wang, XH. Geng, CS. Kim, JU. Kim, "A Variable Threshold-value Authentication Architecture for Wireless Mesh Networks," Journal of Internet Technology, vol. 15, no. 6, pp. 929-936, November, 2014.
  25. G. Jia, G. Han, J. Jiang, L. Liu, "Dynamic Adaptive Replacement Policy in Shared Last-Level Cache of DRAM/PCM Hybrid Memory for Big Data Storage," IEEE Transactions on Industrial Informatics, vol. 99, pp. 1-1, December, 2016.
  26. G. Han, L. Liu, S. Chan, R. Yu, Y. Yang, "HySense: A Hybrid Mobile CrowdSensing Framework for Sensing Opportunities Compensation under Dynamic Coverage Constraint," IEEE C ommunications Magazine, vol. 55, pp. 93-99, March, 2017.