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

      Recommendations

      Comments

      Login options

      Check if you have access through your login credentials or your institution to get full access on this article.

      Sign in
      • 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

        Copyright © 2005 ACM

        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]

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 14 June 2005

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • Article

        Acceptance Rates

        Overall Acceptance Rate785of4,003submissions,20%

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader