English

Skyline Queries in O(1) time?

Databases 2017-09-13 v1

Abstract

The skyline of a set PP of points (SKY(P)SKY(P)) consists of the "best" points with respect to minimization or maximization of the attribute values. A point pp dominates another point qq if pp is as good as qq in all dimensions and it is strictly better than qq in at least one dimension. In this work, we focus on the static 22-d space and provide expected performance guarantees for 33-sided Range Skyline Queries on the Grid, where NN is the cardinality of PP, BB the size of a disk block, and RR the capacity of main memory. We present the MLR-tree, which offers optimal expected cost for finding planar skyline points in a 33-sided query rectangle, q=[a,b]×(,d]q=[a,b]\times(-\infty,d], in both RAM and I/O model on the grid [1,M]×[1,M][1,M]\times [1,M], by single scanning only the points contained in SKY(P)SKY(P). In particular, it supports skyline queries in a 33-sided range in O(ttPAM(N))O(t\cdot t_{PAM}(N)) time (O((t/B)tPAM(N))O((t/B)\cdot t_{PAM}(N)) I/Os), where tt is the answer size and tPAM(N)t_{PAM}(N) the time required for answering predecessor queries for dd in a PAM (Predecessor Access Method) structure, which is a special component of MLR-tree and stores efficiently root-to-leaf paths or sub-paths. By choosing PAM structures with O(1)O(1) expected time for predecessor queries under discrete μ\mu-random distributions of the xx and yy coordinates, MLR-tree supports skyline queries in optimal O(t)O(t) expected time (O(t/B)O(t/B) expected number of I/Os) with high probability. The space cost becomes superlinear and can be reduced to linear for many special practical cases. If we choose a PAM structure with O(1)O(1) amortized time for batched predecessor queries (under no assumption on distributions of the xx and yy coordinates), MLR-tree supports batched skyline queries in optimal O(t)O(t) amortized time, however the space becomes exponential. In dynamic case, the update time complexity is affected by a O(log2N)O(log^{2}N) factor.

Cite

@article{arxiv.1709.03949,
  title  = {Skyline Queries in O(1) time?},
  author = {Spyros Sioutas and Kostas Tsichlas and Andreas Kosmatopoulos and Apostolos N. Papadopoulos and Dimitrios Tsoumakos and Katerina Doka},
  journal= {arXiv preprint arXiv:1709.03949},
  year   = {2017}
}

Comments

22 pages

R2 v1 2026-06-22T21:40:42.484Z