• DocumentCode
    2730403
  • Title

    DeltaSky: Optimal Maintenance of Skyline Deletions without Exclusive Dominance Region Generation

  • Author

    Ping Wu ; Agrawal, Deepak ; Egecioglu, O. ; El Abbadi, Amr

  • Author_Institution
    Dept. of Comput. Sci., California Univ., Santa Barbara, CA, USA
  • fYear
    2007
  • fDate
    15-20 April 2007
  • Firstpage
    486
  • Lastpage
    495
  • Abstract
    This paper addresses the problem of efficient maintenance of a materialized skyline view in response to skyline removals. While there has been significant progress on skyline query computation, an equally important but largely unanswered issue is on the incremental maintenance for skyline deletions. Previous work suggested the use of the so called exclusive dominance region (EDR) to achieve optimal I/O performance for deletion maintenance. However, the shape of an EDR becomes extremely complex in higher dimensions, and algorithms for its computation have not been developed. We derive a systematic way to decompose a d-dimensional EDR into a collection of hyper-rectangles. We show that the number of such hyper-rectangles is O(md), where m is the current skyline result size. We then propose a novel algorithm DeltaSky which determines whether an intermediate R-tree MBR intersects with the EDR without explicitly calculating the EDR itself. This reduces the worse case complexity of the EDR intersection check from O(md) to O(md). Thus DeltaSky helps the branch and bound skyline algorithm achieve I/O optimality for deletion maintenance by finding only the newly appeared skyline points after the deletion. We discuss implementation issues and show that DeltaSky can be efficiently implemented using one extra B-Tree. Moreover, we propose two optimization techniques which further reduce the average cost in practice. Extensive experiments demonstrate that DeltaSky achieves orders of magnitude performance gain over alternative solutions.
  • Keywords
    query processing; software maintenance; trees (mathematics); B-Tree; DeltaSky algorithm; deletion maintenance; exclusive dominance region generation; hyperrectangles; materialized skyline view; skyline deletion; skyline query computation; skyline removal; Acceleration; Algorithm design and analysis; Computer science; Cost function; Database systems; Performance gain; Query processing; Shape;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering, 2007. ICDE 2007. IEEE 23rd International Conference on
  • Conference_Location
    Istanbul
  • Print_ISBN
    1-4244-0802-4
  • Type

    conf

  • DOI
    10.1109/ICDE.2007.367894
  • Filename
    4221697