An efficient parallel processing method for skyline queries in MapReduce

被引:0
|
作者
Junsu Kim
Myoung Ho Kim
机构
[1] KAIST,School of Computing
来源
关键词
Skyline query processing; Parallel processing; Distributed processing; MapReduce; Distributed systems; Big data;
D O I
暂无
中图分类号
学科分类号
摘要
Skyline queries are useful for finding only interesting tuples from multi-dimensional datasets for multi-criteria decision making. To improve the performance of skyline query processing for large-scale data, it is necessary to use parallel and distributed frameworks such as MapReduce that has been widely used recently. There are several approaches which process skyline queries on a MapReduce framework to improve the performance of query processing. Some methods process a part of the skyline computation in a serial manner, while there are other methods that process all parts of the skyline computation in parallel. However, each of them suffers from at least one of two drawbacks: (1) the serial computations may prevent them from fully utilizing the parallelism of the MapReduce framework; (2) when processing the skyline queries in a parallel and distributed manner, the additional overhead for the parallel processing may outweigh the benefit gained from parallelization. In order to efficiently process skyline queries for large data in parallel, we propose a novel two-phase approach in MapReduce framework. In the first phase, we start by dividing the input dataset into a number of subsets (called cells) and then we compute local skylines only for the qualified cells. The outer-cell filter used in this phase considerably improves the performance by eliminating a large number of tuples in unqualified cells. In the second phase, the global skyline is computed from local skylines. To separately determine global skyline tuples from each local skyline in parallel, we design the inner-cell filter and also propose efficient methods to reduce the overhead caused by computing and utilizing the inner-cell filters. The primary advantage of our approach is that it processes skyline queries fast and in a fully parallelized manner in all states of the MapReduce framework with the two filtering techniques. Throughout extensive experiments, we demonstrate that the proposed approach substantially increases the overall performance of skyline queries in comparison with the state-of-the-art skyline processing methods. Especially, the proposed method achieves remarkably good performance and scalability with regard to the dataset size and the dimensionality. Our approach has significant benefits for large-scale query processing of skylines in distributed and parallel computing environments.
引用
收藏
页码:886 / 935
页数:49
相关论文
共 50 条
  • [21] Efficient processing of top k group skyline queries
    Yang, Zhibang
    Zhou, Xu
    Li, Kenli
    Xiao, Guoqing
    Gao, Yunjun
    Li, Keqin
    KNOWLEDGE-BASED SYSTEMS, 2019, 182
  • [22] Parallel Computation of Skyline Queries
    Woods, Louis
    Alonso, Gustavo
    Teubner, Jens
    2013 IEEE 21ST ANNUAL INTERNATIONAL SYMPOSIUM ON FIELD-PROGRAMMABLE CUSTOM COMPUTING MACHINES (FCCM), 2013, : 1 - 8
  • [23] Efficient processing of skyline queries with partially-ordered domains
    Chan, CY
    Eng, PK
    Tan, KL
    ICDE 2005: 21ST INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2005, : 190 - 191
  • [24] Energy Efficient and Progressive Strategy for Processing Skyline Queries on Air
    Ha, JongWoo
    Kwon, Yoon
    Choi, Jae-Ho
    Lee, SangKeun
    DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2009, 5690 : 486 - +
  • [25] An Efficient Pruning Method to Process Reverse Skyline Queries
    Han, Ah
    Park, Youngbae
    Kwon, Dongseop
    JOURNAL OF INFORMATION SCIENCE AND ENGINEERING, 2014, 30 (02) : 501 - 517
  • [26] Efficient Processing of Skyline Group Queries over a Data Stream
    Xi Guo
    Hailing Li
    Aziguli Wulamu
    Yonghong Xie
    Yajing Fu
    Tsinghua Science and Technology, 2016, 21 (01) : 29 - 39
  • [27] Efficient Processing of Skyline Group Queries over a Data Stream
    Guo, Xi
    Li, Hailing
    Wulamu, Aziguli
    Xie, Yonghong
    Fu, Yajing
    TSINGHUA SCIENCE AND TECHNOLOGY, 2016, 21 (01) : 29 - 39
  • [28] An Efficient Approach for Processing Skyline Queries in Incomplete Multidimensional Database
    Ali A. Alwan
    Hamidah Ibrahim
    Nur Izura Udzir
    Fatima Sidi
    Arabian Journal for Science and Engineering, 2016, 41 : 2927 - 2943
  • [29] An Efficient Approach for Processing Skyline Queries in Incomplete Multidimensional Database
    Alwan, Ali A.
    Ibrahim, Hamidah
    Udzir, Nur Izura
    Sidi, Fatima
    ARABIAN JOURNAL FOR SCIENCE AND ENGINEERING, 2016, 41 (08) : 2927 - 2943
  • [30] Augmented Dynamic Skyline Query Processing Method Based on MapReduce
    Ding L.-L.
    Cui Z.-Q.
    Yin X.-K.
    Wang J.-L.
    Song B.-Y.
    Song, Bao-Yan (bysong@lnu.edu.cn), 2018, Chinese Institute of Electronics (46): : 1062 - 1070