Skyline Join Query Processing over Multiple Relations
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.
KeywordsSkyline 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.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.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.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.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.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
- 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
- 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.Teja, A.: Aggregate skyline join queries: skylines with aggregate operations over multiple relations. In: Management of Data, p. 15 (2010)Google Scholar
- 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