Skip to main content
Log in

Efficient maximal reverse skyline query processing

  • Published:
GeoInformatica Aims and scope Submit manuscript

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14

Similar content being viewed by others

Notes

  1. The term point is used as opposed to ’range’ to express that we want to find SSRs that overlap with a query point and not a range.

References

  1. Amazon. http://www.amazon.com

  2. Banaei-Kashani F, Ghaemi P, Wilson JP (2014) Maximal reverse skyline query. In: ACMGIS

  3. Börzsönyi S, Kossmann D, Stocker K (2001) The skyline operator. In: ICDE

  4. Chazelle B (1986) Filtering search: a new approach to query-answering. SIAM J Comput 15:703–724

    Article  Google Scholar 

  5. Chomicki J, Godfrey P, Gryz J, Liang D (2003) Skyline with presorting. In: ICDE

  6. Cohon JL (1978) Multiobjective programming and planning. Mathematics in science and engineering, vol 140. Acad. Press, New York

    Google Scholar 

  7. Dellis E, Seeger B (2007) Efficient computation of reverse skyline queries. In: VLDB

  8. Dobkin DP, Kirkpatrick DG (1983) Fast detection of polyhedral intersection. Theor Comput Sci 27(3):241–253

    Article  Google Scholar 

  9. Du Y, Zhang D, Xia T (2005) The optimal location query. In: Proceedings of advances in spatial and temporal databases

  10. Farahani R, Hekmatfar M (2011) Facility location: concepts, models, algorithms and case studies. Contributions to management science. Physica-Verlag, HD

    Google Scholar 

  11. Farahani RZ, SteadieSeifi M, Asgari N (2010) Multiple criteria facility location problems: a survey. Appl Math Modell 34:1689–1709

    Article  Google Scholar 

  12. Ghaemi P, Shahabi K, Wilson JP, Banaei-Kashani F (2010) Optimal network location queries. In: ACMGIS

  13. Ghaemi P, Shahabi K, Wilson JP, Banaei-Kashani F (2012) Continuous maximal reverse nearest query on spatial networks. In: ACMGIS

  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:2

    Article  Google Scholar 

  15. Guttman A (1984) R-trees: a dynamic index structure for spatial searching, vol 14. ACM

  16. Hekmatfar M, SteadieSeifi M (2009) Multi-criteria location problem. Contributions to management science. Physica-Verlag, HD

    Google Scholar 

  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-Verlag

  18. Kossmann D, Ramsak F, Rost S (2002) Shooting stars in the sky: an online algorithm for skyline queries. In: VLDB

  19. Larichev O, Olson DL (2001) Multiple criteria analysis in strategic siting problems. Kluwer Academic Publishers

  20. Mount DM (2004) Geometric intersection. In: Handbook of discrete and computational geometry, chapter 38, pp 857–876

  21. Papadias D, Fu G, Chase JM, Seeger B (2005) Progressive skyline computation in database systems. ACM Trans Database Syst 30:2005

    Google Scholar 

  22. Szidarovszky F, Gershon M, Duckstein L (1986) Techniques for multiobjective decision making in systems management. Advances in industrial engineering. Elsevier

  23. Tan K, Eng P, Ooi BC (2001) Efficient progressive skyline computation. In: VLDB

  24. Wong RC, Ozsu MT, Yu PS, Fu AW, Liu L (2009) Efficient method for maximizing bichromatic reverse nearest neighbor. In: VLDB

  25. Xiao X, Yao B, Li F (2011) Optimal location queries in road network databases. In: ICDE

  26. Zhang J, Ku W-S, Sun M-T, Qin X, Lu H (2014) Multi-criteria optimal location query with overlapping voronoi diagrams. In: EDBT

  27. Zhou Z, Wu W, Li X, Lee M, Hsu W (2011) Maxfirst for maxbrknn. In: ICDE

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Farnoush Banaei-Kashani.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Banaei-Kashani, F., Ghaemi, P., Movaqar, B. et al. Efficient maximal reverse skyline query processing. Geoinformatica 21, 549–572 (2017). https://doi.org/10.1007/s10707-017-0302-5

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10707-017-0302-5

Keywords

Navigation