skip to main content
10.1145/1620432.1620473acmconferencesArticle/Chapter ViewAbstractPublication PagesideasConference Proceedingsconference-collections
research-article

Evaluation of skyline algorithms in PostgreSQL

Published: 16 September 2009 Publication History

Abstract

In this paper, we present our work on evaluating the skyline algorithms BNL, SFS, and a variant of LESS in PostgreSQL. It is well known that the performance of skyline queries is sensitive to a number of parameters. From extensive experiments on skyline implementations we have discovered several rules, which are remarkably simple and useful, but hard to obtain from theoretical investigation. Our findings are beneficial for developing heuristics for the skyline query optimization, and in the meantime, provide some insight for a deeper understanding of the skyline query characteristics.

References

[1]
S. Börzsönyi, D. Kossmann, and K. Stocker. The skyline operator. In 17th International Conference on Data Engineering (ICDE' 01), pages 421--432, Heidelberg, Germany, 2001. IEEE.
[2]
S. Chaudhuri, N. Dalvi, and R. Kaushik. Robust cardinality and cost estimation for skyline operator. In ICDE '06: Proceedings of the 22nd International Conference on Data Engineering (ICDE'06), page 64, Washington, DC, USA, 2006. IEEE Computer Society.
[3]
J. Chomicki, P. Godfrey, J. Gryz, and D. Liang. Skyline with presorting. In U. Dayal, K. Ramamritham, and T. M. Vijayaraman, editors, ICDE, pages 717--816. IEEE Computer Society, 2003.
[4]
H. Eder. Random dataset generator for skyline operator evaluation. http://randdataset.projects.postgresql.org/, 2007.
[5]
P. Godfrey, R. Shipley, and J. Gryz. Maximal vector computation in large data sets. In K. Böhm, C. S. Jensen, L. M. Haas, M. L. Kersten, P.-Å. Larson, and B. C. Ooi, editors, VLDB, pages 229--240. ACM, 2005.
[6]
P. Godfrey, R. Shipley, and J. Gryz. Algorithms and analyses for maximal vector computation. VLDB J., 16(1):5--28, 2007.
[7]
D. Kossmann, F. Ramsak, and S. Rost. Shooting stars in the sky: An online algorithm for skyline queries. In VLDB, pages 275--286. Morgan Kaufmann, 2002.
[8]
D. Papadias, Y. Tao, G. Fu, and B. Seeger. An optimal and progressive algorithm for skyline queries. In A. Y. Halevy, Z. G. Ives, and A. Doan, editors, SIGMOD Conference, pages 467--478. ACM, 2003.
[9]
D. Papadias, Y. Tao, G. Fu, and B. Seeger. Progressive skyline computation in database systems. ACM Trans. Database Syst., 30(1):41--82, 2005.
[10]
K.-L. Tan, P.-K. Eng, and B. C. Ooi. Efficient progressive skyline computation. In P. M. G. Apers, P. Atzeni, S. Ceri, S. Paraboschi, K. Ramamohanarao, and R. T. Snodgrass, editors, VLDB, pages 301--310. Morgan Kaufmann, 2001.

Cited By

View all
  • (2023)Efficient and Effective Cardinality Estimation for Skyline FamilyProceedings of the ACM on Management of Data10.1145/35889581:1(1-21)Online publication date: 30-May-2023
  • (2017)Multidimensional skyline analysis based on agree concept latticesIntelligent Data Analysis10.3233/IDA-16311121:5(1245-1265)Online publication date: 10-Oct-2017
  • (2016)Si2pProceedings of the VLDB Endowment10.14778/3007263.30072969:13(1509-1512)Online publication date: 1-Sep-2016
  • Show More Cited By

Index Terms

  1. Evaluation of skyline algorithms in PostgreSQL

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    IDEAS '09: Proceedings of the 2009 International Database Engineering & Applications Symposium
    September 2009
    347 pages
    ISBN:9781605584027
    DOI:10.1145/1620432
    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: 16 September 2009

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. PostgreSQL
    2. skyline

    Qualifiers

    • Research-article

    Conference

    IDEAS '09
    Sponsor:
    • ACM
    • Concordia University

    Acceptance Rates

    Overall Acceptance Rate 74 of 210 submissions, 35%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

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

    Other Metrics

    Citations

    Cited By

    View all
    • (2023)Efficient and Effective Cardinality Estimation for Skyline FamilyProceedings of the ACM on Management of Data10.1145/35889581:1(1-21)Online publication date: 30-May-2023
    • (2017)Multidimensional skyline analysis based on agree concept latticesIntelligent Data Analysis10.3233/IDA-16311121:5(1245-1265)Online publication date: 10-Oct-2017
    • (2016)Si2pProceedings of the VLDB Endowment10.14778/3007263.30072969:13(1509-1512)Online publication date: 1-Sep-2016
    • (2015)Scalable parallelization of skyline computation for multi-core processors2015 IEEE 31st International Conference on Data Engineering10.1109/ICDE.2015.7113358(1083-1094)Online publication date: Apr-2015
    • (2011)A clustering based approach for skyline diversityExpert Systems with Applications: An International Journal10.1016/j.eswa.2010.12.10438:7(7984-7993)Online publication date: 1-Jul-2011

    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