期刊文献+

Skyline查询处理数据立方体代数 被引量:1

An Algebra for Skyline Query Processing Data Cube
在线阅读 下载PDF
导出
摘要 维空间的Skyline查询处理技术是近年来数据库技术领域的一个研究重点和热点.目前所有的研究工作都是直接在原始数据表上执行关系查询代数操作来获得最终的结果集,然而,随着原始数据表的数据量和维目标个数的增大,这些研究工作将不再适用.基于此,首次研究Skyline集合上的查询代数操作,使得Skyline查询处理的输入数据来自于小规模的Skyline结果集,而非海量的原始数据表.并且,首次给出一个集成多维对象集合和该对象集合上的Skyline结果集的形式化模型,该模型适合目前Skyline查询计算的应用,并在该模型的实例上研究Skyline集合的查询代数操作.同时,给出查询代数体系的代价评估模型.实验表明,给出的数据模型和查询代数体系具有有效性和实用性. Skyline query processing has recently received a lot of attention in database community. This is mainly due to the importance of skyline result in many applications, such as multi-criteria decision making, data mining and visualization, and user-preference queries. Presently, all the methods get the skyline set by directly executing query algebra operations on the original tables. However, these methods will not be applicable at all when the cardinality of the original tables and the number of dimensions become larger. Motivated by these facts, the query algebra operations on the skyline sets are first studied. The algebra operations only need the input of the skyline query processing to be the skyline sets whose size are much smaller than the original tables. A formalized model is also first proposed, which brings the set of multiple dimensional objects and the result set of skyline query together. And the instances of this formalized model can be used to study the query algebra operations on the skyline sets. Moreover, the cost model of the data model and query algebra operations is proposed. Extensive experiments demonstrate that the data model and query algebra operations are both efficient and effective.
作者 黄震华 汪卫
出处 《计算机研究与发展》 EI CSCD 北大核心 2007年第6期990-999,共10页 Journal of Computer Research and Development
基金 国家自然科学基金项目(60303008) 国家"九七三"重点基础研究发展规划基金项目(2005CB321905)~~
关键词 SKYLINE 查询代数 数据模型 数据立方体 查询处理 代价模型 skyline query algebra data model data cube query processing cost model
  • 相关文献

参考文献14

  • 1S Borzsonyi,D Kossmann,K Stocker.The skyline operator[C].In:Proc of ICDE.Los Alamitos:IEEE Computer Society Press,2001.421-430
  • 2H X Lu,Y Luo,X Lin.An optimal divide conquer algorithm for 2D skyline[C].In:Proc of ADBIS.Berlin:Springer Verlag,2003.46-66
  • 3C Y Chan,P K Eng,K L Tan.Stratified computation of skylines with partially-ordered domains[C].In:Proc of ACM SIGMOD 2005.New York:ACM Press.2005.203-214
  • 4W T Balke,U Guntzer,J X Zheng.Efficient distributed skylining for Web information systems[C].In:Proe of EDBT.Berlin:Springer-Verlag,2004.256-273
  • 5W Jin,J Han,M Ester.Mining thick skylines over large databases[C].In:Proc of PKDD.Berlin:Springer-Verlag,2004.255-266
  • 6P Godfrey.Skyline cardinality for relational processing[C].In:Proc of FolKS.Berlin:Springer-Verlag,2004.78-97
  • 7J Chomicki,P Godfrey,J Gryz,et al.Skyline with presorting[C].In:Proc of ICDE.Los Alamitos:IEEE Computer Society Press,2003.717-719
  • 8D Kossmann,F Ramsak,S Rost.Shooting stars in the sky:An online algorithm for skyline queries[C].In:Proc of VLDB 2002.Trondheim,Norway:Kluwer,2002.290-302
  • 9D Papadias,Y Tao,G Fu,et al.Progressive skyline computation in database systems[J].ACM Trans on Database Systems,2005,30(1):41-82
  • 10X Lin,Y Yuan,W Wang,et al.Stabbing the sky:Efficient skyline computation over sliding windows[C].In:Proc of ICDE.Los Alamitos:IEEE Computer Society Press,2005.276-288

二级参考文献2

共引文献11

同被引文献22

  • 1段江娇,薛永生,林子雨,汪卫,施伯乐.一种新的基于隐Markov模型的分层时间序列聚类算法[J].计算机研究与发展,2006,43(1):61-67. 被引量:10
  • 2Borzsonyi S, Kossmann D, Stocker K. The skyline operator [C] //Proc of the Int Conf on Data Engineering. Los Alamitos, CA: IEEE Computer Society, 2001: 421-430.
  • 3Chomicki J, Godfrey P, Gryz J, et al. Skyline with presorting [C] //Proc of the Int Conf on Data Engineering. Los Alamitos, CA, IEEE Computer Society, 2003:717-719.
  • 4Kossmann D, Ramsak F, Rost S. Shooting stars in the sky; An online algorithm for skyline queries[C] //Proc of the Int Conf on Very Large Data Bases. San Francisco, CA: Morgan Kaufmann, 2002:290-302.
  • 5Papadias D, Tao Y, Fu G, et al. Progressive skyline computation in data systems [J]. ACM Trans on Database Systems, 2005, 30(1):41-82.
  • 6Papadias D, Tao Y, Fu G, et al. An optimal and progressive algorithm for skyline queries [C] //Proc of the ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2003:467-478.
  • 7Sharifzadeh M, Shahabi C. The spatial skyline queries [C]//Proc of the Int Confon Very Large Data Bases. New York: ACM, 2006:751-762.
  • 8Li Q. Lopez L, Moon B. Skyline index for time series data [J]. IEEE Trans on Knowledge and Data Engineering, 2004, 16(6): 669-684.
  • 9Papadimitriou S, Yu P. Optimal multi scale patterns in time series streams [C] //Proc of the ACM SIGMOD Int Conf on Management of Data. New York: ACM, 2006:647-658.
  • 10Pei J, Jiang B, Lin X, et al. Probabilistic skylines on uncertain data [C] //Proe of the Int Conf on Very Large Data Bases. New York: ACM, 2007:641-652.

引证文献1

二级引证文献1

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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