Skyline Join Query Processing over Multiple Relations

  • Jinchao Zhang
  • Zheng LinEmail author
  • Bo Li
  • Weiping Wang
  • Dan Meng
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 9645)


Skyline query on multiple relations, known as skyline join query processing, attracts much attention recently. However, most of the existing algorithms perform skyline join just on two relations. In this paper, we propose an efficient algorithm Skyjog, which is applicable for skyline join on two or even more relations. Skyjog divides each relation into two or three partitions. Based on the proposed group division approach, tuples generated by several join combinations of these partitions definitely are skyline points. Skyjog only has to examine tuples of other join combinations. Thus, Skyjog achieves performance efficiency by avoiding much skyline computation. Experiments demonstrate that Skyjog has an outstanding performance on all datasets, and outperforms the state-of-the-art skyline join algorithms on both two relations and more than two relations.


Skyline join Multiple relations Group division 



This work is supported by the National KeJiZhiCheng Project (2012BAH46B03), the National HeGaoJi Key Project (2013ZX01039-002-001-001), the National Natural Science Foundation of China (61502478), and “Strategic Priority Research Program” of the Chinese Academy of Sciences (XDA06030200).


  1. 1.
    Borzsony, S., Kossmann, D., Stocker, K.: The skyline operator. In: Proceedings of International Conference on Data Engineering, pp. 421–430. IEEE (2001)Google Scholar
  2. 2.
    Chomicki, J., Godfrey, P., Gryz, J., Liang, D.: Skyline with presorting. In: Proceedings of International Conference on Data Engineering, pp. 717–719. IEEE (2003)Google Scholar
  3. 3.
    Jin, W., Ester, M., Hu, Z., Han, J.: The multi-relational skyline operator. In: Proceedings of International Conference on Data Engineering, pp. 1276–1280. IEEE (2007)Google Scholar
  4. 4.
    Jin, W., Morse, M.D., Patel, J.M., Ester, M., Hu, Z.: Evaluating skylines in the presence of equijoins. In: Proceedings of International Conference on Data Engineering, pp. 249–260. IEEE (2010)Google Scholar
  5. 5.
    Nagendra, M., Candan, K.S.: Skyline-sensitive joins with LR-pruning. In: Proceedings of the International Conference on Extending Database Technology, pp. 252–263. ACM (2012)Google Scholar
  6. 6.
    Nagendra, M., Candan, K.S.: Efficient processing of skyline-join queries over multiple data sources. ACM Trans. Database Syst. 40(2), 10 (2015)MathSciNetCrossRefGoogle Scholar
  7. 7.
    Raghavan, V., Rundensteiner, E., et al.: Progressive result generation for multi-criteria decision support queries. In: Proceedings of International Conference on Data Engineering, pp. 733–744. IEEE (2010)Google Scholar
  8. 8.
    Raghavan, V., Rundensteiner, E.A., Srivastava, S.: Skyline and mapping aware join query evaluation. Inf. Syst. 36(6), 917–936 (2011)CrossRefGoogle Scholar
  9. 9.
    Sun, D., Wu, S., Li, J., Tung, A.K.: Skyline-join in distributed databases. In: Proceedings of International Conference on Data Engineering Workshop, pp. 176–181. IEEE (2008)Google Scholar
  10. 10.
    Teja, A.: Aggregate skyline join queries: skylines with aggregate operations over multiple relations. In: Management of Data, p. 15 (2010)Google Scholar
  11. 11.
    Vlachou, A., Doulkeridis, C., Polyzotis, N.: Skyline query processing over joins. In: Proceedings of the 2011 ACM SIGMOD, pp. 73–84. ACM (2011)Google Scholar

Copyright information

© Springer International Publishing Switzerland 2016

Authors and Affiliations

  • Jinchao Zhang
    • 1
    • 2
  • Zheng Lin
    • 1
    Email author
  • Bo Li
    • 1
  • Weiping Wang
    • 1
  • Dan Meng
    • 1
  1. 1.Institute of Information EngineeringChinese Academy of SciencesBeijingChina
  2. 2.University of Chinese Academy of SciencesBeijingChina

Personalised recommendations