skip to main content
10.1145/1066157.1066181acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
Article

Stratified computation of skylines with partially-ordered domains

Published: 14 June 2005 Publication History

Abstract

In this paper, we study the evaluation of skyline queries with partially-ordered attributes. Because such attributes lack a total ordering, traditional index-based evaluation algorithms (e.g., NN and BBS) that are designed for totally-ordered attributes can no longer prune the space as effectively. Our solution is to transform each partially-ordered attribute into a two-integer domain that allows us to exploit index-based algorithms to compute skyline queries on the transformed space. Based on this framework, we propose three novel algorithms: BBS+ is a straightforward adaptation of BBS using the framework, and SDC (Stratification by Dominance Classification) and SDC+ are optimized to handle false positives and support progressive evaluation. Both SDC and SDC+ exploit a dominance relationship to organize the data into strata. While SDC generates its strata at run time, SDC+ partitions the data into strata offline. We also design two dominance classification strategies (MinPC and MaxPC) to further optimize the performance of SDC and SDC+. We implemented the proposed schemes and evaluated their efficiency. Our results show that our proposed techniques outperform existing approaches by a wide margin, with SDC+-MinPC giving the best performance in terms of both response time as well as progressiveness. To the best of our knowledge, this is the first paper to address the problem of skyline query evaluation involving partially-ordered attribute domains.

References

[1]
R. Agrawal, A. Borgida, and H. V. Jagadish. Efficient management of transitive relationships in large data and knowledge bases. In SIGMOD'89
[2]
R. Agrawal and E. Wimmers. A framework for expressing and combining preferences. In SIGMOD'00.
[3]
W. Balke, U. Güntzer, and X. Zheng. Efficient distributed skylining for web information systems. In EDBT'04.
[4]
S. Börzsönyi, D. Kossmann, and K. Stocker. The skyline operator. In ICDE'01.
[5]
M. Carey and D. Kossmann. On saying "enough already!" in SQL. In SIGMOD'97
[6]
J. Chomicki. Querying with intrinsic preferences. In EDBT'02.
[7]
J. Chomicki. Preference formulas in relational queries. ACM TODS, 24(4), 2003.
[8]
V. Hristidis, N. Koudas, and Y. Papakonstantinou. PREFER: a system for the efficient execution of multi-parametric ranked queries. In SIGMOD'01.
[9]
W. Kießling. Foundations of preferences in database systems. In VLDB'02.
[10]
W. Kießling and G. Köstler. Preference SQL - design, implementation, experiences. In VLDB'02.
[11]
D. Kossmann, F. Ramsak, and S. Rost. Shooting stars in the sky: an online algorithm for skyline queries. In VLDB'02.
[12]
H. Kung, F. Luccio, and F. Preparata. On finding the maxima of a set of vectors. JACM, 22(4), 1975.
[13]
J. Matousek. Computing dominances in En. Information Processing Letters, 38(5):277--278, 1991.
[14]
D. Papadias, Y. Tao, G. Fu, and B. Seeger. An optimal and progressive algorithm for skyline queries. In SIGMOD'03.
[15]
C. H. Papadimitriou and M. Yannakakis. Multiobjective query optimization. In PODS'01.
[16]
F. P. Preparata and M. I. Shamos. Computational Geometry: An Introduction. Springer-Verlag, 1985.
[17]
I. Stojmenovic and M. Miyakawa. An optimal parallel algorithm for solving the maximal elements problem in the plane. Parallel Computing, 7(2), June 1988.
[18]
K. L. Tan, P. K. Eng, and B. C. Ooi. Efficient progressive skyline computation. In VLDB'01.
[19]
R. Torlone and P. Ciaccia. Which are my preferred items? In Workshop on Recommendation and Personalization in E-Commerce, May 2002.
[20]
Y. Zibin and J. Y. Gil. Efficient subtyping tests with PQ-encoding. In OOPSLA'01.

Cited By

View all
  • (2023)Crowd-enabled multiple Pareto-optimal queries for multi-criteria decision-making servicesFuture Generation Computer Systems10.1016/j.future.2023.06.007148(342-356)Online publication date: Nov-2023
  • (2023)Collaborative Filtering Skyline (CFS) for Enhanced Recommender SystemsHandbook of Computational Sciences10.1002/9781119763468.ch3(37-67)Online publication date: 14-Jul-2023
  • (2022)Research on SCADA system security reinforcement method based on distributed Pareto algorithmJournal of Computational Methods in Sciences and Engineering10.3233/JCM-21591022:2(697-709)Online publication date: 28-Mar-2022
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data
June 2005
990 pages
ISBN:1595930604
DOI:10.1145/1066157
  • Conference Chair:
  • Fatma Ozcan
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 14 June 2005

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Article

Conference

SIGMOD/PODS05
Sponsor:

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)5
  • Downloads (Last 6 weeks)1
Reflects downloads up to 17 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (2023)Crowd-enabled multiple Pareto-optimal queries for multi-criteria decision-making servicesFuture Generation Computer Systems10.1016/j.future.2023.06.007148(342-356)Online publication date: Nov-2023
  • (2023)Collaborative Filtering Skyline (CFS) for Enhanced Recommender SystemsHandbook of Computational Sciences10.1002/9781119763468.ch3(37-67)Online publication date: 14-Jul-2023
  • (2022)Research on SCADA system security reinforcement method based on distributed Pareto algorithmJournal of Computational Methods in Sciences and Engineering10.3233/JCM-21591022:2(697-709)Online publication date: 28-Mar-2022
  • (2021)A Partitioning Approach for Skyline Queries in Presence of Partial and Dynamic OrdersTransactions on Large-Scale Data- and Knowledge-Centered Systems XLIX10.1007/978-3-662-64148-4_3(70-96)Online publication date: 1-Sep-2021
  • (2018)Skyline Queries and Pareto OptimalityEncyclopedia of Database Systems10.1007/978-1-4614-8265-9_80684(3508-3512)Online publication date: 7-Dec-2018
  • (2017)An Efficient Indexing Method for Skyline Computations with Partially Ordered DomainsIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2017.265690629:5(963-976)Online publication date: 1-May-2017
  • (2017)Parallel Skyline Computation for Partially Ordered Domains2017 IEEE International Symposium on Parallel and Distributed Processing with Applications and 2017 IEEE International Conference on Ubiquitous Computing and Communications (ISPA/IUCC)10.1109/ISPA/IUCC.2017.00109(699-706)Online publication date: Dec-2017
  • (2017)An efficient approach to finding potential products continuouslyInformation Systems10.1016/j.is.2016.10.00365:C(22-35)Online publication date: 1-Apr-2017
  • (2017)Exploring correlation for fast skyline computationThe Journal of Supercomputing10.1007/s11227-017-2064-073:11(5071-5102)Online publication date: 1-Nov-2017
  • (2016)Finding desirable objects under group categorical preferencesKnowledge and Information Systems10.1007/s10115-015-0886-849:1(273-313)Online publication date: 1-Oct-2016
  • Show More Cited By

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media