, Volume 21, Issue 3, pp 549–572 | Cite as

Efficient maximal reverse skyline query processing

  • Farnoush Banaei-KashaniEmail author
  • Parisa Ghaemi
  • Bahman Movaqar
  • Seyed Jalal Kazemitabar


Given a set S of sites and a set O of objects in a metric space, the Optimal Location (OL) problem is about computing a location in the space where introducing a new site (e.g., a retail store) maximizes the number of the objects (e.g., customers) that would choose the new site as their “preferred” site among all sites. However, the existing solutions for the optimal location problem assume that there is only one criterion to determine the preferred site for each object, whereas with numerous real-world applications multiple criteria are used as preference measures. For example, while a single criterion solution might consider the metric distance between the customers and the retail store as the preference measure, a multi-criteria solution might consider the annual membership cost as well as the distance to the retail store to find an optimal location. In this paper, for the first time we develop an efficient and exact solution for the so-called Multi-Criteria Optimal Location (MCOL) problem that can scale with large datasets. Toward that end, first we formalize the MCOL problem as maximal reverse skyline query (MaxRSKY). Given a set of sites and a set of objects in a d-dimensional space, MaxRSKY query returns a location in the space where if a new site s is introduced, the size of the (bichromatic) reverse skyline set of s is maximal. To the best of our knowledge, this paper is the first to define and study MaxRSKY query. Accordingly, we propose a filter-based solution, termed EF-MaxRSKY, that effectively prunes the search space for efficient identification of the optimal location. Our extensive empirical analysis with both real and synthetic datasets show that EF-MaxRSKY is invariably efficient in computing answers for MaxRSKY queries with large datasets containing thousands of sites and objects.


Maximal reverse skyline Multi-criteria optimal location 


  1. 1.
  2. 2.
    Banaei-Kashani F, Ghaemi P, Wilson JP (2014) Maximal reverse skyline query. In: ACMGISGoogle Scholar
  3. 3.
    Börzsönyi S, Kossmann D, Stocker K (2001) The skyline operator. In: ICDEGoogle Scholar
  4. 4.
    Chazelle B (1986) Filtering search: a new approach to query-answering. SIAM J Comput 15:703–724CrossRefGoogle Scholar
  5. 5.
    Chomicki J, Godfrey P, Gryz J, Liang D (2003) Skyline with presorting. In: ICDEGoogle Scholar
  6. 6.
    Cohon JL (1978) Multiobjective programming and planning. Mathematics in science and engineering, vol 140. Acad. Press, New YorkGoogle Scholar
  7. 7.
    Dellis E, Seeger B (2007) Efficient computation of reverse skyline queries. In: VLDBGoogle Scholar
  8. 8.
    Dobkin DP, Kirkpatrick DG (1983) Fast detection of polyhedral intersection. Theor Comput Sci 27(3):241–253CrossRefGoogle Scholar
  9. 9.
    Du Y, Zhang D, Xia T (2005) The optimal location query. In: Proceedings of advances in spatial and temporal databasesGoogle Scholar
  10. 10.
    Farahani R, Hekmatfar M (2011) Facility location: concepts, models, algorithms and case studies. Contributions to management science. Physica-Verlag, HDGoogle Scholar
  11. 11.
    Farahani RZ, SteadieSeifi M, Asgari N (2010) Multiple criteria facility location problems: a survey. Appl Math Modell 34:1689–1709CrossRefGoogle Scholar
  12. 12.
    Ghaemi P, Shahabi K, Wilson JP, Banaei-Kashani F (2010) Optimal network location queries. In: ACMGISGoogle Scholar
  13. 13.
    Ghaemi P, Shahabi K, Wilson JP, Banaei-Kashani F (2012) Continuous maximal reverse nearest query on spatial networks. In: ACMGISGoogle Scholar
  14. 14.
    Ghaemi P, Shahabi K, Wilson JP, Banaei-Kashani F (2014) A comparative study of two approaches for supporting optimal network location queries. GeoInformatica 18:2CrossRefGoogle Scholar
  15. 15.
    Guttman A (1984) R-trees: a dynamic index structure for spatial searching, vol 14. ACMGoogle Scholar
  16. 16.
    Hekmatfar M, SteadieSeifi M (2009) Multi-criteria location problem. Contributions to management science. Physica-Verlag, HDGoogle Scholar
  17. 17.
    Hwang C, Masud A (1979) Multiple objective decision making, methods and applications: a state-of-the-art survey. Lecture notes in economics and mathematical systems. Springer-VerlagGoogle Scholar
  18. 18.
    Kossmann D, Ramsak F, Rost S (2002) Shooting stars in the sky: an online algorithm for skyline queries. In: VLDBGoogle Scholar
  19. 19.
    Larichev O, Olson DL (2001) Multiple criteria analysis in strategic siting problems. Kluwer Academic PublishersGoogle Scholar
  20. 20.
    Mount DM (2004) Geometric intersection. In: Handbook of discrete and computational geometry, chapter 38, pp 857–876Google Scholar
  21. 21.
    Papadias D, Fu G, Chase JM, Seeger B (2005) Progressive skyline computation in database systems. ACM Trans Database Syst 30:2005Google Scholar
  22. 22.
    Szidarovszky F, Gershon M, Duckstein L (1986) Techniques for multiobjective decision making in systems management. Advances in industrial engineering. ElsevierGoogle Scholar
  23. 23.
    Tan K, Eng P, Ooi BC (2001) Efficient progressive skyline computation. In: VLDBGoogle Scholar
  24. 24.
    Wong RC, Ozsu MT, Yu PS, Fu AW, Liu L (2009) Efficient method for maximizing bichromatic reverse nearest neighbor. In: VLDBGoogle Scholar
  25. 25.
    Xiao X, Yao B, Li F (2011) Optimal location queries in road network databases. In: ICDEGoogle Scholar
  26. 26.
    Zhang J, Ku W-S, Sun M-T, Qin X, Lu H (2014) Multi-criteria optimal location query with overlapping voronoi diagrams. In: EDBTGoogle Scholar
  27. 27.
    Zhou Z, Wu W, Li X, Lee M, Hsu W (2011) Maxfirst for maxbrknn. In: ICDEGoogle Scholar

Copyright information

© Springer Science+Business Media New York 2017

Authors and Affiliations

  • Farnoush Banaei-Kashani
    • 1
    Email author
  • Parisa Ghaemi
    • 2
  • Bahman Movaqar
    • 3
  • Seyed Jalal Kazemitabar
    • 2
  1. 1.University of Colorado DenverDenverUSA
  2. 2.University of Southern CaliforniaLos AngelesUSA
  3. 3.University of AhvazAhvazIran

Personalised recommendations