Skip to main content
Erschienen in: The VLDB Journal 3/2022

11.10.2021 | Regular Paper

Continuous monitoring of moving skyline and top-k queries

verfasst von: Arif Hidayat, Muhammad Aamir Cheema, Xuemin Lin, Wenjie Zhang, Ying Zhang

Erschienen in: The VLDB Journal | Ausgabe 3/2022

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

Given a set of criteria, an object o dominates another object \(o'\) if o is more preferable than \(o'\) according to every criterion. A skyline query returns every object that is not dominated by any other object. A top-k query returns k most preferred objects according to a given scoring function. In this paper, we study the problem of continuously monitoring moving skyline queries and moving top-k queries where one of the criteria is the distance between the objects and the moving query. We propose safe zone-based techniques to address the challenge of efficiently updating the results as the query moves. A safe zone is the area such that the results of a query remain unchanged as long as the query lies inside this area. Hence, the results are required to be updated only when the query leaves its safe zone. We present several non-trivial optimizations and propose an efficient algorithm for safe zone construction for both the skyline queries and top-k queries. Our techniques for the moving top-k queries are generic in the sense that these are immediately applicable to any top-k query as long as its scoring function is monotonic. Furthermore, we show that the proposed techniques can also be extended to monitor various other queries for different distance metrics. Our experiments demonstrate that the cost of our techniques is reasonably close to a lower bound cost and is several orders of magnitude lower than the cost of a naïve algorithm.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat Abeywickrama, T., Cheema, M.A., Khan, A.: K-SPIN: efficiently processing spatial keyword queries on road networks. IEEE TKDE 32, 983–997 (2019) Abeywickrama, T., Cheema, M.A., Khan, A.: K-SPIN: efficiently processing spatial keyword queries on road networks. IEEE TKDE 32, 983–997 (2019)
2.
Zurück zum Zitat Abrishamchi, A., Ebrahimian, A., Tajrishi, M., Mariño, M.A.: Case study: application of multicriteria decision making to urban water supply. J. Water Resour. Plan. Manag. 131, 326–335 (2005)CrossRef Abrishamchi, A., Ebrahimian, A., Tajrishi, M., Mariño, M.A.: Case study: application of multicriteria decision making to urban water supply. J. Water Resour. Plan. Manag. 131, 326–335 (2005)CrossRef
3.
Zurück zum Zitat Adriyendi, M.: Multi-attribute decision making using simple additive weighting and weighted product in food choice (2015) Adriyendi, M.: Multi-attribute decision making using simple additive weighting and weighted product in food choice (2015)
4.
Zurück zum Zitat Aurenhammer, F., Edelsbrunner, H.: An optimal algorithm for constructing the weighted voronoi diagram in the plane. Pattern Recognit. 17(2), 251–257 (1984)MathSciNetCrossRef Aurenhammer, F., Edelsbrunner, H.: An optimal algorithm for constructing the weighted voronoi diagram in the plane. Pattern Recognit. 17(2), 251–257 (1984)MathSciNetCrossRef
5.
Zurück zum Zitat Beliakov, G., Pradera, A., Calvo, T., et al.: Aggregation Functions: A Guide for Practitioners, vol. 221. Springer, Heidelberg Beliakov, G., Pradera, A., Calvo, T., et al.: Aggregation Functions: A Guide for Practitioners, vol. 221. Springer, Heidelberg
6.
Zurück zum Zitat Bohm, C., Ooi, B.C., Plant, C., Yan, Y.: Efficiently processing continuous k-NN queries on data streams. In: ICDE, pp. 156–165 (2007) Bohm, C., Ooi, B.C., Plant, C., Yan, Y.: Efficiently processing continuous k-NN queries on data streams. In: ICDE, pp. 156–165 (2007)
7.
Zurück zum Zitat Börzsönyi, S., Kossmann, D., Stocker, K.: The skyline operator. In: ICDE, pp. 421–430 (2001) Börzsönyi, S., Kossmann, D., Stocker, K.: The skyline operator. In: ICDE, pp. 421–430 (2001)
8.
Zurück zum Zitat Brinkhoff, T.: A framework for generating network-based moving objects. GeoInformatica 6(2), 153–180 (2002)CrossRef Brinkhoff, T.: A framework for generating network-based moving objects. GeoInformatica 6(2), 153–180 (2002)CrossRef
9.
Zurück zum Zitat Cheema, M.A., Brankovic, L., Lin, X., Zhang, W., Wang, W.: Continuous monitoring of distance-based range queries. IEEE TKDE 23(8), 1182–1199 (2010) Cheema, M.A., Brankovic, L., Lin, X., Zhang, W., Wang, W.: Continuous monitoring of distance-based range queries. IEEE TKDE 23(8), 1182–1199 (2010)
10.
Zurück zum Zitat Cheema, M.A., Brankovic, L., Lin, X., Zhang, W., Wang, W.: Multi-guarded safe zone: an effective technique to monitor moving circular range queries. In: ICDE (2010) Cheema, M.A., Brankovic, L., Lin, X., Zhang, W., Wang, W.: Multi-guarded safe zone: an effective technique to monitor moving circular range queries. In: ICDE (2010)
11.
Zurück zum Zitat Cheema, M.A., Lin, X., Zhang, W., Zhang, Y.: A safe zone based approach for monitoring moving skyline queries. In: EDBT, pp. 275–286 (2013) Cheema, M.A., Lin, X., Zhang, W., Zhang, Y.: A safe zone based approach for monitoring moving skyline queries. In: EDBT, pp. 275–286 (2013)
12.
Zurück zum Zitat Cheema, M.A., Shen, Z., Lin, X., Zhang, W.: A unified framework for efficiently processing ranking related queries. In: EDBT, pp. 427–438 (2014) Cheema, M.A., Shen, Z., Lin, X., Zhang, W.: A unified framework for efficiently processing ranking related queries. In: EDBT, pp. 427–438 (2014)
13.
Zurück zum Zitat Chen, J., Zheng, J., Jiang, S., Qiu, X.: Distance-based continuous skylines on geo-textual data. In: Asia-Pacific Web Conference, pp. 228–240. Springer (2016) Chen, J., Zheng, J., Jiang, S., Qiu, X.: Distance-based continuous skylines on geo-textual data. In: Asia-Pacific Web Conference, pp. 228–240. Springer (2016)
14.
Zurück zum Zitat Cong, G., Jensen, C.S., Wu, D.: Efficient retrieval of the top-k most relevant spatial web objects. PVLDB 2(1), 337–348 (2009) Cong, G., Jensen, C.S., Wu, D.: Efficient retrieval of the top-k most relevant spatial web objects. PVLDB 2(1), 337–348 (2009)
15.
Zurück zum Zitat Fu, X., Miao, X., Xu, J., Gao, Y.: Continuous range-based skyline queries in road networks. World Wide Web 20(6), 1443–1467 (2017)CrossRef Fu, X., Miao, X., Xu, J., Gao, Y.: Continuous range-based skyline queries in road networks. World Wide Web 20(6), 1443–1467 (2017)CrossRef
16.
Zurück zum Zitat Hsueh, Y., Zimmermann, R., Ku, W.: Efficient updates for continuous skyline computations. In: DEXA (2008) Hsueh, Y., Zimmermann, R., Ku, W.: Efficient updates for continuous skyline computations. In: DEXA (2008)
18.
Zurück zum Zitat Huang, W., Li, G., Tan, K.L., Feng, J.: Efficient safe-region construction for moving top-k spatial keyword queries. In: CIKM, pp. 932–941 (2012) Huang, W., Li, G., Tan, K.L., Feng, J.: Efficient safe-region construction for moving top-k spatial keyword queries. In: CIKM, pp. 932–941 (2012)
19.
Zurück zum Zitat Huang, Z., Lu, H., Ooi, B.C., Tung, A.K.H.: Continuous skyline queries for moving objects. TKDE 18, 1645–1658 (2006) Huang, Z., Lu, H., Ooi, B.C., Tung, A.K.H.: Continuous skyline queries for moving objects. TKDE 18, 1645–1658 (2006)
20.
Zurück zum Zitat Ilyas, I.F., Beskales, G., Soliman, M.A.: A survey of top-k query processing techniques in relational database systems. ACM Comput. Surv. 40(4), 11:1–11:58 (2008) Ilyas, I.F., Beskales, G., Soliman, M.A.: A survey of top-k query processing techniques in relational database systems. ACM Comput. Surv. 40(4), 11:1–11:58 (2008)
21.
Zurück zum Zitat Kang, J.M., Mokbel, M.F., Shekhar, S., Xia, T., Zhang, D.: Continuous evaluation of monochromatic and bichromatic reverse nearest neighbors. In: ICDE (2007) Kang, J.M., Mokbel, M.F., Shekhar, S., Xia, T., Zhang, D.: Continuous evaluation of monochromatic and bichromatic reverse nearest neighbors. In: ICDE (2007)
22.
Zurück zum Zitat Kossmann, D., Ramsak, F., Rost, S.: Shooting stars in the sky: an online algorithm for skyline queries. In: VLDB, pp. 275–286 (2002) Kossmann, D., Ramsak, F., Rost, S.: Shooting stars in the sky: an online algorithm for skyline queries. In: VLDB, pp. 275–286 (2002)
23.
Zurück zum Zitat Lai, C.C., Akbar, Z.F., Liu, C.M., Ta, V.D., Wang, L.C.: Distributed continuous range-skyline query monitoring over the internet of mobile things. IEEE Internet Things J. 6, 6652–6667 (2019)CrossRef Lai, C.C., Akbar, Z.F., Liu, C.M., Ta, V.D., Wang, L.C.: Distributed continuous range-skyline query monitoring over the internet of mobile things. IEEE Internet Things J. 6, 6652–6667 (2019)CrossRef
24.
Zurück zum Zitat Lee, M.W., won Hwang, S.: Continuous skylining on volatile moving data. In: ICDE, pp. 1568–1575 (2009) Lee, M.W., won Hwang, S.: Continuous skylining on volatile moving data. In: ICDE, pp. 1568–1575 (2009)
25.
Zurück zum Zitat Li, H., Yoo, J.: An efficient scheme for continuous skyline query processing over dynamic data set. In: BIGCOMP, pp. 54–59 (2014) Li, H., Yoo, J.: An efficient scheme for continuous skyline query processing over dynamic data set. In: BIGCOMP, pp. 54–59 (2014)
26.
Zurück zum Zitat Lin, X., Yuan, Y., Wang, W., Lu, H.: Stabbing the sky: efficient skyline computation over sliding windows. In: ICDE, pp. 502–513 (2005) Lin, X., Yuan, Y., Wang, W., Lu, H.: Stabbing the sky: efficient skyline computation over sliding windows. In: ICDE, pp. 502–513 (2005)
27.
Zurück zum Zitat Liu, J., Yang, J., Xiong, L., Pei, J., Luo, J.: Skyline diagram: finding the voronoi counterpart for skyline queries. In: ICDE, pp. 653–664 (2018) Liu, J., Yang, J., Xiong, L., Pei, J., Luo, J.: Skyline diagram: finding the voronoi counterpart for skyline queries. In: ICDE, pp. 653–664 (2018)
28.
Zurück zum Zitat Lu, H., Zhou, Y., Haustad, J.: Continuous skyline monitoring over distributed data streams. In: SSDBM (2010) Lu, H., Zhou, Y., Haustad, J.: Continuous skyline monitoring over distributed data streams. In: SSDBM (2010)
29.
Zurück zum Zitat Mateo, J.R.S.C.: Weighted sum method and weighted product method. In: Multi criteria analysis in the renewable energy industry, pp. 19–22. Springer (2012) Mateo, J.R.S.C.: Weighted sum method and weighted product method. In: Multi criteria analysis in the renewable energy industry, pp. 19–22. Springer (2012)
30.
Zurück zum Zitat Mouratidis, K., Bakiras, S., Papadias, D.: Continuous monitoring of top-k queries over sliding windows. In: ACM SIGMOD (2006) Mouratidis, K., Bakiras, S., Papadias, D.: Continuous monitoring of top-k queries over sliding windows. In: ACM SIGMOD (2006)
31.
Zurück zum Zitat Nutanong, S., Zhang, R., Tanin, E., Kulik, L.: The v*-diagram: a query-dependent approach to moving knn queries. PVLDB 1, 1095–1106 (2008) Nutanong, S., Zhang, R., Tanin, E., Kulik, L.: The v*-diagram: a query-dependent approach to moving knn queries. PVLDB 1, 1095–1106 (2008)
32.
Zurück zum Zitat Okabe, A., Boots, B., Sugihara, K., Chiu, S.N.: Spatial Tessellations: Concepts and Applications of Voronoi Diagrams. Wiley, Hoboken (1999)MATH Okabe, A., Boots, B., Sugihara, K., Chiu, S.N.: Spatial Tessellations: Concepts and Applications of Voronoi Diagrams. Wiley, Hoboken (1999)MATH
33.
Zurück zum Zitat Papadias, D., Tao, Y., Fu, G., Seeger, B.: An optimal and progressive algorithm for skyline queries. In: SIGMOD (2003) Papadias, D., Tao, Y., Fu, G., Seeger, B.: An optimal and progressive algorithm for skyline queries. In: SIGMOD (2003)
34.
Zurück zum Zitat Papapetrou, O., Garofalakis, M.: Monitoring distributed fragmented skylines. DAPD 36(4), 675–715 (2018) Papapetrou, O., Garofalakis, M.: Monitoring distributed fragmented skylines. DAPD 36(4), 675–715 (2018)
35.
Zurück zum Zitat Qi, J., Zhang, R., Jensen, C.S., Ramamohanarao, K., He, J.: Continuous spatial query processing: a survey of safe region based techniques. ACM Comput. Surv. (CSUR) 51(3), 64 (2018) Qi, J., Zhang, R., Jensen, C.S., Ramamohanarao, K., He, J.: Continuous spatial query processing: a survey of safe region based techniques. ACM Comput. Surv. (CSUR) 51(3), 64 (2018)
36.
Zurück zum Zitat Shen, Z., Cheema, M.A., Lin, X.: Loyalty-based selection: retrieving objects that persistently satisfy criteria. In: CIKM, pp. 2189–2193 (2012) Shen, Z., Cheema, M.A., Lin, X.: Loyalty-based selection: retrieving objects that persistently satisfy criteria. In: CIKM, pp. 2189–2193 (2012)
37.
Zurück zum Zitat Shen, Z., Cheema, M.A., Lin, X., Zhang, W., Wang, H.: Efficiently monitoring top-k pairs over sliding windows. In: ICDE, pp. 798–809 (2012) Shen, Z., Cheema, M.A., Lin, X., Zhang, W., Wang, H.: Efficiently monitoring top-k pairs over sliding windows. In: ICDE, pp. 798–809 (2012)
38.
Zurück zum Zitat Shen, Z., Cheema, M.A., Lin, X., Zhang, W., Wang, H.: A generic framework for top-k pairs and top-k objects queries over sliding windows. IEEE TKDE 26, 1349–1366 (2014) Shen, Z., Cheema, M.A., Lin, X., Zhang, W., Wang, H.: A generic framework for top-k pairs and top-k objects queries over sliding windows. IEEE TKDE 26, 1349–1366 (2014)
39.
Zurück zum Zitat Shi, C., Qin, X., Wang, L.: Continuous skyline queries for moving objects in road networks. J. Softw. 10, 190–200 (2015)CrossRef Shi, C., Qin, X., Wang, L.: Continuous skyline queries for moving objects in road networks. J. Softw. 10, 190–200 (2015)CrossRef
40.
Zurück zum Zitat Tan, K.L., Eng, P.K., Ooi, B.C.: Efficient progressive skyline computation. In: VLDB, pp. 301–310 (2001) Tan, K.L., Eng, P.K., Ooi, B.C.: Efficient progressive skyline computation. In: VLDB, pp. 301–310 (2001)
41.
Zurück zum Zitat Tang, Y., Chen, S.: Supporting continuous skyline queries in dynamically weighted road networks. Math. Probl. Eng. 10.1155/2018/6749650 (2018) Tang, Y., Chen, S.: Supporting continuous skyline queries in dynamically weighted road networks. Math. Probl. Eng. 10.1155/2018/6749650 (2018)
42.
Zurück zum Zitat Wang, M., Liu, S., Wang, S., Lai, K.K.: A weighted product method for bidding strategies in multi-attribute auctions. J. Syst. Sci. Complex. 23, 194–208 (2010)MathSciNetCrossRef Wang, M., Liu, S., Wang, S., Lai, K.K.: A weighted product method for bidding strategies in multi-attribute auctions. J. Syst. Sci. Complex. 23, 194–208 (2010)MathSciNetCrossRef
43.
Zurück zum Zitat Wu, D., Yiu, M.L., Jensen, C.S., Cong, G.: Efficient continuously moving top-k spatial keyword query processing. In: ICDE, pp. 541–552 (2011) Wu, D., Yiu, M.L., Jensen, C.S., Cong, G.: Efficient continuously moving top-k spatial keyword query processing. In: ICDE, pp. 541–552 (2011)
44.
Zurück zum Zitat Wu, P., Agrawal, D., Egecioglu, Ö., Abbadi, A.E.: Deltasky: optimal maintenance of skyline deletions without exclusive dominance region generation. In: ICDE (2007) Wu, P., Agrawal, D., Egecioglu, Ö., Abbadi, A.E.: Deltasky: optimal maintenance of skyline deletions without exclusive dominance region generation. In: ICDE (2007)
45.
Zurück zum Zitat Xia, T., Zhang, D.: Continuous reverse nearest neighbor monitoring. In: ICDE, p. 77 (2006) Xia, T., Zhang, D.: Continuous reverse nearest neighbor monitoring. In: ICDE, p. 77 (2006)
46.
Zurück zum Zitat Yang, S., Cheema, M.A., Lin, X., Zhang, Y., Zhang, W.: Reverse k nearest neighbors queries and spatial reverse top-k queries. VLDB J. 26(2), 151–176 (2017)CrossRef Yang, S., Cheema, M.A., Lin, X., Zhang, Y., Zhang, W.: Reverse k nearest neighbors queries and spatial reverse top-k queries. VLDB J. 26(2), 151–176 (2017)CrossRef
47.
Zurück zum Zitat Zavadskas, E.K., Antucheviciene, J., Hajiagha, S.H.R., Hashemi, S.S.: Extension of weighted aggregated sum product assessment with interval-valued intuitionistic fuzzy numbers (WASPAS-IVIF). Appl. Soft Comput. 24, 1013–1021 (2014)CrossRef Zavadskas, E.K., Antucheviciene, J., Hajiagha, S.H.R., Hashemi, S.S.: Extension of weighted aggregated sum product assessment with interval-valued intuitionistic fuzzy numbers (WASPAS-IVIF). Appl. Soft Comput. 24, 1013–1021 (2014)CrossRef
48.
Zurück zum Zitat Zhang, J., Zhu, M., Papadias, D., Tao, Y., Lee, D.L.: Location-based spatial queries. In: SIGMOD (2003) Zhang, J., Zhu, M., Papadias, D., Tao, Y., Lee, D.L.: Location-based spatial queries. In: SIGMOD (2003)
49.
Zurück zum Zitat Zheng, J., Jiang, S., Chen, J., Yu, W., Zhang, S.: Dynamic skyline maintaining strategies for moving query points in road networks. J. Internet Technol. 20(5), 1359–1369 (2019) Zheng, J., Jiang, S., Chen, J., Yu, W., Zhang, S.: Dynamic skyline maintaining strategies for moving query points in road networks. J. Internet Technol. 20(5), 1359–1369 (2019)
50.
Zurück zum Zitat Zhong, R., Li, G., Tan, K.L., Zhou, L.: G-tree: an efficient index for knn search on road networks. In: CIKM, pp. 39–48 (2013) Zhong, R., Li, G., Tan, K.L., Zhou, L.: G-tree: an efficient index for knn search on road networks. In: CIKM, pp. 39–48 (2013)
Metadaten
Titel
Continuous monitoring of moving skyline and top-k queries
verfasst von
Arif Hidayat
Muhammad Aamir Cheema
Xuemin Lin
Wenjie Zhang
Ying Zhang
Publikationsdatum
11.10.2021
Verlag
Springer Berlin Heidelberg
Erschienen in
The VLDB Journal / Ausgabe 3/2022
Print ISSN: 1066-8888
Elektronische ISSN: 0949-877X
DOI
https://doi.org/10.1007/s00778-021-00702-4

Weitere Artikel der Ausgabe 3/2022

The VLDB Journal 3/2022 Zur Ausgabe

Premium Partner