期刊文献+

高效的Top-k相互Skyline查询算法 被引量:4

Efficient Top-k Query Processing on Mutual Skyline
下载PDF
导出
摘要 Top-k相互Skyline查询返回相互Skyline查询中的前k个对象.这种查询是数据分析者寻找有意义对象进行决策支持的一种重要直觉工具.然而,这种查询还没有引起研究社区足够的注意力.介绍了几种新颖的算法,包括Topk-TBBS,Topk-dMBBS,Topk-wMBBS.主要的思想是信息重用和高效的修剪策略.特别地,Topk-wMBBS算法由于完全重用了搜索中的节点信息,并利用了最好优先BF搜索策略.因而它获得了最好的性能.同时证明了该算法有最优的I?O访问效率.最后,使用了2个真实数据集和4个服从不同分布的合成数据集进行了集中实验.实验结果表明,提出的算法无论是变化参数k的大小、数据集的尺寸和Cache尺寸都是有效的,且具有很高的效率,尤其Topk-wMBBS具有最小的I?O访问次数. The top-k mutual skyline query returns k data objects among mutual skyline. This query is an important tool for decision support since it provides data analysts an intuitive way for finding significant objects. However, it has not received adequate attention from the research community. In this paper, several new algorithms are introduced, including Topk-TBBS (Topk two step branch and bound skyline), Topk-dMBBS (Topk mutual branch and bound skyline by dynamic skyline), and Topk-zvMBBS (Topk mutual branch and bound skyline by Window Query). The main ideas are information reuse and some efficient pruning policies. Especially, Topk-wMBBS has the least number of node accesses as it fully reuses the information during the search and takes advantage of the best first (BF) search policy. Therefore, it obtains the best performance among all algorithms. Meanwhile, we also show that Topk-wMBBS has the optimal efficiency on I/O cost. Finally, we carry out the extensive experiments using two real datasets and four synthetic datasets which follow different distributions. The results show that the proposed algorithms are effective and have a higher efficiency, especially Topk-wMBBS which has at least I/O accesses, varying the number of parameter k, the cardinality of different datasets, and the cache size.
出处 《计算机研究与发展》 EI CSCD 北大核心 2013年第5期986-997,共12页 Journal of Computer Research and Development
基金 国家自然科学基金项目(61003049) 浙江省自然科学基金项目(LY12F02047 LY12F02019) 浙江省公益性技术应用研究计划基金项目(2011C23130) 中央高校基本科研业务费专项基金项目(2010QNA5051 2012QNA5018) 浙江大学紫金计划重点项目 嘉兴市科技计划基金项目(2011AY1005) 浙江省优秀青年教师基金项目(70611011) 嘉兴学院博士启动项目(70510010)
关键词 算法 Topk查询 动态Skyline 可逆Skyline 相互Skyline algorithm topk query dynamic skyline reverse skyline mutual skyline
  • 相关文献

参考文献16

  • 1Papadias D, Tao Yufei, Fu G, et al. Progressive skyline computation in database systems [J]. ACM Trans on Database System, 2005, 30(1): 41-82.
  • 2Sharifzadeh M, Shahabi C. The spatial skyline queries [C] // Procof VLDBConf. New York: ACM, 2006:751-762.
  • 3Chen Lei, Lian Xiang. Dynamic skyline queries in metric spaces [C] //Proc of ACM EDBT Conf. New York: ACM, 2008:333-343.
  • 4Dellis E, Seeger B. Efficient computation of reverse skyline queries [C]//Proe of VLDB Conf. New York.- ACM, 2007:291-302.
  • 5Lian Xiang, Chen Lei. Monochromatic and bichromatic reverse skyline search over uncertain databases [C] //Proe of ACMSIGMODConf. New York: ACM, 2008:213-226.
  • 6张彬,蒋涛,乐光学,李国徽.基于重用技术的相互Skyline查询算法[J].华中科技大学学报(自然科学版),2010,38(7):111-114. 被引量:3
  • 7张彬,蒋涛,乐光学,李国徽.一种最优的相互skyline查询算法[J].华中科技大学学报(自然科学版),2010,38(8):53-56. 被引量:2
  • 8Lee J, You C W. Hwang queries in high-dimensional 2009, 34(1): 45-61.
  • 9S W. Personalized top-k skyline space [J]. Information Systems, I.in Xueming Yuan Yidong, Zhang Qing, et al. Selecting stars: The k most representative skyline operator [C] //Proc of IEEE ICDE Conf. Los Alamitos, CA:IEEE Computer Society, 2007:86-95.
  • 10Soliman M A, ILyas I F, Koudas N. Finding skyline and top k bargaining solutions [C] //Proe of IEEE ICDE Conf. I.os Alamitos, CA: IEEE Computer Society, 2007:1263-1267.

二级参考文献23

  • 1Borzsonyi S, Kossmann D, Stocker K. The Skylineoperator[C]//Proc of IEEE ICDE Int'l Conf. Heidelberg: IEEE Computer Society, 2001: 421-430.
  • 2Tan K L, Eng P K, Ooi B C. Efficient progressive Skyline computation [C]// Proc of VLDB Conf. Roma: Morgan Kaufmann, 2001: 301-310.
  • 3Kossmann D, Ramsak F, Rost S. Shooting starts in the sky: an online algorithm for Skyline queries[C]// Proc of VLDB Conf. Hong Kong: Morgan Kaufmann, 2002: 275-286.
  • 4Papadias D, Tao Y, Fu G, et al. Progressive Skyline computation in database systems[J]. ACM Trans on Database Syst, 2005, 30(1): 41-82.
  • 5Yuan Y, Lin X, I.iu Q, et al. Efficient computation of the Skyline cube[C]//Proc of VLDB Conf. Trondheim: ACM, 2005: 241-252.
  • 6Gao Y, Zheng B, Chen G, et al. On efficient mutual nearest neighbor query processing in spatial databases [J]. Data and Knowledge Engineering, 2009, 68(8): 705-727.
  • 7Deng K, Zhou X, Shen H T. Multi-source Skyline query processing in road networks[C]//Proc of IEEE ICDE Conf. Istanbul: IEEE Computer Society, 2007: 797-805.
  • 8Sharifzadeh M, Shahabi C. The spatial Skyline queries[C]//Proe of VLDB Conf. Seoul: ACM, 2006: 751-762.
  • 9Chen L, Lian X. Dynamic Skyline queries in metric spaces[C]//Proc of ACMEDBT. Nantes: ACM, 2008 : 333-343.
  • 10Lian X, Chen L. Monochromatic and bichromatic reverse Skyline search over uncertain databases [C]// Proc of SIGMOD Conf. Vancouver: ACM, 2008: 213-226.

共引文献3

同被引文献26

  • 1Papadias D, Tao Y, Fu G, et al. Progressive skyline computation in database systems [J]. ACM Trans on Database Systems, 2005, 30(1): 41-82.
  • 2Sharifzadeh M, Shahabi C. The spatial skyline queries [C] // Procofthe32ndVLDBConf. New York: ACM, 2006:751- 762.
  • 3Chen L, Lian X. Efficient processing of metric skyline queries [J]. IEEE Trans on Knowledge and Data Engineering, 2009, 21(3): 351-365.
  • 4De[lis E, Seeger B, Efficient computation of reverse skyline queries C~ [/Proe of the 33rd VLDB Conf. New York: ACM, 2007:291-302.
  • 5Lian X, Chen L. Monochromatic and bichromatic reverse skyline search over uncertain databases [C3 //Proc of the 28th ACMSIGMOD. New York: ACM, 2008:213-226.
  • 6Lee J, Hwang S. QSkycube: Efficient skycube computation using point-based space partitioning [C] //Proc of the 37th VLDB Conf. New York: ACM, 2011.. 185-196.
  • 7Bartolini I, Ciaccia P, Patella M. Efficient sort based skyline evaluation [J]. ACM Trans on Database Systems, 2008, 33 (4) : 1-49.
  • 8Wu X, Tao Y, Wong R C-W, et al. Finding the influence set through skylines [C] //Proc of the 12th ACM EDBT Conf. New York: ACM, 2009:1030-1041.
  • 9Tao Y, Xiao X, Pei J. Efficient skyline and top-k retrieval in subspaces [J]. IEEE Trans on Knowledge and Data Engineering, 2007, 19(8): 1072-1088.
  • 10Deshpande p M, Deepak P. Efficient reverse skyline retrieval with arbitrary non-metric similarity measures [C] //Proe of the 14thACM EDBT Conf. New York: ACM, 2011: 319- 330.

引证文献4

二级引证文献6

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部