skip to main content
10.1145/1739041.1739112acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
research-article

Efficient computation of trade-off skylines

Published:22 March 2010Publication History

ABSTRACT

When selecting alternatives from large amounts of data, trade-offs play a vital role in everyday decision making. In databases this is primarily reflected by the top-k retrieval paradigm. But recently it has been convincingly argued that it is almost impossible for users to provide meaningful scoring functions for top-k retrieval, subsequently leading to the adoption of the skyline paradigm. Here users just specify the relevant attributes in a query and all suboptimal alternatives are filtered following the Pareto semantics. Up to now the intuitive concept of compensation, however, cannot be used in skyline queries, which also contributes to the often unmanageably large result set sizes. In this paper we discuss an innovative and efficient method for computing skylines allowing the use of qualitative trade-offs. Such trade-offs compare examples from the database on a focused subset of attributes. Thus, users can provide information on how much they are willing to sacrifice to gain an improvement in some other attribute(s). Our contribution is the design of the first skyline algorithm allowing for qualitative compensation across attributes. Moreover, we also provide an novel trade-off representation structure to speed up retrieval. Indeed our experiments show efficient performance allowing for focused skyline sets in practical applications. Moreover, we show that the necessary amount of object comparisons can be sped up by an order of magnitude using our indexing techniques.

References

  1. Balke, W.-T., Lofi, C., Güntzer, U. Incremental Trade-Off Management for Preference Based Queries, Int. Jour. of Computer Science & Applications (IJCSA), 4 (Jun. 2007).Google ScholarGoogle Scholar
  2. Balke, W.-T., Zheng, J., Güntzer, U. Approaching the Efficient Frontier: Cooperative Database Retrieval Using High-Dimensional Skylines, Conf. on Database Systems for Advanced Applications (DASFAA), Beijing, China, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. Börzsönyi, S., Kossmann, D., Stocker, K. The Skyline Operator. Int. Conf. on Data Engineering (ICDE), Heidelberg, Germany, 2001. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. Chan, C.-Y., Jagadish, H. V., Tan, K.-L., Tung, A. K. H., Zhang, Z. Finding k-dominant skylines in high dimensional space, Int. Conf. on Management of Data (SIGMOD), Chicago, IL, USA, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. Chan, C.-Y., Jagadish, H. V., Tan, K.-L., Tung, A. K. H., Zhang, Z. On High Dimensional Skylines, Advances in Database Technology (EDBT), Munich, Germany, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. Chomicki, J. Iterative Modification and Incremental Evaluation of Preference Queries. Int. Symp. on Found. of Inf. and Knowledge Systems (FoIKS), Budapest, Hungary, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. Godfrey, P. Skyline cardinality for relational processing. How many vectors are maximal? Int. Symp. on Foundations of Information and Knowledge Systems (FoIKS). Vienna, Austria, 2004.Google ScholarGoogle ScholarCross RefCross Ref
  8. Godfrey, P.; Shipley, R.; Gryz. J. Maximal Vector Computation in Large Data. Int. Conf. on Very Large Databases (VLDB), Trondheim, Norway, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Hansson, S. O. Preference Logic, Handbook of Philosophical Logic, Second Edition, 4 (2002)Google ScholarGoogle Scholar
  10. Ihab F. Ilyas and George Beskales and Mohamed A. Soliman. A Survey of Top-K Query Processing Techniques in Relational Database Systems, ACM Computing Surveys, 40--4 (2008) Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. Kossmann, D., Ramsak, F., Rost, S. Shooting Stars in the Sky: An Online Algorithm for Skyline Queries. Int. Conf. on Very Large Data Bases (VLDB), Hong Kong, China, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. Lacroix, M., Lavency., P., Preferences: Putting more Knowledge into Queries. Int. Conf. Very Large Databases (VLDB), Brighton, UK, 1987. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. Lee, J., You, G., Hwang, S. Telescope: Zooming to Interesting Skylines. Int. Conf. on Database Systems for Advanced Applications (DASFAA), Bangkok, Thailand, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. Lofi, C., Balke, W.-T., Güntzer, U. Efficiently Performing Consistency Checks for Multi-Dimensional Preference Trade-Offs, Int. Conf. on Research Challenges in Computer Science (RCIS), Marrakech, Morocco, 2008.Google ScholarGoogle ScholarCross RefCross Ref
  15. Papadias, D., Tao, Y., Fu, G., Seeger, B. An Optimal and Progressive Algorithm for Skyline Queries. Int. Conf. on Management of Data (SIGMOD), San Diego, USA, 2003. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. Pei, J., Jin, W., Ester, M., Tao, Y. Catching the best views of skyline: a semantic approach based on decisive subspaces. Int. Conf. on Very Large Data Bases, Trondheim, Norway, 2005 Google ScholarGoogle ScholarDigital LibraryDigital Library
  17. Yuan, Y., Lin, X., Liu, Q., Wang, W., Yu, J. Y., Zhang, Q., Efficient computation of the skyline cube, Int. Conf. on Very Large Data Bases, Trondheim, Norway, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Efficient computation of trade-off skylines

    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 Other conferences
      EDBT '10: Proceedings of the 13th International Conference on Extending Database Technology
      March 2010
      741 pages
      ISBN:9781605589459
      DOI:10.1145/1739041

      Copyright © 2010 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: 22 March 2010

      Permissions

      Request permissions about this article.

      Request Permissions

      Check for updates

      Qualifiers

      • research-article

      Acceptance Rates

      Overall Acceptance Rate7of10submissions,70%

    PDF Format

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader