Online Subspace Skyline Query Processing Using the Compressed Skycube

被引:12
|
作者
Xia, Tian [2 ]
Zhang, Donghui [3 ]
Fang, Zheng [1 ]
Chen, Cindy [1 ]
Wang, Jie [1 ]
机构
[1] Univ Massachusetts, Lowell, MA 01854 USA
[2] Teradata Corp, El Segundo, CA 90245 USA
[3] Microsoft Gray Syst Lab, Madison, WI 53703 USA
来源
ACM TRANSACTIONS ON DATABASE SYSTEMS | 2012年 / 37卷 / 02期
关键词
Algorithms; Design; Performance; Skyline; subspace; compressed; update support; workload; AVERAGE NUMBER; MAXIMA; SET;
D O I
10.1145/2188349.2188357
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The skyline query can help identify the "best" objects in a multi-attribute dataset. During the past decade, this query has received considerable attention in the database research community. Most research focused on computing the "skyline" of a dataset, or the set of "skyline objects" that are not dominated by any other object. Such algorithms are not appropriate in an online system, which should respond in real time to skyline query requests with arbitrary subsets of the attributes (also called subspaces). To guarantee real-time response, an online system should precompute the skylines for all subspaces, and look up a skyline upon query. Unfortunately, because the number of subspaces is exponential to the number of attributes, such pre computation has very expensive storage cost and update cost. We propose the Compressed SkyCube (CSC) that is much more compact, yet can still return the skyline of any subspace without consulting the base table. The CSC therefore combines the advantage of precomputation in that it can respond to queries in real time, and the advantage of no-precomputation in that it has efficient space cost and update cost. This article presents the CSC data structures, the CSC query algorithm, the CSC update algorithm, and the CSC initial computation scheme. A solution to extend to high-dimensional data is also proposed.
引用
收藏
页数:36
相关论文
共 50 条
  • [1] Continuous Probabilistic Subspace Skyline Query Processing Using Grid Projections
    Lei Zhao
    Yan-Yan Yang
    Xiaofang Zhou
    [J]. Journal of Computer Science and Technology, 2014, 29 : 332 - 344
  • [2] Continuous Probabilistic Subspace Skyline Query Processing Using Grid Projections
    赵雷
    杨艳艳
    周晓方
    [J]. Journal of Computer Science & Technology, 2014, 29 (02) : 332 - 344
  • [3] Continuous Probabilistic Subspace Skyline Query Processing Using Grid Projections
    Zhao, Lei
    Yang, Yan-Yan
    Zhou, Xiaofang
    [J]. JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY, 2014, 29 (02) : 332 - 344
  • [4] SkyCube-Tree Based Group-by Query Processing in OLAP Skyline Cubes
    Sato, Hideki
    Usami, Takayuki
    [J]. INTELLIGENT INTERACTIVE MULTIMEDIA SYSTEMS AND SERVICES 2016, 2016, 55 : 297 - 308
  • [5] The subspace global skyline query processing over dynamic databases
    Mei Bai
    Junchang Xin
    Guoren Wang
    Xite Wang
    Roger Zimmermann
    [J]. World Wide Web, 2017, 20 : 291 - 324
  • [6] The subspace global skyline query processing over dynamic databases
    Bai, Mei
    Xin, Junchang
    Wang, Guoren
    Wang, Xite
    Zimmermann, Roger
    [J]. WORLD WIDE WEB-INTERNET AND WEB INFORMATION SYSTEMS, 2017, 20 (02): : 291 - 324
  • [7] Skycube Materialization Using the Topmost Skyline or Functional Dependencies
    Maabout, Sofian
    Ordonez, Carlos
    Wanko, Patrick Kamnang
    Hanusse, Nicolas
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 2016, 41 (04):
  • [8] Skyline and reverse skyline query processing in SpatialHadoop
    Kalyvas, Christos
    Maragoudakis, Manolis
    [J]. DATA & KNOWLEDGE ENGINEERING, 2019, 122 : 55 - 80
  • [9] Efficient subspace skyline query based on user preference using MapReduce
    Li, Yuanyuan
    Li, Zhiyang
    Dong, Mianxiong
    Qu, Wenyu
    Ji, Changqing
    Wu, Junfeng
    [J]. AD HOC NETWORKS, 2015, 35 : 105 - 115
  • [10] Skyline query processing for incomplete data
    Khalefa, Mohamed E.
    Mokbel, Mohamed F.
    Levandoski, Justin J.
    [J]. 2008 IEEE 24TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, VOLS 1-3, 2008, : 556 - 565